Arch Linux

MCMic

Member

Registered: 2015-03-31

Posts: 16

[SOLVED] Akonadi database error

Hello,

I had too many problems with akonadi and kmail, so I’m trying to reset my configuration, since all my data is online anyway (imap and caldav/carddav).

I did the following:

akonadictl stop
delete ~/.local/share/akonadi*
delete ~/.config/akonadi*
akonadictl start

And the last command still shows errors:

org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1452"
org.kde.pim.akonadiserver:   DB error:  "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `col
lectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
org.kde.pim.akonadiserver:   Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `co
llectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Impossible d'exécuter la requête"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(qlonglong, 2))(":1", QVariant(qlonglong, 5)))
org.kde.pim.akonadiserver:   Query: "INSERT INTO CollectionMimeTypeRelation (Collection_id, MimeType_id) VALUES (:0, :1)"
org.kde.pim.akonadiserver: Error during adding a record to table "CollectionMimeTypeRelation"
org.kde.pim.akonadiserver: Failed to append mimetype "inode/directory" to Collection 2
org.kde.pim.akonadiserver: Failed to append mimetypes ("inode/directory", "message/rfc822") to new collection "akonadi_maildir_resource_0" (ID 2 ) in resource "akonadi_maildir_resource_0"
org.kde.pim.akonadiserver: Error while handling command CreateCollection on connection akonadi_maildir_resource_0 (0x555df3856d40)
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1452"
org.kde.pim.akonadiserver:   DB error:  "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `col
lectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
org.kde.pim.akonadiserver:   Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`collectionmimetyperelation`, CONSTRAINT `collectionmimetyperelation_ibfk_1` FOREIGN KEY (`Collection_id`) REFERENCES `co
llectiontable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Impossible d'exécuter la requête"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(qlonglong, 3))(":1", QVariant(qlonglong, 5)))
org.kde.pim.akonadiserver:   Query: "INSERT INTO CollectionMimeTypeRelation (Collection_id, MimeType_id) VALUES (:0, :1)"
org.kde.pim.akonadiserver: Error during adding a record to table "CollectionMimeTypeRelation"
org.kde.pim.akonadiserver: Failed to append mimetype "inode/directory" to Collection 3
org.kde.pim.akonadiserver: Failed to append mimetypes ("inode/directory", "message/rfc822") to new collection "Dossiers locaux" (ID 3 ) in resource "akonadi_maildir_resource_0"
org.kde.pim.akonadiserver: Error while handling command CreateCollection on connection akonadi_maildir_resource_0 (0x555df3856d40)

So I guess there are more things to delete to start from a clean slate?

Last edited by MCMic (2019-07-03 14:23:45)

schard

Forum Moderator

From: Hannover

Registered: 2016-05-06

Posts: 2,671

Website

Re: [SOLVED] Akonadi database error

Are you sure you're not affected by this: https://bugs.archlinux.org/task/63025

---

Inofficial first vice president of the Rust Evangelism Strike Force

MCMic

Member

Registered: 2015-03-31

Posts: 16

Re: [SOLVED] Akonadi database error

Thanks, that seems to be the case.

I have no more errors, I’m gonna try adding my configurations back now :-)