The following bug has been logged on the website:
Bug reference: 14837
Logged by: Georgi Kostov
Email address: gkostov79@gmail.com
PostgreSQL version: 9.6.5
Operating system: Debian
Description:
Hi guys,
I have bit strange problem with pglogical subscription: at first look on
randomly after "select pglogical.alter_subscription_disable('$dbs',false) "
and then select pglogical.alter_subscription_enable('$dbs',false)" not all
subscriptions are replicating this happen rarely but if happen subscription
stay down and not replicating until cluster restart. after that everthing is
fine and all are in state replicating.
In the logs I have only this :
2017-09-29 09:30:26.155 UTC,,,27322,,59ce12b2.6aba,1,,2017-09-29 09:30:26
UTC,5/0,0,LOG,00000,"manager worker [27322] at slot 3 generation 70
detaching cleanly",,,,,,,,,"pglogical manager 12407"
2017-09-29 09:30:26.157 UTC,,,27323,,59ce12b2.6abb,1,,2017-09-29 09:30:26
UTC,5/0,0,LOG,00000,"manager worker [27323] at slot 3 generation 71
detaching cleanly",,,,,,,,,"pglogical manager 1"
Can someone advice me what to do to avoid cluster restart please?
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs