[MDEV-32772] Unexpected "aria_sort_buffer_size is too small" error with aria_repair_threads>1 Created: 2023-11-10  Updated: 2023-11-10

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Aria
Affects Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2
Fix Version/s: 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None


 Description   

--source include/have_sequence.inc
 
SET GLOBAL aria_repair_threads= 2;
 
CREATE TABLE t (a INT, b INT, c VARCHAR(2000), PRIMARY KEY (a), KEY(b), KEY(c)) ENGINE=Aria ROW_FORMAT=DYNAMIC;
INSERT INTO t SELECT seq, seq, 'x' FROM seq_1_to_100;
ALTER TABLE t MODIFY a BIGINT;
select @@aria_sort_buffer_size;
 
# Cleanup
DROP TABLE t;

10.5 ea0b1ccd

select @@aria_sort_buffer_size;
@@aria_sort_buffer_size
268434432
DROP TABLE t;
bug.aria2                                [ fail ]  Found warnings/errors in server log file!
        Test ended at 2023-11-11 01:06:08
line
2023-11-11  1:06:08 0 [ERROR] mariadbd: aria_sort_buffer_size is too small. Current aria_sort_buffer_size: 21845  rows: 101  sort_length: 2010

Something goes wrong there, as aria_sort_buffer_size=256M, but the error claims it to be 21845.


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