Bug#942431: akonadi-backend-mysql: Error during TagSync/ItemFetch faile: "Failed to store tag"
Package: akonadi-backend-mysql
Version: 4:18.08.3-5
Severity: normal
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
-- System Information:
Debian Release: 10.1
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable'), (15, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 4.19.0-6-amd64 (SMP w/16 CPU cores)
Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE= (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages akonadi-backend-mysql depends on:
ii default-mysql-client-core 1.0.5
ii default-mysql-server-core 1.0.5
ii libqt5sql5-mysql 5.11.3+dfsg1-1
ii mariadb-client-core-10.3 [virtual-mysql-client-core] 1:10.3.17-0+deb10u1
ii mariadb-server-core-10.3 [virtual-mysql-server-core] 1:10.3.17-0+deb10u1
Versions of packages akonadi-backend-mysql recommends:
ii akonadi-server 4:18.08.3-5
akonadi-backend-mysql suggests no packages.
-- no debconf information
Reply to: