[Kde-pim] How to Archive Folder in kmail when when database is corrupted?

Sat Jan 10 19:07:20 GMT 2015

>
> First: The database should not get corrupted due to a migration.
> Whether the database has any issue could be determined by looking at logs.
> Look for anything special in
> - ~/.xsession-errors
> - ~/.local/share/akonadi/db_data/mysql.err
> - ~/.local/share/akonadi/akonadi*.log
>
I do not have anything from above, but I have:
.local/share/akonadi/akonadiserver.error
ItemRetrieverException : Unable to retrieve item from resource:
<html>Invalid item retrieved</html>
ItemRetrieverException : Unable to retrieve item from resource:
<html>Invalid item retrieved</html>

> In case of inconsistencies
> akonadictl fsck
> may help
> (but make a backup of your setup first!)

How to make a backup?

> You didn´t write what type of account you use. If its POP3, mails should
> all
> be in a local maildir. Where is likely visible within:
> martin at merkaba:~/.kde/share/config> cat akonadi_maildir_resource_0rc
> [General]
> Path[$e]=$HOME/.local/share/local-mail
> TopLevelIsContainer=true
>
I use POP3 and know its I am trying to solve it from a year ago:
https://forum.kde.org/viewtopic.php?f=215&t=117689
and admin form kde forum advised me to contact KDE PIM developer

But have a look on this:

You have some listings bellow. And you can see, there are some strange
things here - it means folders and files in file-system in some places are
different than in kmail.

First example bellow - listing of (.local-mail). As you can see (listing
1), there is .sent-mail.directory. I keep there (in kmail, in sent-mail
folder) my all old emails form last years, every year in one folder - 2006,
2007, 2008... (listing 2). In listing 3 you can see whats inside 2006
folder, but all of subfolder of 2006 (cur, new, temp) are empty. Even du
command says they are empty (see listing 4), but in compare du command for
2007 folder (see listing 5) says there is 53M of messages (instead of 4.3k
for 2006). In reality, in kmail in sent-mail/2006 folder there are 504
emails! Even akonadi console says so (should be 8.5M of messages):
http://img837.imageshack.us/img837/3773/livu.jpg
So where are those emails in real file system if 2006 folder is empty?

 I have some other examples like that - eg. I have a folder (in kmail) with
5 subfolder, and 100's other sub-sub-folder and over 1000's emails - but in
file system (.inbox.directory) the same folder is empty, there is nothing
appart empty (cur, new, temp) folders. Rest of system looks fine this just
happed for few folder and few thousands emails. So this is reason I thinks
there something wrong with data base.

Listing 1
~/.local/share/local-mail $ ls -la
total 48
drwxr-xr-x 12 me me 4096 Apr  7 09:07 .
drwxr-xr-x 18 me me 4096 Sep 30 22:03 ..
drwxr-xr-x  5 me me 4096 Apr  7 09:07 drafts
drwxr-xr-x  5 me me 4096 Feb 11  2013 import
drwxr-xr-x  4 me me 4096 Feb 12  2013 .import.directory
drwxr-xr-x  5 me me 4096 Feb 10  2013 inbox
drwxr-xr-x 25 me me 4096 Sep 27 23:04 .inbox.directory
drwxr-xr-x  5 me me 4096 Feb 10  2013 outbox
drwxr-xr-x  5 me me 4096 Feb 10  2013 sent-mail
drwxr-xr-x 10 me me 4096 Feb 12  2013 .sent-mail.directory
drwxr-xr-x  5 me me 4096 Apr  7 09:07 templates
drwxr-xr-x  5 me me 4096 Apr  7 09:07 wastebin

Listing 2
$ ls -la
total 40
drwxr-xr-x 10 me me 4096 Feb 12  2013 .
drwxr-xr-x 12 me me 4096 Apr  7 09:07 ..
drwxr-xr-x  5 me me 4096 Feb 12  2013 2006

drwxr-xr-x  5 me me 4096 Feb 12  2013 2007
drwxr-xr-x  5 me me 4096 Feb 12  2013 2008
drwxr-xr-x  5 me me 4096 Feb 12  2013 2009
drwxr-xr-x  5 me me 4096 Feb 12  2013 2010
drwxr-xr-x  5 me me 4096 Feb 12  2013 2011
drwxr-xr-x  5 me me 4096 Feb 12  2013 2012
drwxr-xr-x  5 me me 4096 Feb 11  2013 2013

Listing 3
~/.local/share/local-mail/.sent-mail.directory/2006 $ ls -la
total 20
drwxr-xr-x  5 me me 4096 Feb 12  2013 .
drwxr-xr-x 10 me me 4096 Feb 12  2013 ..
drwxr-xr-x  2 me me 4096 Feb 12  2013 cur
drwxr-xr-x  2 me me 4096 Feb 12  2013 new
drwxr-xr-x  2 me me 4096 Feb 12  2013 tmp

Listing 4
~/.local/share/local-mail/.sent-mail.directory/2006 $ du --si
4.1k    ./cur
4.1k    ./tmp
4.1k    ./new
17k     .

Listing 5
~/.local/share/local-mail/.sent-mail.directory/2007 $ du --si
4.1k    ./cur
4.1k    ./tmp
53M     ./new
53M     .
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/