Hello Gabriele,
On 2012-10-30 16:44, Gabriele wrote:
I have the same problem.
I run piler under Debian Squeeze, using sphinx2 from the official
.deb
archive.
I have sent 1 message to piler, ad it has been fed into the database.
The next messages, are not :-(
what do you mean? Please set verbosity=5, restart piler, send of few
messages, then show me the relevant parts of your maillog.
Here are the infos:
$ mysql -u piler -p piler
mysql> select count(*) from metadata;
+----------+
| count(*) |
+----------+
| 1 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from sph_index;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
$ sudo -u piler ls -la /var/piler/sphinx
total 96
drwx------ 2 piler piler 4096 Oct 30 16:30 .
drwxr-xr-x 7 root root 4096 Oct 30 16:15 ..
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 delta1.spa
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 delta1.spd
-rw-r--r-- 1 piler piler 582 Oct 30 16:30 delta1.sph
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 delta1.spi
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 delta1.spk
-rw------- 1 piler piler 0 Oct 30 16:30 delta1.spl
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 delta1.spm
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 delta1.spp
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 delta1.sps
-rw-r--r-- 1 piler piler 64 Oct 30 16:30 main1.spa
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 main1.spd
-rw-r--r-- 1 piler piler 582 Oct 30 16:30 main1.sph
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 main1.spi
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 main1.spk
-rw------- 1 piler piler 0 Oct 30 16:30 main1.spl
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 main1.spm
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 main1.spp
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 main1.sps
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 note1.spa
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 note1.spd
-rw-r--r-- 1 piler piler 289 Oct 30 16:30 note1.sph
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 note1.spi
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 note1.spk
-rw------- 1 piler piler 0 Oct 30 16:30 note1.spl
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 note1.spm
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 note1.spp
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 note1.sps
-rw------- 1 piler piler 6 Oct 30 16:16 searchd.pid
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 tag1.spa
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 tag1.spd
-rw-r--r-- 1 piler piler 288 Oct 30 16:30 tag1.sph
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 tag1.spi
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 tag1.spk
-rw------- 1 piler piler 0 Oct 30 16:30 tag1.spl
-rw-r--r-- 1 piler piler 0 Oct 30 16:30 tag1.spm
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 tag1.spp
-rw-r--r-- 1 piler piler 1 Oct 30 16:30 tag1.sps
$ mysql -u piler -p piler -h 127.0.0.1 --port 9306
mysql> select * from main1;
Empty set (0.00 sec)
It seems there are two problems here, one woth piler itself, and one
with sphinx ...
yes, the sphinx db is empty. Btw. what is your sphinx version?
Janos
