Complete lockup in KMail

[Russ Kepler]

On Tuesday, January 3, 2017 7:46:18 AM MST Peter Humphrey wrote:
> Hello lists,
> 
> Now I'm completely stuck. I have a duplicate pair of messages in my Gentoo-
> User folder that cannot be retrieved from the database. There's no sign of
> them in the ~/.local/share/local-mail/.Linux.directory/Gentoo-User
> directory. I've tried to delete them in KMail. I've tried using
> akonadiconsole to identify them, and to move them to another folder - but it
> was only showing four messages from months ago. I don't know how to use
> akonadiconsole to fiddle with the database.
> 
> How can I get rid of this duplication? Until I do I can't make archive
> backups or even read e-mails.
> 
> This is kde-apps/kmail-16.12.0-r1.

I was stuck recently after a semi-failed upgrade.  After messing with the 
akonadi database for a few hours I finally just shut akonadi down ('akonadictl 
stop'), removed ~/.local/share/akonadi ('rm ~/.local/share/akonadi') followed 
by a start ('akonadictl start').  The start will see that the database is gone 
and rebuild it from scratch.

I ran into some strangeness - the filters all lost their destination folders, 
the order of the folders was off (only really mattered for the pre-defined 
ones, I think some code uses the index rather than the name) and maybe some 
other stuff.  But it was a lot faster that my messing with trying to manually 
mount and upgrade the mysql db.