Re: BUG #17391: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL tests fail on OpenBSD 7.0

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Thomas Munro <thomas.munro@gmail.com>, byavuz81@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>, Heikki Linnakangas <heikki.linnakangas@iki.fi>, Michael Paquier <michael@paquier.xyz>
Date: 2022-02-03T02:26:35Z
Lists: pgsql-bugs
Hi,

On 2022-02-02 20:31:52 -0500, Tom Lane wrote:
> BTW, I also reproduced something that seems odd from the OP's
> postmaster logs: there are what seem a quite excessive number
> of checkpoints happening during these tests.  That happens
> on my Linux box too, so it's not an OpenBSD issue.  It looks
> like there are two per CREATE DATABASE --- I could understand
> one maybe, but why two?

I think that's unfortunately normal. There's two RequestCheckpoint()s in
createdb(). We should optimize that someday...

Greetings,

Andres Freund



Commits

  1. Move libpq's write_failed mechanism down to pqsecure_raw_write().

  2. Fix thinko in PQisBusy().

  3. Set SNI ClientHello extension to localhost in tests

  4. Improve worst-case performance of text_position_get_match_pos()