Akonadi server is broken after mysql update

[uszatan]

After recent updates, i cannot longer use the Akonadi services - it is failing during the start process with following error message:

search paths: ("/home/piotrek/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: "/usr/bin/mysql_install_db"
Found mysqlcheck: "/usr/bin/mysqlcheck"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/piotrek/.local/share/akonadi/mysql.conf", "--datadir=/home/piotrek/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-piotrek.1jfWsZ/mysql.socket")
stdout: ""
stderr: "2015-04-17 10:12:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x418c8a]
1: akonadiserver() [0x418f04]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x352f0) [0x7fbbcbb662f0]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37) [0x7fbbcbb66267]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7fbbcbb67eca]
5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x12a) [0x7fbbcd390a8a]
6: akonadiserver() [0x41ad0d]
7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8a) [0x7fbbcd43030a]
8: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x121155) [0x7fbbcd440155]
9: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) [0x7fbbcd448ab1]
10: akonadiserver() [0x48235e]
11: akonadiserver() [0x41b90f]
12: akonadiserver() [0x41dff8]
13: akonadiserver() [0x4e2e49]
14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x1e1) [0x7fbbcd4bf891]
15: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8d) [0x7fbbcd4a617d]
16: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x231) [0x7fbbcd4a9a21]
17: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1b669e) [0x7fbbcd4d569e]
18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x24d) [0x7fbbcb22ec3d]
19: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49f20) [0x7fbbcb22ef20]
20: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fbbcb22efcc]
21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x7e) [0x7fbbcd4d580e]
22: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x41) [0x7fbbcd4a4cd1]
23: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1a5) [0x7fbbcd4a5035]
24: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x99) [0x7fbbcd4aaab9]
25: akonadiserver() [0x4131b5]
26: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7fbbcbb51a40]
27: akonadiserver(_start+0x29) [0x413be9]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[RussianNeuroMancer (russianneuromancer)]

Workaround that help me: https://www.kubuntuforums.net/showthread.php?67801-Kontact-Reports-that-Akonadi-in-not-Operational&p=370725&viewfull=1#post370725

[uszatan (belniak)]

I have another solution:
- 1st i run update:
sudo aptitude update
when it is done then:
sudo aptitude purge mysql-server-core-5.6 mysql-client-core-5.6
aptitute will tell it has many dependencies, many packages will be removed ... so it asks if i accept that solution - choose no (n)
then it will propose installing:

1) mariadb-client-core-10.0 [10.0.17-0ubuntu1 (vivid)]
2) mariadb-common [10.0.17-0ubuntu1 (vivid)]
3) mariadb-server-core-10.0 [10.0.17-0ubuntu1 (vivid)]

- if you accept this - mysql will be removed, mariadb (fork of mysql) will be installed, and akonadi will start without any issues.

[Félim Whiteley (felimwhiteley)]

Thank you uszatan I had the same issue and your fix worked perfectly. Many thanks.

[O. Sinclair (o-sinclair)]

Thanks to Usztan, I did this on 14.10 with MySQL 5.5 and feel that KMail and so on are definitely "snappier" since

[Richard Johnson (rmchard)]

Just did the conversion to mariadb and still have the same issue.
Kubuntu 15.10 (daily 10/12/2015)

Trying the next suggested workaround.

$ akonadictl start
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
richard@minerva:~/.kde/share/apps/kwallet$ search paths: ("/home/richard/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: ""
Found mysqlcheck: "/usr/bin/mysqlcheck"
Database process exited unexpectedly during initial connection!
executable: "/usr/sbin/mysqld-akonadi"
arguments: ("--defaults-file=/home/richard/.local/share/akonadi/mysql.conf", "--datadir=/home/richard/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-richard.8Wt1OV/mysql.socket")
stdout: ""
stderr: "151012 19:40:37 [Note] /usr/sbin/mysqld (mysqld 10.0.20-MariaDB-0ubuntu0.15.04.1) starting as process 10038 ...
"
exit code: 1
process error: "Unknown error"
"[
0: akonadiserver() [0x57e2f6]
1: akonadiserver() [0x57e61e]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x352f0) [0x7f2d4b28d2f0]
3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37) [0x7f2d4b28d267]
4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f2d4b28eeca]
5: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_Z17qt_message_output9QtMsgTypeRK18QMessageLogContextRK7QString+0x185) [0x7f2d4bc4b3d5]
6: akonadiserver() [0x580c1c]
7: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN9QIODevice5writeEPKcx+0x10b) [0x7f2d4bd6649b]
8: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(+0x1bca26) [0x7f2d4bd77a26]
9: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN11QTextStreamD2Ev+0x11b) [0x7f2d4bd77c6b]
10: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN6QDebugD1Ev+0x3f) [0x7f2d4bd48bdf]
11: akonadiserver() [0x4974ea]
12: akonadiserver() [0x420b09]
13: akonadiserver() [0x422177]
14: akonadiserver() [0x503289]
15: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN7QObject5eventEP6QEvent+0xf1) [0x7f2d4be6e651]
16: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0xbc) [0x7f2d4be3cefc]
17: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x2c7) [0x7f2d4be3f057]
18: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(+0x2d8e73) [0x7f2d4be93e73]
19: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x2a7) [0x7f2d49cb0ff7]
20: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x4a250) [0x7f2d49cb1250]
21: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f2d49cb12fc]
22: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0x7f2d4be9427f]
23: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x10a) [0x7f2d4be3a75a]
24: /usr/lib/x86_64-linux-gnu/libQt5Core.so.5(_ZN16QCoreApplication4execEv+0x9c) [0x7f2d4be422cc]
25: akonadiserver() [0x41fa79]
26: /lib/x86_64-linux-gnu/libc.so...

[Richard Johnson (rmchard)]

Follow-up to previous note:

as suggested here:
https://www.kubuntuforums.net/showthread.php?67801-Kontact-Reports-that-Akonadi-in-not-Operational&p=370725&viewfull=1#post370725

I removed the two files
~/.local/share/akonadi/db_data/ib_logfile0
and ~/.local/share/akonadi/db_data/ib_logfile1

The result follows. It started the db but is missing a table. I will continue to look for old config files that seem to confuse it.

$ akonadictl start
Starting Akonadi Server...
   done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
richard@minerva:~/.local/share/akonadi/db_data$ search paths: ("/home/richard/bin", "/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin")
Found mysql_install_db: ""
Found mysqlcheck: "/usr/bin/mysqlcheck"
akonadi.collectionattributetable OK
akonadi.collectionmimetyperelation OK
akonadi.collectionpimitemrelation OK
akonadi.collectiontable OK
akonadi.flagtable OK
akonadi.mimetypetable OK
akonadi.parttable OK
akonadi.parttypetable OK
akonadi.pimitemflagrelation OK
akonadi.pimitemtable OK
akonadi.pimitemtagrelation OK
akonadi.relationtable
Error : Table 'akonadi.relationtable' doesn't exist in engine
status : Operation failed
akonadi.relationtypetable
Error : Table 'akonadi.relationtypetable' doesn't exist in engine
status : Operation failed
akonadi.resourcetable OK
akonadi.schemaversiontable OK
akonadi.tagattributetable OK
akonadi.tagremoteidresourcerelationtable OK
akonadi.tagtable OK
akonadi.tagtypetable OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mys...