I found a way to patch MySQLdb and then just add a small change to sqlobject/mysql/mysqlconnection.py in order to fix this problem. I wrote up what I did in this thread over on Pylons forums:
http://groups.google.com/group/pylons-discuss/browse_thread/thread/0e3f72ddce072484/# - Sean Dan Pascu wrote: > On Thursday 03 August 2006 18:06, sophana wrote: >> I have sqlobject-0.8dev (from easysetup). I found the line. I will try >> it. Do you know how to test this? I cannot stop the mysql server it is >> working for another production website... > > You can try it on another mysql server, where you can add a line like > this: > > wait-timeout = 5 > > in the [mysqld] section > > This will make any connection expire in 5 seconds and you can test what > happens without having to wait for 8 hours (which is the default mysqld > innactive connection timeout). Else you will have to wait for 8 hours, or > whatever the wait-timeout value is set in your mysql server. > > Though I'm not sure when the mysql lib generates 2006 (Server gone) and > when it generates 2013 (Server lost), so I cannot tell you how to test > for 2006 precisely. > > Also for this to work, your python-mysqldb must support reconnecting. > Prior to mysql-5.0 it does support reconnecting out of the box. After > mysql-5.0 it depends. If you use debian testing/unstable, they have > applied a patch I've sent them for this. This patch is not in the > official python-mysqldb module and in the latter case, after it timeouts > it won't reconnect. > > I have also noticed that if I use python-mysqldb with the patch applied > and compiled with libmysqlclient from mysql-4.x, it will not reconnect to > a mysql-5.0 server after it timeouts. If it is complied against > libmysqlclient from mysql-5.x then it works. > >> Thanks >> >> Dan Pascu a écrit : > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
