MySQL Forums
Forum List  »  Replication

Re: Mysql replication
Posted by: Mukesh Nagar
Date: August 24, 2012 12:14AM

We are getting below error when start the replication , how we can avoid this error(error code=1032) , we do not know the meaning of this error.



Show slave status



Slave_IO_State: Waiting for master to send event
Master_Host: 172.27.9.60
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: clsoaa22-bin.000019
Read_Master_Log_Pos: 892094
Relay_Log_File: clsoaa21-relay-bin.000004
Relay_Log_Pos: 266
Relay_Master_Log_File: clsoaa22-bin.000017
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: 1032
Last_Error: Could not execute Update_rows_v1 event on table s
sg.cluster_master; Can't find record in 'cluster_master', Error_code: 1032; hand
ler error HA_ERR_END_OF_FILE; the event's master log clsoaa22-bin.000017, end_lo
g_pos 357
Skip_Counter: 0
Exec_Master_Log_Pos: 112
Relay_Log_Space: 1447792
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_v1 event on table s
sg.cluster_master; Can't find record in 'cluster_master', Error_code: 1032; hand
ler error HA_ERR_END_OF_FILE; the event's master log clsoaa22-bin.000017, end_lo
g_pos 357
Master_Bind:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 2



Edited 1 time(s). Last edit at 08/24/2012 12:15AM by Mukesh Nagar.

Options: ReplyQuote


Subject
Views
Written By
Posted
5147
August 21, 2012 04:07AM
2200
August 22, 2012 09:51PM
Re: Mysql replication
5286
August 24, 2012 12:14AM
3064
August 24, 2012 02:27AM
2717
August 26, 2012 06:20PM
2774
August 27, 2012 08:32AM
2400
August 27, 2012 05:55PM
2063
August 24, 2012 04:49AM


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.