Yes, new records don't appear in search results until a complete reindex, which does not run that often.
Here is the directory structure of the share/db/sphinx/prod directory. drwxr-xr-x 2 deploy www-data 4096 2010-10-02 22:00 . drwxr-xr-x 3 deploy www-data 4096 2010-09-29 22:13 .. -rwxr-xr-x 1 deploy www-data 3000 2010-10-02 22:00 post_core.spa -rwxr-xr-x 1 deploy www-data 14344 2010-10-02 22:00 post_core.spd -rwxr-xr-x 1 deploy www-data 797 2010-10-02 22:00 post_core.sph -rwxr-xr-x 1 deploy www-data 4201 2010-10-02 22:00 post_core.spi -rwxr-xr-x 1 deploy www-data 0 2010-10-02 22:00 post_core.spk -rwxr-xr-x 1 deploy www-data 0 2010-10-02 22:00 post_core.spl -rwxr-xr-x 1 deploy www-data 0 2010-10-02 22:00 post_core.spm -rwxr-xr-x 1 deploy www-data 17313 2010-10-02 22:00 post_core.spp -rwxr-xr-x 1 deploy www-data 300 2010-10-02 22:00 post_delta.spa -rwxr-xr-x 1 deploy www-data 501 2010-10-02 22:00 post_delta.spd -rwxr-xr-x 1 deploy www-data 797 2010-10-02 22:00 post_delta.sph -rwxr-xr-x 1 deploy www-data 502 2010-10-02 22:00 post_delta.spi -rwxr-xr-x 1 deploy www-data 0 2010-10-02 22:00 post_delta.spk -rwxr-xr-x 1 deploy www-data 0 2010-10-02 22:00 post_delta.spl -rwxr-xr-x 1 deploy www-data 0 2010-10-02 22:00 post_delta.spm -rwxr-xr-x 1 deploy www-data 409 2010-10-02 22:00 post_delta.spp It seem the delta is owned by the "deploy" user. Here is my crontab file, the jobs don't have a user specified, the file is created by whenever gem. 0 22 * * * cd /var/www/appname/current && RAILS_ENV=production /usr/ bin/env rake ts:index 0 * * * * cd /var/www/appname/current && RAILS_ENV=production /usr/bin/ env rake ts:in:delta On Oct 2, 2:33 am, Pat Allan <[email protected]> wrote: > What exactly is the problem? Are edited records not appearing in the search > results within 60 minutes of them being changed? > > Also: What user is the delta index task being run as? > > The nginx error logs aren't going to help in this case, because delta > indexing doesn't happen via a web request, but by the rake task. I'd be > looking at your cron logs (assuming you're running that task via cron). > > Cheers > > -- > Pat > > On 02/10/2010, at 11:50 AM, badnaam wrote: > > > I have gone through several posts here..but can't seem to understand > > what might be happening in this case. > > > I am using the datatime gem based delta index approach. The delta > > index rake task runs every 60 minutes. > > > I am using passenger with nginx. The nginx process runs as root > > > in nginx.conf file I have the user directive as > > > user www-data www-data; > > > My rails app is owned by user "deploy" in the group www-data. > > > I don't see any obvious permission problem in nginx error logs. I have > > set the delta property appropriately I think. > > > define_index do > > indexes :body > > indexes :topic > > indexes :status > > indexes post_items.option, :as => :option > > indexes category.name, :as => :category_name > > indexes poster.city, :as => :city > > indexes poster.state, :as => :state > > indexes comments.body, :as => :comment_body > > > has created_at, updated_at > > has category_id, user_id, :status > > > has "RADIANS(users.lat)", :as => :lat, :type => :float > > has "RADIANS(users.lng)", :as => :lng, :type => :float > > > set_property :delta => :datetime, :threshold => 75.minutes > > end > > > And the bin_path in sphinx.yml > > > mem_limit: 20M > > enable_star: true > > searchd_file_path: /var/www/myapp/shared/db/sphinx/prod > > enable_star: true > > query_log_file: /var/www/myapp/shared/log/searchd.query.log > > config_file: /var/www/myapp/shared/config/prod_sphinx.conf > > searchd_log_file: /var/www/myapp/shared/log/searchd.log > > morphology: stem_en > > pid_file: /var/www/myapp/shared/pids/searchd_production.pid > > bin_path: '/usr/local/bin/' > > > Any ideas? > > > -- > > 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.
