Thread

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

   Dronamraju Rajesh <drajesh80@yahoo.com> — 2000-12-12T06:28:38Z

   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/
   
   

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

   Jie Liang <jliang@jliang.ipinc.com> — 2000-12-12T18:08:58Z

   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/
   >