When will the throttled state be triggered

Đang mở

#1,389 mở ngày 11/3/2024 1 bình luận 0 reaction 0 người được giao Xem trên GitHub

Maintainer thường phản hồi trong vòng 10 ngày

Chưa có ai nhận issue này.

Đánh giá

Độ khó: 4/5
Thời gian dự kiến: 3-5 ngày
Mức phù hợp với người mới: 25/100

Loại issue: Lỗi
Độ rõ ràng: Cần làm rõ
Mức độ hoạt động: Đình trệ
Công nghệ: go, mysql
Lĩnh vực: databases

Hướng nghiên cứu

Bắt đầu với cách gh-ost 1.1.5 xử lý --panic-flag-file và trạng thái throttle, sử dụng lệnh và đoạn log được cung cấp để tái hiện. Truy vết lý do tệp flag vẫn hoạt động sau khi quá trình migration đạt Copy: 0/0, sau đó xác nhận nguyên nhân và ghi lại một quy trình troubleshooting có thể tái hiện.

Do mô hình lập chỉ mục viết ra từ nội dung của issue.

Mô tả

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

Ngôn ngữ chính: Go
Star: 13.6k
Fork: 1.4k
Merge trung bình: 9 ngày 19 giờ
Pull request đã merge (30 ngày): 1

Chuẩn bị môi trường

Có Dockerfile hoặc tệp Docker Compose
Có mẫu pull request
Đọc hướng dẫn đóng góp

Bắt đầu từ đâu

Đọc hết issue, rồi đọc hướng dẫn đóng góp của dự án.
Bình luận trên issue rằng bạn sẽ nhận — tránh hai người làm cùng một việc.
Fork repository và làm thay đổi trên một nhánh.
Mở pull request có tham chiếu số hiệu của issue.

Issue khác của github/gh-ost

`--resume` without `--execute` drops the ghost table it correctly skipped altering
Có thể đã có người làm @ajm188 đã nhận 56 ngày trước. Đang mở
- Có gì không ổn?
Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 86/100

github/gh-ost#1769 · Mở ngày 18/9/2026

Maintainer thường phản hồi trong vòng 10 ngày
[Suggestion] Apply simple validation to alter command
Có thể đã có người làm @drkemp187 đã nhận 106 ngày trước. Đang mở
- Có gì không ổn?
enhancement good first issue

Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 64/100

github/gh-ost#1431 · 4 bình luận · Mở ngày 9/7/2024

Maintainer thường phản hồi trong vòng 10 ngày
Migration hangs when --attempt-instant-ddl succeeds
Có thể đã có người làm Có pull request liên kết đang mở hoặc đã được merge. Đang mở
- Có gì không ổn?
Độ khó 4/5 3-5 ngày Mức phù hợp với người mới 30/100

github/gh-ost#1795 · Mở ngày 2/11/2026

Maintainer thường phản hồi trong vòng 10 ngày
--resume with --gtid can skip the rest of a large transaction (checkpoint written mid-transaction): silent data loss
Đang mở
- Có gì không ổn?
Độ khó 4/5 3-5 ngày Mức phù hợp với người mới 42/100

github/gh-ost#1781 · Mở ngày 5/10/2026

Maintainer thường phản hồi trong vòng 10 ngày
Atomic cut-over always fails on MySQL 9.1+: information_schema.processlist errors out (3854) while another session runs a non-BMP utf8mb4 statement
Có thể đã có người làm Có pull request liên kết đang mở hoặc đã được merge. Đang mở
- Có gì không ổn?
Độ khó 4/5 3-5 ngày Mức phù hợp với người mới 52/100

github/gh-ost#1780 · 1 bình luận · Mở ngày 5/10/2026

Maintainer thường phản hồi trong vòng 10 ngày

Tất cả issue của github/gh-ost

Issue tương tự

GitLab adapter never sets forge PullRequest.CreatedAt (internal/gitlab/mrs.go toForgePR)
Đang mở
- Có gì không ổn?
type:bug

Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 72/100

nightgauge/nightgauge#3266 · Mở ngày 13/11/2026

Maintainer thường phản hồi trong vòng 1 ngày
transcript_propose is not certified at the thinking level the premium presets use
Đang mở
- Có gì không ổn?
area: ai-models priority: normal

Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 68/100

margince/margince#11479 · Mở ngày 13/11/2026

Maintainer thường phản hồi trong vòng 1 ngày
jobstore.ScanEventsFrom reads with bufio's 4 KiB default buffer
Đang mở
- Có gì không ổn?
Độ khó 1/5 Dưới một giờ Mức phù hợp với người mới 85/100

prime-radiant-inc/evener#6325 · Mở ngày 13/11/2026

Maintainer thường phản hồi trong vòng 1 ngày
Bug: `worktree contains unstaged changes` when a layer targets a non-default branch
Đang mở
- Có gì không ổn?
team:library-maintainers

Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 82/100

padok-team/burrito#1208 · 1 bình luận · Mở ngày 13/11/2026

Maintainer thường phản hồi trong vòng 1 ngày
Filter LTO-dependent CFI sanitizer flags from cgo compiler options
Đang mở
- Có gì không ổn?
Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 62/100

bazel-contrib/rules_go#4784 · 1 bình luận · Mở ngày 13/11/2026

Maintainer thường phản hồi trong vòng 1 ngày

Thêm issue về Go

When will the throttled state be triggered

Có gì không ổn?

Đánh giá

Hướng nghiên cứu

Mô tả

Chuẩn bị môi trường

Bắt đầu từ đâu

Issue khác của github/gh-ost

Có gì không ổn?

Có gì không ổn?

Có gì không ổn?

Có gì không ổn?

Có gì không ổn?

Issue tương tự

Có gì không ổn?

Có gì không ổn?

Có gì không ổn?

Có gì không ổn?

Có gì không ổn?

Nhận issue mới trong hộp thư của bạn