From: Tom Lane <tgl@sss.pgh.pa.us>
To: Daniel Gustafsson <daniel@yesql.se>
cc: Thomas Munro <thomas.munro@gmail.com>, Andres Freund <andres@anarazel.de>,
        byavuz81@gmail.com,
        PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>,
        Heikki Linnakangas <heikki.linnakangas@iki.fi>,
        Michael Paquier <michael@paquier.xyz>
Subject: Re: BUG #17391: While using --with-ssl=openssl and
 PG_TEST_EXTRA='ssl' options, SSL tests fail on OpenBSD 7.0
In-reply-to: <887CBA28-0942-4084-BE09-FBE0D6A1DB53@yesql.se>
References: <17391-304f81bcf724b58b@postgresql.org>
 <20220202213900.h7paogmcge2rtls6@alap3.anarazel.de>
 <CA+hUKGJ4+Ug16QU-PYGEZwUe2O69hdnCuyzLhMHHF02_uA4C5w@mail.gmail.com>
 <131329.1643851912@sss.pgh.pa.us> <203742.1643866877@sss.pgh.pa.us>
 <C44CE9FB-B37E-47D3-924B-4AF808AE98B1@yesql.se>
 <887CBA28-0942-4084-BE09-FBE0D6A1DB53@yesql.se>
Comments: In-reply-to Daniel Gustafsson <daniel@yesql.se>
	message dated "Fri, 04 Feb 2022 15:12:47 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <621770.1644098845.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sat, 05 Feb 2022 17:07:25 -0500
Message-ID: <621771.1644098845@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/621771.1644098845%40sss.pgh.pa.us>
Precedence: bulk

Daniel Gustafsson <daniel@yesql.se> writes:
> Thomas: Does the attached reproduce these results for you?

FWIW, I've also reproduced these results, on a fresh OpenBSD 7.0 install
inside a qemu VM: adding "host=3Dlocalhost" silences all but two failures,
and then the sleep fixes those.

HEAD:

Test Summary Report
-------------------
t/001_ssltests.pl (Wstat: 5632 Tests: 110 Failed: 22)
  Failed tests:  72-76, 79-83, 88-90, 94-95, 97, 99, 102
                104, 106, 108, 110
  Non-zero exit status: 22
t/002_scram.pl   (Wstat: 1792 Tests: 11 Failed: 7)
  Failed tests:  1, 4-5, 7, 9-11
  Non-zero exit status: 7
t/003_sslinfo.pl (Wstat: 7424 Tests: 1 Failed: 1)
  Failed test:  1
  Non-zero exit status: 29
  Parse errors: Bad plan.  You planned 13 tests but ran 1.
Files=3D3, Tests=3D122, 42 wallclock secs ( 0.12 usr  0.05 sys +  6.81 cus=
r  9.99 csys =3D 16.97 CPU)

Add "host=3Dlocalhost" to tests:

Test Summary Report
-------------------
t/001_ssltests.pl (Wstat: 512 Tests: 110 Failed: 2)
  Failed tests:  97, 110
  Non-zero exit status: 2
Files=3D3, Tests=3D134, 48 wallclock secs ( 0.04 usr  0.06 sys +  8.31 cus=
r 12.49 csys =3D 20.90 CPU)

What's even more interesting:

* Adding the sleep alone fixes nothing.

* Sometimes, all the tests will pass without the sleep, just
the "host=3Dlocalhost" hack.

That seems to confirm that there's a timing problem somewhere
in the CRL cases.

I don't have any theory about why "host=3Dlocalhost" helps.

			regards, tom lane