A simple master－to－slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARYA.SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="

题目
A simple master－to－slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY

A.SET GTID_NEXT="CONSISTENCY"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"

B.SET GLOBAL enforce_gtid_consistency=ON

C.SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9"

D.SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"

E.SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

相似考题

1.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

2.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: 10322013-08-27 14:15:47 9056 [warning] Slave: Can‘t find record in ‘t1‘ Error_code: 10322013-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.sB.The table definition on the slave -litters from the masterC.Multi-threaded replication slaves can have temporary errors occurring for cross database updatesD.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist

3.●Information (71) involves all the operations of an office.(71)A. recordB. processingC. inputD. output

4.A MySQL replication slave is set up as follows: User all InnoDB tablesReceives ROW-based binary logs Has the read-only optionThe 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: 10622013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’Error_code: 10622013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix theproblem, 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.sqlB.The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows functionC.For tables with UNIQUE keys, statement-based replication must be used maintain integrityD.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewriteE.The applications have the SUPER privilege, which allows them to update rows

参考答案和解析
参考答案：E
更多“A simple master－to－slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY ”相关问题

  • 第1题：

    已知位于同一文件夹下的两个文件，output.py和test.py的内容如下： #output.py def show（): print（__name__) #test.py import output if __name__=='__main__': output.show（) 运行test.py的输出结果是（）。 知识点：模块和主模块

    A．output

    B．__main__

    C．__name__

    D．test


    通过键盘输入一个3位数的整数，编程输出各个位数的和，例如345，各个位数的和就是3+4+5=12。

  • 第2题：

    下面哪个是GOOGLE推荐的书写规则？

    A．.error_status {}

    B．.test { display: block; height: 100px }

    C．.error-status {}

    D．.TEST


    error-status {}

  • 第3题：

    1、下面哪个是GOOGLE推荐的书写规则？

    A．.error_status {}

    B．.test { display: block; height: 100px }

    C．.error-status {}

    D．.TEST


    error-status {}

  • 第4题：

    7、已知位于同一文件夹下的两个文件，output.py和test.py的内容如下： #output.py def show（): print（__name__) #test.py import output if __name__=='__main__': output.show（) 运行test.py的输出结果是（）。 知识点：模块和主模块

    A．output

    B．__main__

    C．__name__

    D．test


    错误

  • 第5题：

    保证实体完整性的措施： 、unique约束或identity列。

    A．primary 约束

    B．primary key约束

    C．key约束

    D．参照完整性


    主码

相关内容