Excorsing former VOs

[marianne013]

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]

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.

[marianne013]

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.