MySQL Forums
Forum List  »  Replication

Last_SQL_Errno: 1062
Posted by: IT IT
Date: February 06, 2020 11:07AM

After the crash of our slave DBMS; replication fails with error 1062.

Slave_IO_State: Waiting for master to send event
Master_Host: x.x.x.x
Master_User: replication_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.008829
Read_Master_Log_Pos: 36738646
Relay_Log_File: mysql-relay-bin.000002
Relay_Log_Pos: 57296
Relay_Master_Log_File: mysql-bin.008829
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1062
Last_Error: Could not execute Write_rows event on table skyline.wp_options; Duplicate entry '_transient_all_the_cool_cats' for key 'option_name', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.008829, end_log_pos 36528836
Skip_Counter: 0
Exec_Master_Log_Pos: 36528614
Relay_Log_Space: 267535
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1062
Last_SQL_Error: Could not execute Write_rows event on table skyline.wp_options; Duplicate entry '_transient_all_the_cool_cats' for key 'option_name', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.008829, end_log_pos 36528836
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID: 4bc8fdf0-9b35-11e4-bc47-005056975f49
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State:
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp: 200206 16:41:37
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:

how do we fix this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Last_SQL_Errno: 1062
2404
February 06, 2020 11:07AM
758
February 18, 2020 03:59PM
644
February 20, 2020 04:23PM
636
February 20, 2020 04:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.