Changes between Version 34 and Version 35 of howto/ZarafaMigrateConnectux

Timestamp:

06/09/11 22:45:21 (13 years ago)

Author:

Edwin Eefting

Comment:

--

howto/ZarafaMigrateConnectux

@@ -236 +236 @@
 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
-
-}}}
+....
+mysql> ALTER TABLE mvproperties  DROP KEY `hi`;
+Query OK, 103 rows affected (0.07 sec)
+Records: 103  Duplicates: 0  Warnings: 0
+
+}}}
+
+Na lang prutsen blijkt het nodig zijn deze key te droppen, hierna start zarafa correct en gaat de conversie verder:
+{{{
+[Syn-3] root@linux.lazytours.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:
+Thu Jun  9 22:43:11 2011: Start: Update mvproperties key
+Thu Jun  9 22:43:12 2011: Startup succeeded on pid 21456
+Thu Jun  9 22:43:12 2011: Done: Update mvproperties key
+Thu Jun  9 22:43:12 2011: Start: Update DB plugin group to security groups
+Thu Jun  9 22:43:12 2011: Done: Update DB plugin group to security groups
+Thu Jun  9 22:43:12 2011: Start: Update DB/Unix plugin sendas settings
+Thu Jun  9 22:43:12 2011: Done: Update DB/Unix plugin sendas settings
+Thu Jun  9 22:43:12 2011: Ignoring attachment storing conflict as requested. Attachments are now stored with option 'files'
+Thu Jun  9 22:43:12 2011: Listening for pipe connections on /var/run/zarafa
+Thu Jun  9 22:43:12 2011: Listening for TCP connections on port 236
+Thu Jun  9 22:43:12 2011: Startup succeeded on pid 21456
+./convert: line 52: 21472 Terminated              tail -f /var/log/zarafa/server.log
+SYN-3: Converting attachments from database to files
+The size of all attachments in the database is: 5719539712 Bytes (5.33 GB)
+Available space is: 466469113856 Bytes (434.43 GB)
+Finding all attachments...
+Processing 32922 attachments
+
+}}}
+
+
+Bovenstaande problemen heb ik nu 2x achter elkaar gehad, dus het lijk een standaard issue met 6.20->6.40.9 conversies. (de 6.20 database stamt wel af van een nog veel oudere zarafa versie die meerdere malen geupgrade is)
+