Grouper Users - Open Discussion List

[Chris Hyzer <>]

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?

Thanks,
Chris


-----Original Message-----
From: Scott Koranda 
[mailto:]
 
Sent: Wednesday, October 14, 2015 8:14 AM
To: Chris Hyzer
Cc: grouper-users
Subject: Re: [grouper-users] loader job MAINTENANCE_cleanLogs

Hi,

> 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
up.

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
queries.

Thanks,

Scott

> 
> 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
> MAINTENANCE_cleanLogs
> 
> Hi,
> 
> When I use GSH to run
> 
> loaderRunOneJob("MAINTENANCE_cleanLogs");
> 
> I then see in my Oracle database 4 sessions with this
> SQL_TEXT:
> 
> 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