Bug #111178 Unable to set the secondary engine

• Submitted: 29 May 2023 3:33
• Modified: 29 May 2023 8:38
• Reporter: linfeng chen
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S2 (Serious)
• Version: 8.0.25, 8.0.33, 8.3.0
• OS: Any
• CPU Architecture: Any

[29 May 2023 3:33] linfeng chen

Description:
mysql> SET DEBUG='+d,skip_dd_table_access_check';
Query OK, 0 rows affected (5.36 sec)

mysql> ALTER TABLE mysql.tablespaces  SECONDARY_ENGINE = null;
Query OK, 0 rows affected (8.99 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql>  ALTER TABLE mysql.tablespaces SECONDARY_ENGINE = test;
ERROR 3958 (HY000): Failed to delete sdi for mysql.tablespaces in mysql due to missing record.

How to repeat:
SET DEBUG='+d,skip_dd_table_access_check';
ALTER TABLE mysql.tablespaces  SECONDARY_ENGINE = null;
ALTER TABLE mysql.tablespaces SECONDARY_ENGINE = test;

[29 May 2023 8:38] MySQL Verification Team

Hello linfeng chen,

Thank you for the report and test case.

regards,
Umesh