#195 SQLObject does not reconnect

closed-fixed
nobody
DBM (2)
5
2010-02-10
2006-08-26
elpargo
No

this is from the 0.7bug fix branch

a lot of background has been created on this in
Turbogears bug tracker.

mainly in
http://trac.turbogears.org/turbogears/ticket/872
http://trac.turbogears.org/turbogears/ticket/781

Basically the connection after being idle is drop and
SO engine is not aware of this.

Many patches have been proposed but none accepted.

Discussion

  • sophana
    sophana
    2006-12-10

    Logged In: YES
    user_id=931678
    Originator: NO

    I think the best solution is the one included in this mysqldb patch. The reconnection is handled directly in the mysql C api with an option.
    The problem Is that this option is only available from mysql 5.0.x

    http://sourceforge.net/tracker/index.php?func=detail&aid=1483074&group_id=22307&atid=374934

    Other problem this patch is for mysqldb 1.2.1p2 which has problems with unicode.

    Have to see if the patch is already applied or applicable to 1.2.2

     
  • Oleg Broytman
    Oleg Broytman
    2007-03-06

    Logged In: YES
    user_id=4799
    Originator: NO

    Partially fixed: in the revisions 2396-2399 there were patches that allows autoreconnect for MySQLdb 1.2.2+.

     
  • Oleg Broytman
    Oleg Broytman
    2007-03-06

    • status: open --> open-fixed
     
  • Oleg Broytman
    Oleg Broytman
    2010-02-10

    • status: open-fixed --> closed-fixed