Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

DM is making multiple of same Alter again and again !! #60362

Open
kabileshKabi opened this issue Apr 2, 2025 · 7 comments
Open

DM is making multiple of same Alter again and again !! #60362

kabileshKabi opened this issue Apr 2, 2025 · 7 comments
Labels
type/bug The issue is confirmed as a bug.

Comments

@kabileshKabi
Copy link

Bug Report

We use Mysql in the upstream and replicate from there using DM cluster to the TiDB cluster.

When the DDL is executed in MySQL, when its replicating to TIDB via DM, we see the same DDL being executed in multiple threads and causing the replication to go for a lag indefinitely also DDL jobs goes to Queue state as below

| Id        | User | Host                | db              | Command | Time    | State                      | Info                                                                                                 |
+-----------+------+---------------------+-----------------+---------+---------+----------------------------+------------------------------------------------------------------------------------------------------+
| 455089470 | root | 172.31.24.1:42084   | NULL            | Query   |   26395 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090646 | root | 172.31.24.1:49858   | NULL            | Query   |   17855 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091192 | root | 172.31.24.1:41598   | NULL            | Query   |   13890 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088210 | root | 172.31.24.1:39606   | NULL            | Query   |   35545 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092872 | root | 172.31.24.1:58646   | NULL            | Query   |    1690 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088882 | root | 172.31.24.1:47658   | NULL            | Query   |   30665 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092074 | root | 172.31.24.1:52742   | NULL            | Query   |    7485 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091066 | root | 172.31.24.1:34124   | NULL            | Query   |   14805 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088840 | root | 172.31.24.1:50970   | NULL            | Query   |   30970 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088084 | root | 172.31.24.1:48488   | NULL            | Query   |   36460 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092662 | root | 172.31.24.1:51982   | NULL            | Query   |    3215 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455082028 | root | 172.31.6.124:57880  | NULL            | Query   | 1267353 | autocommit                 | create table `underwriting_service`.`blacklisted_mnrl_mobilenumbers` like `underwriting_service`.`bl |
| 455088714 | root | 172.31.24.1:35418   | NULL            | Query   |   31885 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092410 | root | 172.31.24.1:40944   | NULL            | Query   |    5045 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088798 | root | 172.31.24.1:43584   | NULL            | Query   |   31275 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087538 | root | 172.31.24.1:44410   | NULL            | Query   |   40425 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091318 | root | 172.31.24.1:41510   | NULL            | Query   |   12975 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089638 | root | 172.31.24.1:42976   | NULL            | Query   |   25175 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092326 | root | 172.31.24.1:36936   | NULL            | Query   |    5655 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092536 | root | 172.31.24.1:55734   | NULL            | Query   |    4130 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087580 | root | 172.31.24.1:34072   | NULL            | Query   |   40120 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087790 | root | 172.31.24.1:37532   | NULL            | Query   |   38595 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091276 | root | 172.31.24.1:42320   | NULL            | Query   |   13280 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092284 | root | 172.31.24.1:55348   | NULL            | Query   |    5960 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089764 | root | 172.31.24.1:39298   | NULL            | Query   |   24260 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090688 | root | 172.31.24.1:43846   | NULL            | Query   |   17550 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091654 | root | 172.31.24.1:59918   | NULL            | Query   |   10535 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091738 | root | 172.31.24.1:45122   | NULL            | Query   |    9925 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090436 | root | 172.31.24.1:47378   | NULL            | Query   |   19380 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089680 | root | 172.31.24.1:33706   | NULL            | Query   |   24870 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091360 | root | 172.31.24.1:50418   | NULL            | Query   |   12670 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087916 | root | 172.31.24.1:40242   | NULL            | Query   |   37680 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089302 | root | 172.31.24.1:38420   | NULL            | Query   |   27615 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090562 | root | 172.31.24.1:36290   | NULL            | Query   |   18465 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089722 | root | 172.31.24.1:50156   | NULL            | Query   |   24565 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090184 | root | 172.31.24.1:43018   | NULL            | Query   |   21210 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090604 | root | 172.31.24.1:58994   | NULL            | Query   |   18160 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092620 | root | 172.31.24.1:53968   | NULL            | Query   |    3520 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089344 | root | 172.31.24.1:48644   | NULL            | Query   |   27310 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090058 | root | 172.31.24.1:44656   | NULL            | Query   |   22125 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091906 | root | 172.31.24.1:56690   | NULL            | Query   |    8705 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088546 | root | 172.31.24.1:44474   | NULL            | Query   |   33105 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089806 | root | 172.31.24.1:39596   | NULL            | Query   |   23955 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091612 | root | 172.31.24.1:48044   | NULL            | Query   |   10840 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092578 | root | 172.31.24.1:40646   | NULL            | Query   |    3825 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087412 | root | 172.31.24.1:47606   | NULL            | Query   |   41340 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090226 | root | 172.31.24.1:55032   | NULL            | Query   |   20905 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088252 | root | 172.31.24.1:40092   | NULL            | Query   |   35240 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089050 | root | 172.31.24.1:37060   | NULL            | Query   |   29445 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092914 | root | 172.31.24.1:43804   | NULL            | Query   |    1385 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089386 | root | 172.31.24.1:57802   | NULL            | Query   |   27005 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088672 | root | 172.31.24.1:56514   | NULL            | Query   |   32190 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091948 | root | 172.31.24.1:42628   | NULL            | Query   |    8400 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455093004 | root | 172.31.6.124:54460  | payment_service | Query   |       0 | autocommit                 | show processlist                                                                                     |
| 455090898 | root | 172.31.24.1:36742   | NULL            | Query   |   16025 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089008 | root | 172.31.24.1:56738   | NULL            | Query   |   29750 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092368 | root | 172.31.24.1:55104   | NULL            | Query   |    5350 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087622 | root | 172.31.24.1:47798   | NULL            | Query   |   39815 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087664 | root | 172.31.24.1:33730   | NULL            | Query   |   39510 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089134 | root | 172.31.24.1:57496   | NULL            | Query   |   28835 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089176 | root | 172.31.24.1:50510   | NULL            | Query   |   28530 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091150 | root | 172.31.24.1:39662   | NULL            | Query   |   14195 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091990 | root | 172.31.24.1:53540   | NULL            | Query   |    8095 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089428 | root | 172.31.24.1:57782   | NULL            | Query   |   26700 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087958 | root | 172.31.24.1:42028   | NULL            | Query   |   37375 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090940 | root | 172.31.24.1:59804   | NULL            | Query   |   15720 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090772 | root | 172.31.24.1:39816   | NULL            | Query   |   16940 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088168 | root | 172.31.24.1:42298   | NULL            | Query   |   35850 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090310 | root | 172.31.24.1:39982   | NULL            | Query   |   20295 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091444 | root | 172.31.24.1:51196   | NULL            | Query   |   12060 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090352 | root | 172.31.24.1:47488   | NULL            | Query   |   19990 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092494 | root | 172.31.24.1:45452   | NULL            | Query   |    4435 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088042 | root | 172.31.24.1:52280   | NULL            | Query   |   36765 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088588 | root | 172.31.24.1:36914   | NULL            | Query   |   32800 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089848 | root | 172.31.24.1:52716   | NULL            | Query   |   23650 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089554 | root | 172.31.24.1:42270   | NULL            | Query   |   25785 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091696 | root | 172.31.24.1:56026   | NULL            | Query   |   10230 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092452 | root | 172.31.24.1:37296   | NULL            | Query   |    4740 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089974 | root | 172.31.24.1:50738   | NULL            | Query   |   22735 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091402 | root | 172.31.24.1:49374   | NULL            | Query   |   12365 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089260 | root | 172.31.24.1:54278   | NULL            | Query   |   27920 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092242 | root | 172.31.24.1:33214   | NULL            | Query   |    6265 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088504 | root | 172.31.24.1:57512   | NULL            | Query   |   33410 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088630 | root | 172.31.24.1:47596   | NULL            | Query   |   32495 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092158 | root | 172.31.24.1:48482   | NULL            | Query   |    6875 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087874 | root | 172.31.24.1:45986   | NULL            | Query   |   37985 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092998 | root | 172.31.24.1:40112   | NULL            | Query   |     775 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091822 | root | 172.31.24.1:38934   | NULL            | Query   |    9315 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091486 | root | 172.31.24.1:59598   | NULL            | Query   |   11755 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087454 | root | 172.31.24.1:37390   | NULL            | Query   |   41035 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089890 | root | 172.31.24.1:48832   | NULL            | Query   |   23345 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088756 | root | 172.31.24.1:40746   | NULL            | Query   |   31580 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088336 | root | 172.31.24.1:54966   | NULL            | Query   |   34630 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087832 | root | 172.31.24.1:55668   | NULL            | Query   |   38290 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090814 | root | 172.31.24.1:46816   | NULL            | Query   |   16635 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090394 | root | 172.31.24.1:36454   | NULL            | Query   |   19685 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091528 | root | 172.31.24.1:51868   | NULL            | Query   |   11450 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092200 | root | 172.31.24.1:45458   | NULL            | Query   |    6570 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092788 | root | 172.31.24.1:49616   | NULL            | Query   |    2300 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088420 | root | 172.31.24.1:51034   | NULL            | Query   |   34020 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087706 | root | 172.31.24.1:42550   | NULL            | Query   |   39205 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092830 | root | 172.31.24.1:56066   | NULL            | Query   |    1995 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092956 | root | 172.31.24.1:40138   | NULL            | Query   |    1080 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090856 | root | 172.31.24.1:35548   | NULL            | Query   |   16330 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090730 | root | 172.31.24.1:33892   | NULL            | Query   |   17245 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455093084 | root | 172.31.24.1:56282   | NULL            | Query   |     165 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090100 | root | 172.31.24.1:50432   | NULL            | Query   |   21820 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091024 | root | 172.31.24.1:58134   | NULL            | Query   |   15110 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092704 | root | 172.31.24.1:48788   | NULL            | Query   |    2910 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088966 | root | 172.31.24.1:59836   | NULL            | Query   |   30055 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090142 | root | 172.31.24.1:33172   | NULL            | Query   |   21515 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090478 | root | 172.31.24.1:54830   | NULL            | Query   |   19075 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087496 | root | 172.31.24.1:50346   | NULL            | Query   |   40730 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089218 | root | 172.31.24.1:44742   | NULL            | Query   |   28225 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091108 | root | 172.31.24.1:34590   | NULL            | Query   |   14500 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091864 | root | 172.31.24.1:60730   | NULL            | Query   |    9010 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088924 | root | 172.31.24.1:34052   | NULL            | Query   |   30360 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089932 | root | 172.31.24.1:54066   | NULL            | Query   |   23040 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089512 | root | 172.31.24.1:60216   | NULL            | Query   |   26090 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090520 | root | 172.31.24.1:55272   | NULL            | Query   |   18770 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090268 | root | 172.31.24.1:55604   | NULL            | Query   |   20600 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088294 | root | 172.31.24.1:52812   | NULL            | Query   |   34935 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088378 | root | 172.31.24.1:34416   | NULL            | Query   |   34325 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455087748 | root | 172.31.24.1:43664   | NULL            | Query   |   38900 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088126 | root | 172.31.24.1:49646   | NULL            | Query   |   36155 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090982 | root | 172.31.24.1:57744   | NULL            | Query   |   15415 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092746 | root | 172.31.24.1:57900   | NULL            | Query   |    2605 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088462 | root | 172.31.24.1:59832   | NULL            | Query   |   33715 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092032 | root | 172.31.24.1:46578   | NULL            | Query   |    7790 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089596 | root | 172.31.24.1:41188   | NULL            | Query   |   25480 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455089092 | root | 172.31.24.1:36994   | NULL            | Query   |   29140 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455093042 | root | 172.31.24.1:32954   | NULL            | Query   |     470 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091570 | root | 172.31.24.1:42856   | NULL            | Query   |   11145 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455088000 | root | 172.31.24.1:35670   | NULL            | Query   |   37070 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455092116 | root | 172.31.24.1:41004   | NULL            | Query   |    7180 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091234 | root | 172.31.24.1:50500   | NULL            | Query   |   13585 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455091780 | root | 172.31.24.1:45754   | NULL            | Query   |    9620 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
| 455090016 | root | 172.31.24.1:56116   | NULL            | Query   |   22430 | in transaction; autocommit | ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount |
+-----------+------+---------------------+-----------------+---------+---------+----------------------------+------------------------------------------------------------------------------------------------------+```

The table size is zero.

```mysql> select count(*) from `payment_service`.`customer_refund_details`;
+----------+
| count(*) |
+----------+
|        0 |
+----------+```

When we cancel these DDL jobs, they never get cancelled and stays in the queue

```|  14528 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 17:16:07.334000 | NULL                       | NULL                       | queueing   |             |
|  14529 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 17:21:12.283000 | NULL                       | NULL                       | queueing   |             |
|  14530 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 17:26:17.283000 | NULL                       | NULL                       | queueing   |             |
|  14531 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 17:31:22.284000 | NULL                       | NULL                       | queueing   |             |
|  14532 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 17:36:27.284000 | NULL                       | NULL                       | queueing   |             |
|  14533 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 17:41:32.283000 | NULL                       | NULL                       | queueing   |             |
|  14534 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 17:46:37.283000 | NULL                       | NULL                       | queueing   |             |
|  14535 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 17:51:42.284000 | NULL                       | NULL                       | queueing   |             |
|  14536 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 17:56:47.283000 | NULL                       | NULL                       | queueing   |             |
|  14537 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:01:52.234000 | NULL                       | NULL                       | queueing   |             |
|  14538 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:06:57.283000 | NULL                       | NULL                       | queueing   |             |
|  14539 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:12:02.283000 | NULL                       | NULL                       | queueing   |             |
|  14540 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:17:07.283000 | NULL                       | NULL                       | queueing   |             |
|  14541 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:22:12.284000 | NULL                       | NULL                       | queueing   |             |
|  14542 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:27:17.284000 | NULL                       | NULL                       | queueing   |             |
|  14543 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:32:22.284000 | NULL                       | NULL                       | queueing   |             |
|  14544 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:37:27.283000 | NULL                       | NULL                       | queueing   |             |
|  14545 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:42:32.284000 | NULL                       | NULL                       | queueing   |             |
|  14546 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:47:37.284000 | NULL                       | NULL                       | queueing   |             |
|  14547 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:52:42.283000 | NULL                       | NULL                       | queueing   |             |
|  14548 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 18:57:47.283000 | NULL                       | NULL                       | queueing   |             |
|  14549 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:02:52.283000 | NULL                       | NULL                       | queueing   |             |
|  14550 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:07:57.283000 | NULL                       | NULL                       | queueing   |             |
|  14551 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:13:02.283000 | NULL                       | NULL                       | queueing   |             |
|  14552 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:18:07.284000 | NULL                       | NULL                       | queueing   |             |
|  14553 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:23:12.284000 | NULL                       | NULL                       | queueing   |             |
|  14554 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:28:17.283000 | NULL                       | NULL                       | queueing   |             |
|  14555 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:33:22.283000 | NULL                       | NULL                       | queueing   |             |
|  14556 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:38:27.284000 | NULL                       | NULL                       | queueing   |             |
|  14557 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:43:32.283000 | NULL                       | NULL                       | queueing   |             |
|  14558 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:48:37.284000 | NULL                       | NULL                       | queueing   |             |
|  14559 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:53:42.283000 | NULL                       | NULL                       | queueing   |             |
|  14560 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 19:58:47.283000 | NULL                       | NULL                       | queueing   |             |
|  14561 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:03:52.283000 | NULL                       | NULL                       | queueing   |             |
|  14562 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:08:57.233000 | NULL                       | NULL                       | queueing   |             |
|  14563 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:14:02.284000 | NULL                       | NULL                       | queueing   |             |
|  14564 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:19:07.234000 | NULL                       | NULL                       | queueing   |             |
|  14565 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:24:12.283000 | NULL                       | NULL                       | queueing   |             |
|  14566 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:29:17.284000 | NULL                       | NULL                       | queueing   |             |
|  14567 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:34:22.283000 | NULL                       | NULL                       | queueing   |             |
|  14568 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:39:27.284000 | NULL                       | NULL                       | queueing   |             |
|  14569 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:44:32.283000 | NULL                       | NULL                       | queueing   |             |
|  14570 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:49:37.284000 | NULL                       | NULL                       | queueing   |             |
|  14571 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:54:42.283000 | NULL                       | NULL                       | queueing   |             |
|  14572 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 20:59:47.283000 | NULL                       | NULL                       | queueing   |             |
|  14573 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:04:52.283000 | NULL                       | NULL                       | queueing   |             |
|  14574 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:09:57.233000 | NULL                       | NULL                       | queueing   |             |
|  14575 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:15:02.284000 | NULL                       | NULL                       | queueing   |             |
|  14576 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:20:07.283000 | NULL                       | NULL                       | queueing   |             |
|  14577 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:25:12.283000 | NULL                       | NULL                       | queueing   |             |
|  14578 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:30:17.284000 | NULL                       | NULL                       | queueing   |             |
|  14579 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:35:22.284000 | NULL                       | NULL                       | queueing   |             |
|  14580 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:40:27.233000 | NULL                       | NULL                       | queueing   |             |
|  14581 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:45:32.283000 | NULL                       | NULL                       | queueing   |             |
|  14582 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:50:37.283000 | NULL                       | NULL                       | queueing   |             |
|  14583 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 21:55:42.284000 | NULL                       | NULL                       | queueing   |             |
|  14584 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:00:47.283000 | NULL                       | NULL                       | queueing   |             |
|  14585 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:05:52.283000 | NULL                       | NULL                       | queueing   |             |
|  14586 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:10:57.283000 | NULL                       | NULL                       | queueing   |             |
|  14587 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:16:02.284000 | NULL                       | NULL                       | queueing   |             |
|  14588 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:21:07.283000 | NULL                       | NULL                       | queueing   |             |
|  14589 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:26:12.283000 | NULL                       | NULL                       | queueing   |             |
|  14590 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:31:17.283000 | NULL                       | NULL                       | queueing   |             |
|  14591 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:36:22.284000 | NULL                       | NULL                       | queueing   |             |
|  14592 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:41:27.283000 | NULL                       | NULL                       | queueing   |             |
|  14593 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:46:32.233000 | NULL                       | NULL                       | queueing   |             |
|  14594 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:51:37.284000 | NULL                       | NULL                       | queueing   |             |
|  14595 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 22:56:42.283000 | NULL                       | NULL                       | queueing   |             |
|  14596 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:01:47.283000 | NULL                       | NULL                       | queueing   |             |
|  14597 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:06:52.284000 | NULL                       | NULL                       | queueing   |             |
|  14598 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:11:57.283000 | NULL                       | NULL                       | queueing   |             |
|  14599 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:17:02.283000 | NULL                       | NULL                       | queueing   |             |
|  14600 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:22:07.283000 | NULL                       | NULL                       | queueing   |             |
|  14601 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:27:12.283000 | NULL                       | NULL                       | queueing   |             |
|  14602 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:32:17.284000 | NULL                       | NULL                       | queueing   |             |
|  14603 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:37:22.233000 | NULL                       | NULL                       | queueing   |             |
|  14604 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:42:27.283000 | NULL                       | NULL                       | queueing   |             |
|  14605 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:47:32.234000 | NULL                       | NULL                       | queueing   |             |
|  14606 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:52:37.283000 | NULL                       | NULL                       | queueing   |             |
|  14607 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-01 23:57:42.284000 | NULL                       | NULL                       | queueing   |             |
|  14608 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:02:47.284000 | NULL                       | NULL                       | queueing   |             |
|  14609 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:07:52.283000 | NULL                       | NULL                       | queueing   |             |
|  14610 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:12:57.283000 | NULL                       | NULL                       | queueing   |             |
|  14611 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:18:02.283000 | NULL                       | NULL                       | queueing   |             |
|  14612 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:23:07.283000 | NULL                       | NULL                       | queueing   |             |
|  14613 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:28:12.233000 | NULL                       | NULL                       | queueing   |             |
|  14614 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:33:17.284000 | NULL                       | NULL                       | queueing   |             |
|  14615 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:38:22.284000 | NULL                       | NULL                       | queueing   |             |
|  14616 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:43:27.283000 | NULL                       | NULL                       | queueing   |             |
|  14617 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:48:32.283000 | NULL                       | NULL                       | queueing   |             |
|  14618 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:53:37.283000 | NULL                       | NULL                       | queueing   |             |
|  14619 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 00:58:42.284000 | NULL                       | NULL                       | queueing   |             |
|  14620 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:03:47.283000 | NULL                       | NULL                       | queueing   |             |
|  14621 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:08:52.283000 | NULL                       | NULL                       | queueing   |             |
|  14622 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:13:57.284000 | NULL                       | NULL                       | queueing   |             |
|  14623 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:19:02.284000 | NULL                       | NULL                       | queueing   |             |
|  14624 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:24:07.283000 | NULL                       | NULL                       | queueing   |             |
|  14625 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:29:12.283000 | NULL                       | NULL                       | queueing   |             |
|  14626 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:34:17.283000 | NULL                       | NULL                       | queueing   |             |
|  14627 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:39:22.284000 | NULL                       | NULL                       | queueing   |             |
|  14628 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:44:27.284000 | NULL                       | NULL                       | queueing   |             |
|  14629 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:49:32.284000 | NULL                       | NULL                       | queueing   |             |
|  14630 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:54:37.283000 | NULL                       | NULL                       | queueing   |             |
|  14631 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 01:59:42.283000 | NULL                       | NULL                       | queueing   |             |
|  14632 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:04:47.284000 | NULL                       | NULL                       | queueing   |             |
|  14633 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:09:52.284000 | NULL                       | NULL                       | queueing   |             |
|  14634 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:14:57.284000 | NULL                       | NULL                       | queueing   |             |
|  14635 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:20:02.284000 | NULL                       | NULL                       | queueing   |             |
|  14636 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:25:07.284000 | NULL                       | NULL                       | queueing   |             |
|  14637 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:30:12.283000 | NULL                       | NULL                       | queueing   |             |
|  14638 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:35:17.233000 | NULL                       | NULL                       | queueing   |             |
|  14639 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:40:22.283000 | NULL                       | NULL                       | queueing   |             |
|  14640 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:45:27.283000 | NULL                       | NULL                       | queueing   |             |
|  14641 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:50:32.283000 | NULL                       | NULL                       | queueing   |             |
|  14642 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 02:55:37.283000 | NULL                       | NULL                       | queueing   |             |
|  14643 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 03:00:42.283000 | NULL                       | NULL                       | queueing   |             |
|  14644 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 03:05:47.283000 | NULL                       | NULL                       | queueing   |             |
|  14645 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 03:10:52.234000 | NULL                       | NULL                       | queueing   |             |
|  14646 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 03:15:57.284000 | NULL                       | NULL                       | queueing   |             |
|  14647 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 03:21:02.283000 | NULL                       | NULL                       | queueing   |             |
|  14648 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 03:26:07.233000 | NULL                       | NULL                       | queueing   |             |
|  14649 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 03:31:12.284000 | NULL                       | NULL                       | queueing   |             |
|  14650 | payment_service      | customer_refund_details                 | modify column                 | none         |      9514 |    14499 |         0 | 2025-04-02 03:36:17.284000 | NULL                       | NULL                       | queueing   |             |

1. Minimal reproduce step (Required)

we are seeing this issue for the 3rd time, with the same cluster

2. What did you expect to see? (Required)

We expect the alter to be executed once and proceed with the replication

3. What did you see instead (Required)

multiple execution of same alter and making it lag and stall the cluster

4. What is your version? (Required)

we use cluster version as 8.5.1 and DM cluster version as 8.5.1
@kabileshKabi kabileshKabi added the type/bug The issue is confirmed as a bug. label Apr 2, 2025
@kabileshKabi
Copy link
Author

Another observation is when i check the DDL job queue, The DDL is being run by the DM for every 5 mins almost

here is the jobs creation time

 2025-04-02 04:52:32.284000
 2025-04-02 04:59:18.684000
 2025-04-02 05:12:42.333000
 2025-04-02 05:17:47.283000
 2025-04-02 05:22:52.233000
 2025-04-02 05:27:57.283000
 2025-04-02 05:33:02.284000
 2025-04-02 05:38:07.283000
 2025-04-02 05:43:12.283000
 2025-04-02 05:48:17.283000
 2025-04-02 05:53:22.284000
 2025-04-02 05:58:27.283000
 2025-04-02 06:03:32.284000
 2025-04-02 06:08:37.283000
 2025-04-02 06:13:42.284000
 2025-04-02 06:18:47.283000```

@lance6716
Copy link
Contributor

DM should be able to find a DDL is queuing. It will only retry executing DDL after it does not found the DDL is queuing. Can you provide DM worker log for us to locate the problem?

also cc @OliverS929

@kabileshKabi
Copy link
Author 

[2025/04/01 17:21:07.337 +00:00] [ERROR] [baseconn.go:206] ["execute statement failed"] [task=easy_new_migration] [unit="binlog replication"] [query="ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund'"] [argument="[]"] [error="invalid connection"]
[2025/04/01 17:21:07.337 +00:00] [ERROR] [baseconn.go:213] ["rollback failed"] [task=easy_new_migration] [unit="binlog replication"] [query="ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund'"] [argument="[]"] [error="invalid connection"]
[2025/04/01 17:21:07.337 +00:00] [ERROR] [db.go:204] ["execute statements failed after retry"] [task=easy_new_migration] [unit="binlog replication"] [queries="[SET TIMESTAMP = 1743527767 SET SESSION TIME_ZONE = '+00:00' ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund' SET SESSION TIME_ZONE = DEFAULT SET TIMESTAMP = DEFAULT]"] [arguments="[]"] [error="[code=10006:class=database:scope=not-set:level=high], Message: execute statement failed: ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund', RawCause: invalid connection"]
[2025/04/01 17:21:07.337 +00:00] [ERROR] [baseconn.go:124] ["query statement failed"] [task=easy_new_migration] [unit="binlog replication"] [query="ADMIN SHOW DDL JOBS 10"] [argument="[]"] [error="driver: bad connection"]
[2025/04/01 17:21:07.337 +00:00] [WARN] [db.go:303] ["failed to close BaseConn in reset"] [task=easy_new_migration] [unit="binlog replication"]
[2025/04/01 17:21:07.341 +00:00] [WARN] [db.go:253] ["execute sql failed by connection error"] [task=easy_new_migration] [unit="binlog replication"] [retry=0] []
[2025/04/01 17:21:07.341 +00:00] [WARN] [strategy.go:94] ["retry strategy takes effect"] [error="[code=10005:class=database:scope=not-set:level=high], Message: query statement failed: ADMIN SHOW DDL JOBS 10, RawCause: driver: bad connection"] [errorVerbose="[code=10005:class=database:scope=not-set:level=high], Message: query statement failed: ADMIN SHOW DDL JOBS 10, RawCause: driver: bad connection\ngithub.com/pingcap/tiflow/dm/pkg/terror.(*Error).Delegate\n\tgithub.com/pingcap/tiflow/dm/pkg/terror/terror.go:337\ngithub.com/pingcap/tiflow/dm/pkg/conn.(*BaseConn).QuerySQL\n\tgithub.com/pingcap/tiflow/dm/pkg/conn/baseconn.go:128\ngithub.com/pingcap/tiflow/dm/syncer/dbconn.(*DBConn).QuerySQL.func1\n\tgithub.com/pingcap/tiflow/dm/syncer/dbconn/db.go:109\ngithub.com/pingcap/tiflow/dm/pkg/retry.(*FiniteRetryStrategy).Apply\n\tgithub.com/pingcap/tiflow/dm/pkg/retry/strategy.go:84\ngithub.com/pingcap/tiflow/dm/pkg/conn.(*BaseConn).ApplyRetryStrategy\n\tgithub.com/pingcap/tiflow/dm/pkg/conn/baseconn.go:275\ngithub.com/pingcap/tiflow/dm/syncer/dbconn.(*DBConn).QuerySQL\n\tgithub.com/pingcap/tiflow/dm/syncer/dbconn/db.go:104\ngithub.com/pingcap/tiflow/dm/syncer.getDDLStatusFromTiDB\n\tgithub.com/pingcap/tiflow/dm/syncer/util.go:246\ngithub.com/pingcap/tiflow/dm/syncer.(*Syncer).handleSpecialDDLError.func3\n\tgithub.com/pingcap/tiflow/dm/syncer/error.go:232\ngithub.com/pingcap/tiflow/dm/syncer.(*Syncer).handleSpecialDDLError\n\tgithub.com/pingcap/tiflow/dm/syncer/error.go:265\ngithub.com/pingcap/tiflow/dm/syncer.(*Syncer).syncDDL\n\tgithub.com/pingcap/tiflow/dm/syncer/syncer.go:1512\nruntime.goexit\n\truntime/asm_arm64.s:1223"] [retry_times=0] [retry_count=10]
[2025/04/01 17:21:10.480 +00:00] [WARN] [error.go:247] ["Unexpected DDL status"] [task=easy_new_migration] [unit="binlog replication"] ["DDL status"=]
[2025/04/01 17:21:10.480 +00:00] [INFO] [syncer.go:3212] ["flush all jobs"] [task=easy_new_migration] [unit="binlog replication"] ["global checkpoint"="location(position: (mysql-bin-changelog.015533, 7025163), gtid-set: 00000000-0000-0000-0000-000000000000:0) (flushed location(position: (mysql-bin-changelog.015533, 7025163), gtid-set: 00000000-0000-0000-0000-000000000000:0))"] ["flush job seq"=111]
[2025/04/01 17:21:10.480 +00:00] [INFO] [syncer.go:1640] ["received subtask's done, try graceful stop"] [task=easy_new_migration] [unit="binlog replication"]
[2025/04/01 17:21:10.481 +00:00] [WARN] [syncer.go:1280] ["error detected when executing SQL job, skip sync flush checkpoints"] [task=easy_new_migration] [unit="binlog replication"] [checkpoint="location(position: (mysql-bin-changelog.015533, 7025163), gtid-set: 00000000-0000-0000-0000-000000000000:0) (flushed location(position: (mysql-bin-changelog.015533, 7025163), gtid-set: 00000000-0000-0000-0000-000000000000:0))"] [error="[code=10006:class=database:scope=downstream:level=high], Message: startLocation: [position: (mysql-bin-changelog.015533, 7025242), gtid-set: 00000000-0000-0000-0000-000000000000:0], endLocation: [position: (mysql-bin-changelog.015533, 7025492), gtid-set: 00000000-0000-0000-0000-000000000000:0], origin SQL: [ALTER TABLE `customer_refund_details` CHANGE `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund']: execute statement failed: ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund', RawCause: invalid connection"] [errorVerbose="[code=10006:class=database:scope=downstream:level=high], Message: startLocation: [position: (mysql-bin-changelog.015533, 7025242), gtid-set: 00000000-0000-0000-0000-000000000000:0], endLocation: [position: (mysql-bin-changelog.015533, 7025492), gtid-set: 00000000-0000-0000-0000-000000000000:0], origin SQL: [ALTER TABLE `customer_refund_details` CHANGE `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund']: execute statement failed: ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund', RawCause: invalid connection\ngithub.com/pingcap/tiflow/dm/pkg/terror.(*Error).Delegate\n\tgithub.com/pingcap/tiflow/dm/pkg/terror/terror.go:337\ngithub.com/pingcap/tiflow/dm/pkg/conn.(*BaseConn).ExecuteSQLWithIgnoreError\n\tgithub.com/pingcap/tiflow/dm/pkg/conn/baseconn.go:221\ngithub.com/pingcap/tiflow/dm/syncer/dbconn.(*DBConn).ExecuteSQLWithIgnore.func2\n\tgithub.com/pingcap/tiflow/dm/syncer/dbconn/db.go:181\ngithub.com/pingcap/tiflow/dm/pkg/retry.(*FiniteRetryStrategy).Apply\n\tgithub.com/pingcap/tiflow/dm/pkg/retry/strategy.go:84\ngithub.com/pingcap/tiflow/dm/pkg/conn.(*BaseConn).ApplyRetryStrategy\n\tgithub.com/pingcap/tiflow/dm/pkg/conn/baseconn.go:275\ngithub.com/pingcap/tiflow/dm/syncer/dbconn.(*DBConn).ExecuteSQLWithIgnore\n\tgithub.com/pingcap/tiflow/dm/syncer/dbconn/db.go:172\ngithub.com/pingcap/tiflow/dm/syncer.(*Syncer).syncDDL\n\tgithub.com/pingcap/tiflow/dm/syncer/syncer.go:1503\nruntime.goexit\n\truntime/asm_arm64.s:1223"]
[2025/04/01 17:21:10.481 +00:00] [ERROR] [ddl.go:454] ["error detected when executing SQL job"] [task=easy_new_migration] [unit="binlog replication"] [component=ddl] [mode=normal] [error="[code=10006:class=database:scope=downstream:level=high], Message: startLocation: [position: (mysql-bin-changelog.015533, 7025242), gtid-set: 00000000-0000-0000-0000-000000000000:0], endLocation: [position: (mysql-bin-changelog.015533, 7025492), gtid-set: 00000000-0000-0000-0000-000000000000:0], origin SQL: [ALTER TABLE `customer_refund_details` CHANGE `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund']: execute statement failed: ALTER TABLE `payment_service`.`customer_refund_details` CHANGE COLUMN `refund_amount` `refund_amount` DECIMAL(10,3) NOT NULL COMMENT 'Indicates the amount to refund', RawCause: invalid connection"]```

@lance6716
Copy link
Contributor

I see that because

[2025/04/01 17:21:07.337 +00:00] [ERROR] [baseconn.go:124] ["query statement failed"] [task=easy_new_migration] [unit="binlog replication"] [query="ADMIN SHOW DDL JOBS 10"] [argument="[]"] [error="driver: bad connection"]

DM failed to check if DDL is queuing, so it retried again and again. PTAL @OliverS929

@kabileshKabi
Copy link
Author

But the TiDB server is active, and its connecting

@kabileshKabi
Copy link
Author

Inside TIDB DDL queue lot of jobs struck in cancelling state for more than day and some even weeks

@kabileshKabi
Copy link
Author

kabileshKabi commented Apr 2, 2025 •
edited
Loading

we to recover we had to cancel the DDL and they got struck in cancelling state

|  13184 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 17:56:37.234000 | NULL                       | NULL                       | cancelling |             |
|  13185 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:01:42.234000 | NULL                       | NULL                       | cancelling |             |
|  13186 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:06:47.233000 | NULL                       | NULL                       | cancelling |             |
|  13187 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:11:52.284000 | NULL                       | NULL                       | cancelling |             |
|  13188 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:16:57.233000 | NULL                       | NULL                       | cancelling |             |
|  13189 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:22:02.283000 | NULL                       | NULL                       | cancelling |             |
|  13190 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:27:07.283000 | NULL                       | NULL                       | cancelling |             |
|  13191 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:32:12.234000 | NULL                       | NULL                       | cancelling |             |
|  13192 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:37:17.283000 | NULL                       | NULL                       | cancelling |             |
|  13193 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:42:22.234000 | NULL                       | NULL                       | cancelling |             |
|  13194 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:47:27.234000 | NULL                       | NULL                       | cancelling |             |
|  13195 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:52:32.233000 | NULL                       | NULL                       | cancelling |             |
|  13196 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 18:57:37.233000 | NULL                       | NULL                       | cancelling |             |
|  13197 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:02:42.234000 | NULL                       | NULL                       | cancelling |             |
|  13198 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:07:47.284000 | NULL                       | NULL                       | cancelling |             |
|  13199 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:12:52.283000 | NULL                       | NULL                       | cancelling |             |
|  13200 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:17:57.233000 | NULL                       | NULL                       | cancelling |             |
|  13201 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:23:02.234000 | NULL                       | NULL                       | cancelling |             |
|  13202 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:28:07.283000 | NULL                       | NULL                       | cancelling |             |
|  13203 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:33:12.284000 | NULL                       | NULL                       | cancelling |             |
|  13204 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:38:17.233000 | NULL                       | NULL                       | cancelling |             |
|  13205 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:43:22.234000 | NULL                       | NULL                       | cancelling |             |
|  13206 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:48:27.233000 | NULL                       | NULL                       | cancelling |             |
|  13207 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:53:32.234000 | NULL                       | NULL                       | cancelling |             |
|  13208 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 19:58:37.284000 | NULL                       | NULL                       | cancelling |             |
|  13209 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 20:03:42.233000 | NULL                       | NULL                       | cancelling |             |
|  13210 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 20:08:47.234000 | NULL                       | NULL                       | cancelling |             |
|  13211 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 20:13:52.233000 | NULL                       | NULL                       | cancelling |             |
|  13212 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 20:18:57.234000 | NULL                       | NULL                       | cancelling |             |
|  13213 | loan_service         | easy_m_loan_charge             | add index     | none         |      9360 |    10155 |         0 | 2025-03-12 20:24:02.283000 | NULL                       | NULL                       | cancelling |             |
|  13214 | loan_service         | easy_m

1549 rows in set, 1 warning (0.09 sec)```

is there any way to clean them up, i have tried restarting all the TIDB nodes, it didnot help

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@lance6716 @kabileshKabi