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

Very specific OOM from everywhere.

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.14
    • None
    • None

    Description

      OOM from various place but very specific size.

      2025-10-30 9:05:52 173558 [ERROR] mysqld.exe: Out of memory (Needed 33554400 bytes)
      2025-10-30 9:05:53 209775 [ERROR] mysqld.exe: Out of memory (Needed 33554400 bytes)
      2025-10-30 9:05:55 159465 [ERROR] mysqld.exe: Out of memory (Needed 33554400 bytes)

      2025-10-30 11:51:23 366044 [ERROR] mysqld.exe: Out of memory (Needed 134217696 bytes)
      2025-10-30 11:51:24 366030 [ERROR] mysqld.exe: Out of memory (Needed 67108832 bytes)

      this is not only one time, very random but frequent. what is a problem?

      • innodb_buffer_pool_size enough to hit rate over 99%
      • max_heap_table_size = tmp_table_size = 1G that only less than 0.1% of spill rate.
      • but many queries has hint SQL_SMALL_RESULT
      • Windows 11
      • System has 20 or more free space whihc is not reserved.
      • uncommited free paging space still over 80GB.

      So non sense memory issue.
      why it is not use the huge free spaces?
      why it's not automatically turn into disk base temp table?
      Any workaround?

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              npdmailing@gmail.com Mitchell Lee
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.