Connection Refused Question.

[internetchris]

Hi Group,

I have repeatedly received this error over the last 3 months since we've implemented thinking sphinx on a rails app....

Riddle::ConnectionError: Connection to sphinx on 9312 failed

My index routine runs every 5 minutes and we have 3 different servers. I know the servers are talking to each other and I'm pretty certain I've configured everything ok.

I've been dismissing this error as "no big deal" because I made the assumption that this error is occurring because someone is trying to search while the indexer is running.  We get a lot of traffic on our site, so I'm wondering if I should be doing this differently. I didn't want to hassle delta indexes, but maybe that's the best thing to do. Either that or I can change the routine to every 15 minutes. 

Thoughts?  I'm happy to provide my configuration files if necessary.

Chris

[Pat Allan]

Hi Chris

Just to confirm: what does your indexing routine involve? Is it the ts:index task, or ts:rebuild? Also, may be worth noting the times of the errors, and look at Sphinx's log to see if there's any notices there from around the same time.

Cheers

--
Pat

> --
> 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/-/clXZCS8nCtQJ.
> To post to this group, send email to thinkin...@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.

[internetchris]

Hi Pat,

Thank for the reply - I apologize for the late response. I'm basically doing "rake ts:rebuild" using crontab. I will look at the errors and see if they correspond. 

Thanks,

Chris

On Wednesday, February 29, 2012 4:22:24 PM UTC-7, pat wrote:

Hi Chris

Just to confirm: what does your indexing routine involve? Is it the ts:index task, or ts:rebuild? Also, may be worth noting the times of the errors, and look at Sphinx's log to see if there's any notices there from around the same time.

Cheers

--
Pat

On 01/03/2012, at 2:54 AM, internetchris wrote:

> Hi Group,
>
> I have repeatedly received this error over the last 3 months since we've implemented thinking sphinx on a rails app....
>
> Riddle::ConnectionError: Connection to sphinx on 9312 failed
>
> My index routine runs every 5 minutes and we have 3 different servers. I know the servers are talking to each other and I'm pretty certain I've configured everything ok.
>
> I've been dismissing this error as "no big deal" because I made the assumption that this error is occurring because someone is trying to search while the indexer is running.  We get a lot of traffic on our site, so I'm wondering if I should be doing this differently. I didn't want to hassle delta indexes, but maybe that's the best thing to do. Either that or I can change the routine to every 15 minutes.
>
> Thoughts?  I'm happy to provide my configuration files if necessary.
>
> Chris
>
>
>
> --
> 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/-/clXZCS8nCtQJ.

> To post to this group, send email to thinking-sphinx@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphinx+unsubscribe@googlegroups.com.

[Pat Allan]

Hi Chris

You only need to run ts:index - rebuild stops Sphinx, indexes, then starts Sphinx again, which is only necessary when changing the structure of your indices. For just data updates, ts:index will do the trick nicely, and it means Sphinx won't be switched off/on.

Cheers

--
Pat

On 04/03/2012, at 8:51 AM, internetchris wrote:

> Hi Pat,
>
> Thank for the reply - I apologize for the late response. I'm basically doing "rake ts:rebuild" using crontab. I will look at the errors and see if they correspond.
>
> Thanks,
>
> Chris
>
>
> On Wednesday, February 29, 2012 4:22:24 PM UTC-7, pat wrote:
>
> Hi Chris
> Just to confirm: what does your indexing routine involve? Is it the ts:index task, or ts:rebuild? Also, may be worth noting the times of the errors, and look at Sphinx's log to see if there's any notices there from around the same time.
>
> Cheers
>
> --
> Pat
>
> On 01/03/2012, at 2:54 AM, internetchris wrote:
>
> > Hi Group,
> >
> > I have repeatedly received this error over the last 3 months since we've implemented thinking sphinx on a rails app....
> >
> > Riddle::ConnectionError: Connection to sphinx on 9312 failed
> >
> > My index routine runs every 5 minutes and we have 3 different servers. I know the servers are talking to each other and I'm pretty certain I've configured everything ok.
> >
> > I've been dismissing this error as "no big deal" because I made the assumption that this error is occurring because someone is trying to search while the indexer is running. We get a lot of traffic on our site, so I'm wondering if I should be doing this differently. I didn't want to hassle delta indexes, but maybe that's the best thing to do. Either that or I can change the routine to every 15 minutes.
> >
> > Thoughts? I'm happy to provide my configuration files if necessary.
> >
> > Chris
> >
> >
> >
> > --
> > 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/-/clXZCS8nCtQJ.

> > To post to this group, send email to thinkin...@googlegroups.com.
> > To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.

> > 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 view this discussion on the web visit https://groups.google.com/d/msg/thinking-sphinx/-/fihpioLCNdgJ.
> To post to this group, send email to thinkin...@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphi...@googlegroups.com.

[internetchris]

Hi Pat,

Why oh why didn't I ask about this sooner. I appreciate the help and that worked great. It was one of those nagging/ infrequent annoyances that should have been fixed sooner.

Thanks,

Chris

> > To post to this group, send email to thinking-sphinx@googlegroups.com.
> > To unsubscribe from this group, send email to thinking-sphinx+unsubscribe@googlegroups.com.

> > 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 view this discussion on the web visit https://groups.google.com/d/msg/thinking-sphinx/-/fihpioLCNdgJ.

> To post to this group, send email to thinking-sphinx@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphinx+unsubscribe@googlegroups.com.

> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.

> > To post to this group, send email to thinking-sphinx@googlegroups.com.
> > To unsubscribe from this group, send email to thinking-sphinx+unsubscribe@googlegroups.com.

> > 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 view this discussion on the web visit https://groups.google.com/d/msg/thinking-sphinx/-/fihpioLCNdgJ.

> To post to this group, send email to thinking-sphinx@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphinx+unsubscribe@googlegroups.com.

> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.

> > To post to this group, send email to thinking-sphinx@googlegroups.com.
> > To unsubscribe from this group, send email to thinking-sphinx+unsubscribe@googlegroups.com.

> > 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 view this discussion on the web visit https://groups.google.com/d/msg/thinking-sphinx/-/fihpioLCNdgJ.

> To post to this group, send email to thinking-sphinx@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphinx+unsubscribe@googlegroups.com.

> For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.

> > To post to this group, send email to thinking-sphinx@googlegroups.com.
> > To unsubscribe from this group, send email to thinking-sphinx+unsubscribe@googlegroups.com.

> > 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 view this discussion on the web visit https://groups.google.com/d/msg/thinking-sphinx/-/fihpioLCNdgJ.

> To post to this group, send email to thinking-sphinx@googlegroups.com.
> To unsubscribe from this group, send email to thinking-sphinx+unsubscribe@googlegroups.com.