database error with akonadictl fsck

[Paul Vixie]

from time to time you have to burn down your kontact database and 
reinitialize it. your error below is a sign of such times.

1. stop kontact/kmail/etc.
2. stop akonadi.
3. remove (recursively) ~/.local/share/akonadi/*

note, at this point you will have no e-mail cached locally, and all your 
internal folder settings (trash, sent-mail, favorites) are gone.

4. start kontact/kmail/etc which will start akonadi. let it settle.
5. go into account settings. fix your trash, sent-mail, other folders.
6. decide what you want for favorite folders and restore those.

i do it twice a month. probably i should write a script for it.

also note, there's a way to use postgres instead of mysql, and while it 
is faster in general, it doesn't self-corrupt less often. so, i tried 
it, but it didn't really help, so i gave it up.

vixie

re:

Dominique Dumont wrote:
> Hi
>
> akonadictl fsck shows quite a lot of the following error message:
>
> org.kde.pim.akonadiserver: DATABASE ERROR:
> org.kde.pim.akonadiserver:   Error code: "1064"
> org.kde.pim.akonadiserver:   DB error:  "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PartTable.storage = 1 )' at line 1"
> org.kde.pim.akonadiserver:   Error text: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND PartTable.storage = 1 )' at line 1 QMYSQL: Unable to execute query"
> org.kde.pim.akonadiserver:   Query: "SELECT PartTable.id, PartTable.pimItemId, PartTable.partTypeId, PartTable.data, PartTable.datasize, PartTable.version, PartTable.storage FROM PartTable WHERE ( PartTable.pimItemId IN (  ) AND PartTable.storage = :0 )"
> Found duplicates 9048
>
> How can I fix this error ?
>
> Kontact is version 5.9.1 on Debian unstable.
>
> All the best
>
> Dod
>
>
>
>

-- 
P Vixie