Re: [HACKERS] Logical replication: stuck spinlock atReplicationSlotRelease

Albe Laurenz wrote:
> Peter Eisentraut wrote:
> > 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?

Hmm, so for instance in LogicalIncreaseRestartDecodingForSlot() we have
some elog(DEBUG1) calls with the slot spinlock held.  That's probably
uncool.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services