Markus Gritsch wrote: > On 12/28/06, Oleg Broytmann <[EMAIL PROTECTED]> wrote: >> On Thu, Dec 28, 2006 at 06:56:08PM +0100, Markus Gritsch wrote: >>> Since there was no comment on the e-mail below, I resend it in case it got >>> lost. >> Sorry for the silence. I have got it the first time. Just don't have >> time to work on it. > > ok, then sorry for resending it. > >> Regarding the patch. I think to fix the problem I will replace "while 1" >> with "for i in range(1000): sleep(1)". There should be no "raise", or the >> loop would be meaningless at all. The idea of the loop is to wait until the >> server is restarted. > > Well, this would not solve the problem intoduced with SQLObject 0.8. > An Error 2006 occurres in the following scenario using SQLObject 0.7: > * My application is running, being connected to the MySQL database. > * The MySQL service is stopped and restarted. > * Every query from now on on the already made connection fails with > the Error 2006. > * The user can see this in a message box, and reconnect to the > database which solves the problem. > > So the Error 2006 occurrs if the connection to the old server was > broken. It does not matter that the MySQL server is already being > restarted. Trying it 1000 times as mentioned above would not fix the > problem. It would even make it worse, since the user gets no feedback > about what is wrong. Just a hanging app.
We should really figure out a way to use DBUtils under SQLObject in some way, as it would solve this problem: http://www.webwareforpython.org/DBUtils -- Ian Bicking | [EMAIL PROTECTED] | http://blog.ianbicking.org ------------------------------------------------------------------------- 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
