pglogical icon indicating copy to clipboard operation
pglogical copied to clipboard

Stale pglogical extension process breaking logical replication

Open Viralshah009 opened this issue 10 months ago • 0 comments

Environment:

pglogical version: 2.4.3
PostgreSQL version: 14.8
Two production servers

Symptoms:

pg_replication_slots says that the logical replication subscriptions are replicating and active
No data is getting replicated from publisher to subscriber
Stale pglogical extension process found on the subscriber server

Steps taken:

Recreated subscription (no help)
Killed stale pglogical extension process on the subscriber server
Dropped pglogical extension on the subscriber server
Recreated pglogical extension, subscription, etc. on the subscriber server

Outcome:

Replication resumed

Question:

Has anyone else come across this issue? If not, can it be fixed?

Additional notes:

We have tried to recreate this issue in our test environments but are unable to do so.

Viralshah009 avatar Oct 18 '23 18:10 Viralshah009