Unable to see mails post 29th April 2022 in GUI

[Aamir Kabli]

Unable to see mails post 29th April 2022 in GUI. However, I can see latest email when exporting them

[Aamir Kabli]

My installation version is 1.3.11 build 1001

[Janos SUTO]

What’s the last time when the main1.* index files have been updated?

[Aamir Kabli]

Please pardon my ignorance… how do I check this?

[Janos SUTO]

ls -la /var/piler/sphinx/main1*

‌

[Aamir Kabli]

‌

[Janos SUTO]

You have run the indexer manually as root. Big mistake. Stop searchd, then chown piler:piler all files in /var/piler/sphinx, then start searchd, and it should fix it.

[Aamir Kabli]

Thank you so much Janos… Unfortunately, as my Linux administrator is on leave and my knowledge on Linux is limited, can you please share the exact command. I will be obliged.

[Janos SUTO]

Trust me, you want to wait for your linux admin to come back.

[Aamir Kabli]

Hahaha. I totally understand. Anyways, I did consult him and did exactly what you suggested, stopping searchd, chown and then starting searchd. It’s been more than 2 hours, however emails till 29th are only displaying in webgui

[Aamir Kabli]

If I run the reindex -a command, how do I check later how much % reindexing has been completed?

‌

[Janos SUTO]

You don’t really do that. Though you may connect to sphinx: mysql -h 127.0.0.1 -P9306

Then run: select * from main1,dailydelta1; show meta

The total documents counter tells you how many have been reindexed so far.

‌