[MDEV-16492] maria.insert_select-7314 failed in buildbot with timeout Created: 2018-06-14  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Aria, Tests
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: Elena Stepanova Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64/builds/3116

10.1 519060da452925a2f8274b1d30c75188

maria.insert_select-7314                 w1 [ fail ]  timeout after 900 seconds
        Test ended at 2018-05-22 06:36:35
 
Test case timeout after 900 seconds
 
== /dev/shm/var/1/log/insert_select-7314.log == 
drop table if exists t1;
Warnings:
Note	1051	Unknown table 'test.t1'
#
# MDEV-7314
# Concurrent "INSERT INTO table SELECT MAX(id)+1 FROM table" are
# hitting deadlocks on Aria tables using ROW_FORMAT=PAGE
#
create table t1 (pk int primary key) engine=Aria;
insert into t1 values (1);
insert into t1 select sleep(2)+1 from t1;
insert into t1 select 2 from t1;



 Comments   
Comment by Marko Mäkelä [ 2019-09-23 ]

Cross-reference reports this for 10.2, 10.3, 10.4, and 10.5 as well.

Generated at Thu Feb 08 08:29:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.