Hi Ginette, since I'm using capistrano for deployment this link helped me to get all working in production mode: http://stackoverflow.com/questions/1878021/how-do-i-start-thinking-sphinx-delayed-delta-rake-task-from-deploy-script
And these hooks in my deploy.rb are responsible to stop and start the delayed task: before "deploy:update", "delayed_delta:stop" after "deploy:update", "delayed_delta:start" Hope this helps. Frank On May 9, 1:24 pm, "ginettv" <[email protected]> wrote: > Hi Frank, > > How did you go about solving this issue with the delayed job. > > - > Ginette > > ----- Reply message ----- > From: "Frank" <[email protected]> > Date: Wed, May 9, 2012 4:38 pm > Subject: [ts] Re: Delayed delta index doesn't work in production mode > To: "Thinking Sphinx" <[email protected]> > > Hi Pat, > > after checking the whole process again it turned out that the problem > was in my deployment script. Apparently the delayed job was started > too early after deployment and didn't work properly. That one was hard > to find. ;-) > > Thanks a lot for your answer! > Frank > > On 8 Mai, 18:03, Pat Allan <[email protected]> wrote: > > > > > > > > > > > Hi Frank > > > Two things to check: are there any logs from your delayed job worker that > > could provide any clues? > > > And also, you may want to look at setting bin_path in your sphinx.yml > > settings to point to the directory where indexer and searchd are located - > > as Nginx/Apache/Passenger don't pick up the same PATH environment setting > > you will have in a > > shell.http://freelancing-god.github.com/ts/en/common_issues.html#passenger > > > -- > > Pat > > > On 09/05/2012, at 1:00 AM, Frank wrote: > > > > Hello everybody, > > > > after reading a lot of stuff about this issue I'm running out of > > > ideas. When I create a new object it won't appear in the search > > > results unless I do a reindex. Everything works fine in development > > > mode but not in staging/production mode. > > > > Running a manual search in the console or from the command line shows > > > that the delta index doesn't include the new object, though the > > > delayed job was created in the database and after that executed > > > immediately. > > > > This is how my model looks like: > > > > class Topic < ActiveRecord::Base > > > .... > > > define_index do > > > indexes title, :sortable => true > > > indexes body > > > indexes answers.body, :as => :answers > > > ... > > > set_property :delta => :delayed > > > end > > > ... > > > end > > > > sphinx.yml includes for production environment: > > > > enable_star: true > > > min_infix_len: 3 > > > charset_type: utf-8 > > > charset_table: "0..9, a..z, .... " > > > stopwords: config/sphinx/stopwords.txt > > > bin_path: "/usr/bin" > > > port: 9313 > > > > As well searchd and the rails app are running with the same user. > > > > Any ideas what kind of problem this could be? > > > > Thanks in advance for any hint! > > > Frank > > > > -- > > > 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.
