I have multiple entries in my Akonadi DB that lack a remote id (typically email messages that should be on my IMAP server, but are only in the local DB), as seen using Akonadiconsole.

I would of course like these entries to be properly synced with their remote resource.

What can and should I do?

Hi,

at this moment, unfortunately, there is nothing you could do without some serious effort. The only solution is to figure out which messages are those and move them to "Local Folders" temporarily, then move them back to the folders on your IMAP resource where you want them - this is the only method that will cause the IMAP Resource to try to upload the messages again.

A solution for this issue is in the pipeline, no promises on when it will be implemented though.

progdan wrote:[...] The only solution is to figure out which messages are those and move them to "Local Folders" temporarily, then move them back to the folders on your IMAP resource where you want them - this is the only method that will cause the IMAP Resource to try to upload the messages again. [...]

Thanks, I have managed to reduce the problematic non-rid/dirty by half. The ones that remain are trickier: some have a gid (Message-ID), show up in a KMail search, but not in the mail list, and some do not show up in a KMail search; most now don't have a gid, which makes ‘finding’ them hard, datetime-based attempts were unfruitful.

Can you suggest further strategies for finding out what those messages are, an sql query I can run that joins in data from parttable perhaps? (I've no SQL in my fingers yet.)