Can't create piler indexes.
Issue #120
resolved
I've installed Piler 0.1.23 as suggested in the documentation but when I want to run
sh init.d/rc.searchd start
I get
starting searchd . . .
Sphinx 2.0.8-id64-release (r3831)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
listening on 127.0.0.1:9312
listening on 127.0.0.1:9306
precaching index 'main1'
WARNING: index 'main1': preload: failed to open /var/piler/sphinx/main1.sph: No such file or directory; NOT SERVING
precaching index 'main2'
WARNING: index 'main2': preload: failed to open /var/piler/sphinx/main2.sph: No such file or directory; NOT SERVING
precaching index 'main3'
WARNING: index 'main3': preload: failed to open /var/piler/sphinx/main3.sph: No such file or directory; NOT SERVING
precaching index 'main4'
WARNING: index 'main4': preload: failed to open /var/piler/sphinx/main4.sph: No such file or directory; NOT SERVING
precaching index 'delta1'
WARNING: index 'delta1': preload: failed to open /var/piler/sphinx/delta1.sph: No such file or directory; NOT SERVING
precaching index 'tag1'
WARNING: index 'tag1': preload: failed to open /var/piler/sphinx/tag1.sph: No such file or directory; NOT SERVING
precaching index 'note1'
WARNING: index 'note1': preload: failed to open /var/piler/sphinx/note1.sph: No such file or directory; NOT SERVING
FATAL: no valid indexes to serve
I tried running indexer --all and I get
Sphinx 2.0.8-id64-release (r3831)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/etc/sphinxsearch/sphinx.conf'...
indexing index 'main1'...
ERROR: index 'main1': sql_query: Table 'piler.sph_index' doesn't exist (DSN=mysql://piler:***@localhost:3306/piler).
total 0 docs, 0 bytes
total 0.004 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'main2'...
ERROR: index 'main2': sql_query: Table 'piler.sph_index' doesn't exist (DSN=mysql://piler:***@localhost:3306/piler).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'main3'...
ERROR: index 'main3': sql_query: Table 'piler.sph_index' doesn't exist (DSN=mysql://piler:***@localhost:3306/piler).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'main4'...
ERROR: index 'main4': sql_query: Table 'piler.sph_index' doesn't exist (DSN=mysql://piler:***@localhost:3306/piler).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'delta1'...
ERROR: index 'delta1': sql_query_pre[1]: Table 'piler.sph_counter' doesn't exist (DSN=mysql://piler:***@localhost:3306/piler).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'tag1'...
ERROR: index 'tag1': sql_query: Table 'piler.tag' doesn't exist (DSN=mysql://piler:***@localhost:3306/piler).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'note1'...
ERROR: index 'note1': sql_query: Table 'piler.note' doesn't exist (DSN=mysql://piler:***@localhost:3306/piler).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
Comments (3)
-
repo owner
-
reporter
- changed status to resolved
Thanks for your answer.
I tried running searchd when I got the error so I first stopped it then ran indexer --all and got the errors "Table X does't exist". I went into mysql and the table piler is there but inside there is nothing, it has an empty set. I tried creating a dummy "sph_counter" but then MySQL says it can't because the table already exists!
What worked for me was stopping mysql then deleting ibdata1, ib_log0 and ib_log1. When I restarted mysql again the table sph_counter wasn't a phantom anymore!
EMILIO!
-
Might want to update "Mail Piler Installation Notes" to mention this as well..
Start both searchd and piler:
sh init.d/rc.piler start su - piler; indexer --all; exit sh init.d/rc.searchd start
- Log in to comment
Before running searchd, you should initialize the index files, so please stop searchd, then run indexer --all as user piler, then start searchd.
However I think there's a problem with the piler database. Please doublecheck that you can access the piler database and you have sph_index and the other tables. The indexer can't access them.