mails are in metadata but not able to search/view through GUI

[Crzaccount]

Hi: Am rotating the main indexes for every 10lakh mails for smooth search.

As of now it is using main9 search db. But i couldn't search some mails from main8 search db like Jan 28 to Feb 16 mails are not there.

Ex: I checked with mysql db. mail are present for Feb-13 in metadata. I given below 1 sample entry FYI

###Start mysql> select * from rcpt where id='7934188'; +---------+--------------------------+--------------+ | id | to | todomain | +---------+--------------------------+--------------+ | 7934188 | nimit.madan@xxxxxx | xxxxxx | +---------+--------------------------+--------------+ 1 row in set (0.06 sec)

mysql> select subject,arrived,sent from metadata where id='7934188'; +---------------------------------------------------+------------+------------+ | subject | arrived | sent | +---------------------------------------------------+------------+------------+ | Transaction alert for your ICICI Bank Travel Card | 1423830067 | 1423834936 | +---------------------------------------------------+------------+------------+ 1 row in set (0.03 sec)

mysql> ###End

But i couldn't able to search this entry in web using auditor as well as normal user.

My piler -v o/p ###Start piler 0.1.25-master-branch, build 865, Janos SUTO [e-mail]

Build Date: Mon Mar 10 11:05:24 IST 2014 ldd version: ldd (GNU libc) 2.5 gcc version: gcc version 4.1.2 20080704 (Red Hat 4.1.2-54) Configure command: ./configure --localstatedir=/var --with-database=mysql ###End

Please suggest.

[Janos SUTO]

Try the following:

mysql -h 127.0.0.1 -P 9306, then select * from main8 where id=7934188;

Then fix main8 to main7 then to main6 until you find this message. Then fix the $config['SPHINX_MAIN_INDEX'] variable.

[Crzaccount]

I tried the above but I couldn't find out this id 7934188 on main1 to main10.

However it is present in metadata. Pls let me know what can be done further.

[Janos SUTO]

And how could this be possible? Anyway you may reindex this particular message, eg. reindex -f 7934188 -t 7934188, and it will appear in the latest main index.