Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] loader job MAINTENANCE_cleanLogs

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] loader job MAINTENANCE_cleanLogs

Chronological Thread 
  • From: Scott Koranda <>
  • To: Chris Hyzer <>
  • Cc: grouper-users <>
  • Subject: Re: [grouper-users] loader job MAINTENANCE_cleanLogs
  • Date: Wed, 14 Oct 2015 07:13:58 -0500


> Not sure. How many records do you see for the job in
> grouper_loader_log? You should see one.

I cannot say--the reason for the MAINTENANCE_cleanLogs job is
to try and delete a large number of rows from
a grouper_loader_job table that is too large (due to
unimportant reasons and on a development system). The priority
is to get the table under control and the sandbox system back

Later when the sandbox is functional again I can check.

> This is not
> threaded or anything...

I see the four (4) session/serial# combinations and all 4 are in the
STATE 'WAITING'. Three (3) of the four have WAIT_CLASS 'Idle'
and one has WAIT_CLASS 'User I/O'. The three (3) that are idle
are waiting on EVENT 'PX Deq Credit: send blkd' while the one
that is in 'User I/O' has EVENT 'db file sequential read'.

Again, this is not a priority--I am mostly curious why a
single loader job would apparently generate four (4) identical



> Thanks, Chris
> -----Original Message----- From:
> [mailto:]
> On Behalf Of
> Scott Koranda Sent: Tuesday, October 13, 2015 4:03 PM To:
> grouper-users Subject: [grouper-users] loader job
> Hi,
> When I use GSH to run
> loaderRunOneJob("MAINTENANCE_cleanLogs");
> I then see in my Oracle database 4 sessions with this
> delete from grouper_loader_log where last_updated < :1
> Why do I see 4 of those?
> Note that all Grouper processes are stopped. The only
> process connected to the database is the GSH.
> Thanks,
> Scott

Archive powered by MHonArc 2.6.16.

Top of Page