[kmail2] [Bug 409224] New: kmail not able to refresh email list: Unable to append status flags

[bugzilla_noreply at kde.org]

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-bugs at kde.org
          Reporter: piorek at 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 the assignee for the bug.