What are two possible causes for this error to occur?

A MySQL replication slave is set up as follows:
User all InnoDB tables
Receives ROW-based binary logs
Has the read-only option
The 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: 1062
2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’
Error_code: 1062
2013-08-27 13:55:44 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 496
What are two possible causes for this error to occur?

A MySQL replication slave is set up as follows:
User all InnoDB tables
Receives ROW-based binary logs
Has the read-only option
The 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: 1062
2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’
Error_code: 1062
2013-08-27 13:55:44 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 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.

Explanation:



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Steve

Steve

I would say A and E.