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