Ticket #4802 (closed defect: fixed)
"ProgrammingError: closing a closed connection" when Trac has been running for a while
| Reported by: | deryl.seale@… | Owned by: | cboos |
|---|---|---|---|
| Priority: | normal | Milestone: | 0.10.4 |
| Component: | general | Version: | |
| Severity: | critical | Keywords: | mysql connection pool |
| Cc: | asouzis@… |
Description
I am using the latest stable version of Trac with Apache2 (mod_python) and MySQL (5.0.27). Everything seems to be running fine, but after Trac has been runnig a while (~day) I get the following error when I log in:
Traceback (most recent call last):
File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 398, in dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 183, in dispatch
req.perm = PermissionCache(self.env, req.authname)
File "/usr/lib/python2.3/site-packages/trac/perm.py", line 263, in __init__
self.perms = PermissionSystem(env).get_user_permissions(username)
File "/usr/lib/python2.3/site-packages/trac/perm.py", line 227, in get_user_permissions
for perm in self.store.get_user_permissions(username):
File "/usr/lib/python2.3/site-packages/trac/perm.py", line 109, in get_user_permissions
db = self.env.get_db_cnx()
File "/usr/lib/python2.3/site-packages/trac/env.py", line 203, in get_db_cnx
return DatabaseManager(self).get_connection()
File "/usr/lib/python2.3/site-packages/trac/db/api.py", line 75, in get_connection
return self._cnx_pool.get_cnx(self.timeout or None)
File "/usr/lib/python2.3/site-packages/trac/db/pool.py", line 96, in get_cnx
if try_rollback(cnx):
File "/usr/lib/python2.3/site-packages/trac/db/pool.py", line 61, in try_rollback
cnx.close()
ProgrammingError: closing a closed connection
If I restart Apache, then everything returns to normal, but the problem crops up over and over after the site has been running for a while.
Attachments
Change History
Note: See
TracTickets for help on using
tickets.



