Grouper Users - Open Discussion List

[Scott Koranda <>]

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