Today after a major update Akonadi does not start any more.
I wanted to past the whole Akonadi self check log but it was even after editing out repetitive info to long to publish. I hope this short log will give an indication about what’s up. Otherwise I will give the whole report an other try.
Does anyone have an idea what might have gone wrong here?
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld"
arguments: ("--defaults-file=/home/me/.local/share/akonadi/mysql.conf", "--datadir=/home/me/.local/share/akonadi/db_data/", "--socket=/home/me/.local/share/akonadi/socket-linux-zb0m.site/mysql.socket")
stdout: ""
stderr: "2013-06-06 15:54:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
"
exit code: 7
process error: "Process operation timed out"
"
0: akonadiserver(_Z11akBacktracev+0x35) [0x8098195]
1: akonadiserver() [0x80984da]
2: linux-gate.so.1(__kernel_sigreturn+0) [0xb7761400]
3: /lib/libc.so.6(gsignal+0x45) [0xb6e12245]
4: /lib/libc.so.6(abort+0x143) [0xb6e13ac3]
5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8e) [0xb749fe6e]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xd8) [0x809a298]
7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xe8) [0xb7547e58]
8: /usr/lib/libQtCore.so.4(+0x11729d) [0xb755429d]
9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3e) [0xb755d48e]
10: akonadiserver(_ZN13DbConfigMysql19startInternalServerEv+0x18c2) [0x8115732]
11: akonadiserver(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0xe1) [0x809afa1]
12: akonadiserver(_ZN7Akonadi13AkonadiServerC1EP7QObject+0xc6) [0x809bee6]
13: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x46) [0x809d5c6]
14: akonadiserver(main+0x137) [0x8091ee7]
15: /lib/libc.so.6(__libc_start_main+0xf5) [0xb6dfd525]
16: akonadiserver() [0x8092821]
Thanks!
Try to rename the folder /home/me/.local/share/akonadi/db_data/ and see if it helps…
Yes, I tried that too. but it just makes a new db folder. I have also tried to reinstall Kmail. This does not work either.
Kontact works and shows Akregator but KOrganizer and other Akonadi related programs just do not show up.
I have been using 12.3 almost from its release but this is the first time this happens.
Yes, that’s expected. Akonadi keeps its cache there.
I thought maybe that cache has been corrupted somehow so removing it would have fixed that.
I have also tried to reinstall Kmail. This does not work either.
Right, because akonadi does not work. You could try to reinstall the package “akonadi-runtime”
But on Linux you can’t normally solve problems by reinstalling an application… 
Kontact works and shows Akregator but KOrganizer and other Akonadi related programs just do not show up.
Akregator does not use akonadi (yet), that’s why it still works.
I have been using 12.3 almost from its release but this is the first time this happens.
It works fine here on my 12.3 system.
You could also try to delete /home/me/.local/share/akonadi/mysql.conf and /home/me/.config/akonadi/akonadiserverrc .
And are you using mysql or mariadb?
rpm -qa |egrep "mysql|maria"
Most of the time phenomena like this are caused by KDE packages not coming from one and the same repo. Please post output of
zypper lr -d
Question: did you by any means ignore dependency errors on the KDE update?
I haven’t seen the issue in 12.3, nor Tumbleweed, both latest KDE from the Release repo
OK, here is what I did.
Wolfi mentioned about the db servers, something I had been thinking about too.
I was using mysql and decided tot try if installing Mariadb would do the job.
And indeed after de-installing mysql and installing Maria and reboot everything seems to be working fine.
Guess mysql got corrupted somehow.
Thanks everybody for your help!!! :shake:
or it is this issueRe: The akonadi personal management service is not runningFri Jun 28, 2013 8:46 am
I found the solution is:
Rename table_cache to table_open_cache (I did this in my in ~/.local/share/akonadi/mysql.conf)
as table_cache is deprecated since MySQL 5.1.3 (released in Nov. 2005) and was completely removed in MySQL >= 5.6
https://bugs.kde.org/show_bug.cgi?id=319016#c2
kde thread:
http://forum.kde.org/viewtopic.php?f=215&t=111704&p=267451&hilit=+akonadi+mysql#p267451](http://forum.kde.org/viewtopic.php?f=215&t=111704&p=267451&hilit=+akonadi+mysql#p267451)