Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MySQL 8.0.38, 8.4.1 and 9.0.0 crashes on restart if database has 10K tables or more

Description

If server has 10K tables and after restart, MySQL server crashes and refuses to start. Server cannot start.

 

 

How to reproduce:


verify docker is running

use the following script from chatGPT to create 12K tables:
ensure that you have MySQL client available in the PATH.




Environment

None

Attachments

3

Activity

Show:

Yura Sorokin September 11, 2024 at 7:38 PM

Satya Bodapati August 26, 2024 at 11:22 AM

, can you please add the mtr test case for the problem? It is attached here, but it needs a bit of polish.

Satya Bodapati August 21, 2024 at 11:52 AM

QA should verify that 10K tables are not an issue.

Yura Sorokin July 23, 2024 at 1:09 PM
Edited

The issue is fixed by Oracle in MySQL Server 8.0.39 / 8.4.2 / 9.0.1.

8.0.39:

8.4.2:

9.0.1:

Satya Bodapati July 23, 2024 at 10:48 AM

Thanks for the update, . Waiting for GitHub tags/source to be published.

Done

Details

Assignee

Reporter

Labels

Regression Issue

Yes

Upstream Bug URL

https://bugs.mysql.com/bug.php?id=115517

Needs QA

No

Fix versions

Priority

Smart Checklist

Created July 11, 2024 at 1:15 PM
Updated November 4, 2024 at 12:34 PM
Resolved September 11, 2024 at 7:38 PM