[#MDEV-29157] ER_OUT_OF_RESOURCES (Out of memory) upon simple query from small S3 table

[MDEV-29157] ER_OUT_OF_RESOURCES (Out of memory) upon simple query from small S3 table Created: 2022-07-22 Updated: 2023-11-28
Status:	Open
Project:	MariaDB Server
Component/s:	Storage Engine - S3
Affects Version/s:	10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s:	10.5, 10.6

Type:

Bug

Priority:

Major

Reporter:

Elena Stepanova

Assignee:

Michael Widenius

Resolution:

Unresolved

Votes:

Labels:

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.

Generated at Thu Feb 08 10:06:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.