Excorsing former VOs #7461

marianne013 · 2024-02-09T12:02:14Z

marianne013
Feb 9, 2024

Hi,

Quite a while ago we removed the lsst VO from our DIRAC server. Today while frantically grepping for errors (as you do), I found the job cleaning agent swamped with this message:

/opt/dirac/runit/WorkloadManagement/JobCleaningAgent/log/current:2024-01-24 04:22:20 UTC WorkloadManagement/JobCleaningAgent/WorkloadManagement/JobCleaningAgent ERROR: Could not delete jobs for /C=UK/O=eScience/O
U=Imperial/L=Physics/CN=dirac-pilot.grid.hep.ph.ic.ac.uk : lsst_user (n=146) : Unauthorized query ( 1111 : Unauthorized query)

/opt/dirac/runit/WorkloadManagement/JobCleaningAgent/log/current:2024-01-24 04:22:20 UTC WorkloadManagement/JobCleaningAgent/WorkloadManagement/JobCleaningAgent ERROR: Failed to delete jobs with condDict {'JobTyp
e': ['User']}

How do I get rid of this ?
Bonus points for also telling me how to find those:

/opt/dirac/runit/WorkloadManagement/JobCleaningAgent/log/current:2024-01-24 04:37:19 UTC WorkloadManagement/JobCleaningAgent/WorkloadManagement/JobCleaningAgent ERROR: Could not delete jobs for Unknown : Unknown 
(n=7) : Unauthorized query ( 1111 : Unauthorized query)

Unknown ?!

Thanks,
Daniela

fstagni · 2024-02-09T12:06:43Z

fstagni
Feb 9, 2024
Maintainer

We have seen this, and reported in #5355
Some measures have been coded but that's more complex than what it could seem.

So, at the moment the only way out is to delete entries from the database.

0 replies

marianne013 · 2024-02-09T14:27:56Z

marianne013
Feb 9, 2024
Author

For my own records, as I am sure it will come up again, here's the sequence of sql commands:

use JobDB;
select * from Jobs where OwnerGroup='lsst_user';
DELETE from JobParameters where JobID in (SELECT JobID from Jobs where OwnerGroup = 'lsst_user');
DELETE from OptimizerParameters where JobID in (SELECT JobID from Jobs where OwnerGroup = 'lsst_user');
DELETE from HeartBeatLoggingInfo where JobID in (SELECT JobID from Jobs where OwnerGroup = 'lsst_user');
DELETE from Jobs where OwnerGroup='lsst_user';

The 'unknown' jobs had no connections to any other tables.

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Excorsing former VOs #7461

{{title}}

Replies: 2 comments

{{title}}

{{title}}

Select a reply

Excorsing former VOs #7461

marianne013 Feb 9, 2024

Replies: 2 comments

fstagni Feb 9, 2024 Maintainer

marianne013 Feb 9, 2024 Author

marianne013
Feb 9, 2024

fstagni
Feb 9, 2024
Maintainer

marianne013
Feb 9, 2024
Author