Akonadiserver crashes since today

Hi,

I am using EndeavourOS from the beginning and I could fix all small issues by myself. But now I am stuck with “akonadiserver crashes”. System was working fine yesterday - even after finished updates. When starting system today Kmail shows errors that akonadiserver is not running. I tried to start using akonadictl start and it starts but it crashes again… It seems it cannot connect to mysql server:

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 prepare statement"
org.kde.pim.akonadiserver:   Query: "SELECT CollectionTable.id, CollectionTable.remoteId, CollectionTable.remoteRevision, CollectionTable.name, CollectionTable.parentId, CollectionTable.resourceId, CollectionTable.enabled, CollectionTable.syncPref, CollectionTable.displayPref, CollectionTable.indexPref, CollectionTable.cachePolicyInherit, CollectionTable.cachePolicyCheckInterval, CollectionTable.cachePolicyCacheTimeout, CollectionTable.cachePolicySyncOnDemand, CollectionTable.cachePolicyLocalParts, CollectionTable.queryString, CollectionTable.queryAttributes, CollectionTable.queryCollections, CollectionTable.isVirtual FROM CollectionTable WHERE ( CollectionTable.resourceId = :0 )"
org.kde.pim.akonadiserver: Handler exception when handling command FetchCollections on connection akonadi_maildir_resource_0 (0x55c54bc18df0) : Unable to retrieve collection for listing

This message repeats multiple times and akonadi stops. Was there any update during the last 24 hours that can cause that?

This is the crash report:

Application: Akonadi Server (akonadiserver), signal: Segmentation fault

[KCrash Handler]
#4  0x0000556c2e61fdf4 in ?? ()
#5  0x0000556c2e6c4af7 in ?? ()
#6  0x0000556c2e6c2341 in ?? ()
#7  0x00007efcb3ac7582 in QObject::event(QEvent*) () from /usr/lib/libQt5Core.so.5
#8  0x00007efcb3a9aa50 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () from /usr/lib/libQt5Core.so.5
#9  0x00007efcb3a9d573 in QCoreApplicationPrivate::sendPostedEvents(QObject*, int, QThreadData*) () from /usr/lib/libQt5Core.so.5
#10 0x00007efcb3af40a4 in ?? () from /usr/lib/libQt5Core.so.5
#11 0x00007efcb1e2b914 in g_main_context_dispatch () from /usr/lib/libglib-2.0.so.0
#12 0x00007efcb1e7f7d1 in ?? () from /usr/lib/libglib-2.0.so.0
#13 0x00007efcb1e2a121 in g_main_context_iteration () from /usr/lib/libglib-2.0.so.0
#14 0x00007efcb3af36e1 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib/libQt5Core.so.5
#15 0x00007efcb3a993fc in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib/libQt5Core.so.5
#16 0x00007efcb38b1d22 in QThread::exec() () from /usr/lib/libQt5Core.so.5
#17 0x00007efcb38b2f0f in ?? () from /usr/lib/libQt5Core.so.5
#18 0x00007efcb2ba63e9 in start_thread () from /usr/lib/libpthread.so.0
#19 0x00007efcb3525293 in clone () from /usr/lib/libc.so.6

Thread 2 (Thread 0x7efcaf202640 (LWP 45413) "QDBusConnection"):
#1  0x00007efcb34ecb35 in clock_gettime@GLIBC_2.2.5 () from /usr/lib/libc.so.6
#2  0x00007efcb1e7f544 in ?? () from /usr/lib/libglib-2.0.so.0
#3  0x00007efcb1e2a121 in g_main_context_iteration () from /usr/lib/libglib-2.0.so.0
#4  0x00007efcb3af36fc in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib/libQt5Core.so.5
#5  0x00007efcb3a993fc in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib/libQt5Core.so.5
#6  0x00007efcb38b1d22 in QThread::exec() () from /usr/lib/libQt5Core.so.5
#7  0x00007efcb3d96098 in ?? () from /usr/lib/libQt5DBus.so.5
#8  0x00007efcb38b2f0f in ?? () from /usr/lib/libQt5Core.so.5
#9  0x00007efcb2ba63e9 in start_thread () from /usr/lib/libpthread.so.0
#10 0x00007efcb3525293 in clone () from /usr/lib/libc.so.6

Thread 1 (Thread 0x7efcaf4eccc0 (LWP 45407) "akonadiserver"):
#1  0x00007efcb1e7f75f in ?? () from /usr/lib/libglib-2.0.so.0
#2  0x00007efcb1e2a121 in g_main_context_iteration () from /usr/lib/libglib-2.0.so.0
#3  0x00007efcb3af36e1 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib/libQt5Core.so.5
#4  0x00007efcb3a993fc in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib/libQt5Core.so.5
#5  0x00007efcb3aa1894 in QCoreApplication::exec() () from /usr/lib/libQt5Core.so.5
#6  0x0000556c2e5c327f in ?? ()
#7  0x00007efcb344d152 in __libc_start_main () from /usr/lib/libc.so.6
#8  0x0000556c2e5c5eee in ?? ()
[Inferior 1 (process 45407) detached]

Any hints how I can solve this issue?

It looks like it is a local issue on that machine. All other Arch systems I am using work flawlessly.

I tried the following:

  • stop all akonadi applications and akonadi server
  • stop all mysql processes owned by the user
    verify that nothing can interfer with
ps ux | grep akonadi
ps ux | grep mysql

Then I deleted complete Folders ~/.local/share/akonadi*
…and started akonadi again. All resources are present, database actually rebuilds. Only some settings in kmail (folders for sent/drafts) are gone. Less work to correct them than reentering all ressources again. It is still crappy to maintain akonadi if there are any errors. Akonadikonsole does not help there… But that is not an Arch problem at all.

1 Like