可学答题网 > 问答 > 1z0-883题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

ROW-based replication has stopped wor


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_masterbin. 000003' position 684 Why did you receive this error?()

  • AThe slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
  • BThe table definition on the slave -litters from the master
  • CMulti-threaded replication slaves can have temporary errors occurring for cross database updates
  • DThe slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist
参考答案
参考解析:
分类:1z0-883题库
相关推荐

1、autonomous replicating sequence (ARS 序

autonomous replicating sequence (ARS 序列)

2、复制型转座(Replicative transposon)

复制型转座(Replicative transposon)

3、You are using replication and the bina

You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to...

4、If a diesel engine has been stopped be

If a diesel engine has been stopped because of piston seizure due to severe overheating, the crankcase()Ainspection covers should not be opene...

5、A simple master-to-slave replication

A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:Last_SQL_Err...

6、She ought to stop work;she has a heada

She ought to stop work;she has a headache because she()too long.AreadBhad readCis readingDhas been reading