os: Ubuntu 2204
ob:4.2.0
tpcc_load装载了数据,中途ctl+c停止了装载,然后想drop 压测表数据,但是报错:
obclient [ob]> alter table history drop CONSTRAINT `fkey_history_1`;
ERROR 4179 (HY000): execute ddl while there are some long running ddl on foreign key related table not allowed
obclient [ob]> show processlist;
+-------+----------+------+-------------------+--------+-------------+-------------------+-------------------+-------+-------+
| Id | Tenant | User | Host | db | trans_count | svr_session_count | state | tid | pid |
+-------+----------+------+-------------------+--------+-------------+-------------------+-------------------+-------+-------+
| 17548 | yl_mysql | root | 10.xxx:33512 | xxx | 0 | 3 | MCS_ACTIVE_READER | 62980 | 62980 |
+-------+----------+------+-------------------+--------+-------------+-------------------+-------------------+-------+-------+
1 row in set (0.005 sec)
不知道大家遇到这个情况没有?