[MDEV-22727] Hang on optimized builds on CREATE USER attempt, Aria related Created: 2020-05-27  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System, Storage Engine - Aria
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: Roel Van de Paar Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None


 Description    

USE test;
 
SET GLOBAL aria_group_commit=1;
 
SET GLOBAL aria_group_commit_interval=CAST(-1 AS UNSIGNED INT);
 
CREATE TABLE t (c INT KEY) ENGINE=Aria;
 
CREATE USER 'a' IDENTIFIED BY 'a';

Will cause 10.5.2, 10.5.3, and 10.5.4 8569dac1ec9f6853a0b2f3ea9bcbda67644ead24 (dbg+opt) as well as 10.4.14 ea7830eef48333e28f98a9b91f05a95735b465a3 (dbg+opt) to hang. 10.1, 10.2 and 10.3 will also hang, but only on shutdown attempt after the testcase.

 Comments   
Comment by Roel Van de Paar [ 2020-05-27 ]

Propose setting a reasonable upper maximum for aria_group_commit_interval.

Comment by Roel Van de Paar [ 2020-05-27 ]

10.4 and 10.5 will also subsequently hang on shutdown, even after CTRL+C was used to break out of the the CLI.

Comment by Alexander Barkov [ 2020-06-10 ]

monty, can you please check this?

Generated at Thu Feb 08 09:17:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.