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)