not sure, but maybe you should set the reconnect argument
in your sqlalgemy engine definition (this is something mysql specific) :
connect_args={'reconnect':True}
On Fri, Jan 30, 2009 at 10:58 AM, Giovanni Marco Dall'Olio <
[email protected]> wrote:
>
> I wrote an elixir script which uploads a big amount of data in a database.
> Since it takes a long time to run, yesterday I had to leave it running
> for all night, but today, when I returned here, I have found that the
> script aborted with an error status of 'server has gone away'.
>
> It is not clear to me why this has happened.
> Basically, my script reads a file with about some thousand rows, and
> then uploads the data to the database. It takes about 20 minutes for
> every file (I have many of them).
> I have started the mysqld daemon with standard parameters, so,
> according to this reference:
>
> - http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
>
> it should only disconnect after 8 hours of inactivity.
> I don't understand why the mysql server has gone away, while my
> sqlelixir was actively uploading data every 20 minutes.
> Anyway, it could be because of some settings on my computer of which I
> am not aware yet.
> I wanted to ask if there is a way to force sqlelixir to reconnect to
> the server when the connection has falled down for some reason.
> I would like to do something like what is described here:
> """
> If you have a script, you just have to issue the query again for the
> client to do an automatic reconnection. This assumes that you have
> automatic reconnection in the client enabled (which is the default for
> the mysql command-line client).
> """
> from this page again:
> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
>
>
> --
>
> My blog on bioinformatics (now in English): http://bioinfoblog.it
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
