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 Email Updates:
Status: Verified Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:8.0.27 OS:Any
Assigned to: CPU Architecture:Any

[6 Jan 2022 11:49] Mikael Ronström
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