[BUGS] BUG #14837: pglogical subscription strange behavior
От | gkostov79@gmail.com |
---|---|
Тема | [BUGS] BUG #14837: pglogical subscription strange behavior |
Дата | |
Msg-id | 20170929095206.28558.87966@wrigleys.postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: