The purpose of this page is to show how databases replication problems were solved. Please contribute when you fix a MySQL replication problem. If you fix something which is similar to an existing entry, just Add an entry something like 'Fixed problem as in <entry reference>'.

20101104/1429: gpc1 Replication Error

Problem detected through czartool

• Logged onto ipp001
• Started mysql client as root
• 'SHOW SLAVE STATUS\G' showed (shortened)

            Slave_SQL_Running: No
                   Last_Errno: 1062
                   Last_Error: Error 'Duplicate entry '23' for key 1' on query. Default database: 'ippadmin'. 
                               Query: 'INSERT into cookies (username, cookie) values ('psobs', '99497')'
  

• Local non-replicated database involved... Statement skipped (in MySQL client):

    STOP SLAVE;
    SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; 
    START SLAVE;
  

• Then 'SHOW SLAVE STATUS\G' showed (shortened)

            Slave_SQL_Running: Yes
                   Last_Errno: 0
                   Last_Error: 
  

• Czartool doesn't show any problem now