KDE Akonadi crashes at startup

English Applications
1

I have been trying to get Akonadi running in KDE 4 but I have yet to get it to start up. I am running OpenSUSE 11.2 but saw the same problem with OpenSUSE 11.1 when I installed the factory KDE 4.3 support.

I have found only one other reference to this problem from a Kubuntu user but nothing was ever resolved.

I have cleared out everything under .config/akonadi and .local/share/akonadi and used the Akonadi control center app to re-initialize it. It makes no difference if I use the internal MySQL server or not.

If I run the test in the Akonadi Configuration in the control panel it dies at “Akonadi control process not registered at D-Bus.” The report says test 6 was skipped and test 9 fails:

Test 9: ERROR

Akonadi control process not registered at D-Bus.
Details: The Akonadi control process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.

Test 13: ERROR

Current Akonadi server error log found.
Details: The Akonadi server did report error during startup into <a href=‘/home/aaronw/.local/share/akonadi/akonadiserver.error’>/home/aaronw/.local/share/akonadi/akonadiserver.error</a>.

File content of ‘/home/aaronw/.local/share/akonadi/akonadiserver.error’:

"
0: akonadiserver(_Z11akBacktracev+0x39) [0x40b5c9]
1: akonadiserver [0x40bb12]
2: /lib64/libc.so.6 [0x7f7c9be01560]
3: /lib64/libc.so.6(gsignal+0x35) [0x7f7c9be014e5]
4: /lib64/libc.so.6(abort+0x180) [0x7f7c9be029b0]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f7c9cd76954]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c638]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x6e) [0x7f7c9ce00c5e]
8: /usr/lib64/libQtCore.so.4 [0x7f7c9ce0e9e9]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x7f7c9ce0fa18]
10: /usr/lib64/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x45) [0x7f7c9d3b5005]
11: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x1811) [0x7f7c9d3bc671]
12: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x69) [0x7f7c9d3be7d9]
13: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f7c9d3bf9fa]
14: akonadiserver(main+0x3a4) [0x4061e4]
15: /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f7c9bdeda7d]
16: akonadiserver [0x405d49]
]
"

If I try and start it manually I am able to see the following:

% akonadictl start
Starting Akonadi Server…
done.
aaronw@flash:~> [akonadiserver] Database process exited unexpectedly during initial connection!
[akonadiserver] executable: “/usr/sbin/mysqld”
[akonadiserver] arguments: (“–defaults-file=/home/aaronw/.local/share/akonadi//mysql.conf”, “–datadir=/home/aaronw/.local/share/akonadi/db_data/”, “–socket=/home/aaronw/.local/share/akonadi/db_misc/mysql.socket”)
[akonadiserver] stdout: “”
[akonadiserver] stderr: “091113 11:23:27 [ERROR] Wrong option to sql-mode. Option(s) given: strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
[akonadiserver] Alternatives are: ‘REAL_AS_FLOAT’,‘PIPES_AS_CONCAT’,‘ANSI_QUOTES’,‘IGNORE_SPACE’,‘?’,‘ONLY_FULL_GROUP_BY’,‘NO_UNSIGNED_SUBTRACTION’,‘NO_DIR_IN_CREATE’,‘POSTGRESQL’,‘ORACLE’,‘MSSQL’,‘DB2’,‘MAXDB’,‘NO_KEY_OPTIONS’,‘NO_TABLE_OPTIONS’,‘NO_FIELD_OPTIONS’,‘MYSQL323’,‘MYSQL40’,‘ANSI’,‘NO_AUTO_VALUE_ON_ZERO’,‘NO_BACKSLASH_ESCAPES’,‘STRICT_TRANS_TABLES’,‘STRICT_ALL_TABLES’,‘NO_ZERO_IN_DATE’,‘NO_ZERO_DATE’,‘ALLOW_INVALID_DATES’,‘ERROR_FOR_DIVISION_BY_ZERO’,‘TRADITIONAL’,‘NO_AUTO_CREATE_USER’,‘HIGH_NOT_PRECEDENCE’,‘NO_ENGINE_SUBSTITUTION’,‘PAD_CHAR_TO_FULL_LENGTH’
[akonadiserver] : Success
[akonadiserver] 091113 11:23:27 [ERROR] Aborting
[akonadiserver]
[akonadiserver] "
[akonadiserver] exit code: 1
[akonadiserver] process error: “Unknown error”
[akonadiserver] "
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b5c9]
[akonadiserver] 1: akonadiserver [0x40bb12]
[akonadiserver] 2: /lib64/libc.so.6 [0x7f4fca435560]
[akonadiserver] 3: /lib64/libc.so.6(gsignal+0x35) [0x7f4fca4354e5]
[akonadiserver] 4: /lib64/libc.so.6(abort+0x180) [0x7f4fca4369b0]
[akonadiserver] 5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f4fcb3aa954]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c638]
[akonadiserver] 7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x6e) [0x7f4fcb434c5e]
[akonadiserver] 8: /usr/lib64/libQtCore.so.4 [0x7f4fcb4429e9]
[akonadiserver] 9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x7f4fcb443a18]
[akonadiserver] 10: /usr/lib64/libakonadiprivate.so.1(_ZN6QDebugD1Ev+0x45) [0x7f4fcb9e9005]
[akonadiserver] 11: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer20startDatabaseProcessEv+0x1811) [0x7f4fcb9f0671]
[akonadiserver] 12: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x69) [0x7f4fcb9f27d9]
[akonadiserver] 13: /usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f4fcb9f39fa]
[akonadiserver] 14: akonadiserver(main+0x3a4) [0x4061e4]
[akonadiserver] 15: /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f4fca421a7d]
[akonadiserver] 16: akonadiserver [0x405d49]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application ‘akonadiserver’ returned with exit code 255 (Unknown error)
[akonadiserver] Database process exited unexpectedly during initial connection!
[akonadiserver] executable: “/usr/sbin/mysqld”
[akonadiserver] arguments: (”–defaults-file=/home/aaronw/.local/share/akonadi//mysql.conf", “–datadir=/home/aaronw/.local/share/akonadi/db_data/”, “–socket=/home/aaronw/.local/share/akonadi/db_misc/mysql.socket”)
[akonadiserver] stdout: “”
[akonadiserver] stderr: "091113 11:23:27 [ERROR] Wrong option to sql-mode. Option(s) given: strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
[akonadiserver] Alternatives are: ‘REAL_AS_FLOAT’,‘PIPES_AS_CONCAT’,‘ANSI_QUOTES’,‘IGNORE_SPACE’,‘?’,‘ONLY_FULL_GROUP_BY’,‘NO_UNSIGNED_SUBTRACTION’,‘NO_DIR_IN_CREATE’,‘POSTGRESQL’,‘ORACLE’,‘MSSQL’,‘DB2’,‘MAXDB’,‘NO_KEY_OPTIONS’,‘NO_TABLE_OPTIONS’,‘NO_FIELD_OPTIONS’,‘MYSQL323’,‘MYSQL40’,‘ANSI’,‘NO_AUTO_VALUE_ON_ZERO’,‘NO_BACKSLASH_ESCAPES’,‘STRICT_TRANS_TABLES’,‘STRICT_ALL_TABLES’,‘NO_ZERO_IN_DATE’,‘NO_ZERO_DATE’,‘ALLOW_INVALID_DATES’,‘ERROR_FOR_DIVISION_BY_ZERO’,‘TRADITIONAL’,‘NO_AUTO_CREATE_USER’,‘HIGH_NOT_PRECEDENCE’,‘NO_ENGINE_SUBSTITUTION’,‘PAD_CHAR_TO_FULL_LENGTH’
[akonadiserver] : Success
[akonadiserver] 091113 11:23:27 [ERROR] Aborting
[akonadiserver]

Here’s a copy of .config/akonadi/akonadiserverrc:

[QMYSQL]
StartServer=true
ServerPath=/usr/sbin/mysqld
Name=akonadi
Host=
User=
Password=
Options=“UNIX_SOCKET=/home/aaronw/.local/share/akonadi/db_misc/mysql.socket”

%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

Here’s .local/share/akonadi/mysql.conf:

[QMYSQL]
StartServer=true
ServerPath=/usr/sbin/mysqld
Name=akonadi
Host=
User=
Password=
Options=“UNIX_SOCKET=/home/aaronw/.local/share/akonadi/db_misc/mysql.socket”

%General]
Driver=QMYSQL
SizeThreshold=4096
ExternalPayload=false

2

Here we are years later and I am having the same or a similar problem in which akonadi won’t start or crashes at startup. I noticed this never got answered… I’m seriously thinking of ditching my efforts to use Kontakt and Kmail if there’s no support

3

I never had a problem with this, and I’m using the akonadified KMail since version 4.7 beta.

Can you post the akonadi self test?

Maybe try to remove the akonadi database and server configuration, i.e. the folders ~/.config/akonadi/ and ~/.local/share/akaonadi/ and try to start it again.

PS: The OP is from 2009, I doubt it makes any sense to debug his problem now.
I hope it’s been solved in the meantime.