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

Misleading ERROR message "[ERROR] mysqld.exe: Out of memory (Needed 134217696 bytes)" - no context of causing

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • N/A
    • Server
    • None
    • Not for Release Notes

    Description

      There could be a lots of OOM messages.
      but one of message very sure is
      "[ERROR] mysqld.exe: Out of memory (Needed 134217696 bytes)"
      message when MEMORY table engine failed to get allocated space when row inserts.

      • Set tmp table size consies for a test
      • Create a multiple MEMORY tables with fields(single field is okay)
      • Start to insert any of dummy data for each MEMORY tables.
      • You will soon see the "[ERROR] mysqld.exe: Out of memory (Needed 134217696 bytes)" kind message which so confuse since it occurs by insert operation.
        It lead DB Operator make unecessory config tweeking for a long time.
        Make messsage more clearer like.

      "Memory table(xxxxx) reserved area allocation failed." not just oom.

      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:
                Resolved:

                Git Integration

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