seems that it is also related to mysql 5:
*
The |reconnect| flag in the |MYSQL| structure is set to 0 by
|mysql_real_connect()|. Only those client programs which did not
explicitly set this flag to 0 or 1 after |mysql_real_connect()|
experience a change. Having automatic reconnection enabled by
default was considered too dangerous (due to the fact that table
locks, temporary tables, user variables, and session variables are
lost after reconnection).
anyone knows how to set this reconnect flag?
Regards
sophana a écrit :
> I will try the patch below.
> Has anybody tried it?
> This feature seems to be a must-have, don't you think?
>
> gentoo sqlobject # diff -Nura dbconnection.py.orig dbconnection.py
> --- dbconnection.py.orig 2006-07-26 23:21:23.000000000 +0800
> +++ dbconnection.py 2006-07-27 00:12:44.000000000 +0800
> @@ -214,11 +214,27 @@
> self._binaryType = type(self.module.Binary(''))
>
> def _runWithConnection(self, meth, *args):
> + try:
> + import _mysql_exceptions
> + except ImportError:
> + MySQLdbExcept = ImportError
> + else:
> + MySQLdbExcept = _mysql_exceptions.OperationalError
> +
> conn = self.getConnection()
> try:
> val = meth(conn, *args)
> - finally:
> + except MySQLdbExcept:
> + #print "make reconnection"
> self.releaseConnection(conn)
> + conn = self.makeConnection()
> + self._connectionNumbers[id(conn)] = self._connectionCount
> + self._connectionCount += 1
> + try:
> + val = meth(conn, *args)
> + finally:
> + self.releaseConnection(conn)
> + #finally:
> return val
>
> def getConnection(self):
>
>
> Jorge Vargas a écrit :
>
>> On 8/2/06, *sophana* <[EMAIL PROTECTED]
>> <mailto:[EMAIL PROTECTED]>> wrote:
>>
>> hi I don't have a direct answer to you but this is a known problem,
>> and is recurrent in Turbogears (we use SQLObject for the backend)
>> please follow the discussion here.
>>
>> http://trac.turbogears.org/turbogears/ticket/781
>> http://trac.turbogears.org/turbogears/ticket/872
>> <http://trac.turbogears.org/turbogears/ticket/872>
>>
>> if you browser the TG mailing you will find a couple of workarounds
>>
>>
>>
>
>
> -------------------------------------------------------------------------
> 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
>
>
-------------------------------------------------------------------------
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
