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

Martin Steigerwald Martin at lichtvoll.de
Wed Jan 14 11:27:21 GMT 2015 

Am Samstag, 10. Januar 2015, 19:07:20 schrieb Vylaern Vylaern:
> > 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>

I did not yet see these. I usually see this "Unable to retrieve item from 
resource" with "timeout" as explaination. In the status line of the KMail 
window KMail displays it.

I think that for Akonadi Next such a error message will have to go.

Cause it doesn´t explain whats wrong in a way that a user could act upon IMHO.

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

Safe:

Backup your complete home directory.


Maybe incomplete:
- Backup ~/.local/share/local-mail (this is important, cause this is the 
primary storage of your mail).
- Backup ~/.local/share/akonadi (in there is a file_db_data which mail also 
contain mail files and also in database it may cache small files, these may or 
may not yet saved into your local maildirs)
- Backup ~/.config/akonadi
- Backup ~/.kde, specifically ~/.kde/share/config/(kmail*|akonadi*) and likely 
others
- Backup your calender and other locally stored resource data. See the config 
files in ~/.kde/share/config/akonadi* for where they locate their data. The 
calender uses a std.ics file in ~/.kde/share/apps/kabc I think. I use a 
calender directory since a long time and put it into ~/.local/share/calendar


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

I see. My medium is mail tough, so.

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

Did you really make sure you looked into the right folder? Is the folder 
supposed to be empty?

And note: Akonadi may still have kept some mails in file_db_data. It should 
eventually save them out for the local maildir locations, but up to know I do 
not know when it does so.

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

Well, I suggest

find ~/.local/share/local-mail | less

and

find ~/.local-mail.directory | less 

(the latter is empty there, just a few dirs).

Ciao,
-- 
Martin 'Helios' Steigerwald - http://www.Lichtvoll.de
GPG: 03B0 0D6C 0040 0710 4AFA  B82F 991B EAAC A599 84C7
_______________________________________________
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/

More information about the kde-pim mailing list