Short update: It seems that the workers go into some state in which they do not have a correct Rails environment (or db connection). When they enter this state it goes wrong all the time :( Joost Hietbrink (YelloYello) wrote:> Hi all, > > We''re experiencing some problems with Backgroundrb. > > Why is "# master_reactor_instance.result_hash = {}" commented in > packet_master.rb? BackgroundRb only seems to work when it is enabled? > Sometimes we get a "Mysql::Error: Lost connection to MySQL server > during query" error. This in the Backgroundrb job and occurs only half > of the time or something. It seems that the Rails environment isn''t > correct?! or something.. > > Let me know if you have any suggestions! Thanks! > > Joost >
On Dec 27, 2007 1:58 PM, Joost Hietbrink (YelloYello) <joost at yelloyello.com> wrote:> Short update: > It seems that the workers go into some state in which they do not have a > correct Rails environment (or db connection). When they enter this state > it goes wrong all the time :(There doesn''t seem to be any problem with problem with RAILS environment in my application. But first make sure you are running C version of mysql gem.> > Joost Hietbrink (YelloYello) wrote: > > Hi all, > > > > We''re experiencing some problems with Backgroundrb. > > > > Why is "# master_reactor_instance.result_hash = {}" commented in > > packet_master.rb? BackgroundRb only seems to work when it is enabled? > > Sometimes we get a "Mysql::Error: Lost connection to MySQL server > > during query" error. This in the Backgroundrb job and occurs only half > > of the time or something. It seems that the Rails environment isn''t > > correct?! or something.. > > > > Let me know if you have any suggestions! Thanks! > > > > Joost > > > _______________________________________________ > Backgroundrb-devel mailing list > Backgroundrb-devel at rubyforge.org > http://rubyforge.org/mailman/listinfo/backgroundrb-devel >-- Let them talk of their oriental summer climes of everlasting conservatories; give me the privilege of making my own summer with my own coals. http://gnufied.org
I see we haven''t got the mysql gem installed on the production server. So that may cause the problem? Is it required for backgroundrb?! Joost hemant wrote:> On Dec 27, 2007 1:58 PM, Joost Hietbrink (YelloYello) > <joost at yelloyello.com> wrote: > >> Short update: >> It seems that the workers go into some state in which they do not have a >> correct Rails environment (or db connection). When they enter this state >> it goes wrong all the time :( >> > > There doesn''t seem to be any problem with problem with RAILS > environment in my application. > But first make sure you are running C version of mysql gem. > > >> Joost Hietbrink (YelloYello) wrote: >> >>> Hi all, >>> >>> We''re experiencing some problems with Backgroundrb. >>> >>> Why is "# master_reactor_instance.result_hash = {}" commented in >>> packet_master.rb? BackgroundRb only seems to work when it is enabled? >>> Sometimes we get a "Mysql::Error: Lost connection to MySQL server >>> during query" error. This in the Backgroundrb job and occurs only half >>> of the time or something. It seems that the Rails environment isn''t >>> correct?! or something.. >>> >>> Let me know if you have any suggestions! Thanks! >>> >>> Joost >>> >>> >> _______________________________________________ >> Backgroundrb-devel mailing list >> Backgroundrb-devel at rubyforge.org >> http://rubyforge.org/mailman/listinfo/backgroundrb-devel >> >> > > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/backgroundrb-devel/attachments/20071227/2874f051/attachment.html
On Dec 27, 2007 3:17 PM, Joost Hietbrink <joost at yelloyello.com> wrote:> > I see we haven''t got the mysql gem installed on the production server. So > that may cause the problem? Is it required for backgroundrb?!If you are using your models, then surely you need mysql gem. By default rails comes with pure ruby mysql adapter, which is known to have problems with database connectivity. Generally, moving to C based gem solves the problem.> > Joost > > > hemant wrote: > On Dec 27, 2007 1:58 PM, Joost Hietbrink (YelloYello) > <joost at yelloyello.com> wrote: > > > Short update: > It seems that the workers go into some state in which they do not have a > correct Rails environment (or db connection). When they enter this state > it goes wrong all the time :( > > There doesn''t seem to be any problem with problem with RAILS > environment in my application. > But first make sure you are running C version of mysql gem. > > > > Joost Hietbrink (YelloYello) wrote: > > > Hi all, > > We''re experiencing some problems with Backgroundrb. > > Why is "# master_reactor_instance.result_hash = {}" commented in > packet_master.rb? BackgroundRb only seems to work when it is enabled? > Sometimes we get a "Mysql::Error: Lost connection to MySQL server > during query" error. This in the Backgroundrb job and occurs only half > of the time or something. It seems that the Rails environment isn''t > correct?! or something.. > > Let me know if you have any suggestions! Thanks! > > Joost > > > _______________________________________________ > Backgroundrb-devel mailing list > Backgroundrb-devel at rubyforge.org > http://rubyforge.org/mailman/listinfo/backgroundrb-devel > > > > > > >-- Let them talk of their oriental summer climes of everlasting conservatories; give me the privilege of making my own summer with my own coals. http://gnufied.org
Thanks! This fixes the problem! I have another error. When using the trunk version of backgroundrb and when I have "require RAILS_HOME + ''/config/boot.rb''" set in script/backgroundrb I get errors like: /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.6/lib/active_record/base.rb:1238:in `method_missing'': undefined method `attr_readonly'' So I removed that line..(like in the 1.0 version).. and everything works perfectly. Greets, Joost hemant wrote:> On Dec 27, 2007 3:17 PM, Joost Hietbrink <joost at yelloyello.com> wrote: > >> I see we haven''t got the mysql gem installed on the production server. So >> that may cause the problem? Is it required for backgroundrb?! >> > > If you are using your models, then surely you need mysql gem. By > default rails comes with pure ruby mysql adapter, which is known to > have problems with database connectivity. > > Generally, moving to C based gem solves the problem. > > >> Joost >> >> >> hemant wrote: >> On Dec 27, 2007 1:58 PM, Joost Hietbrink (YelloYello) >> <joost at yelloyello.com> wrote: >> >> >> Short update: >> It seems that the workers go into some state in which they do not have a >> correct Rails environment (or db connection). When they enter this state >> it goes wrong all the time :( >> >> There doesn''t seem to be any problem with problem with RAILS >> environment in my application. >> But first make sure you are running C version of mysql gem. >> >> >> >> Joost Hietbrink (YelloYello) wrote: >> >> >> Hi all, >> >> We''re experiencing some problems with Backgroundrb. >> >> Why is "# master_reactor_instance.result_hash = {}" commented in >> packet_master.rb? BackgroundRb only seems to work when it is enabled? >> Sometimes we get a "Mysql::Error: Lost connection to MySQL server >> during query" error. This in the Backgroundrb job and occurs only half >> of the time or something. It seems that the Rails environment isn''t >> correct?! or something.. >> >> Let me know if you have any suggestions! Thanks! >> >> Joost >> >> >> _______________________________________________ >> Backgroundrb-devel mailing list >> Backgroundrb-devel at rubyforge.org >> http://rubyforge.org/mailman/listinfo/backgroundrb-devel >> >> >> >> >> >> >> >> > > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/backgroundrb-devel/attachments/20071227/67029934/attachment.html