Exam 1z0-883 topic 1 question 76 discussion

Actual exam question from Oracle's 1z0-883

Question #: 76
Topic #: 1

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 keyPRIMARY , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the events 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_master-bin.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.

Show Suggested Answer

Suggested Answer: AE 🗳️

by [deleted] at April 4, 2025, 1:03 p.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!