MySQL Forums
Forum List  »  Replication

Last_Errno: 1032, Could not execute Update_rows event on table jiradb.userhistoryitem;
Posted by: Raja Tadi
Date: May 15, 2013 07:46PM

MySql Replication is not working below is the error, This is very urjent to resolved kindly help me.

mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: RCOLNX89194.noam.corp.frk.com
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000009
Read_Master_Log_Pos: 32156874
Relay_Log_File: rcovlnx0124-relay-bin.000005
Relay_Log_Pos: 168612
Relay_Master_Log_File: mysql-bin.000009
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: jiradb,crowd
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1032
Last_Error: Could not execute Update_rows event on table jiradb.userhistoryitem; Ca n't find record in 'userhistoryitem', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event' s master log mysql-bin.000009, end_log_pos 4190003
Skip_Counter: 0
Exec_Master_Log_Pos: 4189741
Relay_Log_Space: 28139415
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: 1032
Last_SQL_Error: Could not execute Update_rows event on table jiradb.userhistoryitem; Ca n't find record in 'userhistoryitem', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event' s master log mysql-bin.000009, end_log_pos 4190003
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID: f5095cc4-ad21-11e2-a67e-3440b5e37058
Master_Info_File: /usr/data/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: 130514 03:01:56
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
Last_Errno: 1032, Could not execute Update_rows event on table jiradb.userhistoryitem;
23297
May 15, 2013 07:46PM


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.