| 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: | Whole Thread | Raw Message | 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/
| 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 |
| 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? |