Re: [SQLObject] Fwd: Regression in SQLObject 0.8.0b1

[Markus G. <m.g...@gm...>]

On 12/28/06, Oleg Broytmann <ph...@ph...> 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.

Kind regards,
Markus