Skip to Content.
Sympa Menu

grouper-dev - Re: [grouper-dev] error deleting a group

Subject: Grouper Developers Forum

List archive

Re: [grouper-dev] error deleting a group


Chronological Thread 
  • From: Shilen Patel <>
  • To: Tom Zeller <>
  • Cc: Jim Fox <>, "" <>
  • Subject: Re: [grouper-dev] error deleting a group
  • Date: Thu, 22 Jul 2010 13:59:47 -0400

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






Archive powered by MHonArc 2.6.16.

Top of Page