Changes between Version 15 and Version 16 of Replication_Issues

Timestamp:

Apr 29, 2011, 9:02:02 AM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -3 +3 @@
 
 [[PageOutline]]
+= 20110429/0850: gpc1 Replication Error =
+From mysql slave on ippc02 (SHOW SLAVE STATUS)
+Query partially completed on the master (error on master: 1317) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; . Query: 'drop table lapExp'.
+
+I checked with Chris and did a 'STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE;'. Hopefully we will not have to ingest a new dump again...
+
 
 = 20110413/1450: ippadmin Replication Error =