【dbdao.com MySQL OCP认证专题】- MySQL 5.6 - OCP 考题讲解 - 5
本帖最后由 biotwang 于 2016-7-19 17:11 编辑【dbdao.com MySQL OCP认证专题】- MySQL 5.6 - OCP 考题讲解
5.
ROW-based replication has stopped working. You investigate the error log file and find the following entries:2013-08-27 14:15:47 9056 Slave SQL: Could not execute Delete_rows event on table test.t1; Can’t find record in ‘t1’, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event’s master log 56_master-bin.000003, end_log_pos 851, Error_code: 1032
2013-08-27 14:15:47 9056 Slave: Can’t find record in ‘t1’ Error_code: 1032
2013-08-27 14:15:47 9056 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”. We stopped at log ‘56_masterbin.000003’ position 684Why did you receive this error?
A. The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
B. The table definition on the slave litters from the master.
C. Multi-threaded replication slaves can have temporary errors occurring for cross database updates.
D. The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist.
-------------------------------------------------------------
答案：D
分析：
报错中说的非常明确Could not execute Delete_rows event on table test.t1; Can’t find record in ‘t1’，
这说明slave上这条记录已经被人为删除了，导致Row-Based Replication进行同步删除的时候，找不到这条记录。ABC选项都和此报错以及所问问题无关。
页:
[1]