[OGo-Bugs][Bug 1884] XmlRpc Daemon Leaks Database Connect On Failed Authentication

bugs@opengroupware.org bugs@opengroupware.org
Sat, 30 Jun 2007 15:29:39 +0200 (CEST)


Please do not reply directly to this email. All additional
comments should be made in the comments box of this bug
report.

http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1884





------- Additional Comments From awilliam@whitemice.org  2007-06-30 15:29 -------
Mail message from list:
Weird thing - as of this morning, with no change in weeks, the OGo
xmlrpcd daemon is stacking up PostgreSQL connections until no more are
available.  Once I restart ogo-xmlrpcd it works until it has again
chewed up all the available connections.

in context:
  <0x0x842d234[WOContext]: 1234676932b0842d234 app=ogo-xmlrpcd-1
sn=4BB04BB002467691C5 eid= rqeid=>.
Jun 18 14:14:03 ogo-xmlrpcd-1.1 [19376]: [ERROR] |ogo-xmlrpcd-1|
<XmlRpcApplication[0x0x817042c]: name=ogo-xmlrpcd-1>: caught:
  (Exception name:NoMoreConnections
class:PostgreSQL72CouldNotOpenChannelException reason:cannot open a
additional connection ! info:<nil>)
in context:

I suspect it looses a database connection when a user authorization
attempt fails, as I had a user causing scads of -
Jun 18 14:17:49 ogo-xmlrpcd-1.1 [19711]: -[LSLoginAccountCommand
_executeInContext:]: login failed: 'RTOBIN'.
Jun 18 14:17:49 ogo-xmlrpcd-1.1 [19711]: -[DirectAction
_commandContextForAuth:inContext:]: login RTOBIN was not authorized !

Once I resolved that the allocation of new database connections ceased.

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.