Re: [HACKERS] Logical replication: stuck spinlock atReplicationSlotRelease

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] Logical replication: stuck spinlock atReplicationSlotRelease
Дата
Msg-id da8efb78-28d9-73c2-d252-375dc27f3e40@2ndquadrant.com
обсуждение исходный текст
Ответ на [HACKERS] Logical replication: stuck spinlock at ReplicationSlotRelease  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Ответы Re: [HACKERS] Logical replication: stuck spinlock atReplicationSlotRelease  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: [HACKERS] pg_bsd_indent 2.0 is available from git.postgresql.org
Следующее
От: Shubham Barai
Дата:
Сообщение: [HACKERS] GSoC 2017 Proposal for predicate locking in hash index