Enhancement: Complete porting of remaining probes to SQLAlchemy syntax

[dynamic-entropy]

Enhancement Description

Three of the probes in our dockerfile need to be modernised:
PRs for two already seem to exist, but might need a review before merging and deploying.

• check_expired_locked_rules: Common: Check_expired_locked_rules modernization. #127 rucio/probes#133

  • one more (can be closed in favour of above I guess): check_deletable_replicas probe ported to SQLAlchemy rucio/probes#43

• check_deletable_replicas: Expired lock: expired locked rules probe ported to SQLAlchemy rucio/probes#46

• check_obsolete_replicas : Did not find PR for this

Use Case

Fix them all!!!

---

I take this statement back (might have mixed up with some other tests):

CMSRucio/docker/rucio-probes/Dockerfile

Line 36 in ced4485

# TODO: Most of these don't work either, each with a different error - different reasons than above

It's just one, reviewed the PR to suggest the necessary fix.

Possible Solution

No response

Related Issues

rucio/probes#89

[ericvaandering]

I've linked the various PRs to this issue. Aside from the one in probes, they are done (and the one in probes isn't needed, we pull from the issue).