madhankumar nagaraj
2009-Jan-02 08:57 UTC
[Backgroundrb-devel] Backgroundrb stops suddenly
hi, i have used backgroundrb to update the database with the files having some useful data, where i am getting files periodically uploaded. it works well, but suddenly it stops the worker and stopped the updation. when i checked the backgroundrb.log file it shows Mysql::Error: MySQL server has gone away: (Query used for updation)? LIMIT 1 - (ActiveRecord::StatementInvalid) but, the query is working fine in mysql. i have created one worker to do the updation with job_key. when i checked the job_key value for the particular worker is shows nil. since the worker was stopped. what would be the problem, how can i make the updation works continuously. thanks Madhan. Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://rubyforge.org/pipermail/backgroundrb-devel/attachments/20090102/29172ec2/attachment.html>
Which version of mysql gem you are using? If you use mysql C gem, you should be fine. Also, try pasting worker code, so as we can help. On Fri, Jan 2, 2009 at 2:27 PM, madhankumar nagaraj <n.madhan at yahoo.co.in> wrote:> hi, > i have used backgroundrb to update the database with the files having some > useful data, where i am getting files periodically uploaded. > it works well, but suddenly it stops the worker and stopped the updation. > when i checked the backgroundrb.log file > it shows > Mysql::Error: MySQL server has gone away: (Query used for updation) LIMIT 1 > - (ActiveRecord::StatementInvalid) > but, the query is working fine in mysql. > > i have created one worker to do the updation with job_key. > when i checked the job_key value for the particular worker is shows nil. > since the worker was stopped. > > what would be the problem, how can i make the updation works continuously. > > > > thanks > Madhan. > > ________________________________ > Add more friends to your messenger and enjoy! Invite them now. > _______________________________________________ > 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