gh-128770: raise warnings as errors in test suite - except for test_socket which still logs warnings

gh-128770: raise warnings as errors in test suite - except for test_socket which still logs warnings #62276