SQL errors running akonadi fsck/vacuum

[Daniel Vrátil]

Hi Joshua,

On Tuesday, March 19, 2019 5:42:22 PM CET Joshua J. Kugler wrote:
> 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 )"
		                 ^
                                        This here looks like the problem

Would you mind opening a bug report on bugs.kde.org and attaching this log 
output?

Thanks,
Dan

> 
> 
> 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kdepim-users/attachments/20190320/ee5c8b54/attachment.sig>