Too Many Connections with mysql.

[ubergeek@…]

I have tracked this bug down to trac, and almost definitely dbauth. It looks as though our mysql server is running out of connections, as dbauth isn't necessarily closing them. I have looked at the CentralDatabaseManager class and the trac source but am not a python programmer so its hard for me to follow.

The good news is that up until now we have not had this issue, but now we have approx 40-50 users on 80+ projects and it is starting to show strain.

[anonymous]

I thought that unused connections would be released upon garbage collection. They are for sqlite and postgres. However, you could pepper some

db.close()

lines in auth.py after the work with the connection is done. Potentially before the lines: 161, 181, 205, 232 (rework to temp var), 265.

See ​http://www.trac-hacks.org/browser/dbauthplugin/0.10/dbauth/perm.py#L62 for an example.