[storm] storm.exceptions.DisconnectionError: (2006, 'MySQL server has gone away')

[Gabriel Rossetti]

James Henstridge wrote:
> On Thu, Sep 11, 2008 at 2:55 PM, Gabriel Rossetti
> <gabriel.rossetti at arimaz.com> wrote:
>   
>> Hello eveyone,
>>
>> I get the following exception when I leave open a connection for a long
>> time :
>>
>> storm.exceptions.DisconnectionError: (2006, 'MySQL server has gone away')
>>
>> I understand the problem, my question is what is the usual thing to do?
>> I thought of :
>>
>>   1. When I get this exception, reconnect.
>>   2. "ping" the server
>>
>>
>> The problem with solution 1 is that I have to wrap all storm related
>> code in a try-catch or create a storm wrapper, which I'd prefer not to
>> have to do.
>>
>> The problem with solution 2 is that I'm not sure how to proceed (do a
>> flush or a commit once in a while?) and it seams a but wasful.
>>
>> Isn't there a way to do this from Strom, as in a parameter somewhere and
>> if the connection closes and it's set then it reconnects and tries again?
>>     
>
> If you do store.rollback(), Storm will automatically reconnect the
> connection for the next transaction.  The disconnection support in
> Storm is designed so that you can treat it just like any other
> transactional error (e.g. serialisation failures or dead locks): roll
> back the transaction and retry.
>
> James.
>   

Ok, thank you

Gabriel