[Karmic] akonadiserver: Database process exited unexpectedly during initial connection

[FriedChicken]

On starting kopete akonadiserver fails loading and blocks kopete:

$ kopete
[akonadiserver] Database process exited unexpectedly during initial connection!
[akonadiserver] executable: "/usr/sbin/mysqld-akonadi"
[akonadiserver] arguments: ("--defaults-file=/home/dominic/.local/share/akonadi//mysql.conf", "--datadir=/home/dominic/.local/share/akonadi/db_data/", "--socket=/home/dominic/.local/share/akonadi/db_misc/mysql.socket")
[akonadiserver] stdout: ""
[akonadiserver] stderr: "091024 14:40:12 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
[akonadiserver] 091024 14:40:12 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages,
[akonadiserver] but it should contain at least 637 error messages.
[akonadiserver] Check that the above file is the right version for this program!
[akonadiserver] "
[akonadiserver] exit code: 1
[akonadiserver] process error: "Process operation timed out"
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x35) [0x8051f25]
[akonadiserver] 1: akonadiserver [0x80523f6]
[akonadiserver] 2: [0x7b9400]
[akonadiserver] 3: [0x7b9422]
[akonadiserver] 4: /lib/tls/i686/cmov/libc.so.6(gsignal+0x51) [0x34f4d1]
[akonadiserver] 5: /lib/tls/i686/cmov/libc.so.6(abort+0x182) [0x352932]
[akonadiserver] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x8c) [0x8eef8c]
[akonadiserver] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8052f54]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x85) [0x9810d5]
[akonadiserver] 9: /usr/lib/libQtCore.so.4 [0x98fed5]
[akonadiserver] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x991298]
[akonadiserver] 11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804dbf3]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x1ab8) [0xd3ea48]
[akonadiserver] 13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x70) [0xd41030]
[akonadiserver] 14: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xd423c8]
[akonadiserver] 15: akonadiserver(main+0x362) [0x804d032]
[akonadiserver] 16: /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0x33bb56]
[akonadiserver] 17: akonadiserver [0x804cc01]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database process exited unexpectedly during initial connection!
   [... two times loading fails again ...]
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!

ProblemType: Bug
Architecture: i386
Date: Sat Oct 24 14:22:48 2009
DistroRelease: Ubuntu 9.10
NonfreeKernelModules: nvidia
Package: akonadi-server 1.2.1-0ubuntu3
ProcEnviron:
 LANGUAGE=de_DE:de:en_GB:en
 LANG=de_DE.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-14.48-386
SourcePackage: akonadi
Uname: Linux 2.6.31-14-386 i686
XsessionErrors: (polkit-gnome-authentication-agent-1:2729): GLib-CRITICAL **: g_once_init_leave: assertion `initialization_value != 0' failed

[FriedChicken (domlyons)]

Forgot to mention: AppArmor is disabled

[Markus Strobl (mstrobl2)]

Same problem here after upgrading to Karmic. Problem is caused by Jaunty installing sql 5.0 but not selecting the MySql meta package. Therefore MySql is not updated to 5.1 during the upgrade to Karmic and Akonadi fails to start.

Simple selecting the mysql-server package will fix the problem. MySql is then updated to 5.1 and akonadi works.

I think the proper fix for this bug would be for the Karmic upgrade manager to ensure the mysql-server meta package has been selected.

BTW, this was the ONLY issue I had with the Karmic upgrade on my eee-pc. Karmic is great!!! Thanks to all the developers!!!

[FriedChicken (domlyons)]

Yes, this helped me, too. So it seems to be a missing or wrong depenency.

[Jonathan Thomas (echidnaman)]

We are really in a tough spot here. Forcing 5.1 is not nice for those people who need mysql 5.0 installed, but apparently akonadi really does need 5.1.

[Launchpad Janitor (janitor)]

This bug was fixed in the package akonadi - 1.2.1-0ubuntu4

---------------
akonadi (1.2.1-0ubuntu4) karmic; urgency=low

  * Revert previous upload (LP: #418342). Apparently Akonadi
    does not like being used with MySQL 5.0. This is probably
    because both Qt and Akonadi are built against 5.1, and the
    5.1 libraries are apparently unable to access a 5.0 server
    part. (LP: #459741)

 -- Harald Sitter <email address hidden> Mon, 26 Oct 2009 11:11:44 +0100

[Patrick Cornelissen (patrickcornelissen)]

I cleaned my akonadi settings upgraded to the new package and run kontact.
At first it complained and showed problems in the dbus registration too but after the migration assistant kicked it it worked!

[bartosz maciaszek (sickboyek)]

It works for me as well (both kopete and korganizer). Just upgraded akonadi-server.
Thanks!

[kelvalok (kelvalok)]

I can confirm this too: installing mysql-server-core-5.1 solves the problem,
thanks,
K.

[Adric Riedel (adric-riedel)]

Confirmed the solution: Install mysql-server-core-5.1

Problem seems to be solved.