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
Tables are not synced even when their "sync_status" are "r" #204
Comments
Add more information that may be helpful: |
@beyondbill,
|
@beyondbill Is this issue resolved? I think it might have to do with syncronize_structure and syncronize_data. If not, I could help you. |
I also have an issue with sync in pglogical. At the subscriber side in the table local_sync_status the records from the replication_set are copied with sync_status "i" and in the statistics of the subscription-table I see Sequential Tuples Read is 12752 from 15 records in the replication-set. (I restarted the instance several times). But nothing has changed in the tables at the subsciberside. |
I managed to setup
pglogical 2.2.0
logical replication from a Postgres 9.6.10 RDS instance to a Postgres 10.4 RDS instance. The subscription checkSELECT subscription_name, status FROM pglogical.show_subscription_status();
returnsreplicating
. The local sync status checkSELECT * FROM pglogical.local_sync_status
returns sync_statusr
for some tables andy
for the rest.However I find tables are not really synced even for those have been reported as
r
. For example,pglogical
reports tabletrip_match_blocks
has been fully synced (e.g. sync_statusr
) from upstream to downstream. But the number of rows is 84679 on the downstream while upstream has 84893 rows. Both row numbers were counted bySELECT count(*) FROM trip_match_blocks
so they are accurate count of all valid rows. There's also nothing thanpglogical
that can write to both upstream and downstream. So their row numbers should be identical if they are fully synced.I have not been able to find any official source that documents how to determine a table has been fully synced or the exact meanings of different
sync_status
inlocal_sync_status
table. My guess about what they mean is all based on the following source codehttps://github.com/2ndQuadrant/pglogical/blob/REL2_x_STABLE/pglogical_sync.h#L43-L51
Could be my misunderstanding of sync_status
r
. If so, how can I tell a table has been fully synced?The text was updated successfully, but these errors were encountered: