Re: [HACKERS] Logical replication: stuck spinlock atReplicationSlotRelease - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Logical replication: stuck spinlock atReplicationSlotRelease
Date
Msg-id da8efb78-28d9-73c2-d252-375dc27f3e40@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] Logical replication: stuck spinlock at ReplicationSlotRelease  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: [HACKERS] Logical replication: stuck spinlock atReplicationSlotRelease  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-hackers
On 6/21/17 09:02, Albe Laurenz wrote:
> 2017-06-21 14:55:12.033 CEST [23124] LOG:  could not send data to client: Broken pipe
> 2017-06-21 14:55:12.033 CEST [23124] FATAL:  connection to client lost
> 2017-06-21 14:55:17.032 CEST [23133] LOG:  logical replication apply worker for subscription "reprec" has started
> DEBUG:  received replication command: IDENTIFY_SYSTEM
> DEBUG:  received replication command: START_REPLICATION SLOT "reprec" LOGICAL 0/0 (proto_version '1',
publication_names'"repsend"')
 
> 2017-06-21 14:57:24.552 CEST [23124] PANIC:  stuck spinlock detected at ReplicationSlotRelease, slot.c:394
> 2017-06-21 14:57:24.885 CEST [23070] LOG:  server process (PID 23124) was terminated by signal 6: Aborted
> 2017-06-21 14:57:24.885 CEST [23070] LOG:  terminating any other active server processes
> 2017-06-21 14:57:24.887 CEST [23134] LOG:  could not send data to client: Broken pipe
> 2017-06-21 14:57:24.890 CEST [23070] LOG:  all server processes terminated; reinitializing

I can't reproduce that.  I let it loop around for about 10 minutes and
it was fine.

I notice that you have some debug settings on.  Could you share your
exact setup steps from initdb, as well as configure options, just in
case one of these settings is causing a problem?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] pg_bsd_indent 2.0 is available from git.postgresql.org
Next
From: Shubham Barai
Date:
Subject: [HACKERS] GSoC 2017 Proposal for predicate locking in hash index