long running scripts lose connection to the mysql server if they don't
have any activity for a while. the connection library is supposed to
reconnect when this happens but in my experience it doesn't.
i'm not sure if this is the problem you're hitting, but if so, one
workaround is to have the script perform a simple query every 5 minutes.
this ensures that the mysql server never closes the connection due.
-Jacob
Mike Aizatsky wrote:
> Hi!
>> My cron-based worker is being indeed invoked by backgroundRB at
> correct times. But... After several runs it can no longer find DB
> columns! The same query, which was running OK an hour ago starts to
> throw MySQL error about unkown column in where clause. If I restart
> backgroundrb it works for some time but stops working after several
> invocations.
>> Has anyone epxerienced the similar beahviour? Are there any ideas of
> what can be wrong? Any hints? Anything I can check?
>