Everytime my akonadi server starts the protocoll shows around many of theses messages below:

DATABASE ERROR:
Error code: 1452
DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadidb`.`CollectionPimItemRelation`, CONSTRAINT `CollectionPimItemRelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES `PimItemTable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadidb`.`CollectionPimItemRelation`, CONSTRAINT `CollectionPimItemRelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES `PimItemTable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
Query: "INSERT INTO CollectionPimItemRelation (Collection_id, PimItem_id) VALUES (:0, :1)"

Do I have to rebuild the akonadi database (and how to do that without deleting my configurations) or how can I solve this?

This is on KDE 4.14.12 on ARCH...

Thanks for help,
piedro

Hi,

please start by removing agents change journals:

rm ~/.config/akonadi/agent_config_akonadi_*_changes.dat

It's possible that some of the journals contains request to perform a change to an Akonadi item (email, contact, etc.) which has already been written to Akonadi, causing the constraint to fail.

Thanks progdan!

This might have been the solution! I do not get this error anymore at the moment. Since I deleted a lot of mails and copied them around I am not completely positive it's been that but this sound sound and it is gone.

So: fixed for the moment I guess and I will keep that in mind if it happens again...


cheers, piedro

Well, spoke too soon!

Among still many emails with empty bodies ( I am sure this is due to bogofilter - happens on the imap server - mails really are corrupted!),
after disbaling bogofilter completely, using spambayes now,
stll I get these errors - sometimes more, sometimes less in the akonadi server error file:

DATABASE ERROR:
Error code: 1452
DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadidb`.`CollectionPimItemRelation`, CONSTRAINT `CollectionPimItemRelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES `PimItemTable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadidb`.`CollectionPimItemRelation`, CONSTRAINT `CollectionPimItemRelation_ibfk_2` FOREIGN KEY (`PimItem_id`) REFERENCES `PimItemTable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
Query: "INSERT INTO CollectionPimItemRelation (Collection_id, PimItem_id) VALUES (:0, :1)"

So I deleted the changes.dat files many times - it still doesn't work.

thx for reading,
piedro