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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-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/
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Lang | 2000-12-12 18:24:16 | Re: v7.1 RPMs |
Previous Message | Stephan Szabo | 2000-12-12 17:56:49 | Re: Foriegn key constraint |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-12-12 18:20:53 | Re: constrains of array |
Previous Message | Bruce Momjian | 2000-12-12 16:22:29 | Re: select cash_out('2'); crashes backend on 7.0.2 |