网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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


参考答案

更多 “ 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 ” 相关考题
考题 How long() you() a member of the club? A.have,,joinedB.have,,beenC.has,,joinedD.has,,been

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

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

考题 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

考题 Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?() A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n

考题 What is the primary syslog file?() A./var/syslog-fileB./var/syslogC./var/log/messagesD./log-file

考题 Whichofthefollowingstatementsbestdescribeserrorlogging?() A.Syslogdcreateserrorlogentriesinthesystemerrorlog.B.Thedefaulterrorlogisstoredin/var/adm/ras/error.log.C.Allentriesintheerrorlogarerelatedtosoftwareproblems.D.Errorloggingisautomaticallyenabledduringsysteminitialization.

考题 以长格式列出当前用户家目录下文件名以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]?"

考题 以长格式列出当前用户家目录下文件名以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]?"

考题 以长格式列出当前用户家目录下文件名以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]?"