[Akonadi] [Bug 422433] New: akonadi constanly crash when updating database (due to rollback)

[Bruno Friedmann]

https://bugs.kde.org/show_bug.cgi?id=422433

            Bug ID: 422433
           Summary: akonadi constanly crash when updating database (due to
                    rollback)
           Product: Akonadi
           Version: unspecified
          Platform: openSUSE RPMs
                OS: Linux
            Status: REPORTED
          Keywords: drkonqi
          Severity: crash
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: bruno at ioda-net.ch
  Target Milestone: ---

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 at 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

-- 
You are receiving this mail because:
You are the assignee for the bug.