LockReplace: xid table corrupted

From: Dronamraju Rajesh <drajesh80(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: LockReplace: xid table corrupted
Date: 2000-12-12 05:55:52
Message-ID: 20001212055552.39675.qmail@web9606.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs

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/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2000-12-12 06:08:14 Re: [BUGS] LockReplace: xid table corrupted
Previous Message Ragnar Kjørstad 2000-12-11 22:22:15 Re: Postgres failover

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-12-12 06:08:14 Re: [BUGS] LockReplace: xid table corrupted
Previous Message Robert B. Easter 2000-12-12 05:01:28 Re: Can't use NULL in IN conditional?