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

Invalidate column id after ddl #3967

Closed
lilinghai opened this issue Feb 7, 2022 · 2 comments · Fixed by #4021 or #4090
Closed

Invalidate column id after ddl #3967

lilinghai opened this issue Feb 7, 2022 · 2 comments · Fixed by #4021 or #4090

Comments

@lilinghai
Copy link

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

https://tcms.pingcap.net/dashboard/executions/plan/602195
http://minio.pingcap.net:42041/buckets/test-infra-testground/browse/YXJjaGl2ZS9lbmRsZXNzLWh0YXAtY2gtbXV0aXBsZS1kaXNrcy10cHMtNjAyMTk1LTEtOTI2Lw==

[2022/02/02 14:35:00.513 +08:00] [INFO] [ddl.go:83] ["ddl sequence"] [sql="alter table warehouse add column adc_2 datetime(6)"]
[2022/02/02 14:35:00.520 +08:00] [INFO] [ddl.go:83] ["ddl sequence"] [sql="update warehouse set adc_2 = null limit 2"]
[2022/02/02 14:35:00.712 +08:00] [INFO] [ddl.go:83] ["ddl sequence"] [sql="select /*+ read_from_storage(TIFLASH[warehouse]) */ adc_2 from warehouse limit 2"]
[2022/02/02 14:35:00.712 +08:00] [ERROR] [ddl.go:85] ["sql error"] [sql="select /*+ read_from_storage(TIFLASH[warehouse]) */ adc_2 from warehouse limit 2"] [error="Error 1105: other error for mpp stream: DB::Exception: code: 49\nmsg: \"DB::String TiDB::TableInfo::getColumnName(const DB::ColumnID) const: Invalidate column id 11 for table warehouse\"\n"]

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

3. What did you see instead (Required)

4. What is your TiFlash version? (Required)

master

[2022/02/02 14:27:07.110 +08:00] [INFO] [client.go:338] ["Cluster version information"] [type=pd] [version=5.5.0-nightly] [git_hash=51960c3a225b43f885e965d5f4b0d4e263183587]
[2022/02/02 14:27:07.110 +08:00] [INFO] [client.go:338] ["Cluster version information"] [type=tiflash] [version=5.5.0-nightly] [git_hash=e7612d90bb763878ae7764ef770cf56c5b3a0ae4]
[2022/02/02 14:27:07.110 +08:00] [INFO] [client.go:338] ["Cluster version information"] [type=tidb] [version=5.5.0-nightly] [git_hash=9f10e692fd8dbfa712c869cd9c13c2bf042af467]
[2022/02/02 14:27:07.110 +08:00] [INFO] [client.go:338] ["Cluster version information"] [type=tikv] [version=5.4.0-alpha] [git_hash=8b23c7bddcd03bed9b83a3bd3cab114a4a40459d]
@lidezhu
Copy link
Contributor

lidezhu commented Feb 22, 2022

Reopen it because the problem is not completely fixed. The problem will be fixed in #4090.

@zanmato1984
Copy link
Contributor

Update.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment