[rt-devel] Handle.pm too many clients

[Jesse]

On Wed, Mar 21, 2001 at 02:29:48AM +0000, Feargal Reilly wrote:
> That was my first guess too, but I checked, and that's not it.
> ps reveals something a bit more interesting though.
> Everytime I follow a link, two processes are created:
> 
> 5757 pts/4    S      0:00 /usr/local/pgsql/bin/postgres 127.0.0.1 sql rt2 idle
> 5758 pts/4    S      0:00 /usr/local/pgsql/bin/postgres 127.0.0.1 sql rt2 idle
> 
> These persist indefinately, it doesn't matter if I've logged out etc, etc.

Apache keeps its database connections open, because the construction/teardown
is so damn expensive.  Apache is designed to always have at least one spare process on hand, in case it gets multiple hits at the same time, iirc.

> The CLI cleans up after itself incidentally, so it's something that's done by the UI, but not the CLI that is causing this.

The cli will clean up after itself because the program which talks to the DB
exits and closes its DB connection.
> 
> Ideas?
> 
> -Feargal.
> 
>     _/_/_/ _/_/_/  _/_/_/  Feargal Reilly,
>    _/       _/   _/    _/  Systems Administrator,
>   _/       _/   _/_/_/_/   The Communications Interactive Agency.
>  _/_/_/ _/_/_/ _/    _/    Phone: +353-86-8157621.
> 
> 
>      On Wednesday, March 21, 2001 01:30:40 +0000, Feargal Reilly 
>      <feargal at online.thecia.ie> wrote:
>      +-----
>      | DBI->connect(dbname=rt2;host=localhost) failed: Sorry, too many clients
>      | already at /usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm
>      +--->8
>      
>      That error is from postgres; the server is complaining about too many 
>      clients.  You should check the postgres server configuration to make sure 
>      it's not limited to some tiny number of simultaneous connections / clients
>      .
>      
>      -- 
>      brandon s. allbery     [os/2][linux][solaris][japh]   allbery at kf8nh.apk.ne
>      t
>      system administrator        [WAY too many hats]         allbery at ece.cmu.ed
>      u
>      electrical and computer engineering                                   KF8N
>      H
>      carnegie mellon university     ["better check the oblivious first" -ke6sls
>      ]
>      
>      
>      _______________________________________________
>      Rt-devel mailing list
>      Rt-devel at lists.fsck.com
>      http://lists.fsck.com/mailman/listinfo/rt-devel
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

I admit that X is the second worst windowing system in the world, but all the 
others I've used are tied for first.