Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

205

积分

19

好友

29

主题
发表于 2016-7-11 10:24:32 | 查看: 688| 回复: 0
本帖最后由 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:
  1. 2013-08-27 14:15:47 9056 [ERROR] 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
  2. 2013-08-27 14:15:47 9056 [warning] Slave: Can’t find record in ‘t1’ Error_code: 1032
  3. 2013-08-27 14:15:47 9056 [ERROR] 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 684
复制代码
Why 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选项都和此报错以及所问问题无关。
您需要登录后才可以回帖 登录 | 注册

扫码加入微信Oracle小密圈


QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

GMT+8, 2018-9-26 00:41 , Processed in 0.059102 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569