Grouper Users - Open Discussion List

[Gagné Sébastien <>]

Shouldn’t the grouper_change_log_entry_temp  table normally be empty ? The Grouper Daemon should empty it and send it to grouper_change_log_entry.

 

De : [mailto:] De la part de Tim Darby
Envoyé : 29 avril 2013 17:42
À : Shilen Patel
Cc :
Objet : Re: [grouper-users] PIT question

 

I checked with our DBA team and it turns out that they already analyze the Grouper tables on a regular basis.  They checked this query and determined that it needed indexes on string01 and string02 in grouper_change_log_entry_temp.  This made a big difference.

Tim Darby
The University of Arizona
Mosaic, Systems Integration and Architecture

UITS, Rm 335, 520-626-3799

 

On Mon, Apr 29, 2013 at 10:39 AM, Tim Darby <> wrote:

grouper_group_set - 4699169 rows

grouper_change_log_entry_temp - 1552245 rows

 

It's probably been at least a month since I analyzed tables, so I'll try that.  Also, I don't really care if I lose the change log data.  Is there a clean way to basically reset and start over?

 

Thanks,

Tim Darby
The University of Arizona
Mosaic, Systems Integration and Architecture

UITS, Rm 335, 520-626-3799

 

On Mon, Apr 29, 2013 at 10:30 AM, Shilen Patel <> wrote:

After that message, the code is doing a database query and it seems that may be taking a while.  How many rows do you have in grouper_group_set and grouper_change_log_entry_temp?  Have you recently analyzed your tables?

 

Thanks!

 

-- Shilen

 

From: Tim Darby <>
Date: Monday, April 29, 2013 1:10 PM
To: "" <>
Subject: [grouper-users] PIT question

 

When I run:

 

edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables()

 

It pretty quickly runs through the various searches until it gets to:

 

Searching for missing active point in time group sets

 

and will not go past that point.  It doesn't come back with "Found x missing..." and the GSH process in the UNIX process table is sleeping and stays that way for hours (I let it run overnight, just to see what would happen).  Any ideas?

Tim Darby
The University of Arizona
Mosaic, Systems Integration and Architecture

UITS, Rm 335, 520-626-3799