#942431 akonadi-backend-mysql: Error during TagSync/ItemFetch faile: "Failed to store tag"

#942431#5
Date:
2019-10-16 07:29:44 UTC
From:
To:
Dear Maintainer,

Since the upgrade to buster, I get error messages when starting akonadi
from the command line. I am including the complete output below:

me@box:~$ LANG=C akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
me@box:~$ akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.parttypetable                              OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.pimitemtagrelation                         OK
akonadi.relationtable                              OK
akonadi.relationtypetable                          OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
akonadi.tagtypetable                               OK
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: "Cannot connect to agent instance with identifier 'akonadi_kolab_resource_0', error message: ''"
org.kde.pim.akonadiserver: "Cannot connect to agent instance with identifier 'akonadi_kolab_resource_0', error message: ''"
org.kde.pim.akonadiserver: "Cannot connect to agent instance with identifier 'akonadi_kolab_resource_0', error message: ''"
org.kde.pim.akonadiserver: "Cannot connect to agent instance with identifier 'akonadi_kolab_resource_0', error message: ''"
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`.`tagtable`, CONSTRAINT `tagtable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `tagtable` (`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`.`tagtable`, CONSTRAINT `tagtable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `tagtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
org.kde.pim.akonadiserver:   Query: "INSERT INTO TagTable (gid, typeId) VALUES (:0, :1)"
org.kde.pim.akonadiserver: Error during insertion into table "TagTable" "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`tagtable`, CONSTRAINT `tagtable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `tagtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
org.kde.pim.akonadicore: Error during TagSync:  "Failed to store tag" Akonadi::TagCreateJob
org.kde.pim.akonadicore: ItemFetch failed:  "Failed to store tag"
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`.`tagtable`, CONSTRAINT `tagtable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `tagtable` (`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`.`tagtable`, CONSTRAINT `tagtable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `tagtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
org.kde.pim.akonadiserver:   Query: "INSERT INTO TagTable (gid, typeId) VALUES (:0, :1)"
org.kde.pim.akonadiserver: Error during insertion into table "TagTable" "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`tagtable`, CONSTRAINT `tagtable_ibfk_1` FOREIGN KEY (`parentId`) REFERENCES `tagtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement"
org.kde.pim.akonadicore: Error during TagSync:  "Failed to store tag" Akonadi::TagCreateJob
org.kde.pim.akonadicore: ItemFetch failed:  "Failed to store tag"


I am not having problems that I think would be caused by this, but I am
afraid something is not working correctly which may have detrimental
effects that I am not aware of.

Kind regards,

Johannes