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

Memory not freed: 264, 280 when using log_bin_trust_function_creators=1

    XMLWordPrintable

Details

    Description

      Lightly sporadic. Similar to MDEV-26335 but a different amount of memory lost.

      SET GLOBAL log_bin_trust_function_creators=1;
      DELETE FROM mysql.user;
      CREATE FUNCTION f (i INT) RETURNS INT RETURN i;
      FLUSH PRIVILEGES;
      CREATE VIEW c AS SELECT f();
      GRANT SELECT (f) ON c TO foo;
      SHUTDOWN;
      

      Leads to:

      11.0.1 f2dc4d4c10ac36a73b5c1eb765352d3aee808d66 (Optimized)

      2023-03-04 11:43:32 0 [Note] /test/MD180223-mariadb-11.0.1-linux-x86_64-opt/bin/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
      2023-03-04 11:43:32 0 [Note] InnoDB: FTS optimize thread exiting.
      2023-03-04 11:43:32 0 [Note] InnoDB: Starting shutdown...
      2023-03-04 11:43:32 0 [Note] InnoDB: Dumping buffer pool(s) to /test/MD180223-mariadb-11.0.1-linux-x86_64-opt/data/ib_buffer_pool
      2023-03-04 11:43:32 0 [Note] InnoDB: Buffer pool(s) dump completed at 230304 11:43:32
       
      Warning: Memory not freed: 280
      

      Bug confirmed present in:
      MariaDB: 10.3.38 (dbg), 10.3.38 (opt), 10.4.29 (dbg), 10.4.29 (opt), 10.5.20 (dbg), 10.5.20 (opt), 10.6.13 (dbg), 10.6.13 (opt), 10.7.8 (dbg), 10.7.8 (opt), 10.8.8 (dbg), 10.8.8 (opt), 10.9.6 (dbg), 10.9.6 (opt), 10.10.4 (dbg), 10.10.4 (opt), 10.11.2 (dbg), 10.11.2 (opt), 11.0.1 (dbg), 11.0.1 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.40 (dbg), 5.7.40 (opt), 8.0.31 (dbg), 8.0.31 (opt)

      No ASAN or UBSAN issues were observed.

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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