| Summary: | deletion of mails doesn't work, deleted mails reappear | ||
|---|---|---|---|
| Product: | [Applications] kmail2 | Reporter: | Ludwig Reiter <ludwig.reiter> |
| Component: | general | Assignee: | kdepim bugs <kdepim-bugs> |
| Status: | RESOLVED FIXED | ||
| Severity: | major | CC: | bjoern.ricks, christophe, sascha.teichmann, thomas, vkrause |
| Priority: | NOR | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | Debian unstable | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: | Full query result. | ||
|
Description
Ludwig Reiter
2010-07-30 12:39:06 UTC
This has been fixed some time ago already. Reopen. The issue still exists in kmail2 from trunk (r1165650) Some tests result with a fresh akonadi setup and a DIMAP account.
I've checked the database state before deleting the message, just after and finally after manually checking the messages in KMail.
The Query I used is:
SELECT pimitemtable.id, pimitemtable.rev, pimitemtable.remoteId,flagtable.name, pimitemtable.remoteRevision, collectiontable.name, mimetypetable.name, pimitemtable.dirty, pimitemtable.size FROM pimitemtable LEFT JOIN collectiontable ON collectiontable.id = pimitemtable.collectionId LEFT JOIN mimetypetable ON pimitemtable.mimeTypeId = mimetypetable.id LEFT JOIN pimitemflagrelation ON pimitemtable.id=pimitemflagrelation.PimItem_id LEFT JOIN flagtable ON pimitemflagrelation.Flag_id= flagtable.id ORDER BY pimitemtable.id
The full output is in the attached file, here's the result for the message I played with.
1/ The messages were downloaded:
| 20 | 0 | 43360 | \Seen | NULL | INBOX | message/rfc822 | 0 | 7891 |
2/ In KMail, the corresponding message is deleted:
| 20 | 1 | {963bdc29-9b5f-463e-ae30-995c9b76bb85} | \Seen | NULL | trash | message/rfc822 | 0 | 7891 |
3/ After a manual check:
| 20 | 1 | {963bdc29-9b5f-463e-ae30-995c9b76bb85} | \Seen | NULL | trash | message/rfc822 | 0 | 7891 |
| 47 | 1 | 43360 | \DELETED | NULL | INBOX | message/rfc822 | 0 | 7891 |
| 47 | 1 | 43360 | \SEEN | NULL | INBOX | message/rfc822 | 0 | 7891 |
At this point, I have a copy in the trash folder for the local maildir resource *AND* the message is also in the INBOX folder but greyed.
If I manually remove the \DELETED flag from the database, I can click this message again.
Created attachment 50947 [details]
Full query result.
Full output.
As discussed on IRC, this was caused by auto-expunge being disabled (in which case mails are not automatically removed from IMAP, just marked as deleted, as intended). I can#t confirm that this in fixed. I updated to 4.9.4 today. I deleted all messages in a folder and clicked on "Nach E-Mail sehen" just a second later. The deleted messages reappear in the folder. This "trick" was reproducible with the messages multiple times. (In reply to comment #6) > I can#t confirm that this in fixed. > > I updated to 4.9.4 today. > > I deleted all messages in a folder and clicked on "Nach E-Mail sehen" just a > second later. The deleted messages reappear in the folder. > > This "trick" was reproducible with the messages multiple times. Additional information: I have 4 to 6 copies of the mail in the trashcan. |