Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[SOLVED] can't start akonadi after update
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Desktop Environments
View previous topic :: View next topic  
Author Message
Barbieken
n00b
n00b


Joined: 22 Mar 2014
Posts: 62

PostPosted: Fri Apr 27, 2018 8:13 am    Post subject: [SOLVED] can't start akonadi after update Reply with quote


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:
akonadictl start



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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Desktop Environments All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum