tencent cloud

TDSQL-C for MySQL

Service Agreement
Service Level Agreement
Terms of Service
Política TDSQL- C
Política de privacidade
Contrato de segurança e processamento de dados
DocumentaçãoTDSQL-C for MySQL

Performing Instant add column and Online DDL Operations Sequentially on a Table Triggering a crash

Modo Foco
Tamanho da Fonte
Última atualização: 2025-12-08 15:56:17

Problem

Performing Instant add column followed by Online DDL on a table causes a crash.

Scenario for Issue Triggering

Performing Instant add column on a table followed by Online DDL operations such as OPTIMIZE TABLE or ALTER TABLE .. ADD PRIMARY KEY may cause a crash due to improper handling of the code (failure to instantly add columns or REDUNDANT format).

Kernel Version Related to the Issue

TXSQL 8.0 versions prior to 3.1.15.001.

Fixed Kernel Version

TXSQL 8.0 3.1.16.003.

Check Method

You can refer to the following command to scan for tables with potential risks.
select replace(name, '/', '.') as 'table_schema.table_name' from information_schema.innodb_tables where TOTAL_ROW_VERSIONS!=0 or INSTANT_COLS!=0;

Fixing Method

1. Upgrade the kernel version to TXSQL 8.0 3.1.16.003. For the procedure, see Upgrading the kernel minor version.
2. After the kernel version is upgraded, rebuild and repair corrupted tables using alter table xx engine = innodb;. To avoid business impact caused by table locking, it is recommended to perform repairs during off-peak hours using tools such as pt-osc.
Próximo: Service Level Agreement

Ajuda e Suporte

Esta página foi útil?

comentários