| 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: | Whole Thread | Raw Message | 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 |
| 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 |