[Akonadi] [Bug 483061] New: Akodani server does not declare UTC times as UTC, resulting in brief denial of service

[Joshua J. Kugler]

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

            Bug ID: 483061
           Summary: Akodani server does not declare UTC times as UTC,
                    resulting in brief denial of service
    Classification: Frameworks and Libraries
           Product: Akonadi
           Version: 6.0.0
          Platform: Neon
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: joshua at joshuakugler.com
                CC: carl at carlschwan.eu
  Target Milestone: ---

SUMMARY

STEPS TO REPRODUCE
1. Try to access e-mail in a time when you are going to "spring forward" and it
generates an atime with a time between 2AM and 3AM.

OBSERVED RESULT
KMail hangs and gets the dreaded "Retrieving folder contents" hang. This error
is seen in the logs:

Error text: "Incorrect datetime value: '2024-03-10 02:15:10' for column
`akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL: Unable to execute
statement"

This tipped me off:
https://linustechtips.com/topic/1028839-mariadb-need-help-incorrect-datetime-value-2018-03-25-022324/

Conclusion: Akonadi is inserting time as UTC, but not declaring it UTC, and the
DB server is saying "That's not a valid time in my time zone!" (I'm currently
in Americas/Anchorage).

Yes, I also am a programmer. Yes, I also hate date/time math.

EXPECTED RESULT
Message loads.

SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: Neon all packages up to date
(available in About System)
KDE Plasma Version: 6.0.0
KDE Frameworks Version: 6.0.0
Qt Version: 6.6.2

ADDITIONAL INFORMATION
Now that is after 2024-03-10 03:00:00 UTC, I can once again access my e-mails.
:)

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