This huge number of pending commands is very likely due to this bug:
https://savannah.cern.ch/bugs/?69545
fixed with the latest version of CREAM released with gLite 3.2 update 17
The solution is:
- to remove the creamdb db
- to update to latest CREAM CE version (if not done already)
- to reconfigure via yaim (which also recreates the DB)
It is true that the query you mentioned is not performant (to be fixed in
the next release) but without that bug it is very unlikely to have many pending
commands in the queue and therefore is not too relevant
Cheers, Massimo
On Sat, 28 Aug 2010, Lukasz Flis wrote:
> Hello Massimo,
>
>> /opt/glite/bin/glite_cream_load_monitor --show
>>
>> Which value does it show for the "Detected value for Number of pending
>> commands" ?
>>
> Here's my output:
>
> Threshold for Number of active jobs: -1 => Detected value for Number of active
> jobs: 6863
> Threshold for Number of pending commands: -1 => Detected value for Number of
> pending commands: 1698003
>
> Quite a lot :)
>
> Best Regards
> --
> Lukasz Flis
>
\\\|///
\\ ~ ~ //
(/ @ @ /)
-------oOOo-(_)-oOOo----------------------------------
Massimo Sgaravatto
INFN Sezione di Padova
Via Marzolo, 8
35131 Padova - Italy
Tel: ++39 0498275908 Fax: ++39 0498275952
oooO E-mail: massimo.sgaravatto [at] pd.infn.it
( ) Oooo Home page: http://www.pd.infn.it/~sgaravat
--------\ (----( )----------------------------------
\_) ) /
(_/
|