how to reindex

Hi,

  When i login account, am gettign the message like "**error sqlstate (hy000) [2003] can't connect to MySQL server on '127.0.0.1' (111) on database: sphinx**"

I cross checked. 9306 is listening. I have restarted rc.piler & rc.searchd. Again i checked. Then i got the message like "Empty search result. Try adding the wildcard character() after a word snippet, eg. duplic to find "duplicate", "duplicated", etc."

Even admin@local account, am getting the same message.

I found that , metadata having 1312756 entries.

###Start mysql> select count() from metadata; +----------+ | count() | +----------+ | 1312756 | +----------+ ###End

When i reindex as a piler user, am getting "Segmentation fault"

##Start [root@archival piler]# su - piler -sh-3.2$ reindex -f 1 -t 1312756 Segmentation fault -sh-3.2$ reindex -f 1 -t 100 Segmentation fault -sh-3.2$ reindex -f 1 -t 10 Segmentation fault -sh-3.2$ which reindex /usr/local/bin/reindex -sh-3.2$ reindex -a Segmentation fault -sh-3.2$ ###End

I have given the piler -V output also.

##Start [root@archival piler]# piler -V piler 0.1.24-master-branch, build 836, Janos SUTO sj@acts.hu

Build Date: Tue Dec 24 18:22:55 IST 2013 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

[root@archival piler]# ##End

Pls check & confirm us.

Comments (3)