Hi there,
after the upgrade, kdepim is broken, more specifically Akonadi. It wonât start, because of it anything related to it wonât work, in my case KMail.
Error logs:
org.kde.pim.akonadiserver: Running DB initializer
org.kde.pim.akonadiserver: DB initializer done
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver: Error code: "2013"
org.kde.pim.akonadiserver: DB error: "Lost connection to MySQL server during query"
org.kde.pim.akonadiserver: Error text: "Lost connection to MySQL server during query QMYSQL3: Unable to execute statement"
org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(qlonglong, 1))(":1", QVariant(qlonglong, 2)))
org.kde.pim.akonadiserver: Query: "SELECT count(DISTINCT PimItemTable.id), sum(PimItemTable.size), sum(CASE WHEN ( SeenFlags.Flag_id IS NOT NULL OR IgnoredFlags.Flag_id IS NOT NULL ) THEN 1 ELSE 0 END), PimItemTable.collectionId FROM PimItemTable LEFT JOIN PimItemFlag
Relation AS SeenFlags ON ( PimItemTable.id = SeenFlags.PimItem_id AND SeenFlags.Flag_id = :0 ) LEFT JOIN PimItemFlagRelation AS IgnoredFlags ON ( PimItemTable.id = IgnoredFlags.PimItem_id AND IgnoredFlags.Flag_id = :1 ) GROUP BY PimItemTable.collectionId"
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Database error: Cannot open database.
org.kde.pim.akonadiserver: Last driver error: "QMYSQL: Unable to connect"
org.kde.pim.akonadiserver: Last database error: "Can't connect to local MySQL server through socket '/run/user/1000/akonadi/mysql.socket' (111)"
QSqlQuery::exec: database not open
org.kde.pim.akonadiserver: Database error: Cannot open database.
org.kde.pim.akonadiserver: Last driver error: "QMYSQL: Unable to connect"
org.kde.pim.akonadiserver: Last database error: "Can't connect to local MySQL server through socket '/run/user/1000/akonadi/mysql.socket' (111)"
QSqlQuery::exec: database not open
org.kde.pim.akonadiserver: Database error: Cannot open database.
org.kde.pim.akonadiserver: Last driver error: "QMYSQL: Unable to connect"
org.kde.pim.akonadiserver: Last database error: "Can't connect to local MySQL server through socket '/run/user/1000/akonadi/mysql.socket' (111)"
QSqlQuery::exec: database not open
QSqlQuery::prepare: database not open
org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY:
org.kde.pim.akonadiserver: Error code: ""
org.kde.pim.akonadiserver: DB error: ""
org.kde.pim.akonadiserver: Error text: ""
org.kde.pim.akonadiserver: Query: "SELECT CollectionTable.id, CollectionTable.remoteId, CollectionTable.remoteRevision, CollectionTable.name, CollectionTable.parentId, CollectionTable.resourceId, CollectionTable.enabled, CollectionTable.syncPref, CollectionTable.displ
ayPref, CollectionTable.indexPref, CollectionTable.cachePolicyInherit, CollectionTable.cachePolicyCheckInterval, CollectionTable.cachePolicyCacheTimeout, CollectionTable.cachePolicySyncOnDemand, CollectionTable.cachePolicyLocalParts, CollectionTable.queryString, Collect
ionTable.queryAttributes, CollectionTable.queryCollections, CollectionTable.isVirtual FROM CollectionTable"
org.kde.pim.akonadiserver: Failed to query initial collections for scheduler!
org.kde.pim.akonadiserver: Not a fatal error, no collections will be scheduled for sync or cache expiration!
org.kde.pim.akonadiserver: Database error: Cannot open database.
org.kde.pim.akonadiserver: Last driver error: "QMYSQL: Unable to connect"
org.kde.pim.akonadiserver: Last database error: "Can't connect to local MySQL server through socket '/run/user/1000/akonadi/mysql.socket' (111)"
QSqlQuery::exec: database not open
QSqlQuery::prepare: database not open
org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY:
org.kde.pim.akonadiserver: Error code: ""
org.kde.pim.akonadiserver: DB error: ""
org.kde.pim.akonadiserver: Error text: ""
org.kde.pim.akonadiserver: Query: "SELECT CollectionTable.id, CollectionTable.remoteId, CollectionTable.remoteRevision, CollectionTable.name, CollectionTable.parentId, CollectionTable.resourceId, CollectionTable.enabled, CollectionTable.syncPref, CollectionTable.displ
ayPref, CollectionTable.indexPref, CollectionTable.cachePolicyInherit, CollectionTable.cachePolicyCheckInterval, CollectionTable.cachePolicyCacheTimeout, CollectionTable.cachePolicySyncOnDemand, CollectionTable.cachePolicyLocalParts, CollectionTable.queryString, Collect
ionTable.queryAttributes, CollectionTable.queryCollections, CollectionTable.isVirtual FROM CollectionTable"
org.kde.pim.akonadiserver: Failed to query initial collections for scheduler!
org.kde.pim.akonadiserver: Not a fatal error, no collections will be scheduled for sync or cache expiration!
org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY:
org.kde.pim.akonadiserver: Error code: "2006"
org.kde.pim.akonadiserver: DB error: "MySQL server has gone away"
org.kde.pim.akonadiserver: Error text: "MySQL server has gone away QMYSQL3: Unable to prepare statement"
org.kde.pim.akonadiserver: Query: "SELECT id, name FROM PartTypeTable WHERE ( ns = :0 AND name = :1 )"
org.kde.pim.akonadiserver: Error during selection of record with ns "ATR" from table "PartTypeTable" "MySQL server has gone away QMYSQL3: Unable to prepare statement"
org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY:
org.kde.pim.akonadiserver: Error code: "2006"
org.kde.pim.akonadiserver: DB error: "MySQL server has gone away"
org.kde.pim.akonadiserver: Error text: "MySQL server has gone away QMYSQL3: Unable to prepare statement"
org.kde.pim.akonadiserver: Query: "INSERT INTO PartTypeTable (name, ns) VALUES (:0, :1)"
org.kde.pim.akonadiserver: Error during insertion into table "PartTypeTable" "MySQL server has gone away QMYSQL3: Unable to prepare statement"
org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY:
org.kde.pim.akonadiserver: Error code: "2006"
org.kde.pim.akonadiserver: DB error: "MySQL server has gone away"
org.kde.pim.akonadiserver: Error text: "MySQL server has gone away QMYSQL3: Unable to prepare statement"
org.kde.pim.akonadiserver: Query: "SELECT id, name, isVirtual FROM ResourceTable"
org.kde.pim.akonadiserver: Error during selection of all records from table "ResourceTable" "MySQL server has gone away QMYSQL3: Unable to prepare statement" "SELECT id, name, isVirtual FROM ResourceTable"
org.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadicontrol: Akonadi server is now operational.
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_unifiedmailbox_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_unifiedmailbox_agent' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_sendlater_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_sendlater_agent' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_archivemail_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_archivemail_agent' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_followupreminder_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_followupreminder_agent' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_migration_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_migration_agent' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_akonotes_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_akonotes_resource' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_maildir_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_maildir_resource' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_ical_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_imap_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_imap_resource' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_birthdays_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_birthdays_resource' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_indexing_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_indexing_agent' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_maildispatcher_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_maildispatcher_agent' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_newmailnotifier_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_newmailnotifier_agent' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_contacts_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_contacts_resource' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_mailfilter_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_mailfilter_agent' crashed. No restart!
This is probably because the mysqld process is crashing when akonadi is trying to start it:
ĐŽĐ”Đș 18 13:37:29 zoki-pc systemd-coredump[21363]: Process 21336 (mysqld) of user 1000 dumped core.
Stack trace of thread 21348:
#0 0x00007f388a16e615 raise (libc.so.6 + 0x3d615)
#1 0x00007f388a157912 abort (libc.so.6 + 0x26912)
#2 0x000055ea5fee3414 n/a (mariadbd + 0x613414)
#3 0x000055ea5fee8383 n/a (mariadbd + 0x618383)
#4 0x000055ea605ba947 n/a (mariadbd + 0xcea947)
#5 0x000055ea604fe7e4 n/a (mariadbd + 0xc2e7e4)
#6 0x000055ea6020774f _ZN7handler11ha_rnd_nextEPh (mariadbd + 0x93774f)
#7 0x000055ea6034f5be _Z13rr_sequentialP11READ_RECORD (mariadbd + 0xa7f5be)
#8 0x000055ea6004645d _Z10sub_selectP4JOINP13st_join_tableb (mariadbd + 0x77645d)
#9 0x000055ea60071221 _ZN4JOIN10exec_innerEv (mariadbd + 0x7a1221)
#10 0x000055ea6007154f _ZN4JOIN4execEv (mariadbd + 0x7a154f)
#11 0x000055ea6006f489 _Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_l
ex_unitP13st_select_lex (mariadbd + 0x79f489)
#12 0x000055ea6006feda _Z13handle_selectP3THDP3LEXP13select_resultm (mariadbd + 0x79feda)
#13 0x000055ea60000664 n/a (mariadbd + 0x730664)
#14 0x000055ea6000d468 _Z21mysql_execute_commandP3THD (mariadbd + 0x73d468)
#15 0x000055ea600224b6 _ZN18Prepared_statement7executeEP6Stringb (mariadbd + 0x7524b6)
#16 0x000055ea600225d9 _ZN18Prepared_statement12execute_loopEP6StringbPhS2_ (mariadbd + 0x7525d9)
#17 0x000055ea60022f2e n/a (mariadbd + 0x752f2e)
#18 0x000055ea6002311c _Z19mysqld_stmt_executeP3THDPcj (mariadbd + 0x75311c)
#19 0x000055ea60011e37 _Z16dispatch_command19enum_server_commandP3THDPcjbb (mariadbd + 0x741e37)
#20 0x000055ea60012bc1 _Z10do_commandP3THD (mariadbd + 0x742bc1)
#21 0x000055ea6010466c _Z24do_handle_one_connectionP7CONNECTb (mariadbd + 0x83466c)
#22 0x000055ea60104906 handle_one_connection (mariadbd + 0x834906)
#23 0x000055ea60464098 n/a (mariadbd + 0xb94098)
#24 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#25 0x00007f388a231293 __clone (libc.so.6 + 0x100293)
Stack trace of thread 21338:
#0 0x00007f388a64e9c8 pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0 + 0xf9c8)
#1 0x000055ea6040386b n/a (mariadbd + 0xb3386b)
#2 0x000055ea603fbdf6 n/a (mariadbd + 0xb2bdf6)
#3 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#4 0x00007f388a231293 __clone (libc.so.6 + 0x100293)
Stack trace of thread 21336:
#0 0x00007f388a22646f __poll (libc.so.6 + 0xf546f)
#1 0x000055ea5ff49a28 _Z26handle_connections_socketsv (mariadbd + 0x679a28)
#2 0x000055ea5ff4a889 _Z11mysqld_mainiPPc (mariadbd + 0x67a889)
#3 0x00007f388a159152 __libc_start_main (libc.so.6 + 0x28152)
#4 0x000055ea5ff3eb7e _start (mariadbd + 0x66eb7e)
Stack trace of thread 21343:
#0 0x00007f388a64ecf8 pthread_cond_clockwait (libpthread.so.0 + 0xfcf8)
#1 0x000055ea606bc03a _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd
+ 0xdec03a)
#2 0x000055ea606bc45f _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd + 0xdec45f)
#3 0x000055ea606bdaae _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd + 0xdedaae)
#4 0x00007f388a529c24 execute_native_thread_routine (libstdc++.so.6 + 0xcfc24)
#5 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#6 0x00007f388a231293 __clone (libc.so.6 + 0x100293)
Stack trace of thread 21340:
#0 0x00007f388a64e9c8 pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0 + 0xf9c8)
#1 0x000055ea60638275 n/a (mariadbd + 0xd68275)
#2 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#3 0x00007f388a231293 __clone (libc.so.6 + 0x100293)
Stack trace of thread 21346:
#0 0x00007f388a64e9c8 pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0 + 0xf9c8)
#1 0x000055ea60104a70 _ZN12Thread_cache4parkEv (mariadbd + 0x834a70)
#2 0x000055ea6010451a _Z24do_handle_one_connectionP7CONNECTb (mariadbd + 0x83451a)
#3 0x000055ea60104906 handle_one_connection (mariadbd + 0x834906)
#4 0x000055ea60464098 n/a (mariadbd + 0xb94098)
#5 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#6 0x00007f388a231293 __clone (libc.so.6 + 0x100293)
Stack trace of thread 21337:
#0 0x00007f388a64e9c8 pthread_cond_timedwait@@GLIBC_2.3.2 (libpthread.so.0 + 0xf9c8)
#1 0x000055ea60720dfb n/a (mariadbd + 0xe50dfb)
#2 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#3 0x00007f388a231293 __clone (libc.so.6 + 0x100293)
Stack trace of thread 21339:
#0 0x00007f388a22bd5d syscall (libc.so.6 + 0xfad5d)
#1 0x00007f388a67c187 n/a (libaio.so.1 + 0x1187)
#2 0x000055ea606bf45a _ZN5tpool9aio_linux23getevent_thread_routineEPS0_ (mariadbd + 0xdef45a)
#3 0x00007f388a529c24 execute_native_thread_routine (libstdc++.so.6 + 0xcfc24)
#4 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#5 0x00007f388a231293 __clone (libc.so.6 + 0x100293)
Stack trace of thread 21345:
#0 0x00007f388a64e6a2 pthread_cond_wait@@GLIBC_2.3.2 (libpthread.so.0 + 0xf6a2)
#1 0x000055ea5ff5f49c handle_slave_background (mariadbd + 0x68f49c)
#2 0x000055ea60464098 n/a (mariadbd + 0xb94098)
#3 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#4 0x00007f388a231293 __clone (libc.so.6 + 0x100293)
Stack trace of thread 21341:
#0 0x00007f388a64ecf8 pthread_cond_clockwait (libpthread.so.0 + 0xfcf8)
#1 0x000055ea606bc03a _ZN5tpool19thread_pool_generic14wait_for_tasksERSt11unique_lockISt5mutexEPNS_11worker_dataE (mariadbd
+ 0xdec03a)
#2 0x000055ea606bc45f _ZN5tpool19thread_pool_generic8get_taskEPNS_11worker_dataEPPNS_4taskE (mariadbd + 0xdec45f)
#3 0x000055ea606bdaae _ZN5tpool19thread_pool_generic11worker_mainEPNS_11worker_dataE (mariadbd + 0xdedaae)
#4 0x00007f388a529c24 execute_native_thread_routine (libstdc++.so.6 + 0xcfc24)
#5 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#6 0x00007f388a231293 __clone (libc.so.6 + 0x100293)
Stack trace of thread 21344:
#0 0x00007f388a16f402 __sigtimedwait (libc.so.6 + 0x3e402)
#1 0x000055ea5ff416a4 signal_hand (mariadbd + 0x6716a4)
#2 0x000055ea60464098 n/a (mariadbd + 0xb94098)
#3 0x00007f388a6483e9 start_thread (libpthread.so.0 + 0x93e9)
#4 0x00007f388a231293 __clone (libc.so.6 + 0x100293)