[MDEV-13406] tokudb.locks-select-update-1 failed in buildbot with lock wait timeout Created: 2017-07-30  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - TokuDB, Tests
Affects Version/s: 5.5, 10.0
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

okudb.locks-select-update-1             w1 [ fail ]
        Test ended at 2017-05-19 23:57:39
 
CURRENT_TEST: tokudb.locks-select-update-1
mysqltest: At line 27: query 'reap' failed: 1205: Lock wait timeout exceeded; try restarting transaction
 
The result from queries just before the failure was:
SET DEFAULT_STORAGE_ENGINE='tokudb';
drop table if exists t;
create table t (a int primary key, b int);
insert into t values (1,0);
set session transaction isolation level repeatable read;
begin;
select * from t where a=1 for update;
a	b
1	0
update t set b=b+1 where a=1;
set session transaction isolation level repeatable read;
begin;
select * from t where a=1 for update;
commit;

(no logs available)

The failure is very rare.


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