Grouper Developers Forum

[Tom Zeller <>]

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