On 6/23/17 13:26, Alvaro Herrera wrote: > Albe Laurenz wrote: >> Peter Eisentraut wrote: >>> On 6/21/17 09:02, Albe Laurenz wrote: >>>> 2017-06-21 14:55:12.033 CEST  LOG: could not send data to client: >>>> Broken pipe >>>> 2017-06-21 14:55:12.033 CEST  FATAL: connection to client lost >>>> 2017-06-21 14:55:17.032 CEST  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  PANIC: stuck spinlock detected at >>>> ReplicationSlotRelease, slot.c:394 >>>> 2017-06-21 14:57:24.885 CEST  LOG: server process (PID 23124) was >>>> terminated by signal 6: Aborted >>>> 2017-06-21 14:57:24.885 CEST  LOG: terminating any other active >>>> server processes >>>> 2017-06-21 14:57:24.887 CEST  LOG: could not send data to client: >>>> Broken pipe >>>> 2017-06-21 14:57:24.890 CEST  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.
I can reproduce the issue with --client-min-messages=debug2 or debug1, but it doesn't appear with the default settings. I don't always get the "stuck spinlock" message, but it hangs badly pretty reliably after two or three rounds of erroring. Removing the call you pointed out doesn't make a difference, but it's possibly something similar. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers