Team
Does any one have experienced the lag while ...
# ask-community-for-troubleshootingv
Vijay Kothareddy
03/01/2022, 10:11 PMTeam
Does any one have experienced the lag while doing CDC on Postgres and filling up the source database disk space
I am doing the sync for every 5 min
👀 1
m
Marcos Marx (Airbyte)
03/01/2022, 10:25 PMWhat do you mean about lag? A different in records?
v
Vijay Kothareddy
03/01/2022, 10:32 PMLag is the data size in the slot which is a difference between lsn of last applied to current lsn
Though the sync on airbyte shows no records but db transaction log is growing
m
Marcos Marx (Airbyte)
03/02/2022, 9:36 PMCan you share the complete log sync to check what was logged? There are some info about the binlog there
v
Vijay Kothareddy
03/03/2022, 12:54 AMVijay Kothareddy
03/03/2022, 12:54 AMthe sync has 0 records
but postgres replication slot is of size 2gb
Vijay Kothareddy
03/03/2022, 9:59 PMdid you had a chance to look into it
m
Marcos Marx (Airbyte)
03/04/2022, 12:43 AM Copy code
2022-03-02 09:19:39 [44msource[0m > 2022-03-02 09:19:39 [32mINFO[m i.a.i.d.i.DebeziumRecordIterator(computeNext):80 - no record found. polling again.
2022-03-02 09:19:39 [44msource[0m > 2022-03-02 09:19:39 [32mINFO[m i.a.i.s.p.PostgresCdcStateHandler(saveState):31 - debezium state: {"{\"schema\":null,\"payload\":[\"otp\",{\"server\":\"otp\"}]}":"{\"last_snapshot_record\":true,\"lsn\":17580309712320,\"txId\":44769321,\"ts_usec\":1646208260214000,\"snapshot\":true}"}Marcos Marx (Airbyte)
03/04/2022, 12:44 AMLooks Debezium didn’t found any records in the binlog, can you double-check the table and replication slot?
3 Views