Error Mergin the Dailydelta into Main1

[Deepak Singh]

Hi I am getting the following error when I run main indexer and I believe because of that I am not able to see the search results more than one day.

/usr/local/libexec/piler/indexer.main.sh

FATAL: failed to merge index 'dailydelta1' into index 'main1': read error in /var/piler/sphinx/main1.spa (Input/output error); 31817728 of 102218320 bytes read

Please suggest

[Janos SUTO]

Show me ls -la /var/piler/sphinx output. Be sure to format it on Bitbucket!

[Deepak Singh]

[root@localhost ~]# ls -la /var/piler/sphinx total 200 drwxr-xr-x 2 piler piler 4096 May 8 15:08 . drwx------. 8 piler piler 4096 May 7 21:19 .. -rw-r--r-- 1 piler piler 0 May 8 15:08 dailydelta1.spa -rw-r--r-- 1 piler piler 1 May 8 15:08 dailydelta1.spd -rw-r--r-- 1 piler piler 1 May 8 15:08 dailydelta1.spe -rw-r--r-- 1 piler piler 622 May 8 15:08 dailydelta1.sph -rw-r--r-- 1 piler piler 1 May 8 15:08 dailydelta1.spi -rw-r--r-- 1 piler piler 0 May 8 15:08 dailydelta1.spk -rw------- 1 piler piler 0 May 8 15:08 dailydelta1.spl -rw-r--r-- 1 piler piler 0 May 8 15:08 dailydelta1.spm -rw-r--r-- 1 piler piler 1 May 8 15:08 dailydelta1.spp -rw-r--r-- 1 piler piler 1 May 8 15:08 dailydelta1.sps -rw-r--r-- 1 piler piler 1 Jan 27 2015 dailydelta1.tmps -rw-r--r-- 1 piler piler 1 May 8 15:08 dailydelta1.tmp.tmps -rw-r--r-- 1 piler piler 480 May 8 15:08 delta1.spa -rw-r--r-- 1 piler piler 14341 May 8 15:08 delta1.spd -rw-r--r-- 1 piler piler 1 May 8 15:08 delta1.spe -rw-r--r-- 1 piler piler 622 May 8 15:08 delta1.sph -rw-r--r-- 1 piler piler 14650 May 8 15:08 delta1.spi -rw-r--r-- 1 piler piler 0 May 8 15:08 delta1.spk -rw------- 1 piler piler 0 May 8 15:08 delta1.spl -rw-r--r-- 1 piler piler 0 May 8 15:08 delta1.spm -rw-r--r-- 1 piler piler 14975 May 8 15:08 delta1.spp -rw-r--r-- 1 piler piler 1 May 8 15:08 delta1.sps -rw-r--r-- 1 piler piler 0 May 8 15:08 main1.spa -rw-r--r-- 1 piler piler 1 May 8 15:08 main1.spd -rw-r--r-- 1 piler piler 1 May 8 15:08 main1.spe -rw-r--r-- 1 piler piler 622 May 8 15:08 main1.sph -rw-r--r-- 1 piler piler 1 May 8 15:08 main1.spi -rw-r--r-- 1 piler piler 0 May 8 15:08 main1.spk -rw------- 1 piler piler 0 May 8 15:08 main1.spl -rw-r--r-- 1 piler piler 0 May 8 15:08 main1.spm -rw-r--r-- 1 piler piler 1 May 8 15:08 main1.spp -rw-r--r-- 1 piler piler 1 May 8 15:08 main1.sps -rw-r--r-- 1 piler piler 1 Jan 27 2015 main1.tmps -rw-r--r-- 1 piler piler 1 May 8 15:08 main1.tmp.tmps -rw-r--r-- 1 piler piler 0 May 8 15:08 note1.spa -rw-r--r-- 1 piler piler 1 May 8 15:08 note1.spd -rw-r--r-- 1 piler piler 1 May 8 15:08 note1.spe -rw-r--r-- 1 piler piler 330 May 8 15:08 note1.sph -rw-r--r-- 1 piler piler 1 May 8 15:08 note1.spi -rw-r--r-- 1 piler piler 0 May 8 15:08 note1.spk -rw------- 1 piler piler 0 May 8 15:08 note1.spl -rw-r--r-- 1 piler piler 0 May 8 15:08 note1.spm -rw-r--r-- 1 piler piler 1 May 8 15:08 note1.spp -rw-r--r-- 1 piler piler 1 May 8 15:08 note1.sps -rw-r--r-- 1 piler piler 1 Jan 27 2015 note1.tmps -rw-r--r-- 1 piler piler 1 May 8 15:08 note1.tmp.tmps -rw-r--r-- 1 piler piler 0 May 8 15:08 tag1.spa -rw-r--r-- 1 piler piler 1 May 8 15:08 tag1.spd -rw-r--r-- 1 piler piler 1 May 8 15:08 tag1.spe -rw-r--r-- 1 piler piler 329 May 8 15:08 tag1.sph -rw-r--r-- 1 piler piler 1 May 8 15:08 tag1.spi -rw-r--r-- 1 piler piler 0 May 8 15:08 tag1.spk -rw------- 1 piler piler 0 May 8 15:08 tag1.spl -rw-r--r-- 1 piler piler 0 May 8 15:08 tag1.spm -rw-r--r-- 1 piler piler 1 May 8 15:08 tag1.spp -rw-r--r-- 1 piler piler 1 May 8 15:08 tag1.sps -rw-r--r-- 1 piler piler 1 Jan 27 2015 tag1.tmps -rw-r--r-- 1 piler piler 1 May 8 15:08 tag1.tmp.tmps

[Deepak Singh]

the formatting is not proper in comment so please refer the output.txt

[Janos SUTO]

Try the following:

/etc/init.d/rc.searchd stop
rm -rf /var/piler/sphinx/*
indexer --all --config /path/to/your/sphinx.conf (as user piler!)
/etc/init.d/rc.searchd start
cd /tmp
reindex -f 1 -t 1000

Finally run as user piler:

/usr/local/libexec/piler/indexer.delta.sh
/usr/local/libexec/piler/indexer.delta.sh

If it gives you some results, then run "reindex -a" (It may take some time depending on how many emails you have).

[Janos SUTO]

No news is good news.