Hey,
I'm reporting a big problem for users who uses many db servers.. it crashed my servers several times :
the problem is :
Last_SQL_Error: Error 'Duplicate entry '238346-282075' for key 'PRIMARY'' on query. Default database: 'xTaZe_6'. Query: 'INSERT INTO v7_force_read_users
(force_read_userid, force_read_threadid)
VALUES
('238346', '282075')'
1 row in set (0.00 sec)
for users who got the same problem add the following to your mysql configuration files, this will ensure replication continues even when there is a duplicate record .
slave-skip-errors = 1146
slave-skip-errors = 1062
|