Changes between Version 41 and Version 42 of Replication_Issues

Timestamp:

Feb 3, 2012, 10:44:19 AM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -8 +8 @@
 ippc17 experienced crashes yesterday and tables were corrupted (see http://svn.pan-starrs.ifa.hawaii.edu/trac/ipp/wiki/PS1_IPP_CzarLog_20120130#Friday:2012.02.03). Repairing the tables crashed the replication server: the error messages were about "Duplicate entr[ies]"
 
-I ran the usual: {{{STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;}}} four times to fix it.
+I ran the usual: {{{STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;}}} about 16 times to fix it.
 = 20120131/08:57: ipp001 = 
 Ken Smith told us about ipp001 unavailability. The mysql server on that host crashed for some unknown reason (it was 62000 seconds behind so I assume it happened around 15:00 HST on Jan 30? Maybe it's related to the global loss of connection to the development cluster that happened around that time). I restarted the mysql server and had to fix it with {{{STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;}}}