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

Memory leak on multiple reuse of prepared statement

    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

            • Assignee:
              Unassigned
              Reporter:
              xani Mariusz Gronczewski
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: