On 24-08-16 18:10, Stefano Dal Pra wrote:
> A check for overload that i use to do here is to query the cream
> database about how many jobs by status
> are in the db:
>
> [root@ce07-lcg cream]# mysql -p********** creamdb
>
> mysql> SELECT count(*), status.type, jsd.name FROM job j,
> job_status_type_description AS jsd, job_status AS status LEFT OUTER
> JOIN job_status AS latest ON latest.jobId=status.jobId AND status.id <
> latest.id WHERE latest.id IS NULL AND j.id=status.jobId AND jsd.type =
> status.type group by status.type;
> +----------+------+----------------+
> | count(*) | type | name |
> +----------+------+----------------+
> | 2 | 0 | REGISTERED |
> | 1 | 1 | PENDING |
> | 722 | 2 | IDLE |
> | 2841 | 4 | REALLY_RUNNING |
> | 3891 | 5 | CANCELLED |
> | 30229 | 7 | DONE_OK |
> | 513 | 8 | DONE_FAILED |
> | 560 | 10 | ABORTED |
> +----------+------+----------------+
> 8 rows in set (1.57 sec)
Hi Stefano,
My CE has this:
+----------+------+----------------+
| count(*) | type | name |
+----------+------+----------------+
| 16203 | 0 | REGISTERED |
| 3 | 1 | PENDING |
| 453 | 2 | IDLE |
| 122 | 4 | REALLY_RUNNING |
| 9686 | 5 | CANCELLED |
| 6128 | 7 | DONE_OK |
| 9 | 8 | DONE_FAILED |
| 453 | 10 | ABORTED |
+----------+------+----------------+
So a lot of registered jobs. Oddly the purge policy was already tuned
down to 2 days (but I'll bring it down further).
Still looks like an odd situation.
Thanks,
Dennis
|