MySQL Forums
Forum List  »  Replication

master -master replication issues error 1062 and 1677
Posted by: Hema v
Date: May 20, 2014 01:56AM

Hi,

Im facing issue in master-master replication failover.

1062 Error 'Duplicate entry '143' for key 'PRIMARY'' on query. Default database: 'commstree4'. Query: 'insert into profile_attachment (profile_id, file_id, type) values (55034, '408d1b90-a034-4b08-9a1e-e63d3ef5cfe5', 'cv')'

1677 error "Column 1 of table 'commstree4.COM_AUDIT_TRAIL' cannot be converted from type 'varchar(45)' to type 'varchar(30)'"

as a temporary fix i have made entry in my.cnf file

skip slave error = 1062
stop slave;
start slave;

but again 1677 occured.

so i made skip slave error = 1677 which doesnt fix the issue.

so made it as skip slave error = all even that doesnt fix it.

tried get global slave_type_conversions

mysql> show variables like "%slave_type%";
+------------------------+---------------+
| Variable_name | Value |
+------------------------+---------------+
| slave_type_conversions | ALL_LOSSY |
+------------------------+---------------+
1 row in set (0.00 sec)

mysql>

but no luck;

So reverted all replication setting from the server.

Please help me on this as this is urgent.

Options: ReplyQuote


Subject
Views
Written By
Posted
master -master replication issues error 1062 and 1677
4681
May 20, 2014 01:56AM


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.