Re: akonadi fsck fails

Daniel Vrátil <[email protected]> Mon, 24 Aug 2015 16:39:37 +0200

Newsgroups	gmane.comp.kde.users.pim
Message-ID	<1973336.s6nb9KWYxP@thor>

On Friday, August 21, 2015 9:16:51 AM CEST J. Roeleveld wrote:
> Hi all,
> 
> Not sure if this is the correct list to post this.
> 
> When I run "akonadictl fsck", I notice an error in the "akonadiserver.error"
> logfile showing a SQL-error.
> 
> The SQL that is used is over 100,000 characters long, with over 54,000
> variables that need to be loaded in during the execute-phase.
> 
> Is there a way to clean up the "PimItemFlagRelation" table manually to
> ensure this error stops?

Hi,

that's a known problem, the query is simply too large and MySQL refuses to 
execute it (same with PostgreSQL). I wouldn'd worry too much though - it does 
not mean that the database is corrupted or anything.  And since we use 
database constraints the PimItemFlagRelation table should not contain any 
orphaned records (this was added mostly for SQLite). It also does not affect 
the rest of fsck process, other checks are executed.

I should probably look at making the query saner, but that's not the top 
priority right now :)

Cheers,
Dan

> 
> Many thanks,
> 
> Joost Roeleveld

-- 
Daniel Vrátil
Email: [email protected]
Jabber: [email protected]
IRC: dvratil on Freenode (#kde, #kontact, #akonadi)

_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users

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