Date: Thu, 19 Sep 2019 13:23:05 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Kuntal Ghosh <kuntalghosh.2007@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	Robert Haas <robertmhaas@gmail.com>,
	Andres Freund <andres@anarazel.de>,
	Thomas Munro <thomas.munro@enterprisedb.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: subscriptionCheck failures on nightjar
Message-ID: <20190919042305.GA21144@paquier.xyz>
References: 
 <CAEepm=0wB7vgztC5sg2nmJ-H3bnrBT5GQfhUzP+Ffq-WT3g8VA@mail.gmail.com>
 <20190213215147.cjbymfojf6xndr4t@alap3.anarazel.de>
 <20190813080435.GL2551@paquier.xyz>
 <20190826132904.3ayuw36qzl2c4ktr@development>
 <CA+TgmoaNOMG9+Ho9d3CX+-10O7+nqqvmSpXb1m0F3dqWB4C-8g@mail.gmail.com>
 <7361.1568738373@sss.pgh.pa.us>
 <20190917194510.iqwyl3be62pz7l27@development>
 <20190918005815.GB8909@paquier.xyz>
 <CAGz5QCJv5JbRDsATDTkJqq7h9F7u0QLnNnLHfxR1nEOa4DnkJQ@mail.gmail.com>
 <20190918215808.yonxqgycme6pbctp@development>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="X1bOJ3K7DJ5YkBrT"
Content-Disposition: inline
In-Reply-To: <20190918215808.yonxqgycme6pbctp@development>
Precedence: bulk


--X1bOJ3K7DJ5YkBrT
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Sep 18, 2019 at 11:58:08PM +0200, Tomas Vondra wrote:
> I kinda suspect it might be just a coincidence that it fails during that
> particular test. What likely plays a role here is a checkpoint timing
> (AFAICS that's the thing removing the file).  On most systems the tests
> complete before any checkpoint is triggered, hence no issue.
>=20
> Maybe aggressively triggering checkpoints on the running cluter from
> another session would do the trick ...

Now that I recall, another thing I forgot to mention on this thread is
that I patched guc.c to reduce the minimum of checkpoint_timeout to
1s.
--
Michael

--X1bOJ3K7DJ5YkBrT
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl2DAqkACgkQnvQgOdby
QH03ChAAgAUrntSrdScD9s4nyIUEYi+HzMh+WGtgBaFGleW3xN5mS6G6yK/tyVqa
GM4n8WRhwlJy3nVYJDcbQiY8WKFO+1t/VWuwD53NIDbnD/2XeF6OzhKdS6l3b/F8
IZusjHBSLJUgYJZlEgYkrHnAfvuudSgzeKpPQpYtrbyLebTUaggdaZFj7SwbiBpZ
I8xDrRPwHCJxAfYG30dTDz1/5fQcZyT5ODwxiYEITmIuL7EOJ/Cw+ljr4B2Rcq9d
wIYBsPdeHb0TmMWQX2I34J8hufc4+JWTA8a/j2Nel952sNhz+8pYqC4vgeyK4pXf
HjRKs1epnF8CtGHQOjlN6qtwuTYq8zIA1M+U3liO5DM6ApfzP4yeiRIXWjrZLwfd
Q0TU/HEXNS7wEj3IyFsnclOwXKS+5OZw50IMHmP5SZbUrL8gxLxL/xeP9DdMs7m4
+JZ7zs/O8r9YuH7+2v2N2xRzs8w6lgzQMs3mBuNZXl7jrANYdFW3Ave6qm8yq6bb
uoy0n5FLtNm/chuP2oK5ggE0/UsS/rMQPEgbpiLaRuf/h5SKeYQKT4UuXFbNZuRm
7SOBlP1B51ztmFwpgaqXZ1RykNoxSlShjxs0tZaysMnJR8m8sixunQHeKMpck60n
B3fBO7NgRO0TL7aA2hXwY+fiq1JrtOcJIRRwNtfY5SmXd2sWOh4=
=4JAY
-----END PGP SIGNATURE-----

--X1bOJ3K7DJ5YkBrT--