missing mails in maildir

[Ingo Klöcker]

You didn't say which versions of KMail and Akonadi you are using.

On Montag, 11. Februar 2019 00:15:16 CET Jos van den Oever wrote:
> In my akonadi/kmail setup with maildir, I'm seeing that mails that are in
> the database are not all as mail files on the filesystem. Since akonadi is
> the cache for the filesystem, I wonder how this discrepancy has come to be.

Does this happen for new mails? Or only for old mails?

How did the mails end up in the folder? Were they moved? Copied? Filtered?

There was a bug where when one moved several mails at once to a maildir folder 
only the first one was actually written to the maildir folder. This bug has 
been fixed in the meantime.

> This is the first time I've seen this and it's worrying me. I'd like to find
> out how many files might be missing and get them back in the maildir.

For me, copying (!; not moving) mails (individually or several at once) to 
another maildir folder made the mails appear in the filesystem (after some 
time, i.e. a few minutes).

> Very concretely, I'm looking for a mail I sent, that shows up in the inbox
> in kmail and akonadi_console, but is not in the maildir. I've connected to
> MariaDB with `mysql -D akonadi` --socket=...
> However, I do not see where (what table column) the mail body is. The
> largest table is parttable, but I do not find any mails in there. The
> largest blob in that table is 4096.

I think you are looking at the right table.


Regards,
Ingo
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 195 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20190211/5f9aae4c/attachment.sig>