Re: SQL errors running akonadi fsck/vacuum

Daniel Vrátil <[email protected]> Wed, 20 Mar 2019 12:38:32 +0100

Newsgroups	gmane.comp.kde.users.pim
Message-ID	<1613075.UQgxmLvFx2@brokkr>

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

signature.asc (application/pgp-signature, 488 B)