database error with akonadictl fsck
paul at redbarn.org
Mon Oct 15 13:44:30 BST 2018
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.
Dominique Dumont wrote:
> 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
More information about the kdepim-users