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

Ghost entries in pglogical.local_sync_status #167

Open PerRommetveit opened 6 years ago

PerRommetveit commented 6 years ago

I have a provider set up with a replication set. Initially the table 'schema.table_tmp' and the table 'schema.table' was added to the replication set. I then replaced the table with the temp table, before doing that, I temporarily removed the 'schema.table' from the replication set. The replacement was done by deleting the first table, then renaming the temp table. The tmp table now being the schema.table was added to the replication set, and the temp table removed. Replication works fine.

However, on the subscriber, the table pglogical.local_sync_status still lists the temp table. Along with this there are also a couple of empty entries where only sync_subid is listed and sync_subid, sync_relname, sync_relname is empty. The sync_subid is equal to that of the current subscriptions.

I have attempted to remove the schema.table_tmp entry from pglogical.local_sync_status by disabling and enabling the subscription. I have also tried to remove, then add the replication set from the subscription. I have tried to resync the subscription, to no avail. I am afraid to delete the entry manually from pglogical.local_sync_status.

Does anyone have an idea what the issue can be, and how to remove this entry? And what about the blank entries, is that normal?

The blank entries look like:

f | 1431843812 | | | r f | 3574879916 | | | r

Versions: pglogical: 2.0.1 and postgres 9.6

prakashrajpoudel commented 4 years ago

I am getting blank entries as well

 d         | 2598229851 |              |                 | r           | 0/0