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

          Activity

            I suspect that this report is a duplicate of MDEV-34265.

            marko Marko Mäkelä added a comment - I suspect that this report is a duplicate of MDEV-34265 .

            Can you please try if this issue is reproducible on MariaDB Server 10.6.19 or a later version?

            marko Marko Mäkelä added a comment - Can you please try if this issue is reproducible on MariaDB Server 10.6.19 or a later version?

            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.