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.

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.17, 10.6.18
    • 10.6
    • 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

            People

              pandi.gurusamy Pandikrishnan Gurusamy
              kennyliao kennyliao
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.