Create 2 universes with enable_replicate_transaction_status_table=true and disable automatic tablet splitting
Create table and indexes at source and target
Setup unidirectional replication from source to target.
Change target’s xcluster role to **STANDBY**
Create snapshot schedule at target
Load data at Source(350K+)
Validate data at both sides - works fine
Stop applications and pause the replication from source to target
At target: Get xcluster safe time and restore to the safe time
Promote Target to Active role and switch applications to target and resume applications.
Delete replication from source to target
Drop table and database at source.
Wait for some time and follow bootstrap flow from target to source(Create same database, table and indexes at source and create replication from target to source)
Observations
There is huge lag.
YSQLSH connectivity issue at source side
1 Node is in unreachable state and 1 node's master is down.
Observed >50% CPU Usage at Source side even though there are no running applications at source
E1229 09:23:50.661798 10204 docdb_compaction_filter_intents.cc:180] T ab64476ef3c14b59944b71c8f3733529: Not found (yb/tablet/transaction_participant.cc:1117): Unknown transaction f4f1aaa3-fcc5-4303-beef-748db1bf6ed1
E1229 09:23:50.661861 10204 docdb_compaction_filter_intents.cc:180] T ab64476ef3c14b59944b71c8f3733529: Not found (yb/tablet/transaction_participant.cc:1117): Unknown transaction f9a00b35-f809-4a0b-9f38-82db18cb4602
E1229 09:23:50.661883 10204 docdb_compaction_filter_intents.cc:180] T ab64476ef3c14b59944b71c8f3733529: Not found (yb/tablet/transaction_participant.cc:1117): Unknown transaction faea383e-2e22-4d4e-a5c2-eae2d2b4da28
Jira Link: DB-4763
Description
Steps:
enable_replicate_transaction_status_table=true
and disable automatic tablet splitting**STANDBY**
Observations
Source:
At Target: