Bug #106082 Activating auto update of index stats activated bugs

• Submitted: 6 Jan 2022 11:49
• Modified: 18 Jan 2022 12:16
• Reporter: Mikael Ronström
• Status: Verified
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 8.0.27
• OS: Any
• CPU Architecture: Any

[6 Jan 2022 11:49] Mikael Ronström

Description:
In MySQL Cluster 8.0.27 auto update of index stats in data nodes was made the default.

However the auto update code in Dbdict.cpp has several flaws:
1) Several index auto updates can start in parallel
2) If an error occurs during the begin schema transaction part we stop the
auto update without releasing the Tx handle. This leads to leak of a resource that
there is only 2 of which in turn leads to a crash when handling API node failure or
handling a normal schema transaction.

How to repeat:
testDict -l 1 -n SchemaTrans T1

This test case causes a crash during API node failure handling

Suggested fix:
Fix above mentioned problems

[18 Jan 2022 12:16] MySQL Verification Team

Thank for the report Mikael,

all best
Bogdan