don't keep open pgsql transaction when trac is idle
|Reported by:||Radim Kolar||Owned by:||Jonas Borgström|
When trac is idle, postgresql database connection is in midle of transaction status
53878 ?? Is 0:01.46 postgres: trac trac [local] idle in transaction
If trac with low user activity is running on server, this behaviour has nasty system-wide effects.
- You can't VACUUM DB. You can but no rows are cleaned
- You can't replicate DB
until transaction is closed. On lowly loaded Trac, it can take days, so it harms other db users. Close transaction while idle please.