From: Tom Lane <tgl@sss.pgh.pa.us>
To: Justin Pryzby <pryzby@telsasoft.com>
cc: Andres Freund <andres@anarazel.de>,
        Matthias van de Meent <boekewurm+postgres@gmail.com>,
        pgsql-hackers@postgresql.org
Subject: Re: v16dev: TRAP: failed Assert("size > SizeOfXLogRecord"),
 File: "xlog.c", Line: 1055, PID: 13564
In-reply-to: <ZD3BaJGa0jDNLXGI@telsasoft.com>
References: <ZD1daibg4RF50IOj@telsasoft.com>
 <CAEze2Wg+Pbec3jaaUSF8E6Piy=bq=gXkFCFyaYwFDYTDjCMSvg@mail.gmail.com>
 <2444561.1681748021@sss.pgh.pa.us> <2454846.1681753830@sss.pgh.pa.us>
 <ZD3BaJGa0jDNLXGI@telsasoft.com>
Comments: In-reply-to Justin Pryzby <pryzby@telsasoft.com>
	message dated "Mon, 17 Apr 2023 17:00:08 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2522098.1681769384.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 17 Apr 2023 18:09:44 -0400
Message-ID: <2522099.1681769384@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2522099.1681769384%40sss.pgh.pa.us>
Precedence: bulk

Justin Pryzby <pryzby@telsasoft.com> writes:
> On Mon, Apr 17, 2023 at 01:50:30PM -0400, Tom Lane wrote:
>> Bingo: bisecting shows the failure started at

> Just curious: what "test" did you use to bisect with ?

The test case I used looked like

start postmaster with -c wal_level=3Dminimal -c max_wal_senders=3D0
make installcheck-parallel
psql -d regression -c "do 'begin for i in 1..1000 loop execute ''create ta=
ble lots''||i||'' as select * from onek''; end loop; end';"
pg_dump -Fc -Z0 regression >~/regression.dump
createdb r2
pg_restore -d r2 --single-transaction --no-tablespace ~/regression.dump

Dumping the regression database as-is didn't reproduce it for me,
but after I added a bunch more tables it did reproduce.

(I added the -Z0 bit after some of the bisection test points hit the
interval where somebody had broken pg_dump's compression features.
It didn't seem relevant to the problem so I just disabled that.)

			regards, tom lane