Hi All, I've recently discovered that a handful of emails from a few months ago have corrupted somehow, and are no longer loading in the WebUI or via 3rd party clients (Thunderbird) [upl-image-preview url=https://community.mailcow.email/assets/files/2022-12-11/1670787520-138275-image.png] See above, I'm able to send and recieve mail just fine, but these emails just don't load and I can't seem to delete them from the WebUI. I also can't run an inbox export either. How can I identify these emails in the database and delete them? Thanks

Certain Emails No Longer Loading / Corrupted

UpperCenter

Hi All,

I’ve recently discovered that a handful of emails from a few months ago have corrupted somehow, and are no longer loading in the WebUI or via 3rd party clients (Thunderbird)

See above, I’m able to send and recieve mail just fine, but these emails just don’t load and I can’t seem to delete them from the WebUI. I also can’t run an inbox export either.
How can I identify these emails in the database and delete them?

Thanks

UpperCenter

Is there really really nothing I can do about this?

UpperCenter

Update:
I tried to use doveadm to remove the emails that were recieved on that day, but it doesn’t seem to have changed anything. Not sure what is going on at this point.

doveadm expunge -u 'user@example.org' mailbox 'Inbox' SAVEDON 2022-10-22

Etc etc.

Is there something I could do with imap instead?

Thanks

UpperCenter

Another update:

I think this is a weird encryption key issue, looking at the logs from mailcow/dovecot:1.21:

Dec 12 21:07:30 b7f15c4c02ca dovecot: imap(user@example.com)<199><328y5KfvYuysFgH4>: Disconnected: FETCH failed: Mailbox INBOX: UID=7576: read() failed: read(/var/vmail/example.com/user/Maildir/cur/1665173325.M156278P138.0cb49019f340,S=1605,W=1651:2,S) failed: Decryption error: no private key available (read reason=prefetch) in=628 out=28830 deleted=0 expunged=0 trashed=0 hdr_count=38 hdr_bytes=121 body_count=0 body_bytes=0

Considering I don’t think there’s a way to recover these emails without the correct key (still not sure how this happened in the first place)

Is there an easy way to find the emails that can’t be read? It’s quite painful having to read the log file each time, as it only tries to load one email at a time, so I have to restart the host in order to get a new error log.

Thanks

karlito96

Did you end up finding a solution to your issue?
I have the same problem here: https://community.mailcow.email/d/2266-lost-access-to-a-mailbox-but-still-receiving-mail/4

I also see others have encountered this issue recently:
https://community.mailcow.email/d/2236-mail-cant-be-readdecrypt-after-restore/2