Bug #111793 | mysqldump memory leaks | ||
---|---|---|---|
Submitted: | 18 Jul 2023 15:06 | Modified: | 6 Dec 2024 0:52 |
Reporter: | Pedro Ferreira | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: mysqldump Command-line Client | Severity: | S2 (Serious) |
Version: | 8.1 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | mysqldump |
[18 Jul 2023 15:06]
Pedro Ferreira
[19 Jul 2023 12:17]
MySQL Verification Team
Hi Mr. Ferreira, Thank you for your bug report. However, we need the additional information in order to be able to process it further. Minimum value of that system variable is not recommended. Do you have the same problems with default value ??? Next, how many schemas and tables do you have and is there anything particular in them. Can you upload the table that makes this problem ??? Next, you have set the category to Server, while it is evidently not a bug in the server. Next, which memory analyser tools have you used ??? One or several of them. We need that info in order rto try to repeat it. We are waiting on your feedback.
[19 Jul 2023 14:04]
Pedro Ferreira
Hello, I am using a testing tool and sometimes I need to test low memory situations, that's why I set the sort buffer size too low. The database was empty, I just initialized it, set the buffer size, then run the dump. I built the server with ASAN, but I forgot to mention it, my apologies: -DWITH_DEBUG=1 -DWITH_ASAN=ON -DWITH_UBSAN=ON
[19 Jul 2023 14:15]
MySQL Verification Team
Hi Mr. Ferreira, We have managed to repeat the behaviour. We have also got the error message on both mysqldump and server side: Error 1038: Out of sort memory, consider increasing server sort buffer size when dumping table `help_topic` at row: 0 This is now a verified bug.
[6 Dec 2024 0:52]
Philip Olson
Posted by developer: Fixed as of the upcoming MySQL Server 9.3.0 release, and here's the proposed changelog entry from the documentation team: Fixed a memory leak in the mysqldump client. Thank you for the bug report.
[6 Dec 2024 10:57]
MySQL Verification Team
Thank you, Philip.