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

ER_OUT_OF_RESOURCES (Out of memory) upon simple query from small S3 table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
    • 10.5, 10.6
    • Storage Engine - S3
    • None

    Description

      Run with S3 options.

      DROP TABLE IF EXISTS t;
      CREATE TABLE t (a INT, b INT, KEY(a), KEY(b)) ENGINE=Aria;
      INSERT INTO t VALUES (0,0),(0,10),(3,10);
      ALTER TABLE t ENGINE=S3;
      SELECT * FROM t WHERE a = 99 OR b = 2;
      DROP TABLE t;
      

      10.5 8494758e

      mysqltest: At line 5: query 'SELECT * FROM t WHERE a = 99 OR b = 2' failed: 1041: Out of memory.
      

      error log

      2022-07-23  1:11:09 4 [ERROR] Got error 128 when reading table './test/t'
      

      Reproducible on 10.5+, with MinIO and AWS alike.

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            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.