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.
