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

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

相关考题：

Which view should a user query to display the columns associated with the constraints on a table owned by the user? () A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUMNSE. USER_COLUMNS
查看答案
MySQL is installed on a Linux server and has the following configuration:What is the purpose of changing ownership of datadir to the ‘mysql’ user?() A.MySQL requires correct file ownership while remaining secureB.MySQL needs to be run as the root user, but file cannot be owned by itC.MySQL cannot be run as the root user
查看答案
When backing up a replication slave, which three should also be backed up in addition to data?() A.The master.info and relay.info filesB.The relay log filesC.The relay index fileD.Mysql.slave_master_info tableE.Mysql.slave_relay_log_info tableF.Mysql.slave_worker_info table
查看答案
在Mysql数据库下,以下哪个选项最好地描述了InnoDB表为什么需要主键并且主键应当尽量短?() A.因为InnoDB在一个日志中保存到所有主键的指针，短的主键使日志小B.因为InnoDB使用主键定位二级索引，短的主键使查询快C.因为InnoDB使用主键定位表记录，短的主键使查询快D.因为InnoDB使用主键定位表，短的主键使查询快
查看答案
A Bluetooth device can be either a master or a slave and any of the devices within a （ ）can be the master. There is only one master and there can be up to （ ） active slave devices at a time within a single network. In addition, a device may be a standby slave or a parked slave. There can be up to （ ） parked slaves. If there are already maximum number of active slaves, then a parked slave must wait until one of the active slaves switches to （ ） mode before it can become active. Within a network, all （请作答此空） communications are prohibited.A.MASTER-TO-MASTER B.MASTER-TO-SLAVE C.SLAVE-TO-SLAVE D.SLAVE-TO-MASTER
查看答案
1、设置MySQL字符集的方法A.修改my.ini配置文件，可修改MySQL默认的字符集。###SXB###B.MySQL提供MySQL命令可以“临时地”修改MySQL“当前会话的”字符集以及字符序。###SXB###C.使用MySQL命令 “set names gbk;”可以“临时一次性地”设置character_set_client、character_set_connection以及character_set_results的字符集为gbk###SXB###D.连接MySQL服务器时指定字符集 mysql --default-character-set=字符集 -h 服务器IP地址 -u 账户名 –p密码
查看答案
MySQL默认提供的用户是 。（）A．adminB．testC．rootD．user
查看答案
MySQL数据库支持以下哪些复制模式？A．master-slaveB．master-masterC．master-master-slaveD．master-slave-slave
查看答案
以下那一个选项是查询数据方法：A．User.objects.filter(username='wangwu').get(pk=1)B．User.objects.filter(id=user_id).update(password='9999')C．User.objects.all().delete()D．User.objects.get(pk=user_id).delete()
查看答案
1、Mysql 的存储引擎,myisam和innodb的区别。
查看答案
热门标签