Re: akonadi fsck fails

Daniel Vrátil <[email protected]> Tue, 25 Aug 2015 13:17:11 +0200
Newsgroups	gmane.comp.kde.users.pim
Message-ID	<1462275.jmlTL5Mh0g@thor>
On Tuesday, August 25, 2015 11:16:15 AM CEST J. Roeleveld wrote:
> On Monday, August 24, 2015 04:39:37 PM Daniel Vrátil wrote:
> > 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
> 
> Hi Dan,
> 
> Thank you for this reply.
> If you can point to where in the code this query is created, I could look
> into this issue.
> I, unfortunately, don't, currently, have the time to go through the entire
> codebase.

Sure. It's in akonadi.git, depending on if you are using 1.13 branch or 
Applications/15.08, the location is

1.13: server/src/storagejanitor.cpp
Applications/15.08, master: src/server/storagejanitor.cpp

the check that fails is in StorageJanitor::findOrphanedPimItemFlags()

Feel free to ask on [email protected] or #akonadi if you have any questions or 
need some help.

Cheers,
Dan

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

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