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.

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

When will the throttled state be triggered #1389

Open
Tracked by #1400
suyestyle opened this issue Mar 11, 2024 · 1 comment
Open
Tracked by #1400

When will the throttled state be triggered #1389

suyestyle opened this issue Mar 11, 2024 · 1 comment

Comments

@suyestyle
Copy link

suyestyle commented Mar 11, 2024

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
Copy link
Collaborator

@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?

@ramshad-sha ramshad-sha mentioned this issue Mar 25, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants