题目内容

A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary logs Has the read-only option The replication slave has been found in an error state. You check the MySQL error log file and find the following entries: 2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’ Error_code: 1062 2013-08-27 13:55:44 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 496 What are two possible causes for this error to occur?()

A. The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql
B. The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function
C. For tables with UNIQUE keys, statement-based replication must be used maintain integrity
D. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite
E. The applications have the SUPER privilege, which allows them to update row

查看答案
更多问题

ISO系列标准中,()是全面的模式,它是在ISO9002的基础上再增加了两项要求,即供方质量体系的要素、设计、控制和服务。

A. ISO9000
B. ISO9001
C. ISO9003
D. ISO9004

电笛受头尾继电器控制。

A. 正确
B. 错误

名片礼是一种()沟通联络形式

A. 口头语言
B. 书面文字
C. 电话
D. 电邮

匡氏总祠崇孝堂,始建于()。

A. 西汉时期
B. 明成化年间
C. 清嘉庆年间

答案查题题库