search

github / gh-ost

GitHub's Online Schema-migration Tool for MySQL
MIT License
12.31k stars 1.25k forks source link

When will the throttled state be triggered #1389

Open suyestyle opened 6 months ago

suyestyle commented 6 months ago

I have a problem now, gh-ost has been "State: throttled, flag-file; ETA: due"

This MySQL is a test environment that no other process accesses except go-ost。This table is also an empty table。

Now in this state for a long time can not complete the operation，how should I troubleshoot this problem。

# ./bin/gh-ost --version
1.1.5
# ./bin/gh-ost --host=xxxx --port=xxxx --user=xxxxxx --password=xxxxxx --database=alterdb_ghost --table=t1 --alter= add uid bigint not null comment '' after `id`;  --replica-server-id=573047282 --serve-socket-file=/opt/logs/mark/f9434462eeff9c2c98d019d9cf51dda8_socket_21651 --panic-flag-file=/opt/logs/mark/c6f22a9c8c5f9a31dc5828ef432bcadb_pause_21651 --allow-on-master --max-load Threads_running=64,Threads_connected=4000 --chunk-size=3000 --max-lag-millis=30000 --cut-over-lock-timeout-seconds=30 --execute --ok-to-drop-table

I can be sure that "Threads_running" and "Threads_connected" will not exceed the set value

|   1 | 2024-03-11 17:35:07 | heartbeat                       | 2024-03-11T17:35:07.346980213+08:00                                                                                                                                                     |
|   2 | 2024-03-11 17:29:46 | state                           | ReadMigrationRangeValues                                                                                                                                                                |
|   3 | 2024-03-11 17:29:46 | throttle                        | flag-file                                                                                                                                                                               |
| 256 | 2024-03-11 17:29:46 | state at 1710149386135787399    | GhostTableMigrated                                                                                                                                                                      |
| 257 | 2024-03-11 17:29:46 | state at 1710149386198027182    | ReadMigrationRangeValues                                                                                                                                                                |
| 258 | 2024-03-11 17:29:46 | throttle at 1710149386222401871 | flag-file                                                                                                                                                                               |
| 259 | 2024-03-11 17:29:46 | copy iteration 0 at 1710149386  | Copy: 0/1 0.0%; Applied: 0; Backlog: 0/1000; Time: 0s(total), 0s(copy); streamer: mysql-bin.000030:3878681; Lag: 0.08s, HeartbeatLag: 0.08s, State: migrating; ETA: N/A                 |
| 261 | 2024-03-11 17:29:47 | copy iteration 0 at 1710149387  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1s(total), 0s(copy); streamer: mysql-bin.000030:3885633; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due    |
| 262 | 2024-03-11 17:29:48 | copy iteration 0 at 1710149388  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2s(total), 0s(copy); streamer: mysql-bin.000030:3891007; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due    |
| 263 | 2024-03-11 17:29:49 | copy iteration 0 at 1710149389  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 3s(total), 0s(copy); streamer: mysql-bin.000030:3896379; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due    |
| 264 | 2024-03-11 17:29:50 | copy iteration 0 at 1710149390  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 4s(total), 0s(copy); streamer: mysql-bin.000030:3901751; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due    |
| 265 | 2024-03-11 17:29:51 | copy iteration 0 at 1710149391  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 5s(total), 0s(copy); streamer: mysql-bin.000030:3907125; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due    |
| 266 | 2024-03-11 17:29:52 | copy iteration 0 at 1710149392  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 6s(total), 0s(copy); streamer: mysql-bin.000030:3912497; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due    |
| 267 | 2024-03-11 17:29:53 | copy iteration 0 at 1710149393  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 7s(total), 0s(copy); streamer: mysql-bin.000030:3917871; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due    |
| 268 | 2024-03-11 17:29:54 | copy iteration 0 at 1710149394  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 8s(total), 0s(copy); streamer: mysql-bin.000030:3923241; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due    |
| 269 | 2024-03-11 17:29:55 | copy iteration 0 at 1710149395  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 9s(total), 0s(copy); streamer: mysql-bin.000030:3928607; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due    |
| 270 | 2024-03-11 17:29:56 | copy iteration 0 at 1710149396  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 10s(total), 0s(copy); streamer: mysql-bin.000030:3933981; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 271 | 2024-03-11 17:29:57 | copy iteration 0 at 1710149397  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 11s(total), 0s(copy); streamer: mysql-bin.000030:3939356; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 272 | 2024-03-11 17:29:58 | copy iteration 0 at 1710149398  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 12s(total), 0s(copy); streamer: mysql-bin.000030:3944727; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 273 | 2024-03-11 17:29:59 | copy iteration 0 at 1710149399  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 13s(total), 0s(copy); streamer: mysql-bin.000030:3950100; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 274 | 2024-03-11 17:30:00 | copy iteration 0 at 1710149400  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 14s(total), 0s(copy); streamer: mysql-bin.000030:3955475; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 275 | 2024-03-11 17:30:01 | copy iteration 0 at 1710149401  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 15s(total), 0s(copy); streamer: mysql-bin.000030:3960844; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 276 | 2024-03-11 17:30:02 | copy iteration 0 at 1710149402  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 16s(total), 0s(copy); streamer: mysql-bin.000030:3966215; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 277 | 2024-03-11 17:30:03 | copy iteration 0 at 1710149403  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 17s(total), 0s(copy); streamer: mysql-bin.000030:3971584; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 278 | 2024-03-11 17:30:04 | copy iteration 0 at 1710149404  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 18s(total), 0s(copy); streamer: mysql-bin.000030:3976952; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 279 | 2024-03-11 17:30:05 | copy iteration 0 at 1710149405  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 19s(total), 0s(copy); streamer: mysql-bin.000030:3982322; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 280 | 2024-03-11 17:30:06 | copy iteration 0 at 1710149406  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 20s(total), 0s(copy); streamer: mysql-bin.000030:3987697; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 281 | 2024-03-11 17:30:07 | copy iteration 0 at 1710149407  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 21s(total), 0s(copy); streamer: mysql-bin.000030:3993072; Lag: 0.09s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 282 | 2024-03-11 17:30:08 | copy iteration 0 at 1710149408  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 22s(total), 0s(copy); streamer: mysql-bin.000030:3998447; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 283 | 2024-03-11 17:30:09 | copy iteration 0 at 1710149409  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 23s(total), 0s(copy); streamer: mysql-bin.000030:4003820; Lag: 0.10s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 284 | 2024-03-11 17:30:10 | copy iteration 0 at 1710149410  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 24s(total), 0s(copy); streamer: mysql-bin.000030:4009191; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 285 | 2024-03-11 17:30:11 | copy iteration 0 at 1710149411  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 25s(total), 0s(copy); streamer: mysql-bin.000030:4014564; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 286 | 2024-03-11 17:30:12 | copy iteration 0 at 1710149412  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 26s(total), 0s(copy); streamer: mysql-bin.000030:4019935; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 287 | 2024-03-11 17:30:13 | copy iteration 0 at 1710149413  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 27s(total), 0s(copy); streamer: mysql-bin.000030:4025309; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 288 | 2024-03-11 17:30:14 | copy iteration 0 at 1710149414  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 28s(total), 0s(copy); streamer: mysql-bin.000030:4030679; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 289 | 2024-03-11 17:30:15 | copy iteration 0 at 1710149415  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 29s(total), 0s(copy); streamer: mysql-bin.000030:4036050; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 290 | 2024-03-11 17:30:16 | copy iteration 0 at 1710149416  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 30s(total), 0s(copy); streamer: mysql-bin.000030:4041424; Lag: 0.07s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 291 | 2024-03-11 17:30:17 | copy iteration 0 at 1710149417  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 31s(total), 0s(copy); streamer: mysql-bin.000030:4046796; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 292 | 2024-03-11 17:30:18 | copy iteration 0 at 1710149418  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 32s(total), 0s(copy); streamer: mysql-bin.000030:4052169; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 293 | 2024-03-11 17:30:19 | copy iteration 0 at 1710149419  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 33s(total), 0s(copy); streamer: mysql-bin.000030:4057544; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 294 | 2024-03-11 17:30:20 | copy iteration 0 at 1710149420  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 34s(total), 0s(copy); streamer: mysql-bin.000030:4062919; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 295 | 2024-03-11 17:30:21 | copy iteration 0 at 1710149421  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 35s(total), 0s(copy); streamer: mysql-bin.000030:4068294; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 296 | 2024-03-11 17:30:22 | copy iteration 0 at 1710149422  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 36s(total), 0s(copy); streamer: mysql-bin.000030:4073667; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 297 | 2024-03-11 17:30:23 | copy iteration 0 at 1710149423  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 37s(total), 0s(copy); streamer: mysql-bin.000030:4079039; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 298 | 2024-03-11 17:30:24 | copy iteration 0 at 1710149424  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 38s(total), 0s(copy); streamer: mysql-bin.000030:4084413; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 299 | 2024-03-11 17:30:25 | copy iteration 0 at 1710149425  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 39s(total), 0s(copy); streamer: mysql-bin.000030:4089787; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 300 | 2024-03-11 17:30:26 | copy iteration 0 at 1710149426  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 40s(total), 0s(copy); streamer: mysql-bin.000030:4095159; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 301 | 2024-03-11 17:30:27 | copy iteration 0 at 1710149427  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 41s(total), 0s(copy); streamer: mysql-bin.000030:4100534; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 302 | 2024-03-11 17:30:28 | copy iteration 0 at 1710149428  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 42s(total), 0s(copy); streamer: mysql-bin.000030:4105909; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 303 | 2024-03-11 17:30:29 | copy iteration 0 at 1710149429  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 43s(total), 0s(copy); streamer: mysql-bin.000030:4111280; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 304 | 2024-03-11 17:30:30 | copy iteration 0 at 1710149430  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 44s(total), 0s(copy); streamer: mysql-bin.000030:4116653; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 305 | 2024-03-11 17:30:31 | copy iteration 0 at 1710149431  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 45s(total), 0s(copy); streamer: mysql-bin.000030:4122025; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 306 | 2024-03-11 17:30:32 | copy iteration 0 at 1710149432  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 46s(total), 0s(copy); streamer: mysql-bin.000030:4127395; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 307 | 2024-03-11 17:30:33 | copy iteration 0 at 1710149433  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 47s(total), 0s(copy); streamer: mysql-bin.000030:4132766; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 308 | 2024-03-11 17:30:34 | copy iteration 0 at 1710149434  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 48s(total), 0s(copy); streamer: mysql-bin.000030:4138141; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 309 | 2024-03-11 17:30:35 | copy iteration 0 at 1710149435  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 49s(total), 0s(copy); streamer: mysql-bin.000030:4143512; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 310 | 2024-03-11 17:30:36 | copy iteration 0 at 1710149436  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 50s(total), 0s(copy); streamer: mysql-bin.000030:4148881; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 311 | 2024-03-11 17:30:37 | copy iteration 0 at 1710149437  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 51s(total), 0s(copy); streamer: mysql-bin.000030:4154253; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 312 | 2024-03-11 17:30:38 | copy iteration 0 at 1710149438  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 52s(total), 0s(copy); streamer: mysql-bin.000030:4159627; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 313 | 2024-03-11 17:30:39 | copy iteration 0 at 1710149439  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 53s(total), 0s(copy); streamer: mysql-bin.000030:4164998; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 314 | 2024-03-11 17:30:40 | copy iteration 0 at 1710149440  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 54s(total), 0s(copy); streamer: mysql-bin.000030:4170373; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 315 | 2024-03-11 17:30:41 | copy iteration 0 at 1710149441  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 55s(total), 0s(copy); streamer: mysql-bin.000030:4175742; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 316 | 2024-03-11 17:30:42 | copy iteration 0 at 1710149442  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 56s(total), 0s(copy); streamer: mysql-bin.000030:4181111; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 317 | 2024-03-11 17:30:43 | copy iteration 0 at 1710149443  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 57s(total), 0s(copy); streamer: mysql-bin.000030:4186484; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 318 | 2024-03-11 17:30:44 | copy iteration 0 at 1710149444  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 58s(total), 0s(copy); streamer: mysql-bin.000030:4191859; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 319 | 2024-03-11 17:30:45 | copy iteration 0 at 1710149445  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 59s(total), 0s(copy); streamer: mysql-bin.000030:4197232; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due   |
| 320 | 2024-03-11 17:30:46 | copy iteration 0 at 1710149446  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m0s(total), 0s(copy); streamer: mysql-bin.000030:4202605; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due  |
| 321 | 2024-03-11 17:30:51 | copy iteration 0 at 1710149451  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m5s(total), 0s(copy); streamer: mysql-bin.000030:4227129; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due  |
| 322 | 2024-03-11 17:30:56 | copy iteration 0 at 1710149456  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m10s(total), 0s(copy); streamer: mysql-bin.000030:4251649; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 323 | 2024-03-11 17:31:01 | copy iteration 0 at 1710149461  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m15s(total), 0s(copy); streamer: mysql-bin.000030:4276176; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 324 | 2024-03-11 17:31:06 | copy iteration 0 at 1710149466  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m20s(total), 0s(copy); streamer: mysql-bin.000030:4300699; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 325 | 2024-03-11 17:31:11 | copy iteration 0 at 1710149471  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m25s(total), 0s(copy); streamer: mysql-bin.000030:4325232; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 326 | 2024-03-11 17:31:16 | copy iteration 0 at 1710149476  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m30s(total), 0s(copy); streamer: mysql-bin.000030:4349761; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 327 | 2024-03-11 17:31:21 | copy iteration 0 at 1710149481  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m35s(total), 0s(copy); streamer: mysql-bin.000030:4374284; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 328 | 2024-03-11 17:31:26 | copy iteration 0 at 1710149486  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m40s(total), 0s(copy); streamer: mysql-bin.000030:4398811; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 329 | 2024-03-11 17:31:31 | copy iteration 0 at 1710149491  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m45s(total), 0s(copy); streamer: mysql-bin.000030:4423342; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 330 | 2024-03-11 17:31:36 | copy iteration 0 at 1710149496  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m50s(total), 0s(copy); streamer: mysql-bin.000030:4447867; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 331 | 2024-03-11 17:31:41 | copy iteration 0 at 1710149501  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 1m55s(total), 0s(copy); streamer: mysql-bin.000030:4472402; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 332 | 2024-03-11 17:31:46 | copy iteration 0 at 1710149506  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m0s(total), 0s(copy); streamer: mysql-bin.000030:4496927; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due  |
| 333 | 2024-03-11 17:31:51 | copy iteration 0 at 1710149511  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m5s(total), 0s(copy); streamer: mysql-bin.000030:4521453; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due  |
| 334 | 2024-03-11 17:31:56 | copy iteration 0 at 1710149516  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m10s(total), 0s(copy); streamer: mysql-bin.000030:4545981; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 335 | 2024-03-11 17:32:01 | copy iteration 0 at 1710149521  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m15s(total), 0s(copy); streamer: mysql-bin.000030:4570504; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 336 | 2024-03-11 17:32:06 | copy iteration 0 at 1710149526  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m20s(total), 0s(copy); streamer: mysql-bin.000030:4595031; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 337 | 2024-03-11 17:32:11 | copy iteration 0 at 1710149531  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m25s(total), 0s(copy); streamer: mysql-bin.000030:4619566; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 338 | 2024-03-11 17:32:16 | copy iteration 0 at 1710149536  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m30s(total), 0s(copy); streamer: mysql-bin.000030:4644088; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 339 | 2024-03-11 17:32:21 | copy iteration 0 at 1710149541  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m35s(total), 0s(copy); streamer: mysql-bin.000030:4668612; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 340 | 2024-03-11 17:32:26 | copy iteration 0 at 1710149546  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m40s(total), 0s(copy); streamer: mysql-bin.000030:4693145; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 341 | 2024-03-11 17:32:31 | copy iteration 0 at 1710149551  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m45s(total), 0s(copy); streamer: mysql-bin.000030:4717672; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 342 | 2024-03-11 17:32:36 | copy iteration 0 at 1710149556  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m50s(total), 0s(copy); streamer: mysql-bin.000030:4742205; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 343 | 2024-03-11 17:32:41 | copy iteration 0 at 1710149561  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 2m55s(total), 0s(copy); streamer: mysql-bin.000030:4766720; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 344 | 2024-03-11 17:32:46 | copy iteration 0 at 1710149566  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 3m0s(total), 0s(copy); streamer: mysql-bin.000030:4791243; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due  |
| 345 | 2024-03-11 17:33:16 | copy iteration 0 at 1710149596  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 3m30s(total), 0s(copy); streamer: mysql-bin.000030:4935424; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 346 | 2024-03-11 17:33:46 | copy iteration 0 at 1710149626  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 4m0s(total), 0s(copy); streamer: mysql-bin.000030:5079634; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due  |
| 347 | 2024-03-11 17:34:16 | copy iteration 0 at 1710149656  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 4m30s(total), 0s(copy); streamer: mysql-bin.000030:5223842; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due |
| 348 | 2024-03-11 17:34:46 | copy iteration 0 at 1710149686  | Copy: 0/0 100.0%; Applied: 0; Backlog: 0/1000; Time: 5m0s(total), 0s(copy); streamer: mysql-bin.000030:5368063; Lag: 0.08s, HeartbeatLag: 0.10s, State: throttled, flag-file; ETA: due  |
+-----+---------------------+---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
timvaillancourt commented 6 months ago

@suyestyle this sounds like a bug

Can you provide the logfile (redacted if you want) and a show create table of the table? And to double-check, the table is empty?