Hello Roberto,
according to your listing, something has just resetted the
sphinx database.
However your emails are still in the archive, just the indices
are lost. Run "reindex -a" to recreate them, and after the piler
cron jobs run then you'll have search results again.
Note that you should check what happened because a mere reboot
shouldn't do such a harm. Reindexing a few thousands messages
won't hurt, but you definitely don't want to reindex a few million
messages.
Janos
On 2013-05-20 14:39, Roberto Bartali wrote:
Hello everyone
Sorry for double posting but my message in a wrong thread
I had to reboot the piler server and now, when I perform a search (as
Auditor too), I get "Empty search result."
In the "Health" section, in "Message disposition" I see that there
are 3699 messages.
- In the table "metadata" I have 5580 records, and I can see the
messages with the command "pilerget <piler_id>."
- typing select count (*) from metadata; returns 5580.
- typing select count (*) from sph_index; returns 0;
-ls -la /var/piler/sphinx return:
-rw-r--r-- 1 piler piler 0 20 mag 13.41 delta1.spa
-rw-r--r-- 1 piler piler 1 20 mag 13.41 delta1.spd
-rw-r--r-- 1 piler piler 582 20 mag 13.41 delta1.sph
-rw-r--r-- 1 piler piler 1 20 mag 13.41 delta1.spi
-rw-r--r-- 1 piler piler 0 20 mag 13.41 delta1.spk
-rw------- 1 piler piler 0 20 mag 13.41 delta1.spl
-rw-r--r-- 1 piler piler 0 20 mag 13.41 delta1.spm
-rw-r--r-- 1 piler piler 1 20 mag 13.41 delta1.spp
-rw-r--r-- 1 piler piler 1 20 mag 13.41 delta1.sps
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main1.spa
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main1.spd
-rw-r--r-- 1 piler piler 582 20 mag 13.41 main1.sph
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main1.spi
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main1.spk
-rw------- 1 piler piler 0 20 mag 13.41 main1.spl
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main1.spm
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main1.spp
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main1.sps
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main2.spa
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main2.spd
-rw-r--r-- 1 piler piler 582 20 mag 13.41 main2.sph
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main2.spi
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main2.spk
-rw------- 1 piler piler 0 20 mag 13.41 main2.spl
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main2.spm
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main2.spp
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main2.sps
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main3.spa
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main3.spd
-rw-r--r-- 1 piler piler 582 20 mag 13.41 main3.sph
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main3.spi
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main3.spk
-rw------- 1 piler piler 0 20 mag 13.41 main3.spl
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main3.spm
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main3.spp
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main3.sps
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main4.spa
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main4.spd
-rw-r--r-- 1 piler piler 582 20 mag 13.41 main4.sph
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main4.spi
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main4.spk
-rw------- 1 piler piler 0 20 mag 13.41 main4.spl
-rw-r--r-- 1 piler piler 0 20 mag 13.41 main4.spm
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main4.spp
-rw-r--r-- 1 piler piler 1 20 mag 13.41 main4.sps
-rw-r--r-- 1 piler piler 0 20 mag 13.45 note1.spa
-rw-r--r-- 1 piler piler 1 20 mag 13.45 note1.spd
-rw-r--r-- 1 piler piler 289 20 mag 13.45 note1.sph
-rw-r--r-- 1 piler piler 1 20 mag 13.45 note1.spi
-rw-r--r-- 1 piler piler 0 20 mag 13.45 note1.spk
-rw------- 1 piler piler 0 20 mag 13.45 note1.spl
-rw-r--r-- 1 piler piler 0 20 mag 13.45 note1.spm
-rw-r--r-- 1 piler piler 1 20 mag 13.45 note1.spp
-rw-r--r-- 1 piler piler 1 20 mag 13.45 note1.sps
-rw-r--r-- 1 piler piler 0 20 mag 13.45 tag1.spa
-rw-r--r-- 1 piler piler 1 20 mag 13.45 tag1.spd
-rw-r--r-- 1 piler piler 288 20 mag 13.45 tag1.sph
-rw-r--r-- 1 piler piler 1 20 mag 13.45 tag1.spi
-rw-r--r-- 1 piler piler 0 20 mag 13.45 tag1.spk
-rw------- 1 piler piler 0 20 mag 13.45 tag1.spl
-rw-r--r-- 1 piler piler 0 20 mag 13.45 tag1.spm
-rw-r--r-- 1 piler piler 1 20 mag 13.45 tag1.spp
-rw-r--r-- 1 piler piler 1 20 mag 13.45 tag1.sps
Connecting to mysql by 9306 port and typing select * from main1; give
"Empty set (0.00 sec)".
I tried to execut the crontab command manually but they give no
output.
I don't what to do, can someone help me please?
Many thanks
Roberto
