Thread: 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/
Dronamraju Rajesh <drajesh80@yahoo.com> writes:
> 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)
If you update to 7.0.3, you'll probably find this problem
goes away. It sounds to me like you are running into a bogus
debug check in the older code that assumed LockRelease should
never need to release more than a thousand locks.
If you don't want to update, try not touching 1000 tables in
the same transaction. I'm guessing you do a lot of large-object
slinging ... otherwise it's not that easy to get to 1000 ...
regards, tom lane
thanks tom....But strange thing is that my database has only 15 tables totally...which are very small too... so how would be the way of me reaching to 1000 tables??? and why do i get an error message "sorry too many clients" ??? Regards Rajesh --- Tom Lane <tgl@sss.pgh.pa.us> wrote: > Dronamraju Rajesh <drajesh80@yahoo.com> writes: > > 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) > > If you update to 7.0.3, you'll probably find this > problem > goes away. It sounds to me like you are running > into a bogus > debug check in the older code that assumed > LockRelease should > never need to release more than a thousand locks. > > If you don't want to update, try not touching 1000 > tables in > the same transaction. I'm guessing you do a lot of > large-object > slinging ... otherwise it's not that easy to get to > 1000 ... > > regards, tom lane __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/
I remember that you cannot open more than 16 sessiones at same time by default, if more than that you have to reset, I believe you can find how from documentation. Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com On Mon, 11 Dec 2000, Dronamraju Rajesh wrote: > thanks tom....But strange thing is that my database > has only 15 tables totally...which are very small > too... > > so how would be the way of me reaching to 1000 > tables??? > > and why do i get an error message "sorry too many > clients" ??? > > Regards > Rajesh > --- Tom Lane <tgl@sss.pgh.pa.us> wrote: > > Dronamraju Rajesh <drajesh80@yahoo.com> writes: > > > 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) > > > > If you update to 7.0.3, you'll probably find this > > problem > > goes away. It sounds to me like you are running > > into a bogus > > debug check in the older code that assumed > > LockRelease should > > never need to release more than a thousand locks. > > > > If you don't want to update, try not touching 1000 > > tables in > > the same transaction. I'm guessing you do a lot of > > large-object > > slinging ... otherwise it's not that easy to get to > > 1000 ... > > > > regards, tom lane > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Thousands of Stores. Millions of Products. > http://shopping.yahoo.com/ >