![]() Registered Member ![]()
|
This happens again, and worse this time I can't restart it! Previously I can restarted the akonadi service by following the instruction stated in http://blogs.kde.org/node/4503, i.e. deleting both $HOME/.local/share/akonadi and $HOME/.config/akonadi. But this time this doesn't work either. It first popps up a small window saying "Failed to connect to database: Unknown database 'akonadi' QMYSQL: Unable to connect", then just black out akonadi control panel or any other akonadi windows such as config window each time I try to restart it.
Here's the logfile:
akonadi database truly sucks! I hope KDE would select a much better and stable database for PIM in the future. |
![]() Administrator ![]()
|
Can you check if mysqld is really not running when Akonadi is stopped?
"Violence is the last refuge of the incompetent."
![]() Plasma FAQ maintainer - Plasma programming with Python |
![]() Registered Member ![]()
|
mysqld is running when akonadi is stopped, actually there're 4 instances of mysqld listed on ksysguard as I see. Here's what I do: 1) remove all mysqld instances shown on ksysguard 2) launch Akonadi Console, and it pops up a small windows stating "Failed to connect to database: Can't connect to local MySQL server through socket '/tmp/akonadi-superuser.bV4qYH/mysql.socket' (2) QMYSQL: Unable to connect". cllck to close this window and Akonadi Console shows up but all blacked out stating "The Akonadi personal information management service is not operational". That's it, I can't do anything on it. Now back to ksysgurad, there's 1 mysqld listed (sometimes 4 instances listed), so it's still running. |
![]() Administrator ![]()
|
Try removing all mysqld processes running as your user, then issuing "akonadictl start" in the terminal. See if there are other issues.
"Violence is the last refuge of the incompetent."
![]() Plasma FAQ maintainer - Plasma programming with Python |
![]() Registered Member ![]()
|
It doesn't help and has the same issue as before. Here's what shows on the terminal:
done. Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) superuser@ThinkPad-T510:~$ search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/opt/cadence/IC616/tools/bin", "/opt/cadence/IC616/tools/dfII/bin", "/opt/cadence/MMSIM13/tools/bin", "/opt/cadence/MMSIM13/tools/spectre/bin", "/opt/cadence/assura/tools/bin", "/opt/cadence/assura/tools/assura/bin", "/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" QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 172 "[ 0: akonadiserver() [0x419cb7] 1: akonadiserver() [0x419f12] 2: /lib/x86_64-linux-gnu/libc.so.6(+0x36ff0) [0x7fcf6a94bff0] 3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39) [0x7fcf6a94bf79] 4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7fcf6a94f388] 5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x102) [0x7fcf6c433c92] 6: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x70ff9) [0x7fcf6c433ff9] 7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x94) [0x7fcf6c434804] 8: akonadiserver() [0x4b30cc] 9: akonadiserver() [0x41c957] 10: akonadiserver() [0x41f1e5] 11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7fcf6c558c1e] 12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7fcf6c5404dd] 13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ed) [0x7fcf6c543b3d] 14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aaf83) [0x7fcf6c56df83] 15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x254) [0x7fcf6a01ae04] 16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49048) [0x7fcf6a01b048] 17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fcf6a01b0ec] 18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x71) [0x7fcf6c56d7a1] 19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fcf6c53f0af] 20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7fcf6c53f3a5] 21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) [0x7fcf6c544b79] 22: akonadiserver() [0x4142e7] 23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7fcf6a936ec5] 24: akonadiserver() [0x414c48] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/opt/cadence/IC616/tools/bin", "/opt/cadence/IC616/tools/dfII/bin", "/opt/cadence/MMSIM13/tools/bin", "/opt/cadence/MMSIM13/tools/spectre/bin", "/opt/cadence/assura/tools/bin", "/opt/cadence/assura/tools/assura/bin", "/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" QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 172 "[ 0: akonadiserver() [0x419cb7] 1: akonadiserver() [0x419f12] 2: /lib/x86_64-linux-gnu/libc.so.6(+0x36ff0) [0x7f7fee9e2ff0] 3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39) [0x7f7fee9e2f79] 4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7f7fee9e6388] 5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x102) [0x7f7ff04cac92] 6: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x70ff9) [0x7f7ff04caff9] 7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x94) [0x7f7ff04cb804] 8: akonadiserver() [0x4b30cc] 9: akonadiserver() [0x41c957] 10: akonadiserver() [0x41f1e5] 11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7f7ff05efc1e] 12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7f7ff05d74dd] 13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ed) [0x7f7ff05dab3d] 14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aaf83) [0x7f7ff0604f83] 15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x254) [0x7f7fee0b1e04] 16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49048) [0x7f7fee0b2048] 17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f7fee0b20ec] 18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x71) [0x7f7ff06047a1] 19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f7ff05d60af] 20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7f7ff05d63a5] 21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) [0x7f7ff05dbb79] 22: akonadiserver() [0x4142e7] 23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7f7fee9cdec5] 24: akonadiserver() [0x414c48] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/opt/cadence/IC616/tools/bin", "/opt/cadence/IC616/tools/dfII/bin", "/opt/cadence/MMSIM13/tools/bin", "/opt/cadence/MMSIM13/tools/spectre/bin", "/opt/cadence/assura/tools/bin", "/opt/cadence/assura/tools/assura/bin", "/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" QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 172 "[ 0: akonadiserver() [0x419cb7] 1: akonadiserver() [0x419f12] 2: /lib/x86_64-linux-gnu/libc.so.6(+0x36ff0) [0x7f250bf41ff0] 3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39) [0x7f250bf41f79] 4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7f250bf45388] 5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x102) [0x7f250da29c92] 6: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x70ff9) [0x7f250da29ff9] 7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x94) [0x7f250da2a804] 8: akonadiserver() [0x4b30cc] 9: akonadiserver() [0x41c957] 10: akonadiserver() [0x41f1e5] 11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7f250db4ec1e] 12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7f250db364dd] 13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ed) [0x7f250db39b3d] 14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aaf83) [0x7f250db63f83] 15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x254) [0x7f250b610e04] 16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49048) [0x7f250b611048] 17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f250b6110ec] 18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x71) [0x7f250db637a1] 19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f250db350af] 20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7f250db353a5] 21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) [0x7f250db3ab79] 22: akonadiserver() [0x4142e7] 23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7f250bf2cec5] 24: akonadiserver() [0x414c48] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) search paths: ("/usr/local/sbin", "/usr/local/bin", "/usr/sbin", "/usr/bin", "/sbin", "/bin", "/usr/games", "/usr/local/games", "/opt/cadence/IC616/tools/bin", "/opt/cadence/IC616/tools/dfII/bin", "/opt/cadence/MMSIM13/tools/bin", "/opt/cadence/MMSIM13/tools/spectre/bin", "/opt/cadence/assura/tools/bin", "/opt/cadence/assura/tools/assura/bin", "/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" QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigmysql.cpp, line 172 "[ 0: akonadiserver() [0x419cb7] 1: akonadiserver() [0x419f12] 2: /lib/x86_64-linux-gnu/libc.so.6(+0x36ff0) [0x7f7d945b5ff0] 3: /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39) [0x7f7d945b5f79] 4: /lib/x86_64-linux-gnu/libc.so.6(abort+0x148) [0x7f7d945b9388] 5: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x102) [0x7f7d9609dc92] 6: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x70ff9) [0x7f7d9609dff9] 7: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x94) [0x7f7d9609e804] 8: akonadiserver() [0x4b30cc] 9: akonadiserver() [0x41c957] 10: akonadiserver() [0x41f1e5] 11: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7f7d961c2c1e] 12: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7f7d961aa4dd] 13: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ed) [0x7f7d961adb3d] 14: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1aaf83) [0x7f7d961d7f83] 15: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x254) [0x7f7d93c84e04] 16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49048) [0x7f7d93c85048] 17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7f7d93c850ec] 18: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x71) [0x7f7d961d77a1] 19: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7f7d961a90af] 20: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7f7d961a93a5] 21: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) [0x7f7d961aeb79] 22: akonadiserver() [0x4142e7] 23: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0x7f7d945a0ec5] 24: akonadiserver() [0x414c48] ] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) "akonadiserver" crashed too often and will not be restarted! |
![]() Administrator ![]()
|
Can you check whether you have the corresponding library installed? Depending on the distribution it may be libqt4-mysql or something similar.
"Violence is the last refuge of the incompetent."
![]() Plasma FAQ maintainer - Plasma programming with Python |
![]() Registered Member ![]()
|
Yes, it certainly has the library installed in /usr/lib/x86_64-linux-gnu/qt4/plugins/sqldrivers/libqsqlmysql.so I'm inclined to give up on the PIM - it runs good for a while, e.g. a couple of months or so, then locks up like the one now happening and can't access - usually happens after some system updates/upgrades. I think I'll stick with Mozilla Thunderbird which is much more stable and accessible for emails, contacts, and so on... |
![]() Administrator ![]()
|
You may want to enquire to your distro, as there may also be specific issues there.
"Violence is the last refuge of the incompetent."
![]() Plasma FAQ maintainer - Plasma programming with Python |
Registered users: Baidu [Spider], Bing [Bot], Google [Bot]