Date: Thu, 23 Aug 2018 13:14:20 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Dmitry Dolgov <9erthalion6@gmail.com>,
	Alexander Kukushkin <cyberdemn@gmail.com>,
	pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15346: Replica fails to start after the crash
Message-ID: <20180823041420.GA1158@paquier.xyz>
References: 
 <CA+q6zcVjv1Lp-3=prBbpq2CbBioK91SHarfw3F8FHuUN4EwcUA@mail.gmail.com>
 <20180822175034.lnvwk5js32k6mjyz@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="HcAYCG3uE/tztfnV"
Content-Disposition: inline
In-Reply-To: <20180822175034.lnvwk5js32k6mjyz@alvherre.pgsql>
Precedence: bulk


--HcAYCG3uE/tztfnV
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Wed, Aug 22, 2018 at 02:50:34PM -0300, Alvaro Herrera wrote:
> On 2018-Aug-22, Dmitry Dolgov wrote:
> I don't know.  I was thinking it could detect some invalid write in
> shared memory.

invalid_page_tab does not use HASH_SHARED_MEM.  What did you have in
mind?

On my side, I have been letting a primary/standby set run for a certain
amount of time with the following running:
- pgbench load on the primary.
- background worker connecting to database, just running in loop and
sleeping.  It uses BgWorkerStart_ConsistentState as start mode.
- The standby gets stopped in immediate mode, and restarted after some
time to let some activity happening after the recovery point has been
reached.

After close to an hour of repeated tests, I am not able to reproduce
that.  Maybe there are some specifics in your schema causing more
certain types of records to be created.  Could you check if in the set
of WAL segments replayed you have references to the block the hash table
is complaining about?
--
Michael

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

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlt+NJwACgkQnvQgOdby
QH18Ag/+M9Lhsrl1RiMij49AA+Y47tbAjUjnZ+U/SEPahv7pfBCAjMzc6dhHAM2U
JCeXKYeE2tSVJ3N+NyfscA3lxNpcKUNGZmjPhrmt61riIYCvh5XFxnni3AApbjXL
skkE1I8xbTOgwW4BRzXZM5DGp3dHp9o8M9u7rYrWD9ZePrjoj6Nx+VhcouHbEo6T
aLNI5xWzhCisHX9XSUQEebhAJ+l0SPd4EX4cgDPLS761Rcushh7xTDynTp7M3WVM
d33pocC597AIFpy8d+Jpm11cQ6RQKXGnkty07fn2Onz3GNs+aKdlsub0b/J8pzgC
TBQi6RID2HCFXutuDjVSc/BUMCZYEjxwZ655dkF/W/ooRt9npy6/eKFfC1de/AIa
L4+TYjtqUmwK5iZWTvQSzJLv+akdXU48apCHN7+6pIPg9mpLrJJ2pYEfLD9t3W5u
0ePm94dGZ3f5TZGTJf/HfY0KKgG21nKnNXhKwyQlHQbWYnwu6pfr95fvMAQl87tP
DkZnUTRfjcXnmRzqF/hkIocqdsB79qmR3fg62JmoKZ/fze4DMjVQhP1yX/u6BNf3
ddnxjdy3CkrQI4BkVy3a8QXoKf15y/aEtwaUssVm/cBvDK+p7EaMaltiVYRCBBe+
bV5yzMTiqJBuGdI9z/lIgCpPJnyR8EuEUX7TizZ6ktf3FkPoXxg=
=ZaDe
-----END PGP SIGNATURE-----

--HcAYCG3uE/tztfnV--