[MDEV-21667] Galera test failure on MW-336 - Jira

Details

Type: Task
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Fix Version/s: 10.5.1, 10.2.32, 10.3.23, 10.4.13
Component/s: Galera, Tests
Labels:
None

Description

galera.MW-336 'innodb'                   w2 [ fail ]

        Test ended at 2020-02-05 09:58:15

CURRENT_TEST: galera.MW-336

--- /usr/share/mysql/mysql-test/suite/galera/r/MW-336.result	2020-02-05 07:41:16.000000000 -0500

+++ /dev/shm/var/2/log/MW-336.reject	2020-02-05 09:58:15.531334676 -0500

@@ -12,6 +12,40 @@

 # Set slave threads to 10 step 2

 SET GLOBAL wsrep_slave_threads = 20;

 # Set slave threads to 20

+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 20 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';

+SELECT COUNT(*), 20 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;

+COUNT(*)	EXPECTED_VALUE

+21	20

+Id	User	Host	db	Command	Time	State	Info	Progress

+1	system user		NULL	Sleep	37	wsrep aborter idle	NULL	0.000

+3	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000

+4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000

+15	root	localhost	test	Sleep	32		NULL	0.000

+16	root	localhost:54312	test	Query	0	Init	show processlist	0.000

+17	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+18	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+20	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+21	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+19	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+22	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+24	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+23	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+25	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+33	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+34	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+35	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+36	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+37	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+26	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+27	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+28	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+30	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+32	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+29	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

+31	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000

 SET GLOBAL wsrep_slave_threads = 1;

 connection node_2;

 INSERT INTO t1 VALUES (1);

@@ -30,6 +64,30 @@

 COUNT(*)

 # Set slave threads to 10 step 3

+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';

+SELECT COUNT(*), 10 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;

+COUNT(*)	EXPECTED_VALUE

+11	10

+Id	User	Host	db	Command	Time	State	Info	Progress

+1	system user		NULL	Sleep	67	wsrep aborter idle	NULL	0.000

+3	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000

+4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000

+7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000

+15	root	localhost	test	Sleep	63		NULL	0.000

+16	root	localhost:54312	test	Query	0	Init	show processlist	0.000

+34	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+35	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+36	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+37	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+26	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+27	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+28	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+30	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+32	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+29	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

+31	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000

 connection node_2;

 INSERT INTO t1 VALUES (11);

 INSERT INTO t1 VALUES (12);

mysqltest: Result length mismatch

 - saving '/dev/shm/var/2/log/galera.MW-336-innodb/' to '/dev/shm/var/log/galera.MW-336-innodb/'

Retrying test galera.MW-336, attempt(2/3)...

Attachments

Activity

Ascending order - Click to sort in descending order

Jan Lindström (Inactive) created issue - 2020-02-05 06:02

Jan Lindström (Inactive) made changes - 2020-02-05 06:02

Field	Original Value	New Value
Status	Open [ 1 ]	In Progress [ 3 ]

Stepan Patryshev (Inactive) made changes - 2020-02-05 14:53

Link

This issue blocks ~~MDEV-19937~~ [ ~~MDEV-19937~~ ]

Stepan Patryshev (Inactive) made changes - 2020-02-05 14:54

Link

This issue blocks MENT-565 [ MENT-565 ]

Stepan Patryshev (Inactive) made changes - 2020-02-05 14:56

Priority

Major [ 3 ]

Critical [ 2 ]

Stepan Patryshev (Inactive) added a comment - 2020-02-05 14:56

Increased the priority since it fails on Azure.

Stepan Patryshev (Inactive) added a comment - 2020-02-05 14:56 Increased the priority since it fails on Azure .

Jan Lindström (Inactive) made changes - 2020-02-07 07:50

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Duplicate [ 3 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Jan Lindström (Inactive) made changes - 2020-02-07 07:50

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s	N/A [ 14700 ]

Jan Lindström (Inactive) made changes - 2020-02-07 07:51

Resolution	Duplicate [ 3 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Jan Lindström (Inactive) made changes - 2020-02-07 07:51

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2020-02-07 07:52

Description

We take LOCK_wsrep_slave_threads while already holding it.

{noformat}
galera.MW-336 'innodb' w2 [ fail ]
Test ended at 2020-02-05 09:58:15

CURRENT_TEST: galera.MW-336
--- /usr/share/mysql/mysql-test/suite/galera/r/MW-336.result 2020-02-05 07:41:16.000000000 -0500
+++ /dev/shm/var/2/log/MW-336.reject 2020-02-05 09:58:15.531334676 -0500
@@ -12,6 +12,40 @@
# Set slave threads to 10 step 2
SET GLOBAL wsrep_slave_threads = 20;
# Set slave threads to 20
+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 20 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
+SELECT COUNT(*), 20 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;
+COUNT(*) EXPECTED_VALUE
+21 20
+Id User Host db Command Time State Info Progress
+1 system user NULL Sleep 37 wsrep aborter idle NULL 0.000
+3 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000
+4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
+6 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
+5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
+7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000
+15 root localhost test Sleep 32 NULL 0.000
+16 root localhost:54312 test Query 0 Init show processlist 0.000
+17 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+18 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+20 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+21 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+19 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+22 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+24 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+23 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+25 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+33 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+34 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+35 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+36 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+37 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+26 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+27 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+28 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+30 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+32 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+29 system user NULL Sleep 30 wsrep applier idle NULL 0.000
+31 system user NULL Sleep 30 wsrep applier idle NULL 0.000
SET GLOBAL wsrep_slave_threads = 1;
connection node_2;
INSERT INTO t1 VALUES (1);
@@ -30,6 +64,30 @@
COUNT(*)
11
# Set slave threads to 10 step 3
+Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
+SELECT COUNT(*), 10 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;
+COUNT(*) EXPECTED_VALUE
+11 10
+Id User Host db Command Time State Info Progress
+1 system user NULL Sleep 67 wsrep aborter idle NULL 0.000
+3 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000
+4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
+6 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
+5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
+7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000
+15 root localhost test Sleep 63 NULL 0.000
+16 root localhost:54312 test Query 0 Init show processlist 0.000
+34 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+35 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+36 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+37 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+26 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+27 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+28 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+30 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+32 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+29 system user NULL Sleep 61 wsrep applier idle NULL 0.000
+31 system user NULL Sleep 61 wsrep applier idle NULL 0.000
connection node_2;
INSERT INTO t1 VALUES (11);
INSERT INTO t1 VALUES (12);

mysqltest: Result length mismatch

- saving '/dev/shm/var/2/log/galera.MW-336-innodb/' to '/dev/shm/var/log/galera.MW-336-innodb/'

Retrying test galera.MW-336, attempt(2/3)...
{noformat}

Jan Lindström (Inactive) made changes - 2020-02-11 08:41

issue.field.resolutiondate

2020-02-11 08:41:22.0

2020-02-11 08:41:22.233

Jan Lindström (Inactive) made changes - 2020-02-11 08:41

Fix Version/s		10.5.1 [ 24029 ]
Fix Version/s		10.2.32 [ 24221 ]
Fix Version/s		10.3.23 [ 24222 ]
Fix Version/s		10.4.13 [ 24223 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Stepan Patryshev (Inactive) made changes - 2020-02-13 10:43

Link

This issue blocks ~~MDEV-19937~~ [ ~~MDEV-19937~~ ]

Stepan Patryshev (Inactive) made changes - 2020-02-13 10:43

Link

This issue blocks MENT-565 [ MENT-565 ]

Sergei Golubchik made changes - 2021-12-06 21:24

Workflow

MariaDB v3 [ 103694 ]

MariaDB v4 [ 134177 ]

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Jan Lindström (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2020-02-05 06:02

Updated:: 2020-02-13 10:43

Resolved:: 2020-02-11 08:41

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration