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-08-30 07:09:04 |
Message-ID: | 3ee70f0e-7edc-8099-73a5-3fb74745c02e@inbox.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 |
---|---|---|
v3-0001-Fix-logical-replica-assert-on-func-error.patch | text/x-patch | 2.4 KB |
repcmd.sql | application/sql | 797 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2022-08-30 07:14:23 | Re: Reducing the chunk header sizes on all memory context types |
Previous Message | Alexander Pyhalov | 2022-08-30 06:58:39 | Re: Add semi-join pushdown to postgres_fdw |