Date: Sat, 12 Feb 2022 16:28:42 -0800
From: Andres Freund <andres@anarazel.de>
To: pgsql-hackers@lists.postgresql.org, Thomas Munro <thomas.munro@gmail.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: =?US-ASCII?Q?Re=3A_FailedAssertion=28=22pre?= =?US-ASCII?Q?v=5Ffirst=5Flsn_=3C_cur=5Ftxn-=3Efi?= =?US-ASCII?Q?rst=5Flsn=22=2C_File=3A_=22reorderb?= =?US-ASCII?Q?uffer=2Ec=22=2C_Line=3A_1173=2C_=2E=2E=2E?=
User-Agent: K-9 Mail for Android
In-Reply-To: <CA+hUKGJSJ+YKAsDsuDi1Py5Y9URFhX5Spz=Rx54TS=AezX4=Lw@mail.gmail.com>
References: <CA+hUKGJSJ+YKAsDsuDi1Py5Y9URFhX5Spz=Rx54TS=AezX4=Lw@mail.gmail.com>
Message-ID: <AC71735B-8D47-40EF-95CF-FD9C388C13E8@anarazel.de>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/AC71735B-8D47-40EF-95CF-FD9C388C13E8%40anarazel.de>
Precedence: bulk

Hi,=20

On February 12, 2022 3:57:28 PM PST, Thomas Munro <thomas=2Emunro@gmail=2E=
com> wrote:
>Hi,
>
>I don't know what happened here, but I my little script that scrapes
>for build farm assertion failures hasn't seen this one before now=2E
>It's on a 15 year old macOS release and compiled with 15 year old GCC
>version, for some added mystery=2E
>
>https://buildfarm=2Epostgresql=2Eorg/cgi-bin/show_log=2Epl?nm=3Dlocust&dt=
=3D2022-02-12%2022%3A07%3A21
>
>2022-02-13 00:09:52=2E859 CET [92423:92] pg_regress/replorigin
>STATEMENT:  SELECT data FROM
>pg_logical_slot_get_changes('regression_slot', NULL, NULL,
>'include-xids', '0', 'skip-empty-xacts', '1', 'include-sequences',
>'0');
>TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File:
>"reorderbuffer=2Ec", Line: 1173, PID: 92423)
>0   postgres                            0x00592dd0 ExceptionalCondition +=
 160\\0
>1   postgres                            0x00391c40
>ReorderBufferGetRelids + 304\\0
>2   postgres                            0x00394794
>ReorderBufferAllocate + 1044\\0
>3   postgres                            0x003834dc heap_decode + 76\\0
>4   postgres                            0x003829c8
>LogicalDecodingProcessRecord + 168\\0
>5   postgres                            0x0038a1d4
>pg_logical_emit_message_text + 1876\\0
>6   postgres                            0x00241810
>ExecMakeTableFunctionResult + 576\\0
>7   postgres                            0x002576c4
>ExecInitFunctionScan + 1444\\0
>8   postgres                            0x00242140 ExecScan + 896\\0
>9   postgres                            0x002397cc standard_ExecutorRun +=
 540\\0
>10  postgres                            0x00427940
>EnsurePortalSnapshotExists + 832\\0
>11  postgres                            0x00428e84 PortalRun + 644\\0
>12  postgres                            0x004252e0 pg_plan_queries + 3232=
\\0
>13  postgres                            0x00426270 PostgresMain + 3424\\0
>14  postgres                            0x0036b9ec PostmasterMain + 8060\=
\0
>15  postgres                            0x0029f24c main + 1356\\0
>16  postgres                            0x00002524 start + 68\\0

I think that may be the bug that Tomas fixed a short while ago=2E He said =
the skip empty xacts stuff didn't yet work for sequences=2E That's only lik=
ely to be hit in slower machines=2E=2E=2E

Andres
--=20
Sent from my Android device with K-9 Mail=2E Please excuse my brevity=2E