Hi all, To summarise the immediate problem with my app: database updates sporadically hang / are killed / die during write operations, and locks aren't released. Consequently, a number of other threads queue up waiting for the locks, until I get Lock wait timeout exceptions - I need to manually kill off errant processes in MySQL.
Obviously, I need to work out exactly why and where these updates are hanging, but for right now, totally disabling transactions would at least buy me some time to sleep :) For SQLObject, there's the notrans database URI prefix - is there an analog for SA? I'm happy hacking database.py but the underlying mysql python driver would revert to transactional behaviour if I let a BEGIN slip through, so I'd really like to get it right first time! James (going to make more coffee :) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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?hl=en -~----------~----~----~----~------~----~------~--~---
