Appserver leaving 'IDLE in transaction' connection open on launch
Bug #85519 reported by
Stuart Bishop
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Launchpad itself |
Fix Released
|
High
|
Stuart Bishop | ||
Bug Description
Launchpad is leaving a connection open on launch with an unfinished transaction. This means PostgreSQL cannot vacuum dead rows from this point in time, resulting is massive database bloat.
A work around has been imlemented restarting the application servers every three hours.
| Changed in launchpad: | |
| importance: | Undecided → Critical |
| status: | Unconfirmed → Confirmed |
| Changed in launchpad: | |
| assignee: | nobody → stub |
| Changed in launchpad: | |
| importance: | Critical → High |
| status: | Confirmed → Fix Committed |
| Changed in launchpad: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
