Installing telnet didn't work. But I saw something weird. I usually use 127.0.0.1 as my host value in database.yml. But I can't connect to the mysql server using 127.0.0.1 as host when I'm in the server. Also, writing to the db times out as well when the sphinx server is running.
On Thu, Jun 10, 2010 at 1:34 PM, Jim Ruther Nill <[email protected]> wrote: > Yup. Like I said before, I'm running the same app in my local machine and > it's working. I also created a sample app with one model to index but the > same behavior. I tried your suggestion using telnet and it seems that I > have telnet in my local but not in the server. I'm asking the moderator to > install telnet and see if that solves the problem. :) I'll keep you posted > :) > > > On Thu, Jun 10, 2010 at 1:25 PM, Pat Allan <[email protected]>wrote: > >> Well, at least we're back to just the one issue ;) >> >> Just to run through this again, since it's been a while... have you tried >> running it on a different machine? And/or a different Rails app on the same >> machine? >> >> -- >> Pat >> >> On 10/06/2010, at 1:23 PM, Jim Ruther Nill wrote: >> >> > Right on Pat! Thanks! >> > >> > However, I can't still search. it's still timing out. >> > >> > >> > On Wed, Jun 9, 2010 at 7:42 PM, Pat Allan <[email protected]> >> wrote: >> > Hi Jim >> > >> > It looks like it's trying to run the rake tasks twice. Do you have TS >> installed as both a gem and a plugin? >> > >> > -- >> > Pat >> > >> > On 09/06/2010, at 4:05 PM, Jim Ruther Nill wrote: >> > >> > > Please ignore my previous email. :D >> > > >> > > Here's the trace and steps I did: >> > > >> > > >> > > new_vps:~/trials/ts $ ps aux | grep searchd >> > > jim 25276 0.0 0.0 2072 640 pts/3 S+ 06:02 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:index (first_time) >> > > ** Invoke thinking_sphinx:app_env >> > > ** Execute thinking_sphinx:index >> > > Generating Configuration to >> /home/jim/trials/ts/config/development.sphinx.conf >> > > Sphinx 0.9.9-release (r2117) >> > > Copyright (c) 2001-2009, Andrew Aksyonoff >> > > >> > > using config file >> '/home/jim/trials/ts/config/development.sphinx.conf'... >> > > indexing index 'post_core'... >> > > collected 0 docs, 0.0 MB >> > > total 0 docs, 0 bytes >> > > total 0.004 sec, 0 bytes/sec, 0.00 docs/sec >> > > distributed index 'post' can not be directly indexed; skipping. >> > > total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg >> > > total 4 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg >> > > Generating Configuration to >> /home/jim/trials/ts/config/development.sphinx.conf >> > > Sphinx 0.9.9-release (r2117) >> > > Copyright (c) 2001-2009, Andrew Aksyonoff >> > > >> > > using config file >> '/home/jim/trials/ts/config/development.sphinx.conf'... >> > > indexing index 'post_core'... >> > > collected 0 docs, 0.0 MB >> > > total 0 docs, 0 bytes >> > > total 0.004 sec, 0 bytes/sec, 0.00 docs/sec >> > > distributed index 'post' can not be directly indexed; skipping. >> > > total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg >> > > total 4 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg >> > > ** Invoke thinking_sphinx:start (first_time) >> > > ** Invoke thinking_sphinx:app_env >> > > ** Execute thinking_sphinx:start >> > > Started successfully (pid 25299). >> > > rake aborted! >> > > searchd is already running. >> > > >> /usr/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.16/lib/thinking_sphinx/tasks.rb:29 >> > > /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:87 >> > > /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 25299 0.0 0.0 8288 716 pts/3 S 06:02 0:00 >> searchd --pidfile --config >> /home/jim/trials/ts/config/development.sphinx.conf >> > > jim 25301 0.0 0.0 2072 640 pts/3 S+ 06:03 0:00 grep >> searchd >> > > >> > > >> > > >> > > -- >> > > 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.
