I encountered multiple issues while migrating my setup as follows:

1) My tables were created by akonadi in myisam format so I had to convert them by hand, maybe update script ought to do itself. This was not problem before as there were not so strict foreign keys.

2) When updating I had some collisions which resulted in things like:

"ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE" 
Updating index failed:  

Which was then easily fixed by mysql command to clear the clashes:
DELETE FROM PartTable WHERE pimItemId NOT IN (SELECT id FROM PimItemTable);

This happened multiple times so it might be good idea to run this call prior the alter...
MariaDB [akonadidb]> DELETE FROM PimItemTable WHERE collectionId NOT IN (SELECT id FROM CollectionTable);
Query OK, 2 rows affected (0.11 sec)
MariaDB [akonadidb]> DELETE FROM PartTable WHERE pimItemId NOT IN (SELECT id FROM PimItemTable);
Query OK, 3 rows affected (0.61 sec)
MariaDB [akonadidb]> DELETE FROM CollectionAttributeTable WHERE collectionId NOT IN (SELECT id FROM CollectionTable);
Query OK, 34 rows affected (0.01 sec)

After I ran all of the above my akonadi is again working as expected.


Reproducible: Always