Bug 31568 - Kmail cannot receive mail because Akonadi has database issues
Summary: Kmail cannot receive mail because Akonadi has database issues
Status: RESOLVED DUPLICATE of bug 29359
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 8
Hardware: All Linux
Priority: Normal major
Target Milestone: ---
Assignee: Mageia Bug Squad
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-02-17 16:05 CET by Tim van de Snepscheut
Modified: 2023-02-17 17:04 CET (History)
0 users

See Also:
Source RPM: mariadb-10.5.19-1.mga8.src.rpm
CVE:
Status comment:


Attachments

Description Tim van de Snepscheut 2023-02-17 16:05:02 CET
Description of problem:
Kmail gives error messages that it cannot append the mail. Looking in the logs shows that database issues are the problem. It is probably related to the mariadb update that was release.

From the Akonandi logs:
2023-02-17T15:58:59 [CRITICAL] org.kde.pim.akonadiserver: DATABASE ERROR:
2023-02-17T15:58:59 [CRITICAL] org.kde.pim.akonadiserver:   Error code: "1292"
2023-02-17T15:58:59 [CRITICAL] org.kde.pim.akonadiserver:   DB error:  "Incorrect datetime value: '2023-02-17T14:58:59Z' for column `akonadi`.`pimitemtable`.`atime` at row 1"
2023-02-17T15:58:59 [CRITICAL] org.kde.pim.akonadiserver:   Error text: "Incorrect datetime value: '2023-02-17T14:58:59Z' for column `akonadi`.`pimitemtable`.`atime` at row 1 QMYSQL: Unable to execute query"
2023-02-17T15:58:59 [CRITICAL] org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QDateTime, QDateTime(2023-02-17 14:58:59.114 UTC Qt::UTC)))(":1", QVariant(qlonglong, 68266)))
2023-02-17T15:58:59 [CRITICAL] org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET atime = :0 WHERE ( ( PimItemTable.id = :1 ) )"
2023-02-17T15:58:59 [WARN ] org.kde.pim.akonadiserver: Unable to update item access time

Version-Release number of selected component (if applicable):
Kmail 20.12.0
Akonandi 20.12.0
Mariadb 10.5.13

How reproducible:
Have a working Kmail, update the software to these versions and try and recieve a new e-mail
Comment 1 sturmvogel 2023-02-17 17:04:13 CET
duplicate

*** This bug has been marked as a duplicate of bug 29359 ***

Status: NEW => RESOLVED
Resolution: (none) => DUPLICATE


Note You need to log in before you can comment on or make changes to this bug.