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

      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

            Assignee:
            monty Michael Widenius
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.