Re: Mysql 5.7.10 Master-Master replication stops with 1032 error

[Chintan Shah]

Hi Rick,

below is the show create statement.

mysql> SHOW CREATE TABLE 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)


Below is the query which update the id in tables.

update crm_crmentity_seq set id=LAST_INSERT_ID(id+1).