SQL storage reindex

[majkrzak]

I've migrated imapsql backend from sqlite to postgresql. Unfortunately this caused inbox getting empty, despite all the messages are still present in the filesystem.

Is there a way to force reindexing?

[mehdiakoudad]

Issue Analysis
After migrating the IMAP backend from SQLite to PostgreSQL, the inbox appears empty even though the message files still exist. This is typically caused by the IMAP index/metadata being out of sync with the actual mail storage.

Solution
Identify your IMAP server and run the appropriate reindex/rebuild commands:

• Dovecot – Delete index files (forces rebuild):

systemctl stop dovecot
cd /path/to/maildir
find . -type f -name 'dovecot.index*' -delete
systemctl start dovecot

[majkrzak]

🤣