pingcap / pingcap/tidb

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

Open
#60,362 8 comments 0 reactions 0 assignees View on GitHub
component/ddl type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR metrics pending

Description

## 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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.