Miscellaneous fixes for things flagged by automated code scan #10859

Job	Run time
Path match check	4s
Python unit tests on Mac OS (3.10)	13m 49s
Python postgres unit tests	12m 15s
Python unit tests (3.6)	10m 40s
Python unit tests (3.7)	10m 23s
Python unit tests (3.8)	9m 50s
Python unit tests on Windows Server (3.8)	17m 37s
Python unit tests (3.9)	9m 54s
Python unit tests (3.10)	9m 54s
Python unit tests (3.11)	9m 10s
Python unit tests (3.12)	9m 9s
	1h 52m 45s

Provide feedback