Any patterns to the timing of the issue? What about load on the server? Harder to track that, I guess...
-- Pat On 20/03/2011, at 9:41 PM, Robby Russell wrote: > Thanks for this. Been running in production for a few hours with > that... but still producing the same problem. *scratches head* > > Now to think of some other ways to dissect this problem. > > On Sun, Mar 20, 2011 at 3:40 PM, Pat Allan <[email protected]> wrote: >> Yeah, unless Sphinx is on the app server, it's best to. This should do the >> trick: >> >> production: >> version: 0.9.9 >> >> That'll make sure Riddle loads its 0.9.9 additions. >> >> -- >> Pat >> >> On 20/03/2011, at 5:35 PM, Robby Russell wrote: >> >>> We're not. Should we be? >>> >>> On Sun, Mar 20, 2011 at 3:25 PM, Pat Allan <[email protected]> >>> wrote: >>>> In a similar vein, are you setting the Sphinx version number in your >>>> config/sphinx.yml file, given that Sphinx isn't on your app servers? >>>> >>>> -- >>>> Pat >>>> >>>> On 20/03/2011, at 5:22 PM, Robby Russell wrote: >>>> >>>>> I noticed that Riddle had some variant code depending on the version >>>>> of the sphinx server. I hadn't restarted the app servers yet, so just >>>>> did that and will see if that makes any difference. >>>>> >>>>> On Sun, Mar 20, 2011 at 3:16 PM, Pat Allan <[email protected]> >>>>> wrote: >>>>>> Fun indeed. >>>>>> >>>>>> Have you posted to the Sphinx forum? Given that post you referred to is >>>>>> three years old, perhaps there's people with a better idea of what's >>>>>> causing it now? >>>>>> >>>>>> And just to check - the timing of the problem doesn't match the timing >>>>>> of your indexing, does it? >>>>>> >>>>>> -- >>>>>> Pat >>>>>> >>>>>> On 20/03/2011, at 4:38 PM, Robby Russell wrote: >>>>>> >>>>>>> A few hours later, it appears that we're still hitting the same >>>>>>> problem with 0.9.9. Fun fun! >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Sun, Mar 20, 2011 at 11:54 AM, Robby Russell >>>>>>> <[email protected]> wrote: >>>>>>>> We're adding more memory to the sphinx servers and upgrading to 0.9.9. >>>>>>>> Will let you know what we uncover through that process... >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Sat, Mar 19, 2011 at 3:45 PM, Pat Allan <[email protected]> >>>>>>>> wrote: >>>>>>>>> Well that's frustrating. >>>>>>>>> >>>>>>>>> I agree that the fact that it's only cropping up since you've >>>>>>>>> switched to TS is a fair reason to suspect TS/Riddle. Can't think why >>>>>>>>> it would be so unreliable (and difficult to reproduce). >>>>>>>>> >>>>>>>>> A shot in the dark, but could you try upgrading to Sphinx 0.9.9 or >>>>>>>>> even 1.10-beta? >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Pat >>>>>>>>> >>>>>>>>> On 19/03/2011, at 5:42 PM, Robby Russell wrote: >>>>>>>>> >>>>>>>>>> On Sat, Mar 19, 2011 at 12:33 PM, Pat Allan >>>>>>>>>> <[email protected]> wrote: >>>>>>>>>>> To be honest, this is at the edge of my Sphinx knowledge. I'd >>>>>>>>>>> recommend posting a question on the Sphinx forum, talk through how >>>>>>>>>>> usually the search works, but sometimes doesn't - and yet results >>>>>>>>>>> from Sphinx say there should be results. >>>>>>>>>>> >>>>>>>>>>> In the meantime, you could add something like the following to your >>>>>>>>>>> controller: >>>>>>>>>>> >>>>>>>>>>> @variations = TourVariation.search 'foo' >>>>>>>>>>> if @variations.empty? && @variations.results[:total] > 0 >>>>>>>>>>> @variations = TourVariation.search 'foo' >>>>>>>>>>> end >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Actually, we tried raising an exception, rescuing and forcing it to >>>>>>>>>> retry up time five times with a short delay between... and each time >>>>>>>>>> it was still returning zero results. When it's not cooperating... it >>>>>>>>>> seems like that individual request is just a lost cause. >>>>>>>>>> >>>>>>>>>> Robby >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> 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. >>>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> 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. >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> 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. >>>>>>> >>>>>> >>>>>> -- >>>>>> 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. >>>>>> >>>>>> >>>>> >>>>> -- >>>>> 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. >>>>> >>>> >>>> -- >>>> 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. >>>> >>>> >>> >>> -- >>> 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. >>> >> >> -- >> 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. >> >> > > -- > 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. > -- 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.
