[MDEV-33106] innodb.innodb-lock-inherit-read_commited fails with timeout Created: 2023-12-21  Updated: 2023-12-21

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests
Affects Version/s: 10.5, 10.6
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Vladislav Vaintroub Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

According to cross-reference, this test fails rather often on buildbot.

First occurence, according to cross-reference was 2023-12-07 05:58:09
Typical 10.5 error - "timeout after 900 seconds", ánd in 10.6 error "debug sync point timeout"

Example of failing build https://buildbot.mariadb.net/buildbot/builders/kvm-fulltest2-protocols/builds/1305

Sample output from failure

innodb.innodb-lock-inherit-read_commited 'innodb' w2 [ fail ]  timeout after 900 seconds
        Test ended at 2023-12-19 15:42:20
 
Test case timeout after 900 seconds
 
== /mnt/buildbot/build/mariadb-10.5.24/mysql-test/var/2/log/innodb-lock-inherit-read_commited.log == 
con1_locks_done WAIT_FOR con1_go';
SET debug_sync = 'ha_commit_trans_after_acquire_commit_lock SIGNAL
con1_insert_done WAIT_FOR con1_finish';
REPLACE INTO t1 VALUES (1,2);
connect con2,localhost,root,,;
SET debug_sync = 'now WAIT_FOR con1_locks_done';
SET debug_sync = 'lock_wait_suspend_thread_enter SIGNAL con2_blocked
WAIT_FOR con2_go';
SET debug_sync = 'ha_commit_trans_after_acquire_commit_lock
WAIT_FOR con2_finish';
SET debug_sync = 'ib_after_row_insert SIGNAL con2_insert_done';
REPLACE INTO t1 VALUES (1,3);
connection default;
SET debug_sync = 'now WAIT_FOR con2_blocked';
connection purge_control;
COMMIT;
disconnect purge_control;
connection default;
InnoDB		0 transactions not purged
SET debug_sync = 'now SIGNAL con2_go WAIT_FOR con2_insert_done';
 
 
 - saving '/mnt/buildbot/build/mariadb-10.5.24/mysql-test/var/2/log/innodb.innodb-lock-inherit-read_commited-innodb/' to '/mnt/buildbot/build/mariadb-10.5.24/mysql-test/var/log/innodb.innodb-lock-inherit-read_commited-innodb/'
 
Retrying test innodb.innodb-lock-inherit-read_commited, attempt(2/3)...


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