Sébastien HEITZMANN wrote:
Hi,
for a couple of week i search how i should handle mysql disconnection on
my twisted web service. When I restart the database without restarting
my service i got some ConnectionLost fired. I have used the cp_reconnect
on the connection pool and it seem to work ( the lost connection is
restarted ) but the current query isn't executed.
I ran into a similar thing using mssql with adbapi (through pyodbc).
The adbapi connection pool holds connections open and uses them to do
the access, which was causing problems when the database (or the network
connection between my server and the database) was reset between
accesses to my service. I hacked a workaround by creating a thin
wrapper around adbapi that closes each connection when I'm through with it.
FWIW,
--
Don Dwiggins
Advanced Publishing Technology
_______________________________________________
Twisted-Python mailing list
Twisted-Python@twistedmatrix.com
http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
