Beyond indexing and query logs, I can't think of anywhere else to look, sorry.
-- Pat On 16/02/2011, at 6:14 AM, gmoniey wrote: > Yea...I took a snapshot of the production database. > > Are there any other logs, or anywhere else that I can look at? > > The odd thing, is I have been using sphinx in a separate app setup for > almost a year and a half, and never ran into this issue. > > > On Feb 15, 12:42 am, Pat Allan <[email protected]> wrote: >> I'm at a bit of a loss what could be causing the problem... is the data the >> same on dev and production? >> >> -- >> Pat >> >> On 15/02/2011, at 7:05 PM, gmoniey wrote: >> >> >> >> >> >> >> >>> Yup...I verified that the version across both systems are the same: >> >>> Sphinx 0.9.9-release (r2117) >>> daemon_controller (0.2.5) >>> daemons (1.1.0) >>> delayed_job (2.0.3) >>> riddle (1.2.2) >>> thinking-sphinx (1.3.20) >>> ts-delayed-delta (1.1.1) >> >>> And I rebuilt the indexes on both machines before running my tests. >> >>> On Feb 14, 2:52 pm, Pat Allan <[email protected]> wrote: >>>> Is it the same version of Sphinx on both machines? And I'm guessing you've >>>> run rake ts:rebuild on your production server? >> >>>> -- >>>> Pat >> >>>> On 15/02/2011, at 5:51 AM, gmoniey <[email protected]> wrote: >> >>>>> I'm not sure whats going on, and I was hoping someone could help point >>>>> me in the right direction as far as debugging is concerned. It seems >>>>> that when I perform a simple search on my production setup, I am >>>>> returned no results, while my local returns the correct result. >> >>>>> I tested this in script/console, with the following query. On my >>>>> local, 1 result was returned (which is correct), while on production >>>>> an empty array is returned.: >> >>>>> Contact.search('*107703*') >> >>>>> I verified that I have the same set of gems on both machines. I >>>>> checked the logs, and they didn't report any errors. I'm not sure >>>>> where else to look. >> >>>>> I also tried setting my local to production mode, and I continue to >>>>> get the correct results. So I don't believe it is an issue with my >>>>> yaml: >> >>>>> development: >>>>> enable_star: 1 >>>>> min_infix_len: 1 >>>>> morphology: stem_en >> >>>>> testing: >>>>> enable_star: 1 >>>>> min_infix_len: 1 >>>>> morphology: stem_en >> >>>>> production: >>>>> version: 0.9.9 >>>>> mem_limit: 256M >>>>> enable_star: 1 >>>>> min_infix_len: 1 >>>>> morphology: stem_en >>>>> bin_path: "/usr/local/bin" >>>>> config_file: "/u/apps/my_app/shared/config/production.sphinx.conf" >>>>> searchd_file_path: "/u/apps/my_app/shared/system/sphinx" >>>>> searchd_log_file: "/u/apps/my_app/shared/log/searchd.log" >>>>> query_log_file: "/u/apps/my_app/shared/log/searchd.query.log" >>>>> pid_file: "/u/apps/my_app/shared/pids/searchd.pid" >> >>>>> It seems to only happen on specific records. Any ideas? Any other >>>>> places that I should be looking for debug info? >> >>>>> -- >>>>> 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 >>> 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. > -- 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.
