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.
