[MDEV-17585] wsrep.variables failed in buildbot with deadlock on CREATE USER Created: 2018-10-31  Updated: 2020-12-07  Resolved: 2020-10-12

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.1, 10.2.30, 10.3.21
Fix Version/s: 10.2.35, 10.3.26, 10.4.16, 10.5.7, 10.6.0

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-20581 Crash on wsrep.variables test case Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-x86/builds/7149

wsrep.variables                          w1 [ fail ]
        Test ended at 2018-10-30 10:53:07
 
CURRENT_TEST: wsrep.variables
mysqltest: At line 132: query 'create user test@localhost' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
 
The result from queries just before the failure was:
< snip >
gcomm://
SHOW STATUS LIKE 'threads_connected';
Variable_name	Value
Threads_connected	1
SHOW STATUS LIKE 'wsrep_thread_count';
Variable_name	Value
wsrep_thread_count	2
 
SET @wsrep_slave_threads_saved= @@global.wsrep_slave_threads;
SET GLOBAL wsrep_slave_threads= 10;
# Wait for applier threads to get created.
SHOW STATUS LIKE 'threads_connected';
Variable_name	Value
Threads_connected	1
SHOW STATUS LIKE 'wsrep_thread_count';
Variable_name	Value
wsrep_thread_count	11
set wsrep_on=0;
set wsrep_on=1;
create user test@localhost;



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-01-08 ]

Last time it failed on bb on 03.01.2020:
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/5267

10.1 1adc559370cc53ca69e225739a942287

wsrep.variables                          w2 [ fail ]
        Test ended at 2020-01-03 21:34:09
 
CURRENT_TEST: wsrep.variables
--- /usr/share/mysql/mysql-test/suite/wsrep/r/variables.result	2020-01-03 12:44:19.000000000 -0500
+++ /dev/shm/var/2/log/variables.reject	2020-01-03 21:34:09.045400914 -0500
@@ -154,7 +154,7 @@
 Threads_connected	1
 SHOW STATUS LIKE 'wsrep_thread_count';
 Variable_name	Value
-wsrep_thread_count	11
+wsrep_thread_count	9
 set wsrep_on=0;
 set wsrep_on=1;
 create user test@localhost;
 
mysqltest: Result length mismatch
 
 - saving '/dev/shm/var/2/log/wsrep.variables/' to '/dev/shm/var/log/wsrep.variables/'
 
Retrying test wsrep.variables, attempt(2/3)...
 
worker[2] > Restart  - not started

Comment by Stepan Patryshev (Inactive) [ 2020-01-15 ]

It failed also on Azure: 10.2.30-5-MariaDB-enterprise, run #20200113.1 and on 10.3.21-5-MariaDB-enterprise, run #20200104.2.

Comment by Stepan Patryshev (Inactive) [ 2020-01-15 ]

Increased the priority since it failed on Azure.

Comment by Elena Stepanova [ 2020-10-12 ]

It hasn't been merged into 10.3 yet (and obviously not into ES), so naturally it still fails there.

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