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=AUTOMATICB.SET GLOBAL enforce_gtid_consistency=ONC.SET GTID_EXECUTED=38f32e23480a7-32a1-c323f78067fd37821 : 9D.SET GTID_NEXT=38f32e23480a7-32a1-c323f78067fd37821 : 9; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATICE.SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

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


相关考题:

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

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

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

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

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

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

下面哪个是GOOGLE推荐的书写规则?A..error_status {}B..test { display: block; height: 100px }C..error-status {}D..TEST

保证实体完整性的措施: 、unique约束或identity列。A.primary 约束B.primary key约束C.key约束D.参照完整性

1、下面哪个是GOOGLE推荐的书写规则?A..error_status {}B..test { display: block; height: 100px }C..error-status {}D..TEST