Re: [BUG] Logical replica crash if there was an error in a function.

From: "Anton A(dot) Melnikov" <aamelnikov(at)inbox(dot)ru>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Maxim Orlov <orlovmg(at)gmail(dot)com>
Subject: Re: [BUG] Logical replica crash if there was an error in a function.
Date: 2022-09-08 08:47:06
Message-ID: 40642b7a-1202-7e09-fc57-1a119f1528b7@inbox.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello!

Added a TAP test for this case.

On 30.08.2022 10:09, Anton A. Melnikov wrote:
> Hello!
>
> The patch was rebased on current master.
> And here is a simplified crash reproduction:
> 1) On primary with 'wal_level = logical' execute:
>  CREATE TABLE public.test (id int NOT NULL, val integer);
>  CREATE PUBLICATION test_pub FOR TABLE test;
>
> 2) On replica replace XXXX in the repcmd.sql  attached with primary port and execute it:
> psql -f repcmd.sql
>
> 3) On master execute command:
> INSERT INTO test VALUES ('1');
>

With best regards,

--
Anton A. Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
v4-0001-Fix-logical-replica-assert-on-func-error.patch text/x-patch 5.6 KB
repcmd.sql application/sql 797 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2022-09-08 08:55:40 Re: Bump MIN_WINNT to 0x0600 (Vista) as minimal runtime in 16~
Previous Message Vik Fearing 2022-09-08 08:14:56 Re: Doc fix and adjustment for MERGE command