Hi Chris I'm not spotting anything immediately obvious that would cause this problem... but I guess the core issue is that Thinking Sphinx, within the context of cron, doesn't think that Sphinx is running. The fact that it's not consistent with this is definitely confusing.
Can you run us through the contents of your sphinx.yml file, if you have one? -- Pat On 16/10/2012, at 3:14 AM, internetchris wrote: > Hi Group, > > I'm not sure why this isn't working. I have setup TS in the past without > issue. I'm re-indexins my Rails app using a cronjob... > > The cronjob log makes it looks like it's successful, if I run the script > manually I get the following output. > > Generating Configuration to > /home/public_html/myapp.com/releases/20121015032144/config/production.sphinx.conf > Sphinx 2.0.5-release (r3308) > Copyright (c) 2001-2012, Andrew Aksyonoff > Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com) > > using config file > '/home/public_html/myapp.com/releases/20121015032144/config/production.sphinx.conf'... > indexing index 'user_core'... > WARNING: collect_hits: mem_limit=0 kb too low, increasing to 13568 kb > collected 74 docs, 0.0 MB > sorted 0.0 Mhits, 100.0% done > total 74 docs, 2438 bytes > total 0.028 sec, 86026 bytes/sec, 2611.15 docs/sec > skipping non-plain index 'user'... > total 3 reads, 0.000 sec, 1.5 kb/call avg, 0.0 msec/call avg > total 9 writes, 0.000 sec, 1.1 kb/call avg, 0.0 msec/call avg > rotating indices: succesfully sent SIGHUP to searchd (pid=713). > > > The biggest thing I see here is that it's "rotating indices" and I don't > remember seeing any of my previous apps doing this. In addition, I'm using a > rackspace cloud mysql db, but that should make a difference if it's finding > my data. I can finally get it to work after several attempts using "rake > ts:rebuild", but that's not ideal. > > > Here's my cronjob: > > # m h dom mon dow command > */1 * * * * cd /home/public_html/myapp.com/current && source > /home/internetchris/.rvm/gems/rub-1.9.3-p194@global/bin/rake && > /usr/bin/rake RAILS_ENV=production ts:index > > > Here's my syslog output for the cronjob: > > Oct 15 16:03:01 web01 CRON[16079]: (internetchris) CMD (cd > /home/public_html/myapp.com/current && source > /home/internetchris/.rvm/gems/rub-1.9.3-p194@global/bin/rake && > /usr/bin/rake RAILS_ENV=production ts:index) > > > Any ideas? > > > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/thinking-sphinx/-/p_xtiN0qcH4J. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
