From: | Erik Rijkers <er(at)xs4all(dot)nl> |
---|---|
To: | Petr Jelinek <petr(at)2ndquadrant(dot)com> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, Steve Singer <steve(at)ssinger(dot)info>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers-owner(at)postgresql(dot)org |
Subject: | Re: Logical Replication WIP |
Date: | 2016-11-22 17:42:02 |
Message-ID: | e23285d1f616e3ff2e73ba8afa2ad9c4@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2016-11-20 19:02, Petr Jelinek wrote:
> 0001-Add-support-for-TE...cation-slots-v8.patch.gz (~8 KB)
> 0002-Refactor-libpqwalreceiver-v8.patch.gz (~9 KB)
> 0003-Add-PUBLICATION-catalogs-and-DDL-v8.patch.gz (~30 KB)
> 0004-Add-SUBSCRIPTION-catalog-and-DDL-v8.patch.gz (~27 KB)
> 0005-Define-logical-rep...output-plugi-v8.patch.gz (~13 KB)
> 0006-Add-logical-replication-workers-v8.patch.gz (~43 KB)
> 0007-Add-separate-synch...for-logical--v8.patch.gz (~2 KB)
Apply, make, make check, install OK.
A crash of the subscriber can be forced by running vacuum <published
table> on the publisher.
- publisher
create table if not exists testt( id integer primary key, c text );
create publication pub1 for table testt;
- subscriber
create table if not exists testt( id integer primary key, c text );
create subscription sub1 connection 'dbname=testdb port=6444'
publication pub1 with (disabled);
alter subscription sub1 enable;
- publisher
vacuum testt;
now data change on the published table, (perhaps also a select on the
subscriber-side data) leads to:
- subscriber log:
TRAP: FailedAssertion("!(pointer != ((void *)0))", File: "mcxt.c", Line:
1001)
2016-11-22 18:13:13.983 CET 10177 LOG: worker process: ??)? (PID 10334)
was terminated by signal 6: Aborted
2016-11-22 18:13:13.983 CET 10177 LOG: terminating any other active
server processes
2016-11-22 18:13:13.983 CET 10338 WARNING: terminating connection
because of crash of another server process
2016-11-22 18:13:13.983 CET 10338 DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit,
because another server process exited abnormally and possibly corrupted
shared memory.
[...]
Erik Rijkers
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-11-22 17:54:48 | Re: [RFC] Should we fix postmaster to avoid slow shutdown? |
Previous Message | Jon Nelson | 2016-11-22 17:37:26 | Re: macaddr 64 bit (EUI-64) datatype support |