mmm ok thanks... I will try later (maybe next week) and let you know. Sorry if I post here while this could be a sqlalchemy's related issue, but I am using elixir and I don't know whether it could be due to one instead of another.
On Fri, Jan 30, 2009 at 11:09 AM, Erik Janssens <[email protected]> wrote: > 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 >> >> > > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
