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-b...@kde.org Reporter: jos...@joshuakugler.com CC: c...@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 watching all bug changes.