RE: LockReplace: xid table corrupted

Well, not to sound silly but, how many connections exist. Are you out of
connections?

I know that some clients on some OSes fail to free socket connections if
they die. We had this problem with JDBC on Win NT and I've heard of problems
with PHP as well. Our solution was to rewrite part of the clients so that in
all cases they shut down the db connection even if they then die a fiery
death.

--Rainer

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Dronamraju Rajesh
> Sent: Tuesday, December 12, 2000 2:56 PM
> To: pgsql-admin(at)postgresql(dot)org; pgsql-bugs(at)postgresql(dot)org
> Subject: [ADMIN] LockReplace: xid table corrupted
>
>
> Hi There,
>
> I have production systems running postgres for
> 24x7x365. But suddenly it stops serving the requests
> but the postmaster does not die. I cant do select or
> even say pgsql <database-name> until i kill postmaster
> clear shared memory segments and restart it again. for
> all the forth coming requests it says "sorry, too many
> clients already".
>
> My system config :-
>
> os:- Red Hat linux 6.2
> memory:- 1GB
> cpu:- dual CPU
> database:- Postgres 6.5.2 ( pl dont suggest to upgrade
> to 7.0.2. once this problem is solved. then i can do
> testing of my app with postgres 7.0.2)
>
> command:- postmaster -i -N 256 -B 512
> >>/usr/local/pgsql/server.log 2>&1 &
>
> can anybody tell me why this happens and what the
> solution is for this ????
>
> Regards
> Rajesh
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
> http://shopping.yahoo.com/