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

[Warning] InnoDB: Could not free any blocks in the buffer pool! 129856 blocks are in use and 0 free. Consider increasing innodb_buffer_pool_size.

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.6.17, 10.6.18
    • N/A
    • None
    • None
    • windows
      red hat

    Description

      The phenomenon is that even root users cannot access the database, and the memory of the mysqld process in the task manager cannot be released and remains unchanged.
      innodb_buffer_pool_size=2048M

      2024-06-24 21:01:08 136 [Warning] Aborted connection 136 to db: 'dss' user: 'mysql' host: '192.168.1.91' (Got an error reading communication packets)
      2024-06-24 21:01:08 137 [Warning] Aborted connection 137 to db: 'dss' user: 'mysql' host: '192.168.1.91' (Got an error reading communication packets)
      2024-06-24 21:01:08 139 [Warning] Aborted connection 139 to db: 'dss' user: 'mysql' host: '192.168.1.91' (Got an error reading communication packets)
      2024-06-24 21:01:08 140 [Warning] Aborted connection 140 to db: 'dss' user: 'mysql' host: '192.168.1.91' (Got an error reading communication packets)
      2024-06-24 21:01:08 148 [Warning] Aborted connection 148 to db: 'dss' user: 'mysql' host: '192.168.1.91' (Got an error reading communication packets)
      2024-06-24 21:01:08 141 [Warning] Aborted connection 141 to db: 'dss' user: 'mysql' host: '192.168.1.91' (Got an error reading communication packets)
      2024-06-24 21:01:08 149 [Warning] Aborted connection 149 to db: 'dss' user: 'mysql' host: '192.168.1.91' (Got an error reading communication packets)
      2024-06-24 21:01:27 153 [Warning] Access denied for user 'ޔ^p?'?Vf?J>???'@'192.168.1.91' (using password: YES)
      2024-06-24 21:01:37 181 [Warning] Access denied for user 'ޔ^p?'?Vf?J>???'@'192.168.1.91' (using password: YES)
      2024-06-24 21:01:37 182 [Warning] Access denied for user 'ޔ^p?'?Vf?J>???'@'192.168.1.91' (using password: YES)
      2024-06-24 21:01:47 188 [Warning] Access denied for user 'ޔ^p?'?Vf?J>???'@'192.168.1.91' (using password: YES)
      2024-06-24 21:01:57 189 [Warning] Access denied for user 'ޔ^p?'?Vf?J>???'@'192.168.1.91' (using password: YES)
      2024-06-24 21:02:07 190 [Warning] Access denied for user 'ޔ^p?'?Vf?J>???'@'192.168.1.91' (using password: YES)
      2024-06-24 21:02:17 191 [Warning] Access denied for user 'ޔ^p?'?Vf?J>???'@'192.168.1.91' (using password: YES)
      2024-06-24 21:02:27 199 [Warning] Access denied for user 'ޔ^p?'?Vf?J>???'@'192.168.1.91' (using password: YES)
      2024-06-24 21:57:27 226 [Warning] InnoDB: Could not free any blocks in the buffer pool! 129856 blocks are in use and 0 free. Consider increasing innodb_buffer_pool_size.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34265 Possible hang during IO burst with innodb_flush_sync enabled

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Julien Fritsch made transition -
            Needs Feedback Open
            		57d 8h 19m 1
            Julien Fritsch made transition -
            Open Needs Feedback
            		121d 1h 7m 2
            Julien Fritsch made transition -
            Needs Feedback Closed
            		20d 17h 58m 1

            People

              pandi.gurusamy Pandikrishnan Gurusamy
              kennyliao kennyliao
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.