corrupted akonadi database can't be repaired
Posted: May 17th, '18, 04:48
The great update buggered my kmail installation; I lost my access to a gmail account that I use for work. I went through the process to reinstall it, and did not succeed; the folders in the left panel simply did not appear although all the steps in accessing gmail and obtaining a valid token seem to have gone properly. I have 2FA activated on the gmail account, which forces me to use their oauth system; I can't just use a normal password.
After wrestling with this for awhile and never getting the folders to appear in the left pane, I started fiddling with akonadictl. I ran "akonadictl fsck" and it cleaned up a lot of things, but also left me with this:
There are three such errors listed. Looks like akonadictl has not kept up with mariadb.
Any suggestions about how to proceed?
As an aside, I have been sufficiently pissed off with kmail that I downloaded evolution and was going to try a migration to it. However, I got killed by the same webkit problem that is preventing me from starting drakconf; evolution won't start.
sigh.
After wrestling with this for awhile and never getting the folders to appear in the left pane, I started fiddling with akonadictl. I ran "akonadictl fsck" and it cleaned up a lot of things, but also left me with this:
- Code: Select all
PartTable.storage FROM PartTable WHERE ( PartTable.pimItemId IN ( ) AND PartTable.storage = :0 )"
Found duplicates 1387742194.R544.Dadsbox:2,S
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 MariaDB 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 MariaDB server version for the right syntax to use near ') AND PartTable.storage = 1 )' at line 1 QMYSQL: Unable to execute query"
There are three such errors listed. Looks like akonadictl has not kept up with mariadb.
Any suggestions about how to proceed?
As an aside, I have been sufficiently pissed off with kmail that I downloaded evolution and was going to try a migration to it. However, I got killed by the same webkit problem that is preventing me from starting drakconf; evolution won't start.
sigh.