Author Topic: Sphinx Problems  (Read 273 times)

0 Members and 1 Guest are viewing this topic.

Offline Stylewarz3

  • Newbie
  • *
  • Posts: 2
    • View Profile
Sphinx Problems
« on: December 19, 2011, 07:21:03 am »
Hallo,

when i look at the log file /var/log/sphinx_indexer.log, i see this messages with errors:

Starting Sphinx Indexer: 2011-12-18 23:55:01
Spawning DELTA indexer for delta idx_delta_logs
Running Command: /var/www/logzilla/sphinx/bin/indexer --config /var/www/logzilla/sphinx/sphinx.conf --rotate idx_delta_logs


Starting Sphinx Indexer: 2011-12-18 23:55:01
Spawning DELTA indexer for delta idx_delta_logs
Running Command: /var/www/logzilla/sphinx/bin/indexer --config /var/www/logzilla/sphinx/sphinx.conf --rotate idx_delta_logs
Sphinx 0.9.9-id64-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/var/www/logzilla/sphinx/sphinx.conf'...
indexing index 'idx_delta_logs'...
Sphinx 0.9.9-id64-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/var/www/logzilla/sphinx/sphinx.conf'...
indexing index 'idx_delta_logs'...
FATAL: failed to lock /var/www/logzilla/sphinx/data/idx_delta_logs.tmp.spl: Resource temporarily unavailable, will not index. Try --rotate option.
Indexer started on 2011-12-18 at 23:55:01 and completed on 2011-12-18 at 23:55:01
collected 197779 docs, 26.8 MB
sorted 2.3 Mhits, 100.0% done
total 197779 docs, 26824969 bytes
total 2.041 sec, 13138256 bytes/sec, 96867.63 docs/sec
total 3 reads, 0.015 sec, 7347.0 kb/call avg, 5.0 msec/call avg
total 40 writes, 0.044 sec, 1262.0 kb/call avg, 1.1 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=11024).



and this:

Starting Sphinx Indexer: 2011-12-19 00:00:01
Spawning MERGE indexer for idx_logs and idx_delta_logs
Running command: /var/www/logzilla/sphinx/bin/indexer --config /var/www/logzilla/sphinx/sphinx.conf --merge idx_logs idx_delta_logs --rotate


Starting Sphinx Indexer: 2011-12-19 00:00:01
Spawning DELTA indexer for delta idx_delta_logs
Running Command: /var/www/logzilla/sphinx/bin/indexer --config /var/www/logzilla/sphinx/sphinx.conf --rotate idx_delta_logs


Starting Sphinx Indexer: 2011-12-19 00:00:01
Spawning DELTA indexer for delta idx_delta_logs
Running Command: /var/www/logzilla/sphinx/bin/indexer --config /var/www/logzilla/sphinx/sphinx.conf --rotate idx_delta_logs


Starting Sphinx Indexer: 2011-12-19 00:00:01
Spawning MERGE indexer for idx_logs and idx_delta_logs
Running command: /var/www/logzilla/sphinx/bin/indexer --config /var/www/logzilla/sphinx/sphinx.conf --merge idx_logs idx_delta_logs --rotate
Sphinx 0.9.9-id64-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/var/www/logzilla/sphinx/sphinx.conf'...
indexing index 'idx_delta_logs'...
Sphinx 0.9.9-id64-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/var/www/logzilla/sphinx/sphinx.conf'...
indexing index 'idx_delta_logs'...
FATAL: failed to lock /var/www/logzilla/sphinx/data/idx_delta_logs.tmp.spl: Resource temporarily unavailable, will not index. Try --rotate option.
Indexer started on 2011-12-19 at 00:00:01 and completed on 2011-12-19 at 00:00:01
Sphinx 0.9.9-id64-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/var/www/logzilla/sphinx/sphinx.conf'...
merged 25.4 Kwords
Sphinx 0.9.9-id64-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/var/www/logzilla/sphinx/sphinx.conf'...
merged 25.4 Kwords
merged in 0.496 sec
ERROR: index 'idx_logs': failed to rename '/var/www/logzilla/sphinx/data/idx_logs.sph.tmp' to '/var/www/logzilla/sphinx/data/idx_logs.new.sph': No such file or directorytotal 4 reads, 0.013 sec, 2193.7 kb/call avg, 3.4 msec/call avg
total 114 writes, 0.033 sec, 250.1 kb/call avg, 0.2 msec/call avg
merged in 0.461 sec
total 4 reads, 0.007 sec, 2193.7 kb/call avg, 1.7 msec/call avg
total 114 writes, 0.025 sec, 250.1 kb/call avg, 0.2 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=11024).
Indexer started on 2011-12-19 at 00:00:01 and completed on 2011-12-19 at 00:00:01
Indexer started on 2011-12-19 at 00:00:01 and completed on 2011-12-19 at 00:00:01
collected 198196 docs, 26.9 MB
sorted 2.3 Mhits, 100.0% done
total 198196 docs, 26881634 bytes
total 2.846 sec, 9444569 bytes/sec, 69634.00 docs/sec
total 3 reads, 0.014 sec, 7362.6 kb/call avg, 4.8 msec/call avg
total 40 writes, 0.051 sec, 1264.6 kb/call avg, 1.2 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=11024).
Indexer started on 2011-12-19 at 00:00:01 and completed on 2011-12-19 at 00:00:03

What can i do to avoid this?

Best regards
« Last Edit: December 19, 2011, 07:52:51 am by Stylewarz3 »

Offline cdukes

  • LogZilla
  • Administrator
  • Hero Member
  • *****
  • Posts: 951
    • View Profile
    • LogZilla
Re: Sphinx Problems
« Reply #1 on: December 19, 2011, 10:59:00 am »
This error:
Quote
FATAL: failed to lock /var/www/logzilla/sphinx/data/idx_delta_logs.tmp.spl: Resource temporarily unavailable, will not index. Try --rotate option.

Means that your indexing times are overlapping. Check your /etc/cron.d/logzilla and change the default 1 minute to a higher number.

The other one:
Quote
ERROR: index 'idx_logs': failed to rename '/var/www/logzilla/sphinx/data/idx_logs.sph.tmp

I'm not sure, but take care of the first and it may fix the second :)

Also, I've opened up the beta this week if you are interested - here are the details:
http://forum.logzilla.pro/index.php/topic,422.0.html
Your Network is Your Business.  Be Proactive.  Go LogZilla.
Clayton Dukes
CTO, LogZilla, LLC
http://www.logzilla.pro

Offline Stylewarz3

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: Sphinx Problems
« Reply #2 on: December 19, 2011, 12:19:07 pm »
many thanks!!!

the problem was: 2 simultan cronjobs, one with "crontab -e" and one with "/etc/cron.d/logzilla"