Re: [HACKERS] Server Crashes if try to provide slot_name='none' atthe time of creating subscription. - Mailing list pgsql-hackers

From Kuntal Ghosh
Subject Re: [HACKERS] Server Crashes if try to provide slot_name='none' atthe time of creating subscription.
Date
Msg-id CAGz5QCLSVo60Nn+9OPpSuZJfaMZSKQtQhz7Zg4UDz9GMkMxSWg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Server Crashes if try to provide slot_name='none' atthe time of creating subscription.  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: [HACKERS] Server Crashes if try to provide slot_name='none' atthe time of creating subscription.  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
On Mon, May 15, 2017 at 4:39 PM, Masahiko Sawada <sawada.mshk@gmail.com> wrote:

While testing with logical replication, I've found that the server
hangs if we create a subscription to the same server. For example,

$ ./pg_ctl -D Test start -o "-p 5432"
$ ./psql -p 5432 postgres -c "CREATE PUBLICATION abc for all tables
with (publish='delete');"
$ ./psql -p 5432 postgres -c "create subscription sub connection
'dbname=postgres port=5432 user=edb password=edb' publication abc with
(slot_name='abcslot');"
NOTICE:  synchronized table states
LOG:  logical decoding found initial starting point at 0/162DF18
DETAIL:  Waiting for transactions (approximately 1) older than 560 to end.

And, it hangs. Is this an expected behavior?

-- 
Thanks & Regards,
Kuntal Ghosh
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Server Crashes if try to provide slot_name='none' atthe time of creating subscription.
Next
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Server Crashes if try to provide slot_name='none' atthe time of creating subscription.