Modifying Table Structure Triggers Bug: Changing Field Type from decimal(12, 2) to decimal(12, 3) Causes TiFlash to Fail to Restart

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 修改表结构触发bug，字段类型 decimal(12, 2) 修改成 decimal(12, 3) tiflash无法重启

| username: 最强王者

Bug Report
Clearly and accurately describe the issue you found. Providing any possible steps to reproduce the issue will help the development team address it promptly.
[TiDB Version]
Version 5.2.3
[Impact of the Bug]
TiFlash crashes and cannot restart, TiDB node CPU is very high
Logs are as follows

image
image1380×390 298 KB

Syntax modification
alter table table modify weight decimal(12, 3) DEFAULT ‘0.000’
[Possible Steps to Reproduce the Issue]

[Observed Unexpected Behavior]

[Expected Behavior]

[Related Components and Specific Versions]

[Other Background Information or Screenshots]
Such as cluster topology, system and kernel version, application app information, etc.; if the issue is related to SQL, please provide SQL statements and related table schema information; if there are critical errors in node logs, please provide relevant node log content or files; if some business-sensitive information is inconvenient to provide, please leave contact information, and we will communicate with you privately.

2
| username: 有猫万事足 | Original post link

This issue has been fixed.

3
| username: 最强王者 | Original post link

Hello, could you please tell me in which version this was fixed?

4
| username: 有猫万事足 | Original post link

It was fixed on February 2, 2023, and directly submitted to the master branch. This means that all x.x.0 versions released after this date will include this fix. After checking, it should be included in versions 6.6.0 and later. However, it is recommended to use the LTS version, so you might need to upgrade to 7.1 or 7.5.

5
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.