I am currently running scripts to gather data in cross languages during this process while connected some languages such as no, sl, ro my script fails due to MySQL server has gone away.
OperationalError: (2006, 'MySQL server has gone away') Sleeping for 19.0 seconds, 2013-03-26 08:25:27 Sleeping for 22.0 seconds, 2013-03-26 08:25:46 Sleeping for 12.0 seconds, 2013-03-26 08:26:09 Sleeping for 5.0 seconds, 2013-03-26 08:26:21
My solution was to put a try except to handle this and reconnect to the server if the exception error code is 2006 but the problem is I have many query that I execute in multiple methods. I think an easy way to do is edit the mysql configure but obviously thats not an option. It doesn't happen all the time. Any suggestion or solutions? I am using python as my coding language.
Here is a rough idea of my solution: except MySQLdb.OperationalError, sqlEx: if sqlEx[0] == 2006: logging.info("Caught the MySQL Server Gone away exception correctly") logging.exception(sqlEx) time.sleep(10) self.connectServer() self.dbCursor.execute(botUserQuery)
Thank You, -- Anuradha Uduwage (Anu)