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

题目

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

相似考题

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

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

3.在Mysql数据库下,以下哪个选项最好地描述了InnoDB表为什么需要主键并且主键应当尽量短?()A.因为InnoDB在一个日志中保存到所有主键的指针，短的主键使日志小B.因为InnoDB使用主键定位二级索引，短的主键使查询快C.因为InnoDB使用主键定位表记录，短的主键使查询快D.因为InnoDB使用主键定位表，短的主键使查询快

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

更多“A MySQL replication slave is set up as follows: User all InnoDB tablesReceives ROW－based b ”相关问题

  • 第1题：

    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

    答案：C
    解析：
    解析：参考译文
    蓝牙设备可以是一个主设备也可以是一个从设备，位于（ ）中的任一设备都可以成为主设备。在一个网络中只有一个主设备，最多有（ ）个激活的从设备。另外，一个设备可以是活跃的从设备或是休眠的从设备，最多有（ ）个休眠的从设备。如果已有最大数量的活跃从设备，那么，一个休眠的从设备就必须等到某活跃从设备切换到（ ）模式后才能被激活。在一个网络内，所有的（请作答此空）通信都是被禁止的。

  • 第2题：

    MySQL默认提供的用户是 。（）

    A．admin

    B．test

    C．root

    D．user


    root

  • 第3题：

    以下那一个选项是查询数据方法：

    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()


    query()

  • 第4题：

    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密码
    A

  • 第5题：

    MySQL数据库支持以下哪些复制模式？

    A．master-slave

    B．master-master

    C．master-master-slave

    D．master-slave-slave


    master-slave;master-master;master-master-slave;master-slave-slave

  • 第6题：

    1、Mysql 的存储引擎,myisam和innodb的区别。


    MyISAM不支持事务

相关内容