[Bug 851577] New: akonadi fails to start after 12.3 to 13.1 upgrade
https://bugzilla.novell.com/show_bug.cgi?id=851577 https://bugzilla.novell.com/show_bug.cgi?id=851577#c0 Summary: akonadi fails to start after 12.3 to 13.1 upgrade Classification: openSUSE Product: openSUSE 13.1 Version: Final Platform: Other OS/Version: openSUSE 13.1 Status: NEW Severity: Normal Priority: P5 - None Component: KDE4 Workspace AssignedTo: kde-maintainers@suse.de ReportedBy: fisiu@opensuse.org QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux i686; rv:25.0) Gecko/20100101 Firefox/25.0 I use system mariadb instance as akonadi backend. I migrated from embeded mysql after 12.3 install. It worked really well so far. But after zypper dup from 12.3 to 13.1 akonadi fails to start. It looks like, akonadi is looking for a new table names in CamelCase scheme, while the old ones are named with lowercase scheme. Here is akonadictl start output: fisiu@pendrak ~ $ akonadictl start fisiu@pendrak ~ $ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) search paths: ("/opt/java/latest7/bin", "/home/fisiu/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/android/android-sdk-linux/tools", "/opt/android/android-sdk-linux/platform-tools", "/opt/java/maven/apache-maven/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work. " Sql error: Table 'akonadi.SchemaVersionTable' doesn't exist QMYSQL: Unable to execute query Query: ALTER TABLE SchemaVersionTable ADD COLUMN version INTEGER NOT NULL DEFAULT 0" Unable to initialize database. "[ 0: akonadiserver(_Z11akBacktracev+0x35) [0x80966d5] 1: akonadiserver() [0x8096991] 2: linux-gate.so.1(__kernel_sigreturn+0) [0xb779f400] 3: linux-gate.so.1(__kernel_vsyscall+0x10) [0xb779f424] 4: /lib/libc.so.6(gsignal+0x46) [0xb6e0c6a6] 5: /lib/libc.so.6(abort+0x143) [0xb6e0de33] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x7d) [0xb74f308d] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8098a74] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7597d68] 9: /usr/lib/libQtCore.so.4(+0x114fde) [0xb75a5fde] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb75af6c5] 11: akonadiserver(_ZN7Akonadi13AkonadiServer4initEv+0x62c) [0x809b98c] 12: /usr/lib/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb761f3da] 13: /usr/lib/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb76272bb] 14: /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb760e1b0] 15: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb760e214] 16: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb760dfba] 17: /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1d5) [0xb76112e5] 18: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb761180c] 19: /usr/lib/libQtCore.so.4(+0x1ace0e) [0xb763de0e] 20: /usr/lib/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6ce77ce] 21: /usr/lib/libglib-2.0.so.0(+0x49b78) [0xb6ce7b78] 22: /usr/lib/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6ce7c38] 23: /usr/lib/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb763d5ef] 24: /usr/lib/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb760ca03] 25: /usr/lib/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb760cd29] 26: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb76124fe] 27: akonadiserver(main+0x1e1) [0x808e901] 28: /lib/libc.so.6(__libc_start_main+0xf3) [0xb6df79d3] 29: akonadiserver() [0x808f0d5] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/opt/java/latest7/bin", "/home/fisiu/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/android/android-sdk-linux/tools", "/opt/android/android-sdk-linux/platform-tools", "/opt/java/maven/apache-maven/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work. " Sql error: Table 'akonadi.SchemaVersionTable' doesn't exist QMYSQL: Unable to execute query Query: ALTER TABLE SchemaVersionTable ADD COLUMN version INTEGER NOT NULL DEFAULT 0" Unable to initialize database. "[ 0: akonadiserver(_Z11akBacktracev+0x35) [0x80966d5] 1: akonadiserver() [0x8096991] 2: linux-gate.so.1(__kernel_sigreturn+0) [0xb7742400] 3: linux-gate.so.1(__kernel_vsyscall+0x10) [0xb7742424] 4: /lib/libc.so.6(gsignal+0x46) [0xb6daf6a6] 5: /lib/libc.so.6(abort+0x143) [0xb6db0e33] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x7d) [0xb749608d] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8098a74] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb753ad68] 9: /usr/lib/libQtCore.so.4(+0x114fde) [0xb7548fde] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb75526c5] 11: akonadiserver(_ZN7Akonadi13AkonadiServer4initEv+0x62c) [0x809b98c] 12: /usr/lib/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb75c23da] 13: /usr/lib/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb75ca2bb] 14: /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb75b11b0] 15: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb75b1214] 16: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb75b0fba] 17: /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1d5) [0xb75b42e5] 18: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb75b480c] 19: /usr/lib/libQtCore.so.4(+0x1ace0e) [0xb75e0e0e] 20: /usr/lib/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6c8a7ce] 21: /usr/lib/libglib-2.0.so.0(+0x49b78) [0xb6c8ab78] 22: /usr/lib/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6c8ac38] 23: /usr/lib/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb75e05ef] 24: /usr/lib/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb75afa03] 25: /usr/lib/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb75afd29] 26: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb75b54fe] 27: akonadiserver(main+0x1e1) [0x808e901] 28: /lib/libc.so.6(__libc_start_main+0xf3) [0xb6d9a9d3] 29: akonadiserver() [0x808f0d5] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/opt/java/latest7/bin", "/home/fisiu/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/android/android-sdk-linux/tools", "/opt/android/android-sdk-linux/platform-tools", "/opt/java/maven/apache-maven/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work. " Sql error: Table 'akonadi.SchemaVersionTable' doesn't exist QMYSQL: Unable to execute query Query: ALTER TABLE SchemaVersionTable ADD COLUMN version INTEGER NOT NULL DEFAULT 0" Unable to initialize database. "[ 0: akonadiserver(_Z11akBacktracev+0x35) [0x80966d5] 1: akonadiserver() [0x8096991] 2: linux-gate.so.1(__kernel_sigreturn+0) [0xb77b7400] 3: linux-gate.so.1(__kernel_vsyscall+0x10) [0xb77b7424] 4: /lib/libc.so.6(gsignal+0x46) [0xb6e246a6] 5: /lib/libc.so.6(abort+0x143) [0xb6e25e33] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x7d) [0xb750b08d] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8098a74] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb75afd68] 9: /usr/lib/libQtCore.so.4(+0x114fde) [0xb75bdfde] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb75c76c5] 11: akonadiserver(_ZN7Akonadi13AkonadiServer4initEv+0x62c) [0x809b98c] 12: /usr/lib/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb76373da] 13: /usr/lib/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb763f2bb] 14: /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb76261b0] 15: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb7626214] 16: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb7625fba] 17: /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1d5) [0xb76292e5] 18: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb762980c] 19: /usr/lib/libQtCore.so.4(+0x1ace0e) [0xb7655e0e] 20: /usr/lib/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6cff7ce] 21: /usr/lib/libglib-2.0.so.0(+0x49b78) [0xb6cffb78] 22: /usr/lib/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6cffc38] 23: /usr/lib/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb76555ef] 24: /usr/lib/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb7624a03] 25: /usr/lib/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb7624d29] 26: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb762a4fe] 27: akonadiserver(main+0x1e1) [0x808e901] 28: /lib/libc.so.6(__libc_start_main+0xf3) [0xb6e0f9d3] 29: akonadiserver() [0x808f0d5] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/opt/java/latest7/bin", "/home/fisiu/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/X11R6/bin", "/usr/games", "/opt/android/android-sdk-linux/tools", "/opt/android/android-sdk-linux/platform-tools", "/opt/java/maven/apache-maven/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") QSqlDatabasePrivate::removeDatabase: connection 'initConnection' is still in use, all queries will cease to work. " Sql error: Table 'akonadi.SchemaVersionTable' doesn't exist QMYSQL: Unable to execute query Query: ALTER TABLE SchemaVersionTable ADD COLUMN version INTEGER NOT NULL DEFAULT 0" Unable to initialize database. "[ 0: akonadiserver(_Z11akBacktracev+0x35) [0x80966d5] 1: akonadiserver() [0x8096991] 2: linux-gate.so.1(__kernel_sigreturn+0) [0xb7798400] 3: linux-gate.so.1(__kernel_vsyscall+0x10) [0xb7798424] 4: /lib/libc.so.6(gsignal+0x46) [0xb6e056a6] 5: /lib/libc.so.6(abort+0x143) [0xb6e06e33] 6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x7d) [0xb74ec08d] 7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8098a74] 8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xc8) [0xb7590d68] 9: /usr/lib/libQtCore.so.4(+0x114fde) [0xb759efde] 10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x35) [0xb75a86c5] 11: akonadiserver(_ZN7Akonadi13AkonadiServer4initEv+0x62c) [0x809b98c] 12: /usr/lib/libQtCore.so.4(_ZN14QMetaCallEvent13placeMetaCallEP7QObject+0x3a) [0xb76183da] 13: /usr/lib/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x20b) [0xb76202bb] 14: /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate13notify_helperEP7QObjectP6QEvent+0x60) [0xb76071b0] 15: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication6notifyEP7QObjectP6QEvent+0x54) [0xb7607214] 16: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x7a) [0xb7606fba] 17: /usr/lib/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1d5) [0xb760a2e5] 18: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication16sendPostedEventsEP7QObjecti+0x2c) [0xb760a80c] 19: /usr/lib/libQtCore.so.4(+0x1ace0e) [0xb7636e0e] 20: /usr/lib/libglib-2.0.so.0(g_main_context_dispatch+0x13e) [0xb6ce07ce] 21: /usr/lib/libglib-2.0.so.0(+0x49b78) [0xb6ce0b78] 22: /usr/lib/libglib-2.0.so.0(g_main_context_iteration+0x38) [0xb6ce0c38] 23: /usr/lib/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x5f) [0xb76365ef] 24: /usr/lib/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x43) [0xb7605a03] 25: /usr/lib/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x179) [0xb7605d29] 26: /usr/lib/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x8e) [0xb760b4fe] 27: akonadiserver(main+0x1e1) [0x808e901] 28: /lib/libc.so.6(__libc_start_main+0xf3) [0xb6df09d3] 29: akonadiserver() [0x808f0d5] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) "akonadiserver" crashed too often and will not be restarted! Reproducible: Always Steps to Reproduce: 1. 2. 3. One of the old table name: akonadi.schemaversiontable Requested name by aconadi: akonadi.SchemaVersionTable After manual renaming tables, akonadi starts and works without problems. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=851577 https://bugzilla.novell.com/show_bug.cgi?id=851577#c1 Bernd Weigelt <weigelt.bernd@web.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |weigelt.bernd@web.de --- Comment #1 from Bernd Weigelt <weigelt.bernd@web.de> 2013-12-02 11:19:30 UTC --- Same problem here after update with zypper dup from 12.3 to 13.1 a fresh akonadi-config, remove or rename all config-files, works only for a few days. sorry that i can't give you more infos -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=851577 https://bugzilla.novell.com/show_bug.cgi?id=851577#c2 --- Comment #2 from Bernd Weigelt <weigelt.bernd@web.de> 2013-12-02 11:42:35 UTC --- Made something with a little by help by Google as workaround http://forum.kde.org/viewtopic.php?f=215&t=118256#p295853 After delete the following two akonadi-processes, akonadiserver and akonadi_control, i can start akonadi with 'akonadictl start' -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=851577 https://bugzilla.novell.com/show_bug.cgi?id=851577#c3 Mark Draheim <rickscafe.casablanca@gmx.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |rickscafe.casablanca@gmx.ne | |t --- Comment #3 from Mark Draheim <rickscafe.casablanca@gmx.net> 2013-12-03 08:48:05 UTC --- similar problem here, though the error is always "not registered with D-Bus". Upgraded from 12.3 to 13.1, backend is mariadb. Problem shows on three computers with both old and newly created users. It seems to be a timing problem because akonadi startup works half of the time and is more likely to fail on slow connections. 1. akonadi db on local SSD: has not failed once 2. akonadi db on local spin disk: fails sometimes 3. akonadi db on NFS mounted /home: fails every time Killing akonadi server and doing akonadictl start brings back akonadi and kontact starts without error. Log out, log back in, and akonadi fails again. check these, especially the second one: https://bugs.kde.org/show_bug.cgi?id=326480 https://git.reviewboard.kde.org/r/112062/ -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=851577 https://bugzilla.novell.com/show_bug.cgi?id=851577#c4 --- Comment #4 from Mark Draheim <rickscafe.casablanca@gmx.net> 2013-12-04 12:08:12 UTC --- alright, forget point 3) in my previous comment. That is a different problem and I will put that into its own ticket: akonadi's mysqld keeps running even after logout from KDE. That means mysqld has a lock on the DB files which prevents another instance of mysqld from accessing them, like having a laptop accessing the DB on the desktop via NFS exported home. Created bnc #853619 . -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=851577 https://bugzilla.novell.com/show_bug.cgi?id=851577#c5 Andreas Hahn <andreas.hahn@tu-cottbus.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |andreas.hahn@tu-cottbus.de --- Comment #5 from Andreas Hahn <andreas.hahn@tu-cottbus.de> 2014-01-03 10:12:12 UTC --- Same here, but there is a workaround: After creating a new account and configuring kmail, I did a diff against the old '.local/share/akonadi/mysql.conf': 40a41
# Deprecated in MySQL >= 5.6.3 91c92 < table_cache=200
table_open_cache=200
Solution is changing the variable name in old 'mysql.conf' from 'table_cache' to 'table_open_cache' and starting akonadi: akonadictl start -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠novell.com