Changes between Version 30 and Version 31 of Replication_Issues

Timestamp:

Nov 9, 2011, 1:36:51 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -19 +19 @@
 }}}
 
-They broke the database replication on both ippdb03 and ipp001.
+They broke the database replication on both ippdb03 and ipp001 (because of the multiple diff_skyfile_id = 10264768 in diffInputSkyfile. Error message was: "ERROR 1062 (23000): Duplicate entry '10264768' for key 1"). On both hosts I ran:
+{{{
+mysql> STOP SLAVE;
+mysql> delete from diffInputSkyfile where diff_id = 162937 and skycell_id = 'skycell.1485.049';
+mysql> update diffInputSkyfile set diff_skyfile_id = 10264767 where diff_id = 162937 and skycell_id = 'skycell.1485.059';
+}}}
+and ran again the ALTER command:
+{{{
+mysql> ALTER TABLE diffInputSkyfile DROP PRIMARY KEY, ADD PRIMARY KEY(diff_skyfile_id);
+}}}
+and then:
+{{{
 
+}}}
 = 20110921/13:56: ippdb03 error =
 From Anonymous: "screwed-up the replication to ippdb03 while adding the new ippMonitor user (i didn't think i could update a slave, so believed i was safe). i've tried to fix it"