https://bugs.kde.org/show_bug.cgi?id=435510
Bug ID: 435510 Summary: Akonadi db corrupt, crashes KMail, Kontakt Product: kmail2 Version: unspecified Platform: openSUSE RPMs OS: Linux Status: REPORTED Keywords: drkonqi Severity: crash Priority: NOR Component: general Assignee: kdepim-b...@kde.org Reporter: vaesb...@telenet.be Target Milestone: --- Application: kmail (5.14.2 (20.04.2)) Qt Version: 5.12.7 Frameworks Version: 5.71.0 Operating System: Linux 5.3.18-lp152.66-default x86_64 Windowing system: X11 Distribution: openSUSE Leap 15.2 -- Information about the crash: - What I was doing when the application crashed: After a botched shutdown, akonadi mysql db seems corrupt: from /var/log/messages: DATABASE ERROR: 2021-04-05T15:43:43.961455+02:00 localhost akonadiserver[17580]: org.kde.pim.akonadiserver: Error code: "1062" 2021-04-05T15:43:43.961632+02:00 localhost akonadiserver[17580]: org.kde.pim.akonadiserver: DB error: "Duplicate entry '4-trash' for key 'CollectionTable_parentAndNameIndex'" 2021-04-05T15:43:43.961810+02:00 localhost akonadiserver[17580]: org.kde.pim.akonadiserver: Error text: "Duplicate entry '4-trash' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement" 2021-04-05T15:43:43.961979+02:00 localhost akonadiserver[17580]: org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(QString, ""))(":1", QVariant(QString, ""))(":10", QVariant(int, -1))(":11", QVariant(int, -1))(":12", QVariant(bool, false))(":13", QVariant(QString, ""))(":14", QVariant(bool, false))(":2", QVariant(QString, "trash"))(":3", QVariant(qlonglong, 4))(":4", QVariant(qlonglong, 4))(":5", QVariant(bool, true))(":6", QVariant(int, 2))(":7", QVariant(int, 2))(":8", QVariant(int, 2))(":9", QVariant(bool, true))) 2021-04-05T15:43:43.962163+02:00 localhost akonadiserver[17580]: org.kde.pim.akonadiserver: Query: "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, enabled, syncPref, displayPref, indexPref, cachePolicyInherit, cachePolicyCheckInterval, cachePolicyCacheTimeout, cachePolicySyncOnDemand, cachePolicyLocalParts, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)" 2021-04-05T15:43:43.962353+02:00 localhost akonadiserver[17580]: org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" "Duplicate entry '4-trash' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement" Now Kmail crashes at startup with: The Email program encountered a fatal error and will terminate now. The error was: Could not create collection trash, resourceId 4 The crash can be reproduced every time. -- Backtrace: Application: KMail (kmail), signal: Aborted [KCrash Handler] #4 0x00007f75bdd31420 in raise () from /lib64/libc.so.6 #5 0x00007f75bdd32a01 in abort () from /lib64/libc.so.6 #6 0x00007f75be15a016 in ?? () from /usr/lib64/libstdc++.so.6 #7 0x00007f75be16588c in ?? () from /usr/lib64/libstdc++.so.6 #8 0x00007f75be1658f7 in std::terminate() () from /usr/lib64/libstdc++.so.6 #9 0x00007f75be165ba9 in __cxa_throw () from /usr/lib64/libstdc++.so.6 #10 0x00007f75be541f92 in qBadAlloc () at global/qglobal.cpp:3192 #11 0x00007f75be5c4de4 in QListData::detach_grow (this=this@entry=0x55c86bf90b38, idx=idx@entry=0x7ffd63f47ccc, num=num@entry=1) at tools/qlist.cpp:80 #12 0x00007f75bf5d779c in QList<QWidget*>::detach_helper_grow (this=0x55c86bf90b38, i=<optimized out>, i@entry=2147483647, c=c@entry=1) at ../../include/QtCore/../../src/corelib/tools/qlist.h:759 #13 0x00007f75bf5d788d in QList<QWidget*>::append (this=<optimized out>, t=@0x7ffd63f47d20: 0x55c86bf5f0f0) at ../../include/QtCore/../../src/corelib/tools/qlist.h:585 #14 0x00007f75bf6037e8 in QWidget::insertAction (this=this@entry=0x55c86bf5f0f0, before=<optimized out>, before@entry=0x0, action=0x55c86bf90b50) at kernel/qwidget.cpp:3314 #15 0x00007f75bd8453e2 in KXMLGUI::ActionList::plug (this=this@entry=0x55c86c126840, container=0x55c86bf5f0f0, index=<optimized out>) at /usr/src/debug/kxmlgui-5.71.0-lp152.1.1.x86_64/src/kxmlguifactory_p.cpp:45 #16 0x00007f75bd848d02 in KXMLGUI::ContainerNode::plugActionList (this=this@entry=0x55c86befb370, state=..., mergingIdxIt=...) at /usr/src/debug/kxmlgui-5.71.0-lp152.1.1.x86_64/src/kxmlguifactory_p.cpp:234 #17 0x00007f75bd848ec6 in KXMLGUI::ContainerNode::plugActionList (this=0x55c86befb370, state=...) at /usr/src/debug/kxmlgui-5.71.0-lp152.1.1.x86_64/src/kxmlguifactory_p.cpp:204 #18 0x00007f75bd848f03 in KXMLGUI::ContainerNode::plugActionList (this=<optimized out>, state=...) at /usr/src/debug/kxmlgui-5.71.0-lp152.1.1.x86_64/src/kxmlguifactory_p.cpp:208 #19 0x00007f75bd848f03 in KXMLGUI::ContainerNode::plugActionList (this=<optimized out>, state=...) at /usr/src/debug/kxmlgui-5.71.0-lp152.1.1.x86_64/src/kxmlguifactory_p.cpp:208 #20 0x00007f75bd8427fb in KXMLGUIFactory::plugActionList (this=0x55c86c77e460, client=client@entry=0x7f753c030060, name=..., actionList=...) at /usr/src/debug/kxmlgui-5.71.0-lp152.1.1.x86_64/src/kxmlguifactory.cpp:574 #21 0x00007f75bd839cc9 in KXMLGUIClient::plugActionList (this=this@entry=0x7f753c030060, name=..., actionList=...) at /usr/src/debug/kxmlgui-5.71.0-lp152.1.1.x86_64/src/kxmlguiclient.cpp:709 #22 0x00007f75b90edb1d in PimCommon::PluginInterface::initializePluginActions (this=<optimized out>, prefix=..., guiClient=0x7f753c030060) at /usr/src/debug/pimcommon-20.04.2-lp152.1.1.x86_64/src/pimcommonakonadi/genericplugins/plugininterface.cpp:168 #23 0x00007f75c07933ce in KMMainWidget::initializePluginActions (this=this@entry=0x55c86bdd1090) at /usr/src/debug/kmail-20.04.2-lp152.2.3.1.x86_64/src/kmmainwidget.cpp:4217 #24 0x00007f75c079ac53 in KMMainWidget::slotShowStartupFolder (this=0x55c86bdd1090) at /usr/src/debug/kmail-20.04.2-lp152.2.3.1.x86_64/src/kmmainwidget.cpp:4121 #25 0x00007f75be77de04 in QtPrivate::QSlotObjectBase::call (a=0x7ffd63f48150, r=<optimized out>, this=<optimized out>) at ../../include/QtCore/../../src/corelib/kernel/qobjectdefs_impl.h:394 #26 QSingleShotTimer::timerEvent (this=0x55c86bfa2210) at kernel/qtimer.cpp:318 #27 0x00007f75be77199b in QObject::event (this=0x55c86bfa2210, e=<optimized out>) at kernel/qobject.cpp:1283 #28 0x00007f75bf5cbf2c in QApplicationPrivate::notify_helper (this=this@entry=0x55c86b8776a0, receiver=receiver@entry=0x55c86bfa2210, e=e@entry=0x7ffd63f48490) at kernel/qapplication.cpp:3701 #29 0x00007f75bf5d3540 in QApplication::notify (this=0x7ffd63f48c00, receiver=0x55c86bfa2210, e=0x7ffd63f48490) at kernel/qapplication.cpp:3447 #30 0x00007f75be741328 in QCoreApplication::notifyInternal2 (receiver=0x55c86bfa2210, event=0x7ffd63f48490) at kernel/qcoreapplication.cpp:1088 #31 0x00007f75be79d819 in QTimerInfoList::activateTimers (this=0x55c86b93b250) at kernel/qtimerinfo_unix.cpp:643 #32 0x00007f75be79dfe1 in timerSourceDispatch (source=<optimized out>) at kernel/qeventdispatcher_glib.cpp:182 #33 0x00007f75b1162624 in g_main_context_dispatch () from /usr/lib64/libglib-2.0.so.0 #34 0x00007f75b11629c0 in ?? () from /usr/lib64/libglib-2.0.so.0 #35 0x00007f75b1162a4c in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0 #36 0x00007f75be79e3af in QEventDispatcherGlib::processEvents (this=0x55c86b95ad30, flags=...) at kernel/qeventdispatcher_glib.cpp:422 #37 0x00007f75be73f57a in QEventLoop::exec (this=this@entry=0x7ffd63f486e0, flags=..., flags@entry=...) at kernel/qeventloop.cpp:225 #38 0x00007f75be748780 in QCoreApplication::exec () at kernel/qcoreapplication.cpp:1389 #39 0x000055c86a077a2b in main (argc=<optimized out>, argv=<optimized out>) at /usr/src/debug/kmail-20.04.2-lp152.2.3.1.x86_64/src/main.cpp:163 [Inferior 1 (process 31372) detached] Possible duplicates by query: bug 426463, bug 423904, bug 422151, bug 421432, bug 418784. Reported using DrKonqi -- You are receiving this mail because: You are watching all bug changes.