MySQL Forums
Forum List  »  Replication

Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
Posted by: Chintan Shah
Date: June 02, 2016 10:30PM

Here is details of issue:
We have master-master config. on 2 node.
Now whenever replication start, immediately it show me below error.
After all analysis we came to know that null values are affecting this issue.
We have implemented RBR.

mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: xxxxxxxxxx
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000005
Read_Master_Log_Pos: 83703724
Relay_Log_File: mysql-relay-bin.000002
Relay_Log_Pos: 320
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB: information_schema,mysql,performance_schema,sys
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 crestel_data_cdma.crm_crmentity_seq; Can't find record in 'crm_crmentity_seq', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log mysql-bin.000001, end_log_pos 5407
Skip_Counter: 0
Exec_Master_Log_Pos: 5133
Relay_Log_Space: 922564401
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 crestel_data_cdma.crm_crmentity_seq; Can't find record in 'crm_crmentity_seq', Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event's master log mysql-bin.000001, end_log_pos 5407
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
Master_UUID: 7c176e05-c351-11e5-b51e-9457a552aad0
Master_Info_File: mysql.slave_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: 160601 18:20:42
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in set (0.00 sec)

Below is table structure.

mysql> SHOW CREATE TABLE crestel_data_cdma.crm_crmentity_seq;
+-------------------+-------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------------------+-------------------------------------------------------------------------------------------------+
| crm_crmentity_seq | CREATE TABLE `crm_crmentity_seq` (
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------------------+-------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> desc crestel_data_cdma.crm_crmentity_seq;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | NO | | NULL | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.01 sec)


Urgent help is required, as we are stuck.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql 5.7.10 Master-Master replication stops with 1032 error
5835
June 02, 2016 10:30PM


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.