Re: BUG #16233: Yet another "logical replication worker" was terminated by signal 11: Segmentation fault - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16233: Yet another "logical replication worker" was terminated by signal 11: Segmentation fault
Date
Msg-id 30599.1580056098@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16233: Yet another "logical replication worker" was terminated by signal 11: Segmentation fault  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16233: Yet another "logical replication worker" wasterminated by signal 11: Segmentation fault
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> I browsed around and noticed a few people having similar issues with logical
> replication.
> To my eyes it looks similar to the issue here:
> https://www.postgresql.org/message-id/flat/16129-a0c0f48e71741e5f%40postgresql.org
> which was fixed here:
> https://git.postgresql.org/gitweb/?p=postgresql.git&a=commit&h=a2aa224e

The stack trace does look the same, but do you have the same triggering
condition we identified (that is, fairly wide column values in the
subscriber table that are not getting replaced during a
logical-replication update? or possibly dropped columns in the
subscriber table?)

> When is 12.2 due out? Feb 13?

https://www.postgresql.org/developer/roadmap/

How quickly downstream packages appear isn't entirely under our
control, though.

> Are there any daily Ubuntu builds available
> anywhere so I can test the patch for my purposes, before I try to compile
> from scratch?

Couldn't say, but with most packaging systems it's relatively simple
to rebuild a given package with a custom patch or two added.  (If
memory serves, with Debian's system you don't even have to modify
any files, just add the patch into the relevant subdirectory.)
That's a skill worth acquiring if you deal with open source a lot.

FWIW, I do know that Christoph does test builds for Debian and Ubuntu
on a pretty regular basis, because he complains when things break ;-).
Whether he makes those builds widely available, though, I don't know.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Lukáš Sobotka
Date:
Subject: Segfault on updating foreign table
Next
From: Tom Lane
Date:
Subject: Re: Segfault on updating foreign table