[MDEV-18666] galera_sr.galera_sr_kill_all_norecovery: Test failure: query 'let $_server_id= `SELECT @@server_id`' failed: 1205: Lock wait timeout exceeded Created: 2019-02-20  Updated: 2020-12-08  Resolved: 2019-08-21

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.3
Fix Version/s: 10.4.7

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Daniele Sciascia
Resolution: Fixed Votes: 0
Labels: galera, galera_4
Environment:

OS: CentOS Linux release 7.6.1810 (Core).

Attachments: Zip Archive 190220_galera_sr.galera_sr_kill_all_norecovery.zip     Text File 190220_galera_sr.galera_sr_kill_all_norecovery_stdout_desktop.log    
Issue Links:
Relates
relates to MDEV-17046 Galera 4: Streaming replication Closed

 Description   

MariaDB Server: 10.4.3-MariaDB-- built from sources, commit 764429271dc94e5af08706dd0ac6fb962c15726d .
Galera4 lib: debug built from sources, commit 9cdbeb86c330b808571b14270e6428accb899c58.

Run: 

./mtr galera_sr.galera_sr_kill_all_norecovery --force --max-test-fail=0 --repeat=3
 
./mtr --suite galera_sr --force --big-test --max-test-fail=0

stdout.log: (the whole file is attached: 190220_galera_sr.galera_sr_kill_all_norecovery_stdout_desktop.log)

galera_sr.galera_sr_kill_all_norecovery 'innodb' [ fail ]
 
 
 
mysqltest: In included file "./include/kill_galera.inc": 
included from /home/stepan/galera/git/10.4/server/mysql-test/suite/galera_sr/t/galera_sr_kill_all_norecovery.test at line 32:
 
At line 4: query 'let $_server_id= `SELECT @@server_id`' failed: 1205: Lock wait timeout exceeded; try restarting transaction

See also attached 190220_galera_sr.galera_sr_kill_all_norecovery.zip.

Note: This test failed on a HDD desktop, but passed on a SSD laptop.

 Comments   
Comment by Stepan Patryshev (Inactive) [ 2019-04-01 ]

Last time it failed on my machine on 15.03.2019.

Comment by Daniele Sciascia [ 2019-08-21 ]

@Stepan Patryshev can this issue be closed?
A pull request fixing this has been submitted and merged long time ago.

Comment by Stepan Patryshev (Inactive) [ 2019-08-21 ]

Closing it as fixed.

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