Bug 422433 - akonadi constanly crash when updating database (due to rollback)
Summary: akonadi constanly crash when updating database (due to rollback)
Status: RESOLVED WORKSFORME
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: server (show other bugs)
Version: unspecified
Platform: openSUSE Linux
: NOR crash
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords: drkonqi
Depends on:
Blocks:
 
Reported: 2020-06-03 20:00 UTC by Bruno Friedmann
Modified: 2022-10-10 11:21 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
Full trace (99.50 KB, text/plain)
2020-06-04 07:46 UTC, Bruno Friedmann
Details
New crash information added by DrKonqi (43.41 KB, patch)
2020-06-11 20:07 UTC, Kerler Marian
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Bruno Friedmann 2020-06-03 20:00:48 UTC
Application: akonadiserver (5.14.1 (20.04.0))

Qt Version: 5.14.1
Frameworks Version: 5.70.0
Operating System: Linux 5.6.14-1-default x86_64
Windowing system: X11
Distribution: "openSUSE Tumbleweed"

-- Information about the crash:
- What I was doing when the application crashed: Start deleting several mails and going back and forth on 3 differents accounts.
Akonadi crash constantly even after executing an fsck action.

Error found on console
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: ""
org.kde.pim.akonadiserver: Database error: DataStore::commitTransaction
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   DB error:  "could not receive data from server: Bad file descriptor\n()"
org.kde.pim.akonadiserver:   Error text: "could not receive data from server: Bad file descriptor\n() QPSQL: Unable to create query"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QDateTime, QDateTime(2020-06-03 19:52:26.642 UTC Qt::UTC)))(":1", QVariant(qlonglong, 1348604)))
org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET atime = :0 WHERE ( ( PimItemTable.id = :1 ) )"
org.kde.pim.akonadiserver: Unable to update item access time
org.kde.pim.akonadiserver: Database error: DataStore::rollbackTransaction
org.kde.pim.akonadiserver:   Last driver error: "QPSQL: Could not rollback transaction"
org.kde.pim.akonadiserver:   Last database error: "could not receive data from server: Bad file descriptor\n()"
org.kde.pim.akonadiserver:   Last driver error: "QPSQL: Could not commit transaction"
org.kde.pim.akonadiserver:   Last database error: "could not receive data from server: Bad file descriptor\n()"
org.kde.pim.akonadiserver:   Error code: ""
org.kde.pim.akonadiserver:   DB error:  "could not receive data from server: Bad file descriptor\n()"
org.kde.pim.akonadiserver:   Error text: "could not receive data from server: Bad file descriptor\n() QPSQL: Unable to create query"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(qlonglong, 2))(":1", QVariant(qlonglong, 33))(":2", QVariant(qlonglong, 660)))
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) FROM PimItemTable LEFT JOIN PimItemFlagRelation 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 ) WHERE ( collectionId = :2 )"
org.kde.pim.akonadiserver: Database error: DataStore::rollbackTransaction
org.kde.pim.akonadiserver:   Last driver error: "QPSQL: Could not rollback transaction"
org.kde.pim.akonadiserver:   Last database error: "could not receive data from server: Bad file descriptor\n()"

The crash can be reproduced every time.

-- Backtrace (Reduced):
#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#5  0x00007f87793a253d in __GI_abort () at abort.c:79
#6  0x00007f87795ff816 in __gnu_cxx::__verbose_terminate_handler () at ../../../../libstdc++-v3/libsupc++/vterminate.cc:95
#7  0x00007f877960a918 in __cxxabiv1::__terminate (handler=<optimized out>) at ../../../../libstdc++-v3/libsupc++/eh_terminate.cc:48
#8  0x00007f877960a983 in std::terminate () at ../../../../libstdc++-v3/libsupc++/eh_terminate.cc:58


The reporter indicates this bug may be a duplicate of or related to bug 422017.

Possible duplicates by query: bug 422017, bug 421576, bug 420414, bug 419798, bug 418804.

Reported using DrKonqi
Comment 1 Bruno Friedmann 2020-06-04 07:46:04 UTC
Created attachment 129040 [details]
Full trace

Someone should ask admin why kcrash attachement can't be uploaded directly.
Comment 2 Kerler Marian 2020-06-10 19:14:41 UTC
*** Bug 422775 has been marked as a duplicate of this bug. ***
Comment 3 Kerler Marian 2020-06-11 20:07:51 UTC
Created attachment 129243 [details]
New crash information added by DrKonqi

kontact (5.13.3 (19.12.3)) using Qt 5.12.8

- What I was doing when the application crashed:

Changed Imap Resource and then open Email

-- Backtrace (Reduced):
#6  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#7  0x00007f6358332859 in __GI_abort () at abort.c:79
#8  0x00007f6358332729 in __assert_fail_base (fmt=0x7f6343716422 "%s%s%s:%u: %s%sZusicherung \302\273%s\302\253 nicht erf\303\274llt.\n%n", assertion=0x7f6341c6c068 "kref", file=0x7f6341c6c052 "../nouveau/pushbuf.c", line=723, function=<optimized out>) at assert.c:92
#9  0x00007f6358343f36 in __GI___assert_fail (assertion=assertion@entry=0x7f6341c6c068 "kref", file=file@entry=0x7f6341c6c052 "../nouveau/pushbuf.c", line=line@entry=723, function=function@entry=0x7f6341c6c1a0 <__PRETTY_FUNCTION__.6636> "nouveau_pushbuf_data") at assert.c:101
#10 0x00007f6341c69547 in nouveau_pushbuf_data (push=0x55dc39ee6c60, bo=0x55dc39ee6150, offset=275512, length=552) at ../nouveau/pushbuf.c:723
Comment 4 Wolfgang Bauer 2020-06-12 08:04:41 UTC
(In reply to Kerler Marian from comment #3)
> Created attachment 129243 [details]
> New crash information added by DrKonqi
> 
> kontact (5.13.3 (19.12.3)) using Qt 5.12.8
> 
> - What I was doing when the application crashed:
> 
> Changed Imap Resource and then open Email
> 
> -- Backtrace (Reduced):
> #6  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
> #7  0x00007f6358332859 in __GI_abort () at abort.c:79
> #8  0x00007f6358332729 in __assert_fail_base (fmt=0x7f6343716422 "%s%s%s:%u:
> %s%sZusicherung \302\273%s\302\253 nicht erf\303\274llt.\n%n",
> assertion=0x7f6341c6c068 "kref", file=0x7f6341c6c052 "../nouveau/pushbuf.c",
> line=723, function=<optimized out>) at assert.c:92
> #9  0x00007f6358343f36 in __GI___assert_fail
> (assertion=assertion@entry=0x7f6341c6c068 "kref",
> file=file@entry=0x7f6341c6c052 "../nouveau/pushbuf.c", line=line@entry=723,
> function=function@entry=0x7f6341c6c1a0 <__PRETTY_FUNCTION__.6636>
> "nouveau_pushbuf_data") at assert.c:101
> #10 0x00007f6341c69547 in nouveau_pushbuf_data (push=0x55dc39ee6c60,
> bo=0x55dc39ee6150, offset=275512, length=552) at ../nouveau/pushbuf.c:723

That's a well knwon bug in the nouveau driver, but totally unrelated to the original report.
Comment 5 Justin Zobel 2022-10-10 11:16:40 UTC
Thank you for reporting this crash in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the crash with a recent software version?

If you can reproduce the issue, please change the status to "CONFIRMED" when replying. Thank you!
Comment 6 Bruno Friedmann 2022-10-10 11:21:26 UTC
Works at least with 
openSUSE Tumbleweed - 20220930
Linux 5.19.12-1-default x86_64 GNU/Linux
nvidia: 515.65.01
Qt: 5.15.6
KDE Frameworks: 5.98.0
Plasma: 5.25.5
kmail2 5.21.1 (22.08.1)