Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] problem with running the Loader,

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] problem with running the Loader,

Chronological Thread 
  • From: Michael McManaman <>
  • To: Shilen Patel <>
  • Cc: "" <>
  • Subject: Re: [grouper-users] problem with running the Loader,
  • Date: Fri, 2 Sep 2016 15:05:14 -0400
  • Ironport-phdr: 9a23:5nW8ERxEtw3iBx7XCy+O+j09IxM/srCxBDY+r6Qd0uMTIJqq85mqBkHD//Il1AaPBtqLra8fwLOL+4nbGkU+or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6aijSI4DUTAhTyMxZubqSwQ9aKzpf/6+fnwJ3SZwhOzAK0fb52ZEGtrQTVu88+jZZhJ+A8xgaf8VVSfOED4GJjJVuem17Z7eK5+pdm+iIY7/cu8pFoW7j0ca08SvpVAClwYDN939HiqRSWFVjH3XAbSGhD10MQWwU=

Thanks Shilen.

The grouper_change_log_entry_temp table had in excess of 900 rows in it.

We've been testing different bulk load methods and I'm guessing that's where those records came from.

They're not needed so I truncated the table and the command still hangs.

Is there another table that could be the problem, or is there a was to trace what the gsh is doing & where it's stopping processing that command?

Thanks again!


On 09/02/2016 02:13 PM, Shilen Patel wrote:
Hi Mike,

That could mean that you have a lot of rows in the
grouper_change_log_entry_temp table that haven't been processed. And that
could happen if you haven't been running the Grouper Daemon. Typically the
daemon runs the changeLogTempToChangeLog job every minute to prevent a
backlog. In any case, while running that job from GSH, do a few counts on
the table and see if the number of rows is decreasing. If so, you just
have a backlog and you can estimate how long it will take to finish.
Otherwise, it may be stuck on a change.


- Shilen

On 9/2/16, 1:35 PM, "Michael McManaman"

Hello -

I'm trying to follow the online videos in setting for Grouper Training -
Admin - PSP, and in part 3, I hit a problem with the first couple
commands entered into gsh. I cannot get this command to run:


It stalls and never returns. I set debug (GSH_DEBUG = true) and still
see nothing & nothing in the logs.

Other commands like:




Return with "loader ran successfully: null"

I have change log records - when i ran


I got back:

loader ran successfully: Deleted 10 records from grouper_loader_log
older than 7 days old. Deleted 283206 records from
grouper_change_log_entry older than 14 days old.

Anyone have any ideas?

Thanks in advance.


Archive powered by MHonArc 2.6.19.

Top of Page