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

Memory leak on multiple reuse of prepared statement

    XMLWordPrintable

Details

    Description

      See attached screenshot for memory stats. MariaDB is biggest running process in system and it has only ~100MB database (it is slave)

      We've upgraded version of mysql that runs our PowerDNS instances (and PowerDNS version itself) and noticed they started leaking memory.

      After closer inspection via wireshark I've noticed PowerDNS just makes one prepared statement then constantly executes and resets it, which leads me to believe there is a leak somewhere. After restarting PowerDNS (which ends the connection to MariaDB), memory is freed.

      The prepared statement is made to a view if that has any significance

      Attachments

        1. Zaznaczenie_2018-09-06_001.png
          Zaznaczenie_2018-09-06_001.png
          56 kB
        2. schema.sql
          10 kB
        3. leak-dump.pcap
          2.52 MB

        Activity

          People

            Unassigned Unassigned
            xani Mariusz Gronczewski
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.