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: Chris Hyzer <>
  • To: Scott Koranda <>
  • Cc: grouper-users <>
  • Subject: RE: [grouper-users] loader job MAINTENANCE_cleanLogs
  • Date: Wed, 14 Oct 2015 12:17:49 +0000
  • Accept-language: en-US

You cant connect to the DB and run a query? I meant how many rows for the
MAINTENANCE_cleanLogs job running a few minutes ago.

My hunch is that you ran it previously, killed it, and the process is still
running on oracle. Now you run it again, trying to delete the same rows and
thd previous run is locking it? Maybe try to kill all those session, and
manually try to delete some of the records starting with oldest? Might have
to do this a few times before the table gets under control and the job from
grouper will work again?


-----Original Message-----
From: Scott Koranda

Sent: Wednesday, October 14, 2015 8:14 AM
To: Chris Hyzer
Cc: grouper-users
Subject: Re: [grouper-users] loader job MAINTENANCE_cleanLogs


> 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