[xCluster][DB-Scope DR] Replication failing with error ColocationId not found

[agsh-yb]

Jira Link: DB-12116

Description

Setup:
xCluster(DB-Scope DR) + colocation + Copy commands

Observed on version 2024.1.1.0-b127
Error:

E0710 22:56:07.960215 113130 xcluster_output_client.cc:657] Error while applying replicated record: Not found (yb/tserver/xcluster_output_client.cc:287): ColocationId 40000 not found., consumer tablet: 846e488bed384d00ab6c7d3fe32bbed1

Master UI shows that both clusters have tables with the same colocation id

Query to create table:

CREATE TABLE employees_col_cpy(id text, uuid_col uuid DEFAULT uuid_generate_v4 (), name text, c complex, info json, contact JSONB, arr smallint[], cash money, i inet, m macaddr, i2 serial, i3 bigserial, val smallint, details e_details, age int, collated_data text collate "POSIX", date DATE, n NUMERIC (3, 2), r real, c1 CHAR(1), created_at timestamptz, uuid0 uuid DEFAULT uuid_nil(), uuid1 uuid DEFAULT uuid_generate_v1(), p1 POINT, t1 TIME, ts1 TIMESTAMP, i4 INTERVAL, p2 path, p3 polygon, b box, c2 circle, l line, l1 lseg, a2 text[][], zip postal_code, PRIMARY KEY(id, name, uuid_col, age)) WITH (colocated = True,COLOCATION_ID=40000)

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.

[agsh-yb]

cc: @kripasreenivasan

[lingamsandeep]

Duplicate of #23188