Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37196

Memory leaks after calling mysqldump -L

    XMLWordPrintable

Details

    • Can result in unexpected behaviour
    • Q3/2025 Maintenance

    Description

      here database test was not dumped+leaks:

      --exec $MYSQL_DUMP --wildcards=ON t%
      

      main.1_my                                [ fail ]
              Test ended at 2025-07-10 09:49:33
       
      CURRENT_TEST: main.1_my
       
      =================================================================
      ==3477625==ERROR: LeakSanitizer: detected memory leaks
       
      Direct leak of 144 byte(s) in 1 object(s) allocated from:
          #0 0x7f45422d02b7 in __interceptor_calloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:77
          #1 0x564062d4b4d4 in mysql_store_result /12.1/src/libmariadb/libmariadb/mariadb_lib.c:3030
          #2 0x564062d0265c in mysql_query_with_error_report /12.1/src/client/mysqldump.cc:1517
          #3 0x564062d2086c in dump_databases_wild(int, char**) /12.1/src/client/mysqldump.cc:7447
          #4 0x564062d21aeb in main /12.1/src/client/mysqldump.cc:7668
          #5 0x7f4541892082 in __libc_start_main ../csu/libc-start.c:308
       
      Indirect leak of 8168 byte(s) in 1 object(s) allocated from:
          #0 0x7f45422d08ff in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:69
          #1 0x564062d61d98 in ma_alloc_root /12.1/src/libmariadb/libmariadb/ma_alloc.c:91
          #2 0x564062d3a94d in unpack_fields /12.1/src/libmariadb/libmariadb/mariadb_lib.c:1111
          #3 0x564062d4a69f in mthd_my_read_query_result /12.1/src/libmariadb/libmariadb/mariadb_lib.c:2941
          #4 0x564062d4b222 in mysql_real_query /12.1/src/libmariadb/libmariadb/mariadb_lib.c:3008
          #5 0x564062d46fb2 in mysql_query /12.1/src/libmariadb/libmariadb/mariadb_lib.c:2570
          #6 0x564062d02645 in mysql_query_with_error_report /12.1/src/client/mysqldump.cc:1516
          #7 0x564062d2086c in dump_databases_wild(int, char**) /12.1/src/client/mysqldump.cc:7447
          #8 0x564062d21aeb in main /12.1/src/client/mysqldump.cc:7668
          #9 0x7f4541892082 in __libc_start_main ../csu/libc-start.c:308
       
      Indirect leak of 8168 byte(s) in 1 object(s) allocated from:
          #0 0x7f45422d08ff in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:69
          #1 0x564062d61d98 in ma_alloc_root /12.1/src/libmariadb/libmariadb/ma_alloc.c:91
          #2 0x564062d3bb3d in mthd_my_read_rows /12.1/src/libmariadb/libmariadb/mariadb_lib.c:1216
          #3 0x564062d4b7a4 in mysql_store_result /12.1/src/libmariadb/libmariadb/mariadb_lib.c:3038
          #4 0x564062d0265c in mysql_query_with_error_report /12.1/src/client/mysqldump.cc:1517
          #5 0x564062d2086c in dump_databases_wild(int, char**) /12.1/src/client/mysqldump.cc:7447
          #6 0x564062d21aeb in main /12.1/src/client/mysqldump.cc:7668
          #7 0x7f4541892082 in __libc_start_main ../csu/libc-start.c:308
       
      Indirect leak of 96 byte(s) in 1 object(s) allocated from:
          #0 0x7f45422d02b7 in __interceptor_calloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:77
          #1 0x564062d3b864 in mthd_my_read_rows /12.1/src/libmariadb/libmariadb/mariadb_lib.c:1202
          #2 0x564062d4b7a4 in mysql_store_result /12.1/src/libmariadb/libmariadb/mariadb_lib.c:3038
          #3 0x564062d0265c in mysql_query_with_error_report /12.1/src/client/mysqldump.cc:1517
          #4 0x564062d2086c in dump_databases_wild(int, char**) /12.1/src/client/mysqldump.cc:7447
          #5 0x564062d21aeb in main /12.1/src/client/mysqldump.cc:7668
          #6 0x7f4541892082 in __libc_start_main ../csu/libc-start.c:308
       
      SUMMARY: AddressSanitizer: 16576 byte(s) leaked in 4 allocation(s).
      Aborted
      mysqltest: At line 5: exec of '/12.1/bld/client//mariadb-dump --defaults-file=/12.1/bld/mysql-test/var/my.cnf --defaults-group-suffix=.1 --wildcards=ON t%' failed, error: 34304, status: 134, errno: 11
      Output from before failure:
      /*M!999999\- enable the sandbox mode */ 
      -- MariaDB dump 10.19-12.0.1-MariaDB, for Linux (x86_64)
      --
      -- Host: localhost    Database: t%
      -- ------------------------------------------------------
      -- Server version	12.0.1-MariaDB-debug-log
       
      /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
      /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
      /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
      /*!40101 SET NAMES utf8mb4 */;
      /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
      /*!40103 SET TIME_ZONE='+00:00' */;
      /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
      /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
      /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
      /*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
      /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
       
      /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
      /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
      /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
      /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
      /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
      /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
      /*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;
       
      -- Dump completed on 2025-07-10  9:49:32
      

      --exec $MYSQL_DUMP -L --databases t%
      

      CURRENT_TEST: main.1_my
       
      =================================================================
      ==3477947==ERROR: LeakSanitizer: detected memory leaks
       
      Direct leak of 144 byte(s) in 1 object(s) allocated from:
          #0 0x7f5d9551c2b7 in __interceptor_calloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:77
          #1 0x5645cbab64d4 in mysql_store_result /12.1/src/libmariadb/libmariadb/mariadb_lib.c:3030
          #2 0x5645cba6d65c in mysql_query_with_error_report /12.1/src/client/mysqldump.cc:1517
          #3 0x5645cba8b86c in dump_databases_wild(int, char**) /12.1/src/client/mysqldump.cc:7447
          #4 0x5645cba8caeb in main /12.1/src/client/mysqldump.cc:7668
          #5 0x7f5d94ade082 in __libc_start_main ../csu/libc-start.c:308
       
      Indirect leak of 8168 byte(s) in 1 object(s) allocated from:
          #0 0x7f5d9551c8ff in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:69
          #1 0x5645cbaccd98 in ma_alloc_root /12.1/src/libmariadb/libmariadb/ma_alloc.c:91
          #2 0x5645cbaa594d in unpack_fields /12.1/src/libmariadb/libmariadb/mariadb_lib.c:1111
          #3 0x5645cbab569f in mthd_my_read_query_result /12.1/src/libmariadb/libmariadb/mariadb_lib.c:2941
          #4 0x5645cbab6222 in mysql_real_query /12.1/src/libmariadb/libmariadb/mariadb_lib.c:3008
          #5 0x5645cbab1fb2 in mysql_query /12.1/src/libmariadb/libmariadb/mariadb_lib.c:2570
          #6 0x5645cba6d645 in mysql_query_with_error_report /12.1/src/client/mysqldump.cc:1516
          #7 0x5645cba8b86c in dump_databases_wild(int, char**) /12.1/src/client/mysqldump.cc:7447
          #8 0x5645cba8caeb in main /12.1/src/client/mysqldump.cc:7668
          #9 0x7f5d94ade082 in __libc_start_main ../csu/libc-start.c:308
       
      Indirect leak of 8168 byte(s) in 1 object(s) allocated from:
          #0 0x7f5d9551c8ff in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:69
          #1 0x5645cbaccd98 in ma_alloc_root /12.1/src/libmariadb/libmariadb/ma_alloc.c:91
          #2 0x5645cbaa6b3d in mthd_my_read_rows /12.1/src/libmariadb/libmariadb/mariadb_lib.c:1216
          #3 0x5645cbab67a4 in mysql_store_result /12.1/src/libmariadb/libmariadb/mariadb_lib.c:3038
          #4 0x5645cba6d65c in mysql_query_with_error_report /12.1/src/client/mysqldump.cc:1517
          #5 0x5645cba8b86c in dump_databases_wild(int, char**) /12.1/src/client/mysqldump.cc:7447
          #6 0x5645cba8caeb in main /12.1/src/client/mysqldump.cc:7668
          #7 0x7f5d94ade082 in __libc_start_main ../csu/libc-start.c:308
       
      Indirect leak of 96 byte(s) in 1 object(s) allocated from:
          #0 0x7f5d9551c2b7 in __interceptor_calloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:77
          #1 0x5645cbaa6864 in mthd_my_read_rows /12.1/src/libmariadb/libmariadb/mariadb_lib.c:1202
          #2 0x5645cbab67a4 in mysql_store_result /12.1/src/libmariadb/libmariadb/mariadb_lib.c:3038
          #3 0x5645cba6d65c in mysql_query_with_error_report /12.1/src/client/mysqldump.cc:1517
          #4 0x5645cba8b86c in dump_databases_wild(int, char**) /12.1/src/client/mysqldump.cc:7447
          #5 0x5645cba8caeb in main /12.1/src/client/mysqldump.cc:7668
          #6 0x7f5d94ade082 in __libc_start_main ../csu/libc-start.c:308
       
      SUMMARY: AddressSanitizer: 16576 byte(s) leaked in 4 allocation(s).
      Aborted
      mysqltest: At line 5: exec of '/12.1/bld/client//mariadb-dump --defaults-file=/12.1/bld/mysql-test/var/my.cnf --defaults-group-suffix=.1 -L --databases t%' failed, error: 34304, status: 134, errno: 11
      Output from before failure:
      /*M!999999\- enable the sandbox mode */ 
      -- MariaDB dump 10.19-12.0.1-MariaDB, for Linux (x86_64)
      --
      -- Host: localhost    Database: t%
      -- ------------------------------------------------------
      -- Server version	12.0.1-MariaDB-debug-log
       
      /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
      /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
      /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
      /*!40101 SET NAMES utf8mb4 */;
      /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
      /*!40103 SET TIME_ZONE='+00:00' */;
      /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
      /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
      /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
      /*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
       
      --
      -- Current Database: `test`
      --
       
      CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */;
       
      USE `test`;
      /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
       
      /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
      /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
      /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
      /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
      /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
      /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
      /*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;
       
      -- Dump completed on 2025-07-10  9:55:49
      

      Attachments

        Issue Links

          Activity

            People

              holyfoot Alexey Botchkov
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.