search

pingcap / tidb

TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://www.pingcap.com/tidb-serverless/
https://pingcap.com
Apache License 2.0
36.4k stars 5.73k forks source link

Upgrade TiDB failed: unknown column 'owner_id' in field list #53327

Closed tangenta closed 1 month ago

tangenta commented 1 month ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Upgrade TiDB to master.

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

Upgrade successfully.

3. What did you see instead (Required)

TiDB is unable to provide services.

[2024/05/16 14:49:23.148 +08:00] [INFO] [ddl_worker.go:1191] ["run DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=104] [category=ddl] [job="ID:104, Type:add column, State:queueing, SchemaState:none, SchemaID:1, TableID:281474976710651, RowCount:0, ArgLen:0, start time: 2024-05-16 14:49:22.125 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/16 14:49:23.151 +08:00] [INFO] [column.go:135] ["run add column job"] [category=ddl] [job="ID:104, Type:add column, State:running, SchemaState:none, SchemaID:1, TableID:281474976710651, RowCount:0, ArgLen:4, start time: 2024-05-16 14:49:22.125 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"] [columnInfo="{\"id\":4,\"name\":{\"O\":\"owner_id\",\"L\":\"owner_id\"},\"offset\":3,\"origin_default\":\"\",\"origin_default_bit\":null,\"default\":\"\",\"default_bit\":null,\"default_is_expr\":false,\"generated_expr_string\":\"\",\"generated_stored\":false,\"dependences\":null,\"type\":{},\"state\":0,\"comment\":\"\",\"hidden\":false,\"change_state_info\":null,\"version\":2}"]
[2024/05/16 14:49:23.156 +08:00] [INFO] [job_table.go:466] ["handle ddl job failed"] [worker="worker 1, tp general"] [category=ddl] [error="[planner:1054]Unknown column 'owner_id' in 'field list'"] [job="ID:104, Type:add column, State:running, SchemaState:delete only, SchemaID:1, TableID:281474976710651, RowCount:0, ArgLen:4, start time: 2024-05-16 14:49:22.125 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]
[2024/05/16 14:49:23.164 +08:00] [INFO] [ddl_worker.go:1191] ["run DDL job"] [worker="worker 1, tp general"] [category=ddl] [jobID=104] [category=ddl] [job="ID:104, Type:add column, State:queueing, SchemaState:none, SchemaID:1, TableID:281474976710651, RowCount:0, ArgLen:0, start time: 2024-05-16 14:49:22.125 +0800 CST, Err:<nil>, ErrCount:0, SnapshotVersion:0, LocalMode: false"]

4. What is your TiDB version? (Required)

cc127c14b8c