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)