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; han

题目

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

相似考题

1.How long() you() a member of the club?A.have,,joinedB.have,,beenC.has,,joinedD.has,,been

2.Whenperformingadatabaseduplication,whichduplicatedatabaseparameterwouldyousettoensurethattheonlineredologsarecreatedinthecorrectlocation?()A.log_file_name_convertB.convert_log_file_nameC.file_name_convert_logD.redo_log_file_name_convertE.logfile_convert_directory

3.Consider the MySQL Enterprise Audit plugin.On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error.In the audit log file, you notice the final entry:…What action should you take to fix the error and allow the service to start?（）A.Re-install the audit pluginB.Execute the command FLUSH LOGSC.Execute the command SET GLOBAL audit_log_fiush= OND.Move or rename the existing audit.log file

4.假设文件file处于当前目录下某个子目录中,下列哪个命令可以得到其具体路径名:()A.find.-namefile-printB.FIND.-namefile-printC.find-namefile-print

更多“ROW－based replication has stopped working. You investigate the error log file and find the ”相关问题

  • 第1题：

    Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?()

    A.DB_CREATE_FILE_DEST

    B.DB_RECOVERY_FILE_DEST

    C.DB_RECOVERY_FILE_DEST_SIZE

    D.DB_ONLINE_LOG_DEST_n


    参考答案：B, C

  • 第2题：

    Whichofthefollowingstatementsbestdescribeserrorlogging?()

    A.Syslogdcreateserrorlogentriesinthesystemerrorlog.

    B.Thedefaulterrorlogisstoredin/var/adm/ras/error.log.

    C.Allentriesintheerrorlogarerelatedtosoftwareproblems.

    D.Errorloggingisautomaticallyenabledduringsysteminitialization.


    参考答案：D

  • 第3题：

    以长格式列出当前用户家目录下文件名以file开头，跟着2到5之间的一个数字的所有文件

    A．ls -l ~/file[2-5]*

    B．find ~ -name "file[2-5]*"

    C．ls -a ~/file[2-5]*

    D．find ~ -name "file[2-5]？"


    ls -l ~;ll ~

  • 第4题：

    What is the primary syslog file?()

    A./var/syslog-file

    B./var/syslog

    C./var/log/messages

    D./log-file


    参考答案：C

  • 第5题：

    以长格式列出当前用户家目录下文件名以file开头，跟着2到5之间的一个数字的所有文件

    A．ls -l ~/file[2-5]*

    B．find ~ -name "file[2-5]*" -exec ls -l {} ;

    C．find ~ -name "file[2-5]*"

    D．ls -a ~/file[2-5]*

    E．ls -l ~/file[2-5]

    F．find ~ -name "file[2-5]？"


    ls -l ~;ll ~

  • 第6题：

    以长格式列出当前用户家目录下文件名以file开头，跟着2到5之间的一个数字的所有文件，下面哪种做法是正确的？

    A．ls -l ~/file[2-5]*

    B．find ~ -name "file[2-5]*" -exec ls -l {} ;

    C．find ~ -name "file[2-5]*"

    D．ls -a ~/file[2-5]*

    E．ls -l ~/file[2-5]

    F．find ~ -name "file[2-5]？"


    ls -l ~;ll ~

相关内容