#872: MySQLdb/gears does not reconnect if mysql drops connection
-------------------------------+--------------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: anonymous
Type: defect | Status: new
Priority: high | Milestone: 0.9
Component: SQLObject | Version: 0.9a5
Severity: major | Keywords:
-------------------------------+--------------------------------------------
At present, TG is permanently hosed if you lose the mysql connection.
This can happen if the connection times out, or the server is restarted.
This is not going to fly in a production environment, or in one where your
hosting provider does dumb things to the database settings.
On Mark Ramm's request, I am filing this ticket so that once MySQLdb
exposes an auto-reconnect interface, SQLObject/Gears can make use of it.
I have submitted a patch to the MySQLdb sourceforge that exposes the
interface. Hopefully they will add it soon.
Link:http://sourceforge.net/tracker/index.php?func=detail&aid=1483074&group_id=22307&atid=374934
Here's a thread on this topic, which includes a quicker hardcoded
workaround (also in the MySQLdb code -- I couldn't find any other way to
do it):
http://groups.google.com/group/turbogears/browse_frm/thread/4f0ae451e72b4717/7cfd7592010b4959?lnk=arm#7cfd7592010b4959
--
Ticket URL: <http://trac.turbogears.org/turbogears/ticket/872>
TurboGears <http://www.turbogears.org/>
TurboGears front-to-back web development
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears Tickets" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears-tickets
-~----------~----~----~----~------~----~------~--~---
