[Bug]: Duplicate Operation in mo-cluster

[sukki37]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):60e6d323b36ce7c288cf439537fe134ced928e5b
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

1. Duplicate database and db.table existed in one mo cluster：
2. System databases have been initialized twice
3. Any SQL seems to be executing twice

Expected Behavior

No response

Steps to Reproduce

start a mo-cluster with mo-operator.

Additional information

No response

[daviszhen]

i think the transaction may have bugs.

[reusee]

fixed in https://github.com/matrixorigin/matrixone/pull/5421

[aylei]

This issue is still observed in the nightly build https://github.com/matrixorigin/matrixone/commit/724c8affc1cc45e72a734248150a95a7ff3cbdd3

> mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| mo_catalog         |
| system             |
| system_metrics     |
| information_schema |
| mo_catalog         |
| system             |
| system_metrics     |
| information_schema |
+--------------------+
8 rows in set (0.02 sec)

> kubectl get mo -n mo mo -oyaml | grep version
  version: nightly-724c8aff

@reusee

[sukki37]

update, This issue is still observed in the 43446ad2 commit. @reusee

cluster spec: 3 cn, 1 dn, 3 logservice

problem: all metadata seems duplicated

[sukki37]

multi-cn has not been tested yet

[sukki37]

test pass with 92439b1d3f73552ca912de6180099821c39955fd

overall configuration: 2 tpcn, 1 dn, 3 logservice with s3 enabled