Grouper Developers Forum

[Shilen Patel <>]

Also as discussed on the call, I added a test that deletes a group with 
10K members.  The test fails on postgres with the same "out of shared 
memory" error using the default postgres configuration.  I increased 
max_locks_per_transaction to 300 and the test still failed.  Next I 
increased it to 500 and the test succeeded.

Thanks!

-- Shilen


On 7/21/10 1:01 PM, Tom Zeller wrote:
> As we discussed on the call, it seems like increasing
> max_locks_per_transaction and shared_buffers would be interesting
> tests. Increasing postgres logging seems good too (log_statement =
> all).
>
> So, maybe double max_locks_per_transaction if it is at the default 64,
> and increase shared_buffers to 128MB (since shmmax is 134MB).
>
> Thanks for being willing to test.
>
> On Tue, Jul 20, 2010 at 6:10 PM, Jim 
> Fox<>
>   wrote:
>    
> > Found the shared buffers:
> >
> > shared_buffers = 32MB
> >
> > Jim
> >
> >
> > On Tue, 20 Jul 2010, Jim Fox wrote:
> >
> >      
> > > Date: Tue, 20 Jul 2010 16:07:41 -0700
> > > From: Jim 
> > > Fox<>
> > > To: Tom 
> > > Zeller<>
> > > Cc: 
> > > ""<>
> > > Subject: Re: [grouper-dev] error deleting a group
> > >
> > >
> > >
> > >
> > >        
> > > > What are your OS shared memory settings ? e.g. shmmax and shmall
> > > >          
> > > shmmax = 134217728
> > > shmall = 4294967296
> > >
> > >
> > >        
> > > > And postgres shared_buffers ? (I'm not sure this matters but I'm curious)
> > > >          
> > > Don't know about shared_buffers.  How do I look that up?
> > >
> > >        
> > > > And approximately how many memberships do you have ?
> > > >          
> > > 2127944
> > >
> > > Jim
> > >
> > >        
> > > > Thanks,
> > > > TomZ
> > > >
> > > > On Sun, Jul 18, 2010 at 12:20 AM, Jim 
> > > > Fox<>
> > > >   wrote:
> > > >          
> > > > > I can do that.  What resource exactly?  Is it max_locks_per_transaction?
> > > > > I know I've created larger groups than this.  And I think I've deleted
> > > > > them.
> > > > > What takes so much space?
> > > > > Jim
> > > > > On Jul 17, 2010, at 5:55 PM, Chris Hyzer wrote:
> > > > >
> > > > > It looks like this is the problem (different than last time?)  Can you
> > > > > give
> > > > > more resources to the DB?
> > > > >
> > > > > Caused by: org.postgresql.util.PSQLException: ERROR: out of shared
> > > > > memory
> > > > >
> > > > > Thanks,
> > > > > Chris
> > > > >
> > > > > -----Original Message-----
> > > > > From: Jim Fox 
> > > > > [mailto:]
> > > > > Sent: Friday, July 16, 2010 4:14 PM
> > > > > To: Chris Hyzer
> > > > > Cc: 
> > > > >
> > > > > Subject: RE: [grouper-dev] error deleting a group
> > > > >
> > > > >
> > > > >
> > > > > Fyi, I changed the Grouper DB layer so it logs the nextException for
> > > > > postgres, and sent Jim a build, hopefully we will see the root problem.
> > > > >   Will keep you posted...
> > > > >
> > > > >
> > > > > Ran with the new grouper.jar.
> > > > >
> > > > > The event log is attached.
> > > > >
> > > > > Jim
> > > > >
> > > > >
> > > > >            
> >