Hi Pat, I really need to make TS run in our app server so I reinvestigated this. So I ran rebuild which gave the following
new_vps:~/trials/ts $ ps aux | grep searchd jim 25261 0.0 0.0 2072 636 pts/3 S+ 05:54 0:00 grep searchd new_vps:~/trials/ts $ rake ts:rebuild --trace (in /home/jim/trials/ts) ** Invoke ts:rebuild (first_time) ** Invoke thinking_sphinx:rebuild (first_time) ** Invoke thinking_sphinx:app_env (first_time) ** Execute thinking_sphinx:app_env ** Invoke environment (first_time) ** Execute environment ** Invoke environment ** Execute thinking_sphinx:rebuild ** Invoke thinking_sphinx:stop (first_time) ** Invoke thinking_sphinx:app_env ** Execute thinking_sphinx:stop Stopped search daemon (pid 25249). rake aborted! No such file or directory - /home/jim/trials/ts/log/searchd.development.pid /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/controller.rb:56:in `read' /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/controller.rb:56:in `pid' /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/controller.rb:49:in `stop' /usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.16/lib/thinking_sphinx/tasks.rb:49 /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' /home/jim/trials/ts/vendor/plugins/thinking-sphinx/tasks/../lib/thinking_sphinx/tasks.rb:85 /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:607:in `invoke_prerequisites' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:604:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:604:in `invoke_prerequisites' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:596:in `invoke_with_call_chain' /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 /usr/bin/rake:19:in `load' /usr/bin/rake:19 new_vps:~/trials/ts $ ps aux | grep searchd jim 25270 0.0 0.0 8288 716 pts/3 S 05:54 0:00 searchd --pidfile --config /home/jim/trials/ts/config/development.sphinx.conf jim 25272 0.0 0.0 2072 636 pts/3 S+ 05:55 0:00 grep searchd Searchd runs fine but there's an error. Any hint what's causing the error? On Mon, May 17, 2010 at 6:31 PM, Jim Ruther Nill <[email protected]> wrote: > No problem Pat. Thanks for the time. If you ever have any other ideas that > I can try, just hit me up an email. I will implement a search method for > the meantime. > > Thanks! > > > On Mon, May 17, 2010 at 5:49 PM, Pat Allan <[email protected]>wrote: > >> Sorry Jim, I've hit a bit of a brick wall with this... I'm not sure why >> it's timing out. I guess you could try opening up a socket connection >> yourself to Sphinx via telnet ('telnet localhost 9312'), to check that that >> works? Although, I would hope that's what the 'search' tool does too. >> >> -- >> Pat >> >> On 17/05/2010, at 7:17 PM, Jim Ruther Nill wrote: >> >> > yup. only the max_matches configuration. >> > >> > all: &DEFAULTS >> > max_matches: 100000 >> > development: >> > <<: *DEFAULTS >> > staging: >> > <<: *DEFAULTS >> > test: >> > <<: *DEFAULTS >> > production: >> > <<: *DEFAULTS >> > >> > >> > On Mon, May 17, 2010 at 5:10 PM, Pat Allan <[email protected]> >> wrote: >> > Hmm, okay, I think that rules out the firewall suggestion... >> > >> > Do you have anything in config/sphinx.yml? >> > >> > -- >> > Pat >> > >> > On 17/05/2010, at 7:03 PM, Jim Ruther Nill wrote: >> > >> > > i also tried that but it is working fine :( >> > > >> > > Sphinx 0.9.9-release (r2117) >> > > Copyright (c) 2001-2009, Andrew Aksyonoff >> > > >> > > using config file 'config/staging.sphinx.conf'... >> > > index 'contact_core': query '': returned 1000 matches of 2695 total in >> 0.000 sec >> > > >> > > displaying matches: >> > > 1. document=1, weight=1, sphinx_internal_id=1, class_crc=2212487076, >> subclass_crcs=(2212487076), sphinx_deleted=0, name_sort=2636, >> full_number_sort=2636, gnames_sort=5330, user_id=4, group_ids=(0) >> > > id=1 >> > > user_id=4 >> > > name=the quick brown >> > > country_code=65 >> > > phone_number=12312121 >> > > created_at=2010-04-15 09:01:22 >> > > updated_at=2010-04-15 09:01:22 >> > > contacts_count=(NULL) >> > > status=active >> > > delta=0 >> > > 2. document=2, weight=1, sphinx_internal_id=2, class_crc=2212487076, >> subclass_crcs=(2212487076), sphinx_deleted=0, name_sort=2634, >> full_number_sort=2637, gnames_sort=5330, user_id=4, group_ids=(0) >> > > id=2 >> > > user_id=4 >> > > name=fox jumped >> > > country_code=65 >> > > phone_number=12312122 >> > > created_at=2010-04-15 09:01:22 >> > > updated_at=2010-04-15 09:01:22 >> > > contacts_count=(NULL) >> > > status=active >> > > delta=0 >> > > . >> > > . >> > > . >> > > >> > > words: >> > > >> > > index 'contact_delta': query '': returned 0 matches of 0 total in >> 0.000 sec >> > > >> > > words: >> > > >> > > On Mon, May 17, 2010 at 4:55 PM, Pat Allan <[email protected]> >> wrote: >> > > I think the odds of it being a firewall issue are small, but it's just >> odd that searchd is running, and yet we can't talk to it... and really, a >> firewall should not block traffic from within the server, just from outside >> getting in. >> > > >> > > I guess one other thing to try is 'search', which is the command line >> tool that comes with Sphinx. You'll need to run it like this (from the >> contactor dir): >> > > >> > > search --config config/staging.sphinx.conf >> > > >> > > What output does that provide? >> > > >> > > -- >> > > Pat >> > > >> > > On 17/05/2010, at 6:48 PM, Jim Ruther Nill wrote: >> > > >> > > > yup I'm testing in staging console. >> > > > >> > > > Pardon me for asking but would there be a firewall issue for ubuntu? >> > > > >> > > > On Mon, May 17, 2010 at 4:45 PM, Pat Allan < >> [email protected]> wrote: >> > > > And you're testing from 'script/console staging'? >> > > > >> > > > If so, this is definitely an odd problem. Would it be a firewall >> issue? >> > > > >> > > > -- >> > > > Pat >> > > > >> > > > On 17/05/2010, at 6:39 PM, Jim Ruther Nill wrote: >> > > > >> > > > > here's the output. >> > > > > jim 17106 0.0 0.0 8492 736 pts/0 S 08:05 0:00 >> searchd --pidfile --config >> /var/www/staging/contactor/config/staging.sphinx.conf >> > > > > >> > > > > currently, i'm just running the staging searchd but the staging >> and the production app is in the same server. >> > > > > >> > > > > other details: >> > > > > >> > > > > I'm running the rake task the same way as I do in my development >> box. >> > > > > >> > > > > rake ts:rebuild RAILS_ENV=staging >> > > > > >> > > > > or >> > > > > >> > > > > rake ts:index RAILS_ENV=staging >> > > > > rake ts:start RAILS_ENV=staging >> > > > > >> > > > > Thanks! >> > > > > >> > > > > On Mon, May 17, 2010 at 4:35 PM, Pat Allan < >> [email protected]> wrote: >> > > > > Hi Jim >> > > > > >> > > > > I just want to double-check - what's the output of (on the command >> line): >> > > > > ps aux | grep searchd >> > > > > >> > > > > Your email hadn't gotten lost - I've just been away for the >> weekend :) >> > > > > >> > > > > -- >> > > > > Pat >> > > > > >> > > > > On 17/05/2010, at 6:31 PM, Jim Ruther Nill wrote: >> > > > > >> > > > > > Hi Pat, >> > > > > > >> > > > > > I've sent a pm thinking that this message was probably lost or >> something. >> > > > > > >> > > > > > Anyway, I'm sure that there's a searchd process running. The >> ts:index outcome was: >> > > > > > >> > > > > > indexing index 'contact_core'... >> > > > > > collected 2695 docs, 0.1 MB >> > > > > > collected 5391 attr values >> > > > > > sorted 0.0 Mvalues, 100.0% done >> > > > > > sorted 0.0 Mhits, 100.0% done >> > > > > > total 2695 docs, 65171 bytes >> > > > > > total 0.269 sec, 241950 bytes/sec, 10005.30 docs/sec >> > > > > > indexing index 'contact_delta'... >> > > > > > collected 0 docs, 0.0 MB >> > > > > > collected 0 attr values >> > > > > > sorted 0.0 Mvalues, nan% done >> > > > > > total 0 docs, 0 bytes >> > > > > > total 0.008 sec, 0 bytes/sec, 0.00 docs/sec >> > > > > > distributed index 'contact' can not be directly indexed; >> skipping. >> > > > > > total 16 reads, 0.000 sec, 32.4 kb/call avg, 0.0 msec/call avg >> > > > > > total 16 writes, 0.013 sec, 52.7 kb/call avg, 0.8 msec/call avg >> > > > > > Started successfully (pid 17106). >> > > > > > >> > > > > > >> > > > > > On Mon, May 17, 2010 at 4:13 PM, Pat Allan < >> [email protected]> wrote: >> > > > > > Hi Jim >> > > > > > >> > > > > > Can you confirm that there is a searchd process running? Seems >> like you've done everything right... >> > > > > > >> > > > > > -- >> > > > > > Pat >> > > > > > >> > > > > > On 13/05/2010, at 4:23 PM, jim wrote: >> > > > > > >> > > > > > > Hi guys! I'm new here so please be patient with my questions >> :D >> > > > > > > >> > > > > > > I just installed sphinx and thinking_sphinx. I also >> successfully run >> > > > > > > the ts:index and ts:start rake tasks. However, when I go to >> the >> > > > > > > console and try searching, I get a timeout error. Any ideas? >> > > > > > > >> > > > > > > The stack trace below: >> > > > > > >>> Contact.search '' >> > > > > > > Errno::ETIMEDOUT: Connection timed out - connect(2) >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/client.rb: >> > > > > > > 512:in `initialize' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/client.rb: >> > > > > > > 512:in `new' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/client.rb: >> > > > > > > 512:in `initialise_socket' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/0.9.9/ >> > > > > > > client.rb:8:in `initialise_connection' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/client.rb: >> > > > > > > 452:in `open_socket' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/client.rb: >> > > > > > > 479:in `connect' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/client.rb: >> > > > > > > 535:in `request' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/client.rb: >> > > > > > > 203:in `run' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/riddle-1.0.10/lib/riddle/client.rb: >> > > > > > > 310:in `query' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.16/lib/ >> > > > > > > thinking_sphinx/search.rb:266:in `populate' >> > > > > > > from /usr/lib/ruby/1.8/benchmark.rb:308:in `realtime' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.16/lib/ >> > > > > > > thinking_sphinx/search.rb:265:in `populate' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.16/lib/ >> > > > > > > thinking_sphinx/search.rb:388:in `call' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.16/lib/ >> > > > > > > thinking_sphinx/search.rb:388:in `retry_on_stale_index' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.16/lib/ >> > > > > > > thinking_sphinx/search.rb:262:in `populate' >> > > > > > > from >> /usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.16/lib/ >> > > > > > > thinking_sphinx/search.rb:118:in `method_missing' >> > > > > > > from /usr/lib/ruby/1.8/irb.rb:302:in `output_value' >> > > > > > > from /usr/lib/ruby/1.8/irb.rb:151:in `eval_input' >> > > > > > > from /usr/lib/ruby/1.8/irb.rb:263:in `signal_status' >> > > > > > > from /usr/lib/ruby/1.8/irb.rb:147:in `eval_input' >> > > > > > > from /usr/lib/ruby/1.8/irb.rb:146:in `eval_input' >> > > > > > > from /usr/lib/ruby/1.8/irb.rb:70:in `start' >> > > > > > > from /usr/lib/ruby/1.8/irb.rb:69:in `catch' >> > > > > > > from /usr/lib/ruby/1.8/irb.rb:69:in `start' >> > > > > > > from /usr/bin/irb:13 >> > > > > > > >> > > > > > > -- >> > > > > > > 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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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]<thinking-sphinx%[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.
