[xCluster][DDL Replication] Table state is stuck at preparing state on target

[agsh-yb]

Jira Link: DB-12523

Description

Version: 2.23.1.0-b55

After performing several operations, I attempted to set up replication and create a table at the source. However, the process is taking significantly longer than expected(Stuck) to fetch the table at the target. The UI indicates that the table is in the “preparing” state.

Steps performed:

yugabyte=# \c db8
You are now connected to database "db8" as user "yugabyte".
db8=# create table t (id int);
CREATE TABLE
db8=# select * from yb_xcluster_ddl_replication.ddl_queue;
    start_time    | query_id  |                                                                               
        yb_data                                                                                        
------------------+-----------+-------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
 1724440824452743 | 696290502 | {"user": "yugabyte", "query": "create table t (id int);", "schema": "public", 
"version": 1, "command_tag": "CREATE TABLE", "new_rel_map": [{"rel_name": "t", "relfile_oid": 16402}]}
(1 row)

Additional Information:

Support bundles for both the source and target have been created and attached to the corresponding Jira ticket for further investigation.

cc: @Arjun-yb

Issue Type

kind/bug

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

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

[agsh-yb]

If I tries to create table in another database which is already under replication with in replication group it's restricting to do so with error

db5=# create table ts(id int);
ERROR:  Error parsing ddl_queue_primary_key_start_time: