Andreas Motl

### java.net.SocketException: Unrecognized Windows Sockets error: 10106: socket Some resources suggest to set the `SystemRoot` environment variable to `C:\Windows`: - https://bz.apache.org/netbeans/show_bug.cgi?id=91532 - https://stackoverflow.com/questions/3947555/java-net-socketexception-unrecognized-windows-sockets-error-0-jvm-bind-jboss/60072492#60072492 - https://community.microfocus.com/t5/StarTeam-Knowledge-Base/Network-problem-Unrecognized-Windows-Sockets-error-10106-create/ta-p/1755101 Indeed: With 4c05db6, CrateDB seems...

Now, we are seeing this: ``` Error in test D:\a\crate-python\crate-python\src\crate\client\sqlalchemy\doctests\itests.txt Traceback (most recent call last): File "C:\hostedtoolcache\windows\Python\3.6.8\x64\lib\unittest\case.py", line 59, in testPartExecutor yield File "C:\hostedtoolcache\windows\Python\3.6.8\x64\lib\unittest\case.py", line 601, in run self.setUp() File...

I have not been able to observe this error recently, so I am closing this.

The error is not gone yet, those are two more data points. - https://github.com/crate/crate-python/actions/runs/3177362098/jobs/5177712919#step:4:511 - https://github.com/crate/crate-python/actions/runs/3274701823/jobs/5388588426#step:4:486

Another different one from `doctests/layer.txt`. ``` File "/Users/runner/work/crate-python/crate-python/src/crate/testing/doctests/layer.txt", line 219, in layer.txt Failed example: num_nodes Expected: 2 Got: 1 ``` -- https://github.com/crate/crate-python/actions/runs/3218694497/jobs/5263181322#step:4:363

Maybe this happens because the retry interval is set to a very low value when running the tests. https://github.com/crate/crate-python/blob/afb3b0b3c8a9b5b59ccead9743ab7cf73dd5bd3f/src/crate/client/test_http.py#L311-L313 So, the `invalid_host` might have gotten swapped out and back in...

Observed this again when running the tests on behalf of #402. So, I added 89507a0fb9 there.

The same thing happened again at https://github.com/crate/crate-python/runs/2297326550#step:6:184. ``` File "/home/runner/work/crate-python/crate-python/src/crate/client/doctests/http.txt", line 41, in http.txt Failed example: http_client._active_servers Expected: ['http://127.0.0.1:44209'] Got: ['http://invalid_host:9999', 'http://127.0.0.1:44209'] ```

Now also, slightly different but the same issue, at https://github.com/crate/crate-python/runs/2297736340#step:6:166. ``` File "/home/runner/work/crate-python/crate-python/src/crate/client/doctests/http.txt", line 61, in http.txt Failed example: http_client._get_server() Expected: 'http://invalid_host:9999' Got: 'http://even_more_invalid_host:9999' ```

Same thing happens again [^1][^2]: ``` File "/home/runner/work/crate-python/crate-python/src/crate/client/doctests/http.txt", line 41, in http.txt Failed example: http_client._active_servers Expected: ['http://127.0.0.1:44209/'] Got: ['http://invalid_host:9999', 'http://127.0.0.1:44209/'] ``` [^1]: https://github.com/crate/crate-python/runs/6210356011#step:6:283 [^2]: https://github.com/crate/crate-python/runs/6300072011#step:5:287