Re: MSVC SSL test failure

On 12/5/21 12:50, Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.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
connectionunexpectedly
 
>>     #       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