Fix EL9 related unit tests

[khurtado]

Impact of the new feature
The following unit tests are broken in the RHEL9 jenkins nodes:

* WMComponent_t.JobArchiver_t.JobArchiver_t.JobArchiverTest.testBasicFunctionTest
* WMComponent_t.WorkflowUpdater_t.WorkflowUpdaterPoller_t.WorkflowUpdaterPollerTest.testWritePileupJson
* WMCore_t.MicroService_t.MSManager_t.MSManagerTest.test_services
* WMCore_t.ReqMgr_t.Service_t.Auxiliary_t.AuxiliaryTest.testCMSSWVersions
* WMCore_t.Services_t.ReqMgr_t.ReqMgr_t.ReqMgrTest.testRequestClone
* WMCore_t.Services_t.ReqMgr_t.ReqMgr_t.ReqMgrTest.testRequestSimpleCycle
* WMCore_t.Services_t.Requests_t.testRequestExceptions.test404Error
* WMCore_t.Services_t.Requests_t.testRequestExceptions.test404Error_with_pycurl
* WMCore_t.Services_t.Rucio_t.RucioUtils_t.RucioUtilsTest.testWeightedChoice
* WMCore_t.WMInit_t.WMInit_t.testMySQLDatabase
* WMCore_t.WMSpec_t.Steps_t.Executors_t.CMSSW_t.CMSSW_t.testD_ExecuteNoOutput
* WMCore_t.WMSpec_t.Steps_t.Executors_t.CMSSW_t.CMSSW_t.testSubprocessTime
* WMCore_t.WMSpec_t.Steps_t.Fetchers_t.URLFetcher_t.URLFetcherTest.testA_BasicFunction
* nose.failure.Failure.runTest

Is your feature request related to a problem? Please describe.
Some unit tests in RHEL9 are broken due to changes in the environment (OS, python version, etc).

Describe the solution you'd like
We should revisit each of these tests (which are excluding unit tests that fail in the RHEL7 jenkins environment) and fix them.

Describe alternatives you've considered
Do nothing

Additional context
This is related to issue #11978

[d-ylee]

Looking through old GitHub issues, this could also be included: #11778

[amaltaro]

@d-ylee we could, be #11778 is not really related to the Alma9 migration, AFAICT. So IMO we can keep that one separated not to inflate too much the Alma9 unit tests meta-issue.