and maybe setting pool_recycle=True in the engine definition helps as well...
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 -~----------~----~----~----~------~----~------~--~---
