search

2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.01k stars 153 forks source link

Pglogical subscription status is down and log shows error #305

Open azrarabbani opened 3 years ago

azrarabbani commented 3 years ago

Instances works fine with an almost empty database with a simple table.

But when I use my schema the provider, subscriber and subscription creates fine but the subscription status is shown as down.

The schema is not large and i've tried with no data in it as well but no difference.

the logs shows errors like:

2021-03-13 00:37:30.019 UTC [9792] LOG: starting pglogical database manager for database sandbox 2021-03-13 00:45:33.169 UTC [9852] LOG: logical decoding found consistent point at 0/1153AB78 2021-03-13 00:45:33.169 UTC [9852] DETAIL: There are no running transactions. 2021-03-13 00:45:33.169 UTC [9852] LOG: exported logical decoding snapshot: "00000010-000000A6-1" with 0 transaction IDs 2021-03-13 00:45:33.263 UTC [9853] LOG: unexpected EOF on client connection with an open transaction 2021-03-13 00:45:33.264 UTC [9852] LOG: unexpected EOF on client connection with an open transaction

Please help i am not finding any way to troubleshoot this issue.

Thanks

gowthamakanthan commented 2 years ago

Have you fixed this ?