[Akonadi] [Bug 354056] New: Deleted emails stay, but greyed out

[Alex Merry via KDE Bugzilla]

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

            Bug ID: 354056
           Summary: Deleted emails stay, but greyed out
           Product: Akonadi
           Version: GIT (master)
          Platform: Compiled Sources
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: IMAP resource
          Assignee: chrigi_1 at fastmail.fm
          Reporter: alex.merry at kde.org
                CC: kdepim-bugs at kde.org, vkrause at kde.org

With one of my IMAP accounts (but not the other), when I delete emails, they
disappear from the message list, and reappear in the trash folder (on the same
server) as expected. However, when I switch back to the original folder, the
messages have reappeared there, but greyed out, and unselectable.

Roundcube webmail (0.9.5) also displays these messages as grey and with a
circle-with-a-line-through-it symbol in the status column (but there I can
select them and delete them properly).

This also happens when I try to empty the trash folder.

Reproducible: Always

Steps to Reproduce:
1. Delete an email from the inbox
2. Switch to a different folder
3. Switch back to the inbox

Actual Results:  
Email has reappeared, but greyed out.

Expected Results:  
Email stays gone.

It happens whether or not I have offline emails enabled for the account.

Note that I don't have a particularly large number of emails in my inbox (where
I've observed this behaviour).

Possibly relevant is this from akonadiserver.error:

DATABASE ERROR: 
  Error code: 1452 
  DB error:  "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`)
REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)" 
  Error text: "Cannot add or update a child row: a foreign key constraint fails
(`akonadi`.`parttable`, CONSTRAINT `parttable_ibfk_1` FOREIGN KEY (`pimItemId`)
REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL3:
Unable to execute statement" 
  Query: "INSERT INTO PartTable (pimItemId, partTypeId, data, datasize,
version, external) VALUES (:0, :1, :2, :3, :4, :5)"

Akonadi is also using a ridiculous amount of bandwidth when communicating with
the IMAP server (in August, when I also observed this bug, it used nearly 30Gb
over the month, and I have at most a couple hundred Mb of emails on the
server). This may or may not be related.

-- 
You are receiving this mail because:
You are on the CC list for the bug.