Skip site navigation (1) Skip section navigation (2)

Re: Re: [BUGS] LockReplace: xid table corrupted

From: Jie Liang <jliang(at)jliang(dot)ipinc(dot)com>
To: Dronamraju Rajesh <drajesh80(at)yahoo(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Re: [BUGS] LockReplace: xid table corrupted
Date: 2000-12-12 18:08:58
Message-ID: Pine.BSF.4.21.0012121005550.25634-100000@jliang.ipinc.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugs
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(at)ipinc(dot)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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Dronamraju Rajesh <drajesh80(at)yahoo(dot)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/
> 


In response to

pgsql-admin by date

Next:From: Adam LangDate: 2000-12-12 18:24:16
Subject: Re: v7.1 RPMs
Previous:From: Stephan SzaboDate: 2000-12-12 17:56:49
Subject: Re: Foriegn key constraint

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2000-12-12 18:20:53
Subject: Re: constrains of array
Previous:From: Bruce MomjianDate: 2000-12-12 16:22:29
Subject: Re: select cash_out('2'); crashes backend on 7.0.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group