Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Table Synchronization status unknown #493

Open
RakeshThirunahari opened this issue Jan 3, 2025 · 0 comments
Open

Table Synchronization status unknown #493

RakeshThirunahari opened this issue Jan 3, 2025 · 0 comments

Comments

@RakeshThirunahari
Copy link

For some of the replicated tables, I get a status "unknown" on the subscriber when I call select * from pglogical.show_subscription_table(subscription_name name, relation regclass);.
In fact, I've discovered that 5 tables are missing when I issue select * from pglogical.local_sync_status; on the subscriber.
On the provider: select * from pglogical.replication_set_table; returns 40 lines for the set_id used.
On the subscriber: select * from pglogical.tables; returns the same 40 tables. But, select * from pglogical.local_sync_status; returns only 35 tables even if the data seem synchronized for the missing tables.

To reproduce the issue create the subscription with synchronize_data := false

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant