[OGo-Users] xmlrpcd using up PostgreSQL connections

Adam Tauno Williams users@opengroupware.org
Mon, 18 Jun 2007 10:39:03 -0400


--=-h9bVwMKl6Gyfmay49bRc
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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=3Dogo-xmlrpcd-1
sn=3D4BB04BB002467691C5 eid=3D rqeid=3D>.
Jun 18 14:14:03 ogo-xmlrpcd-1.1 [19376]: [ERROR] |ogo-xmlrpcd-1|
<XmlRpcApplication[0x0x817042c]: name=3Dogo-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.

Has anyone seen this?  Confirm it?



--=-h9bVwMKl6Gyfmay49bRc
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBGdpkGLRePpNle04MRAitGAJ4ghQEljGN0sZB0YC8U6Noo9bOczwCdHM1t
lk5jJ2HPI/yosGPUubkcKUY=
=OE2k
-----END PGP SIGNATURE-----

--=-h9bVwMKl6Gyfmay49bRc--