Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 0.9.56
    • 0.9.57
    • DBAPI 2.0
    • None

    Description

      Wnen opening and closing a cursor in a loop, the size of used memory increases constantly.

      How to repeat:

      import mariadb
      import resource
       
      i=0
      end=10000
      i=0
      connection= mariadb.connect(user="georg")
      last_used_mem= resource.getrusage(resource.RUSAGE_SELF).ru_maxrss
       
      while i < end:
           cursor=connection.cursor()
           cursor.close()
           diff_mem= resource.getrusage(resource.RUSAGE_SELF).ru_maxrss - last_used_mem
           if diff_mem > 0:
              print("leak: %s" % diff_mem)
              last_used_mem+= diff_mem
      conn.close()
      

      Attachments

        Activity

          georg Georg Richter created issue -
          georg Georg Richter made changes -
          Field Original Value New Value
          Status Open [ 1 ] Confirmed [ 10101 ]
          georg Georg Richter made changes -
          Labels SupportCase
          georg Georg Richter made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          georg Georg Richter made changes -
          Description Wnen opening and closing a cursor in a loop, the size of used memory increases constantly.

          How to repeat:


          {code:python}
          import mariadb
          import resource

          i=0
          end=10000
          i=0
          connection= mariadb.connect(user="georg")
          last_used_mem= resource.getrusage(resource.RUSAGE_SELF).ru_maxrss

          while i < end:
               cursor=connection.cursor()
               cursor.close()
               diff_mem= resource.getrusage(resource.RUSAGE_SELF).ru_maxrss - last_used_mem
               if diff_mem > 0:
                  print("leak: %s" % diff)
                  last_used_mem+= diff
          conn.close()
          {code}
          Wnen opening and closing a cursor in a loop, the size of used memory increases constantly.

          How to repeat:


          {code:python}
          import mariadb
          import resource

          i=0
          end=10000
          i=0
          connection= mariadb.connect(user="georg")
          last_used_mem= resource.getrusage(resource.RUSAGE_SELF).ru_maxrss

          while i < end:
               cursor=connection.cursor()
               cursor.close()
               diff_mem= resource.getrusage(resource.RUSAGE_SELF).ru_maxrss - last_used_mem
               if diff_mem > 0:
                  print("leak: %s" % diff_mem)
                  last_used_mem+= diff_mem
          conn.close()
          {code}
          georg Georg Richter made changes -
          Priority Major [ 3 ] Blocker [ 1 ]
          georg Georg Richter made changes -
          Labels SupportCase
          georg Georg Richter added a comment -

          Fixed in rev. e2cebf7d39c1dac8c41e8c42a3cf10e0ba4554d0

          georg Georg Richter added a comment - Fixed in rev. e2cebf7d39c1dac8c41e8c42a3cf10e0ba4554d0
          georg Georg Richter made changes -
          issue.field.resolutiondate 2020-04-10 15:30:03.0 2020-04-10 15:30:03.174
          georg Georg Richter made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 107005 ] MariaDB v4 [ 135630 ]

          People

            georg Georg Richter
            georg Georg Richter
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.