Re: MSVC SSL test failure

On 12/5/21 12:50, Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>> I am getting this test failure 001_ssltests.pl on my test MSVC system
>> when SSL tests are enabled:
>> not ok 110 - certificate authorization fails with revoked client cert with server-side CRL directory: matches
>> # Failed test 'certificate authorization fails with revoked client cert with server-side CRL directory: matches'
>> # at t/001_ssltests.pl line 618.
>> # 'psql: error: connection to server at "127.0.0.1", port 59491 failed: server closed the connection unexpectedly
>> # This probably means the server terminated abnormally
>> # before or while processing the request.
>> # server closed the connection unexpectedly
>> # This probably means the server terminated abnormally
>> # before or while processing the request.
>> # server closed the connection unexpectedly
>> # This probably means the server terminated abnormally
>> # before or while processing the request.'
>> # doesn't match '(?^:SSL error: sslv3 alert certificate revoked)'
>> There's nothing terribly suspicious in the server log, so I'm not quite
>> sure what's going on here.
> Hmm .. does enabling log_connections/log_disconnections produce
> any useful info?

No, that's already turned on (this test is run using a standard
buildfarm client).

>
> This looks quite a bit like the sort of failure that commit
> 6051857fc was meant to forestall. I wonder whether reverting
> that commit changes the results? You might also try inserting
> a shutdown() call, as we'd decided not to do [1].
>
> regards, tom lane
>
> [1] https://www.postgresql.org/message-id/1283317.1638213407%40sss.pgh.pa.us

Commenting out the closesocket() worked.

I will look at shutdown().

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com