yes I have run my usual capistrano deployment and I also tried to run /usr/local/bin/indexer --config /var/sport195/sphinx/config/ production.sphinx.conf --rotate --all directly logged into the server.
WARNING: failed to scanf pid from pid_file '/var/sport195/sphinx/log/ searchd.pid'. WARNING: indices NOT rotated. Still same result. On Sep 12, 2:59 pm, Pat Allan <[email protected]> wrote: > Have you run all of your migrations on your production server? > > -- > Pat > > On 13/09/2011, at 6:54 AM, gerberdata <[email protected]> wrote: > > > > > > > > > I am getting an error when I index on production but not on my local > > machine > > > Here is the error > > > ERROR: index 'injury_core': sql_range_query: You have an error in your > > SQL syntax; check the manual that corresponds to your MySQL server > > version for the right syntax to use near ' `injuries`.`id`, > > `injuries`.`name`, `injuries`.`id`, `injuries`.`injury_area_id' at > > line 1 (DSN=mysql://root:***@localhost:3306/m10_production). > > total 0 docs, 0 bytes > > total 0.001 sec, 0 bytes/sec, 0.00 docs/sec > > indexing index 'injury_delta'... > > ERROR: index 'injury_delta': sql_range_query: You have an error in > > your SQL syntax; check the manual that corresponds to your MySQL > > server version for the right syntax to use near ' `injuries`.`id`, > > `injuries`.`name`, `injuries`.`id`, `injuries`.`injury_area_id' at > > line 1 (DSN=mysql://root:***@localhost:3306/m10_production). > > total 0 docs, 0 bytes > > > WARNING: failed to scanf pid from pid_file '/var/sport195/sphinx/log/ > > searchd.pid'. > > WARNING: indices NOT rotated. > > > I am not getting this same error on development machine > > > total 0.093 sec, 123640 bytes/sec, 1343.11 docs/sec > > indexing index 'athlete_injury_delta'... > > collected 0 docs, 0.0 MB > > collected 0 attr values > > sorted 0.0 Mvalues, nan% done > > total 0 docs, 0 bytes > > total 0.012 sec, 0 bytes/sec, 0.00 docs/sec > > distributed index 'athlete_injury' can not be directly indexed; > > skipping. > > indexing index 'brand_core'... > > collected 2789 docs, 0.2 MB > > collected 5877 attr values > > sorted 0.0 Mvalues, 100.0% done > > sorted 0.0 Mhits, 100.0% done > > total 2789 docs, 151761 bytes > > total 399.961 sec, 379 bytes/sec, 6.97 docs/sec > > > Any ideas what might be causing this? > > > -- > > 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 > > athttp://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.
