Thanks,
I now noticed that there is a default sphinxsearch cronjob doing the
following which i think caused this issue. I removed it, will test it
further.
# Rebuild all indexes daily and notify searchd.
@daily root . /etc/default/sphinxsearch && if [ "$START" = "yes" ] &&
[ -x /usr/bin/indexer ]; then /usr/bin/indexer --quiet --rotate --all; fi
# Example for rotating only specific indexes (usually these would be part of
# a larger combined index).
# */5 * * * * root [ -x /usr/bin/indexer ] && /usr/bin/indexer --quiet
--rotate postdelta threaddelta
### PILERSTART
*/5 * * * * LC_ALL=C mpstat | tail -1 | awk '{print }' >
/var/piler/stat/cpu.stat
5,35 * * * * /usr/bin/indexer --quiet delta1 --rotate && sleep 2 &&
/usr/bin/indexer --quiet --merge main1 delta1 --merge-dst-range deleted 0 0
--rotate
*/15 * * * * /usr/bin/indexer --quiet tag1 --rotate
*/15 * * * * /usr/bin/indexer --quiet note1 --rotate
### PILEREND
total 152
drwx------ 2 piler piler 4096 Jul 23 22:15 .
drwxr-xr-x 7 root root 4096 Jul 15 20:26 ..
-rw-r--r-- 1 piler piler 0 Jul 23 22:05 delta1.spa
-rw-r--r-- 1 piler piler 1 Jul 23 22:05 delta1.spd
-rw-r--r-- 1 piler piler 582 Jul 23 22:05 delta1.sph
-rw-r--r-- 1 piler piler 1 Jul 23 22:05 delta1.spi
-rw-r--r-- 1 piler piler 0 Jul 23 22:05 delta1.spk
-rw------- 1 piler piler 0 Jul 23 22:05 delta1.spl
-rw-r--r-- 1 piler piler 0 Jul 23 22:05 delta1.spm
-rw-r--r-- 1 piler piler 1 Jul 23 22:05 delta1.spp
-rw-r--r-- 1 piler piler 1 Jul 23 22:05 delta1.sps
-rw-r--r-- 1 piler piler 160 Jul 23 22:05 main1.spa
-rw-r--r-- 1 piler piler 498 Jul 23 22:05 main1.spd
-rw-r--r-- 1 piler piler 582 Jul 23 22:05 main1.sph
-rw-r--r-- 1 piler piler 1195 Jul 23 22:05 main1.spi
-rw-r--r-- 1 piler piler 0 Jul 23 22:05 main1.spk
-rw------- 1 piler piler 0 Jul 23 22:05 main1.spl
-rw-r--r-- 1 piler piler 0 Jul 23 22:05 main1.spm
-rw-r--r-- 1 piler piler 146 Jul 23 22:05 main1.spp
-rw-r--r-- 1 piler piler 1 Jul 23 22:05 main1.sps
-rw-r--r-- 1 root root 0 Jul 23 00:00 main2.spa
-rw-r--r-- 1 root root 1 Jul 23 00:00 main2.spd
-rw-r--r-- 1 root root 582 Jul 23 00:00 main2.sph
-rw-r--r-- 1 root root 1 Jul 23 00:00 main2.spi
-rw-r--r-- 1 root root 0 Jul 23 00:00 main2.spk
-rw------- 1 piler piler 0 Jul 23 12:14 main2.spl
-rw-r--r-- 1 root root 0 Jul 23 00:00 main2.spm
-rw-r--r-- 1 root root 1 Jul 23 00:00 main2.spp
-rw-r--r-- 1 root root 1 Jul 23 00:00 main2.sps
-rw-r--r-- 1 root root 0 Jul 23 00:00 main3.spa
-rw-r--r-- 1 root root 1 Jul 23 00:00 main3.spd
-rw-r--r-- 1 root root 582 Jul 23 00:00 main3.sph
-rw-r--r-- 1 root root 1 Jul 23 00:00 main3.spi
-rw-r--r-- 1 root root 0 Jul 23 00:00 main3.spk
-rw------- 1 piler piler 0 Jul 23 12:14 main3.spl
-rw-r--r-- 1 root root 0 Jul 23 00:00 main3.spm
-rw-r--r-- 1 root root 1 Jul 23 00:00 main3.spp
-rw-r--r-- 1 root root 1 Jul 23 00:00 main3.sps
-rw-r--r-- 1 root root 0 Jul 23 00:00 main4.spa
-rw-r--r-- 1 root root 1 Jul 23 00:00 main4.spd
-rw-r--r-- 1 root root 582 Jul 23 00:00 main4.sph
-rw-r--r-- 1 root root 1 Jul 23 00:00 main4.spi
-rw-r--r-- 1 root root 0 Jul 23 00:00 main4.spk
-rw------- 1 piler piler 0 Jul 23 12:14 main4.spl
-rw-r--r-- 1 root root 0 Jul 23 00:00 main4.spm
-rw-r--r-- 1 root root 1 Jul 23 00:00 main4.spp
-rw-r--r-- 1 root root 1 Jul 23 00:00 main4.sps
-rw-r--r-- 1 piler piler 0 Jul 23 22:15 note1.spa
-rw-r--r-- 1 piler piler 1 Jul 23 22:15 note1.spd
-rw-r--r-- 1 piler piler 289 Jul 23 22:15 note1.sph
-rw-r--r-- 1 piler piler 1 Jul 23 22:15 note1.spi
-rw-r--r-- 1 piler piler 0 Jul 23 22:15 note1.spk
-rw------- 1 piler piler 0 Jul 23 22:15 note1.spl
-rw-r--r-- 1 piler piler 0 Jul 23 22:15 note1.spm
-rw-r--r-- 1 piler piler 1 Jul 23 22:15 note1.spp
-rw-r--r-- 1 piler piler 1 Jul 23 22:15 note1.sps
-rw-r--r-- 1 piler piler 0 Jul 23 22:15 tag1.spa
-rw-r--r-- 1 piler piler 1 Jul 23 22:15 tag1.spd
-rw-r--r-- 1 piler piler 288 Jul 23 22:15 tag1.sph
-rw-r--r-- 1 piler piler 1 Jul 23 22:15 tag1.spi
-rw-r--r-- 1 piler piler 0 Jul 23 22:15 tag1.spk
-rw------- 1 piler piler 0 Jul 23 22:15 tag1.spl
-rw-r--r-- 1 piler piler 0 Jul 23 22:15 tag1.spm
-rw-r--r-- 1 piler piler 1 Jul 23 22:15 tag1.spp
-rw-r--r-- 1 piler piler 1 Jul 23 22:15 tag1.sps
On Tue, Jul 23, 2013 at 5:12 PM, Janos SUTO <[email protected]> wrote:
>
> Hello,
>
> On 2013-07-23 11:34, JC Putter wrote:
>
>>
>> There seems to be an issue with my search, again it is only showing
>> email from today and not all the other days. I then do a reindex -a
>> and then i am able to search previous days as well..
>>
>
> I suspect that your sphinx database gets corrupted. Please show me
> ls -la /var/piler/sphinx, and crontab -l -u piler
>
>
> Janos
>
>
>
>
