The purpose of this page is to show how databases replication problems were solved.
[[PageOutline]]

= 20101104/1429: gpc1 replication on ipp001 =
  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: 
}}}