Open zhaoyi0113 opened 2 years ago
I faced the same issue in v16 and was able to fix it by using the below steps:
2024-05-08 01:34:09.581 UTC [26390] ERROR: replication origin "pgl_logi_provider1_subscription1" does not exist
logi=# select pglogical.drop_subscription('subscription1');
drop_subscription
-------------------
1
(1 row)
logi=# select pg_replication_origin_create('pgl_logi_provider1_subscription1');
pg_replication_origin_create
------------------------------
1
(1 row)
logi=# SELECT pglogical.create_subscription(subscription_name := 'subscription1',provider_dsn := 'host=10.x.x.x port=5432 dbname=logi user=pglogical password=xxxxx');
create_subscription
---------------------
1763399739
(1 row)
However, I am not sure why this error occurred when the same steps without manually creating a replication origin worked in v14.
I have two postgresql 11.9 and 13.4.
The node, replica_set and subscription are all created successfully in both clusters. However, when I check the subscription status in the target database, the status is down:
In the target database log, I can see below error:
in the source database log:
I can see there are errors in both source and target instances. But I can't figure out what could be the issue.