fix(test): make unit tests deterministic #7992

Job	Run time
Test Python (1, 3.8)	11m 9s
Test Python (1, 3.11)	10m 23s
Test Python (2, 3.8)	8m 58s
Test Python (2, 3.11)	8m 58s
Test Python (3, 3.8)	9m 44s
Test Python (3, 3.11)	9m 56s
Test Python (4, 3.8)	9m 44s
Test Python (4, 3.11)	9m 37s
Test Python (5, 3.8)	10m 23s
Test Python (5, 3.11)	9m 35s
Test Python (6, 3.8)	10m 27s
Test Python (6, 3.11)	9m 28s
Combine and update integration test durations	0s
Pass testing Python	3s
	1h 58m 25s

Provide feedback