Hi,
I'm using Slackware64-current and just migrated to ALienBOB's KDE 4.13 and akonadi 1.12.1 packages from his previous 4.12.4 and 1.11.0.
After the upgrade, akonadi failed to start with the following errors :

Code: Select all

Updating index failed:
Sql error: Cannot add or update a child row: a foreign key constraint fails (akonadi.#sql-9bc_3f, CONSTRAINT #sql-9bc_
3f_ibfk_1 FOREIGN KEY (parentId) REFERENCES collectiontable (id) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable
to execute query
Query: ALTER TABLE CollectionTable ADD FOREIGN KEY (parentId) REFERENCES CollectionTable(id) ON UPDATE CASCADE ON DELETE CA
SCADE

Looking around, I found that this could be caused by a corrupted or old akonadi database, so I went ahead and deleted the whole ~/.local/share/akonadi directory.
Now, when I run "akonadictl start", I see that it does try to rebuild the database but fails with the following message :

Code: Select all

Sql error: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. QMYSQL: Unable to execute query

This is supposed, according to this page, to be fixed by a system-level parameter in my.conf :
https://confluence.atlassian.com/pages/ ... =251724630

But on my system, a brand new user manages to start akonadi without problem so it cannot be a system-wide issue.
What can I do?

I should have looked a bit harder.
After also removing the ~/.config/akonadi dir, akonadi now starts.
Sorry for the noise.

Glad that's working for you! Please mark this topic as solved if you are no longer experiencing problems. Thanks!