Changes between Version 32 and Version 33 of howto/ZarafaMigrateConnectux

Timestamp:

06/09/11 22:39:41 (13 years ago)

Author:

Edwin Eefting

Comment:

--

howto/ZarafaMigrateConnectux

@@ -199 +199 @@
 mysql> 
 }}}
+
+We starten het script nogmaals, in FORCE mode omdat de user conversie al geweest is:
+{{{
+[Syn-3] root@linux.ours.local ~# FORCE=1 ./convert 
+Stopping /service/zarafa-server ...OK
+SYN-3: Reading user ID converions:
+old user id -> username -> new user id
+ERROR 1054 (42S22) at line 1: Unknown column 'object_type' in 'where clause'
+Something went wrong with user conversion..
+SYN-3: Updating database:
+query: 
+SYN-3: Starting zarafa in conversion mode:
+SYN-3: Waiting for conversion to finish...
+Thu Jun  9 22:36:18 2011: Done: Update acl key
+Thu Jun  9 22:36:18 2011: Start: Update externid in object table
+Thu Jun  9 22:36:18 2011: Done: Update externid in object table
+Thu Jun  9 22:36:18 2011: Start: Update keys in 'changes' table
+Thu Jun  9 22:36:18 2011: Done: Update keys in 'changes' table
+Thu Jun  9 22:36:18 2011: Start: Update mvproperties key
+Thu Jun  9 22:36:18 2011: 0x0000000a356568: SQL Failed: Incorrect table definition; there can be only one auto column and it must be defined as a key, Query: "ALTER TABLE mvproperties DROP PRIMARY KEY, ADD PRIMARY KEY (`hierarchyid`,`tag`,`type`,`orderid`), DROP KEY `hi`"
+Thu Jun  9 22:36:18 2011: Failed: Rollback database
+Thu Jun  9 22:36:18 2011: Can't update the database: Unable to upgrade zarafa from version 6.40.27223 to 6.40.8.27223
+Thu Jun  9 22:36:18 2011: Server shutdown complete.
+
+}}}
+
+Nu gaat het mis op een andere table, we doen dezelfde sql magic:
+{{{
+[Syn-3] root@linux.ours.local ~# mysql -p`cat /etc/my.passwd` zarafa
+Welcome to the MySQL monitor.  Commands end with ; or \g.
+Your MySQL connection id is 77
+Server version: 5.0.91 Source distribution
+
+Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
+
+mysql> ALTER TABLE mvproperties DROP PRIMARY KEY, ADD PRIMARY KEY (`hierarchyid`,`tag`,`type`,`orderid`), DROP KEY `hi`;
+ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
+
+}}}