It never happened but last night

English Applications
#1 
**erlangen:~ #** timedatectl               
               Local time: Sun 2022-03-27 11:26:11 CEST 
           Universal time: Sun 2022-03-27 09:26:11 UTC 
                 RTC time: Sun 2022-03-27 09:26:11 
                Time zone: Europe/Berlin (CEST, +0200) 
System clock synchronized: yes 
              NTP service: active 
          RTC in local TZ: no 
**erlangen:~ #** journalctl -p3 _PID=16865 
Mar 27 04:49:18 erlangen akonadiserver[16865]: **org.kde.pim.akonadiserver: DATABASE ERROR:**
Mar 27 04:49:18 erlangen akonadiserver[16865]: **org.kde.pim.akonadiserver:   Error code: "1292"**
Mar 27 04:49:18 erlangen akonadiserver[16865]: **org.kde.pim.akonadiserver:   DB error:  "Incorrect datetime value: '2022-03-27 02:49:18.157000' for column `akonadi`.`pimitemtable`.`atime` at row 1"**
Mar 27 04:49:18 erlangen akonadiserver[16865]: **org.kde.pim.akonadiserver:   Error text: "Incorrect datetime value: '2022-03-27 02:49:18.157000' for column `akonadi`.`pimitemtable`.`atime` at row 1 QMYSQL3: Der Befehl konnte nicht ausgeführt werden"**
Mar 27 04:49:18 erlangen akonadiserver[16865]: **org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QDateTime, QDateTime(2022-03-27 02:49:18.157 UTC Qt::UTC)))(":1", QVariant(qlonglong, 264)))**
Mar 27 04:49:18 erlangen akonadiserver[16865]: **org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET atime = :0 WHERE ( PimItemTable.collectionId = :1 )"**
**erlangen:~ #**

Any idea?

#2

Very likely related to switching to Daylight saving time

#3

Headers of the offending mail:

karl@erlangen:~> grep Sun 1648346499.V2bI492eacM787248.erlangen  
        for <karl@localhost>; **Sun**, 27 Mar 2022 04:01:39 +0200 (CEST) 
        for <karl@localhost> (single-drop); **Sun**, 27 Mar 2022 04:01:39 +0200 (CEST) 
        for <*********>; **Sun**, 27 Mar 2022 01:40:28 +0100 
        ; **Sun**, 27 Mar 2022 01:40:28 +0100 
        for <*****************@**********>; **Sun**, 27 Mar 2022 01:40:28 +0100 (CET) 
        **Sun**, 27 Mar 2022 01:40:27 +0100 (CET) 
        for <*****************@**********>; **Sun**, 27 Mar 2022 01:40:27 +0100 (CET) 
        id 93BE4A8DB2D; **Sun**, 27 Mar 2022 01:40:27 +0100 (CET) 
Date: **Sun**, 27 Mar 2022 01:40:27 +0100 (CET) 
karl@erlangen:~>

Akonadi erroneously generates 02:49:18.157000 CEST and quits with a fatal error:

**DB error:  "Incorrect datetime value: '2022-03-27 02:49:18.157000' for column `akonadi`.`pimitemtable`.`atime` at row 1"**
#4

The timestamps only in a list:

Sun, 27 Mar 2022 04:01:39 +0200 (CEST)
Sun, 27 Mar 2022 04:01:39 +0200 (CEST)
Sun, 27 Mar 2022 01:40:28 +0100
Sun, 27 Mar 2022 01:40:28 +0100
Sun, 27 Mar 2022 01:40:28 +0100 (CET)
Sun, 27 Mar 2022 01:40:27 +0100 (CET)
Sun, 27 Mar 2022 01:40:27 +0100 (CET)
Sun, 27 Mar 2022 01:40:27 +0100 (CET)

Any idea which one triggered the problem?

#5

Hi
Sounds like the same as this…?
https://www.mail-archive.com/kdepim-bugs@kde.org/msg133951.html
https://bugs.kde.org/show_bug.cgi?id=451963

#6

None of the above. Errors encountered when adding the message:

**erlangen:~ #** journalctl -b -2 --identifier akonadiserver --priority warning --no-pager -g error 
Mar 24 19:20:35 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ****Error**** while handling command MoveItems on connection akonadi_mailfilter_agent (0x560a3ff5b970)**
Mar 25 10:15:26 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ****Error**** while handling command MoveItems on connection akonadi_mailfilter_agent (0x560a3ff5b970)**
Mar 25 18:18:06 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ****Error**** while handling command MoveItems on connection akonadi_mailfilter_agent (0x560a3ff5b970)**
Mar 25 18:49:06 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ****Error**** while handling command MoveItems on connection akonadi_mailfilter_agent (0x560a3ff5b970)**
Mar 26 21:18:06 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ****Error**** while handling command MoveItems on connection akonadi_mailfilter_agent (0x560a3ff5b970)**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: DATABASE ****ERROR****:**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver:   ****Error**** code: "1292"**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver:   DB ****error****:  "Incorrect datetime value: '2022-03-27 02:00:58' for column `akonadi`.`pimitemtable`.`datetime` at row 1"**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver:   ****Error**** text: "Incorrect datetime value: '2022-03-27 02:00:58' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL3: Der Befehl konnte nicht ausgeführt werden"**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ****Error**** during updating record with id 78336  in table "PimItemTable" "Incorrect datetime value: '2022-03-27 02:00:58' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL3: Der Befehl konnte**
 nicht ausgeführt werden"
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ****Error**** while handling command ModifyItems on connection akonadi_maildir_resource_0 (0x560a3ff66370)**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ItemRetrievalJob for request 3977 finished with ****error****: "Unable to retrieve item from resource: Unable to write item changes into the database"**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: DATABASE ****ERROR****:**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver:   ****Error**** code: "1292"**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver:   DB ****error****:  "Incorrect datetime value: '2022-03-27 02:00:58.645000' for column `akonadi`.`pimitemtable`.`atime` at row 1"**
Mar 27 04:00:58 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver:   ****Error**** text: "Incorrect datetime value: '2022-03-27 02:00:58.645000' for column `akonadi`.`pimitemtable`.`atime` at row 1 QMYSQL3: Der Befehl konnte nicht ausgeführt werden"**
Mar 27 04:01:40 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: DATABASE ****ERROR****:**
Mar 27 04:01:40 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver:   ****Error**** code: "1292"**
Mar 27 04:01:40 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver:   DB ****error****:  "Incorrect datetime value: '2022-03-27 02:01:40.457000' for column `akonadi`.`pimitemtable`.`datetime` at row 1"**
Mar 27 04:01:40 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver:   ****Error**** text: "Incorrect datetime value: '2022-03-27 02:01:40.457000' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL3: Der Befehl konnte nicht ausgeführt werden"**
Mar 27 04:01:40 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ****Error**** during insertion into table "PimItemTable" "Incorrect datetime value: '2022-03-27 02:01:40.457000' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL3: Der Befehl konnte nicht ausge**
führt werden"
Mar 27 04:01:40 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ****Error**** while handling command CreateItem on connection akonadi_maildir_resource_0 (0x560a3ff66370)**
Mar 27 04:06:45 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ItemRetrievalJob for request 3978 finished with ****error****: "Unable to retrieve item from resource: Did not receive a reply. Possible causes include: the remote application did not send a reply, the messa**
ge bus security policy blocked the reply, the reply timeout expired, or the network connection was broken."
Mar 27 04:11:28 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ItemRetrievalJob for request 3980 finished with ****error****: "Unable to retrieve item from resource: Message recipient disconnected from message bus without replying"**
Mar 27 04:11:28 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: Cannot connect to agent instance with identifier 'akonadi_maildir_resource_0', ****error**** message: ''**
Mar 27 04:11:28 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ItemRetrievalJob for request 3983 finished with ****error****: "Unable to contact resource"**
Mar 27 04:11:28 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: Cannot connect to agent instance with identifier 'akonadi_maildir_resource_0', ****error**** message: ''**
Mar 27 04:11:28 erlangen akonadiserver[1493]: **org.kde.pim.akonadiserver: ItemRetrievalJob for request 3984 finished with ****error****: "Unable to contact resource"**
**erlangen:~ #**

I temporarily moved the message, removed the erroneous row of pimitemtable, restarted akonadi and eventually added the unmodified message without encountering more errors.

#7

Yes. The issue results from sloppy coding. Needed to remove erroneous row of pimitemtable.