Bug #115931 MySQL hangs on installing plugin with innodb_thread_concurrency=1

• Submitted: 26 Aug 2024 12:32
• Modified: 26 Aug 2024 14:29
• Reporter: Sveta Smirnova (OCA)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 8.0.39, 8.4.0
• OS: Any
• CPU Architecture: Any
• Tags: regression

[26 Aug 2024 12:32] Sveta Smirnova

Description:
Since MySQL 8.0, INSTALL PLUGIN hangs with innodb_thread_concurrency=1.

While this is not a frequent value of innodb_thread_concurrency, it makes sense on single-core servers.

The bug is not reproducible on 5.7. I believe this is related to the new system dictionary.

How to repeat:
Start MySQL Server (e.g., cd mysql-test; ./mtr --start innodb &

Connect to it, run:

mysql> set global innodb_thread_concurrency=1;
Query OK, 0 rows affected (0,00 sec)

mysql> INSTALL PLUGIN example SONAME 'ha_example.so';

Wait forever.

Suggested fix:
Don't hang.

[26 Aug 2024 14:29] MySQL Verification Team

Hello Sveta,

Thank you for the report and feedback.
Verified as described.

regards,
Umesh