SQL errors running akonadi fsck/vacuum
Joshua J. Kugler
joshua at joshuakugler.com
Tue Mar 19 16:42:22 GMT 2019
I'm trying to run akonadi fsck and vacuum, and am seeing a lot of these in the
output:
Found duplicates 1429184580.R736.hosanna
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver: Error code: "1064"
org.kde.pim.akonadiserver: DB error: "You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near ') AND PartTable.storage = 1 )' at line 1"
org.kde.pim.akonadiserver: Error text: "You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near ') AND PartTable.storage = 1 )' at line 1 QMYSQL:
Unable to execute query"
org.kde.pim.akonadiserver: Query: "SELECT PartTable.id, PartTable.pimItemId,
PartTable.partTypeId, PartTable.data, PartTable.datasize, PartTable.version,
PartTable.storage FROM PartTable WHERE ( PartTable.pimItemId IN ( ) AND
PartTable.storage = :0 )"
akonadi-backend-mysql 4:17.12.3-0ubuntu3
akonadi-server 4:17.12.3-0ubuntu3
mysql-server-core-5.7 5.7.25-0ubuntu0.18.04.2
What is the best way to go about debugging this?
Thanks!
j
--
Joshua J. Kugler -- Fairbanks, AK
Blogs: http://jjncj.com/blog/ (Family) -- http://joshuakugler.com (Geek)
Philippians 2:9-11
More information about the kdepim-users
mailing list