重庆思庄Oracle、Redhat认证学习论坛

标题: 1z0-883 第五题 [打印本页]

作者: jikcheng 时间: 2014-12-22 13:38
标题: 1z0-883 第五题
ROW-based replication has stopped working. You investigate the error log file and find the following entries:

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

2013-08-27 14:15:47 9056 [warning] Slave: Can’t find record in ‘t1’ Error_code: 1032

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_master- bin. 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.

作者: jikcheng 时间: 2014-12-22 13:43
原文翻译:基于行的复制环境，已经停止工作。你查看错误日志文件发现以下错误。

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

2013-08-27 14:15:47 9056 [warning] Slave: Can’t find record in ‘t1’ Error_code: 1032

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_master- bin. 000003’ position 684
为什么会导致这个错误。

[此贴子已经被作者于2014-12-22 13:44:11编辑过]

作者: jikcheng 时间: 2014-12-22 13:45
答案:D

Could not execute Delete_rows event on table test.t1; Can’t find record in ‘t1’

不能执行删除行的事件在test.t1 没有找到相关的记录。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)