[YSQL] create colocated table hangs with --report_ysql_ddl_txn_status_to_master=false

[myang2021]

Jira Link: DB-12618

Description

To reproduce the bug:

(1) create a local cluster with the following command

bin/yb-ctl create --rf 1 --tserver_flags=report_ysql_ddl_txn_status_to_master=false

(2) Run the following SQL via ysqlsh

$ ./bin/ysqlsh 
ysqlsh (11.2-YB-2.23.1.0-b0)
Type "help" for help.

yugabyte=# CREATE DATABASE colocation_db colocation = true;
CREATE DATABASE
yugabyte=# \c colocation_db
You are now connected to database "colocation_db" as user "yugabyte".
colocation_db=# CREATE TABLE foo(id INT);

The CREATE TABLE statement will not complete until after 10 minutes.

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.