Barbieken Tux's lil' helper
Joined: 22 Mar 2014 Posts: 82
|
Posted: Fri Apr 27, 2018 8:13 am Post subject: [SOLVED] can't start akonadi after update |
|
|
Solved. It's teh case of mysql/mariadb database corruption.
Steps to fix:
- In console start mysql instance with config file of akonadi. Start with the current user, no root. replace [username] with the current user name.
/usr/sbin/mysqld --defaults-file=/home/[username]/.local/share/akonadi/mysql.conf --datadir=/home/[username]/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-[username].3yYywh/mysql.socket --pid-file=/tmp/akonadi-[username].3yYywh/mysql.pid
- In another console conect to the started instance with
mysql --defaults-file=/home/[username]/.local/share/akonadi/mysql.conf --socket=/tmp/[username]/mysql.socket
- in the mysql REPL do
use akonadi;
drop table parttable;
drop table schemaversiontable;
exit, close all consoles, start akonadi
After emerge @world akonady won't start wnymore. Kmail and other apps which depend on akonady don't work.
Code: |
onmimetyperelation OK
akonadi.collectionpimitemrelation OK
akonadi.collectiontable OK
akonadi.flagtable OK
akonadi.mimetypetable OK
akonadi.parttable
Error : Table 'akonadi.parttable' doesn't exist in engine
status : Operation failed
akonadi.parttypetable OK
akonadi.pimitemflagrelation OK
akonadi.pimitemtable OK
akonadi.pimitemtagrelation OK
akonadi.relationtable OK
akonadi.relationtypetable OK
akonadi.resourcetable OK
akonadi.schemaversiontable OK
akonadi.tagattributetable OK
akonadi.tagremoteidresourcerelationtable OK
akonadi.tagtable OK
akonadi.tagtypetable OK
Repairing tables
akonadi.parttable
Error : Table 'akonadi.parttable' doesn't exist in engine
status : Operation failed
org.kde.pim.akonadiserver: "\nSql error: Table 'akonadi.parttable' doesn't exist in engine QMYSQL: Unable to execute query\nQuery: ALTER TABLE PartTable ADD COLUMN id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY"
org.kde.pim.akonadiserver: Unable to initialize database.
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...
|
How can I fix this? I don't want to purge entire .config and I don't want to lose in kmail. |
|