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

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

Closed
tangenta opened this issue May 16, 2024 · 0 comments · Fixed by #53332 or #53355
Closed

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

tangenta opened this issue May 16, 2024 · 0 comments · Fixed by #53332 or #53355
Assignees
Labels
affects-8.1 This bug affects the 8.1.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development severity/critical type/bug The issue is confirmed as a bug.

Comments

@tangenta
Copy link
Contributor

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)

cc127c1

@tangenta tangenta added type/bug The issue is confirmed as a bug. severity/critical feature/developing the related feature is in development affects-8.1 This bug affects the 8.1.x(LTS) versions. labels May 16, 2024
@tangenta tangenta self-assigned this May 16, 2024
@jebter jebter added the component/ddl This issue is related to DDL of TiDB. label May 16, 2024
terry1purcell pushed a commit to terry1purcell/tidb that referenced this issue May 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-8.1 This bug affects the 8.1.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development severity/critical type/bug The issue is confirmed as a bug.
Projects
None yet
2 participants