Akonadi server is broken after mysql update

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

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

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.

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

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

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...

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...