Changes between Version 28 and Version 29 of Replication_Issues

Timestamp:

Nov 9, 2011, 12:12:04 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

Replication_Issues

@@ -5 +5 @@
 
 = 20111109/12:11: ippdb03/ipp001 errors =
+
+Alterations to gpc1: 
+{{{
+mysql> ALTER TABLE diffInputSkyfile DROP PRIMARY KEY, ADD PRIMARY KEY(diff_skyfile_id);
+Query OK, 11661867 rows affected (12 min 37.50 sec)
+Records: 11661867  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE diffInputSkyfile CHANGE COLUMN skycell_id  skycell_id VARCHAR(64) DEFAULT NULL;
+Query OK, 11661867 rows affected (11 min 28.22 sec)
+Records: 11661867  Duplicates: 0  Warnings: 0
+
+
+mysql> UPDATE dbversion set schema_version = '1.1.71', updated= CURRENT_TIMESTAMP();
+Query OK, 1 row affected (0.00 sec)
+Rows matched: 1  Changed: 1  Warnings: 0
+}}}
 
 = 20110921/13:56: ippdb03 error =