That sounds like a BackgroundRb bug.<br><br>FWIW -- I've got a production backgroundrb app running smoothly,<br>but I use the RAILS_ENV setting in the backgroundrb.yml to<br>set it to a production environment. I do not use the -r setting.
<br><br>Mason<br><br><div><span class="gmail_quote">On 1/22/07, <b class="gmail_sendername">Mike Aizatsky</b> <<a href="mailto:mike.aizatsky@gmail.com">mike.aizatsky@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Mason,<br><br>I've just had an idea and it turned out to be true in my situation. It<br>turned out, that after a while backgroundrb connects to my<br>_development_ database instead of production one. I'm invoking<br>
backgroundrb with the following command:<br><br>script/backgroundrb start -- -r production<br><br>It looks like -r doesn't propagate nicely.<br><br>On 1/22/07, Mason Hale <<a href="mailto:masonhale@gmail.com">masonhale@gmail.com
</a>> wrote:<br>> Hi Mike --<br>><br>> Can you please provide a stack trace or error message?<br>><br>> If you run the same worker over and over, can you recreate the problem?<br>> Or does this happen after no worker is run for some extended period of time?
<br>> (I'm guessing<br>> here that the db connection might be timing out)<br>><br>> Do you know if the problem is triggered by a certain number of innvocations,<br>> or is it a lack of activity, or neither?
<br>><br>> Mason<br>><br>><br>> On 1/22/07, Mike Aizatsky <<a href="mailto:mike.aizatsky@gmail.com">mike.aizatsky@gmail.com</a>> wrote:<br>> ><br>> > Hi!<br>> ><br>> > My cron-based worker is being indeed invoked by backgroundRB at
<br>> > correct times. But... After several runs it can no longer find DB<br>> > columns! The same query, which was running OK an hour ago starts to<br>> > throw MySQL error about unkown column in where clause. If I restart
<br>> > backgroundrb it works for some time but stops working after several<br>> > invocations.<br>> ><br>> > Has anyone epxerienced the similar beahviour? Are there any ideas of<br>> > what can be wrong? Any hints? Anything I can check?
<br>> ><br>> > --<br>> > Regards,<br>> > Mike<br>> > _______________________________________________<br>> > Backgroundrb-devel mailing list<br>> > <a href="mailto:Backgroundrb-devel@rubyforge.org">
Backgroundrb-devel@rubyforge.org</a><br>> ><br>> <a href="http://rubyforge.org/mailman/listinfo/backgroundrb-devel">http://rubyforge.org/mailman/listinfo/backgroundrb-devel</a><br>> ><br>><br>><br><br>
<br>--<br>Regards,<br>Mike<br></blockquote></div><br>