Segmentation Fault (Logical Replication)

Started by M Rehman Kahloonabout 6 years ago3 messagesbugs
Jump to latest
#1M Rehman Kahloon
m.rehman@3gca.org

Hi

I am facing very critical issue with my master database when
implemented logical replication using pglogical and built in replication
feature ( publisher using postgrSQL 10 and subscription using PostgreSQL
11).

DB crashing frequently with error 'Segmentation Fault' error. Same issue
when seeting pg-wal logical and replica.

Please need your kind response to sort out issue.

Your sincerely

Mr Kahloon

Senior Data ANALYST.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: M Rehman Kahloon (#1)
Re: Segmentation Fault (Logical Replication)

"M Rehman Kahloon" <m.rehman@3gca.org> writes:

I am facing very critical issue with my master database when
implemented logical replication using pglogical and built in replication
feature ( publisher using postgrSQL 10 and subscription using PostgreSQL
11).
DB crashing frequently with error 'Segmentation Fault' error. Same issue
when seeting pg-wal logical and replica.

There's nowhere near enough information in this report for anyone to
help you. Please see

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

and

https://www.postgresql.org/docs/11/bug-reporting.html

for some advice about what to put in a useful trouble report.
Since you're getting crashes, we'd probably also wish to see
a stack trace,

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

regards, tom lane

#3Michael Paquier
michael@paquier.xyz
In reply to: Tom Lane (#2)
Re: Segmentation Fault (Logical Replication)

On Wed, Jan 29, 2020 at 10:25:38AM -0500, Tom Lane wrote:

for some advice about what to put in a useful trouble report.
Since you're getting crashes, we'd probably also wish to see
a stack trace,

https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

Impossible to say if that's Postgres problem without at least a
backtrace (even better a reproducible scenario), but you could also
consider contacting the maintainers of pglogical:
https://github.com/2ndQuadrant/pglogical
--
Michael