Changes between Version 14 and Version 15 of Replication_Issues

Timestamp:

Apr 13, 2011, 2:56:25 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -6 +6 @@
 = 20110413/1450: ippadmin Replication Error =
  *  Logged onto ipp001
-  * Started mysql client as root
-  * 'SHOW SLAVE STATUS\G' shows the following error:
+ * Started mysql client as root
+ * 'SHOW SLAVE STATUS\G' shows the following error:
 {{{
 Last_Error: Error 'Duplicate entry '26' for key 1' on query. Default database: 'ippadmin'. Query: 'insert into users (username, password) values ('denver', '********')'
 }}}
- * 
-
-
+ * I did the usual 'STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE;'
+ * The slave is 172833 seconds (i.e. 2 days) behind its master. It clearly shows that no one looks at the replication server statuses.
 = 20110307/0830: Nebulous Replication Error =
   * Logged onto ippdb02