https://bugs.kde.org/show_bug.cgi?id=409224
Bug ID: 409224 Summary: kmail not able to refresh email list: Unable to append status flags Product: kmail2 Version: 5.11.2 Platform: Other OS: Linux Status: REPORTED Severity: normal Priority: NOR Component: general Assignee: kdepim-b...@kde.org Reporter: pio...@piorekf.org Target Milestone: --- SUMMARY For two days I have not launched kmail on my main computer running KMail 5.11.2 however meanwhile I've been using my company laptop with some old KMail version. Both computers have the same account configured over IMAP. When I started KMail today on my main machine it can't refresh email list. I can't see new email and still see older mails in state unread when I have actually already read them on the second machine. STEPS TO REPRODUCE 1. launch kmail 2. click "Check Mail" button OBSERVED RESULT 1. mail list is not refreshed 2. in the status bars in the bottom right corner error "Unable to append status flags" can be seen EXPECTED RESULT New mail arrive and old change status SOFTWARE/OS VERSIONS Linux/KDE Plasma: Gentoo (available in About System) KDE Plasma Version: 5.16.1 KDE Frameworks Version: 5.59.0 Qt Version: Qt 5.12.3 (built against 5.12.3) ADDITIONAL INFORMATION In .local/share/akonadi/akonadiserver.error I can see error messages like this: 2019-06-26T23:12:31 [CRITICAL] org.kde.pim.akonadiserver: DATABASE ERROR: 2019-06-26T23:12:31 [CRITICAL] org.kde.pim.akonadiserver: Error code: "1452" 2019-06-26T23:12:31 [CRITICAL] org.kde.pim.akonadiserver: DB error: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`pimitemflagrelation`, CONSTRAINT `pimitemflagrelation_ibfk_1` FOREIGN KEY (`PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" 2019-06-26T23:12:31 [CRITICAL] org.kde.pim.akonadiserver: Error text: "Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`pimitemflagrelation`, CONSTRAINT `pimitemflagrelation_ibfk_1` FOREIGN KEY (`PimItem_id`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3: Unable to execute statement" 2019-06-26T23:12:31 [CRITICAL] org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(qlonglong, 73282))(":1", QVariant(qlonglong, 1))) 2019-06-26T23:12:31 [CRITICAL] org.kde.pim.akonadiserver: Query: "INSERT INTO PimItemFlagRelation (PimItem_id, Flag_id) VALUES (:0, :1)" 2019-06-26T23:12:31 [WARN ] org.kde.pim.akonadiserver: Failed to append flag "\\SEEN" to Items (QVariant(qlonglong, 73282)) 2019-06-26T23:12:31 [WARN ] org.kde.pim.akonadiserver: Error while handling command CreateItem on connection akonadi_imap_resource_2 (0x563e53aa43e0) When I looked with akonadiconsole indeed there was no item with ID 73282 in pimitemtable. Where does it takes this ID from then? How can I fix this so thath my KMail starts working again? -- You are receiving this mail because: You are watching all bug changes.