[MDEV-23591] galera_3nodes.GCF-354 MTR failed: 1047: WSREP has not yet prepared node for application use - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5.6
Fix Version/s: 10.5.7, 10.6.0, 10.7.1, 10.8.1, 10.9.1, 10.10.1, 10.11.1, 11.0.1
Component/s: Galera, Tests
Labels:
None
Environment:
kvm-rpm-centos74-aarch64

Description

galera_3nodes.GCF-354 failed on BB 10.5: "query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use".

stdio.log:

10.5.6 97a4a3872e5037b8db1e8c27152740190330ab9c
galera_3nodes.GCF-354 'innodb' w1 [ fail ]
Test ended at 2020-08-26 15:20:24

CURRENT_TEST: galera_3nodes.GCF-354
mysqltest: At line 36: query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use

The result from queries just before the failure was:
< snip >
SET wsrep_on=OFF;
CREATE TABLE test.t1 (f1 INTEGER);
connection node_1;
CREATE TABLE test.t1 (f1 INTEGER);
Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'
Id User Host db Command Time State Info Progress
2 system user NULL Sleep 42 wsrep aborter idle NULL 0.000
1 system user NULL Sleep 42 closing tables NULL 0.000
10 root localhost test Sleep 33 NULL 0.000
11 root localhost:59516 test Query 0 starting show full processlist 0.000
SHOW STATUS LIKE 'wsrep_cluster_status';
Variable_name Value
wsrep_cluster_status non-Primary
DROP TABLE test.t1;

Attachments

Issue Links

blocks

MDEV-22122 Galera test failures on 10.5

Open

relates to

MDEV-23587 galera_3nodes.galera_var_dirty_reads2 MTR failed: 1047: WSREP has not yet prepared node for application use

Closed

Activity

Ascending order - Click to sort in descending order

Stepan Patryshev (Inactive) created issue - 2020-08-26 17:34

Stepan Patryshev (Inactive) made changes - 2020-08-26 17:34

Field	Original Value	New Value
Link		This issue blocks MDEV-22122 [ MDEV-22122 ]

Stepan Patryshev (Inactive) made changes - 2020-08-26 17:34

Link

This issue relates to ~~MDEV-23587~~ [ ~~MDEV-23587~~ ]

Stepan Patryshev (Inactive) made changes - 2020-08-26 17:35

Assignee

Stepan Patryshev [ stepan.patryshev ]

Jan Lindström [ jplindst ]

Jan Lindström (Inactive) made changes - 2020-09-14 05:35

Status

Open [ 1 ]

In Progress [ 3 ]

Jan Lindström (Inactive) added a comment - 2020-09-14 08:17

galera_3nodes.GCF-354 'innodb'           w1 [ fail ]

        Test ended at 2020-09-13 11:40:42

CURRENT_TEST: galera_3nodes.GCF-354

mysqltest: At line 36: query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use

The result from queries just before the failure was:

< snip >

SET wsrep_on=OFF;

CREATE TABLE test.t1 (f1 INTEGER);

connection node_1;

CREATE TABLE test.t1 (f1 INTEGER);

Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'

Id	User	Host	db	Command	Time	State	Info	Progress

1	system user		NULL	Sleep	54	closing tables	NULL	0.000

2	system user		NULL	Sleep	54	wsrep aborter idle	NULL	0.000

10	root	localhost	test	Sleep	33		NULL	0.000

11	root	localhost:37284	test	Query	0	starting	show full processlist	0.000

SHOW STATUS LIKE 'wsrep_cluster_status';

Variable_name	Value

wsrep_cluster_status	non-Primary

DROP TABLE test.t1;

More results from queries before failure can be found in /dev/shm/var/1/log/GCF-354.log

 - saving '/dev/shm/var/1/log/galera_3nodes.GCF-354-innodb/' to '/dev/shm/var/log/galera_3nodes.GCF-354-innodb/'

Retrying test galera_3nodes.GCF-354, attempt(2/3)...

worker[1] > Restart  - not started

worker[1] > Restart  - not started

worker[1] > Restart  - not started

***Warnings generated in error logs during shutdown after running tests: galera_3nodes.GCF-354

2020-09-13 11:40:11 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on d3acd8c9-f5b5-11ea-a0b0-32133b7e7efe:4

2020-09-13 11:40:11 1 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on d3acd8c9-f5b5-11ea-a0b0-32133b7e7efe:4

galera_3nodes.galera_safe_to_bootstrap 'innodb' w2 [ pass ]  36587

galera_3nodes.GCF-354 'innodb'           w1 [ retry-fail ]

        Test ended at 2020-09-13 11:41:21

CURRENT_TEST: galera_3nodes.GCF-354

mysqltest: At line 36: query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use

The result from queries just before the failure was:

< snip >

SET wsrep_on=OFF;

CREATE TABLE test.t1 (f1 INTEGER);

connection node_1;

CREATE TABLE test.t1 (f1 INTEGER);

Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'

Id	User	Host	db	Command	Time	State	Info	Progress

1	system user		NULL	Sleep	38	wsrep aborter idle	NULL	0.000

2	system user		NULL	Sleep	38	closing tables	NULL	0.000

10	root	localhost	test	Sleep	32		NULL	0.000

11	root	localhost:37518	test	Query	0	starting	show full processlist	0.000

SHOW STATUS LIKE 'wsrep_cluster_status';

Variable_name	Value

wsrep_cluster_status	non-Primary

DROP TABLE test.t1;

More results from queries before failure can be found in /dev/shm/var/1/log/GCF-354.log

Jan Lindström (Inactive) added a comment - 2020-09-14 08:17 galera_3nodes.GCF-354 'innodb' w1 [ fail ] Test ended at 2020-09-13 11:40:42 CURRENT_TEST: galera_3nodes.GCF-354 mysqltest: At line 36: query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use The result from queries just before the failure was: < snip > SET wsrep_on=OFF; CREATE TABLE test.t1 (f1 INTEGER); connection node_1; CREATE TABLE test.t1 (f1 INTEGER); Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status' Id User Host db Command Time State Info Progress 1 system user NULL Sleep 54 closing tables NULL 0.000 2 system user NULL Sleep 54 wsrep aborter idle NULL 0.000 10 root localhost test Sleep 33 NULL 0.000 11 root localhost:37284 test Query 0 starting show full processlist 0.000 SHOW STATUS LIKE 'wsrep_cluster_status'; Variable_name Value wsrep_cluster_status non-Primary DROP TABLE test.t1; More results from queries before failure can be found in /dev/shm/var/1/log/GCF-354.log - saving '/dev/shm/var/1/log/galera_3nodes.GCF-354-innodb/' to '/dev/shm/var/log/galera_3nodes.GCF-354-innodb/' Retrying test galera_3nodes.GCF-354, attempt(2/3)... worker[1] > Restart - not started worker[1] > Restart - not started worker[1] > Restart - not started ***Warnings generated in error logs during shutdown after running tests: galera_3nodes.GCF-354 2020-09-13 11:40:11 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on d3acd8c9-f5b5-11ea-a0b0-32133b7e7efe:4 2020-09-13 11:40:11 1 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on d3acd8c9-f5b5-11ea-a0b0-32133b7e7efe:4 galera_3nodes.galera_safe_to_bootstrap 'innodb' w2 [ pass ] 36587 galera_3nodes.GCF-354 'innodb' w1 [ retry-fail ] Test ended at 2020-09-13 11:41:21 CURRENT_TEST: galera_3nodes.GCF-354 mysqltest: At line 36: query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use The result from queries just before the failure was: < snip > SET wsrep_on=OFF; CREATE TABLE test.t1 (f1 INTEGER); connection node_1; CREATE TABLE test.t1 (f1 INTEGER); Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status' Id User Host db Command Time State Info Progress 1 system user NULL Sleep 38 wsrep aborter idle NULL 0.000 2 system user NULL Sleep 38 closing tables NULL 0.000 10 root localhost test Sleep 32 NULL 0.000 11 root localhost:37518 test Query 0 starting show full processlist 0.000 SHOW STATUS LIKE 'wsrep_cluster_status'; Variable_name Value wsrep_cluster_status non-Primary DROP TABLE test.t1; More results from queries before failure can be found in /dev/shm/var/1/log/GCF-354.log

Jan Lindström (Inactive) made changes - 2020-09-14 08:17

Assignee

Jan Lindström [ jplindst ]

Teemu Ollakka [ teemu.ollakka ]

Jan Lindström (Inactive) made changes - 2020-09-14 08:48

Assignee

Teemu Ollakka [ teemu.ollakka ]

Jan Lindström [ jplindst ]

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

Workflow

MariaDB v3 [ 112966 ]

MariaDB v4 [ 144569 ]

Jan Lindström made changes - 2023-04-11 05:54

Assignee

Jan Lindström [ jplindst ]

Julius Goryavsky [ sysprg ]

Julius Goryavsky added a comment - 2023-04-11 06:56

Already fixed and merged with head revisions

Julius Goryavsky added a comment - 2023-04-11 06:56 Already fixed and merged with head revisions

Julius Goryavsky made changes - 2023-04-11 06:56

issue.field.resolutiondate

2023-04-11 06:56:48.0

2023-04-11 06:56:48.828

Julius Goryavsky made changes - 2023-04-11 06:56

Fix Version/s		10.11.1 [ 28454 ]
Fix Version/s		11.0.1 [ 28548 ]
Fix Version/s		10.10.1 [ 27913 ]
Fix Version/s		10.9.1 [ 27114 ]
Fix Version/s		10.8.1 [ 26815 ]
Fix Version/s		10.7.1 [ 26120 ]
Fix Version/s		10.6.0 [ 24431 ]
Fix Version/s		10.5.7 [ 25019 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

People

Assignee:: Julius Goryavsky

Reporter:: Stepan Patryshev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2020-08-26 17:34

Updated:: 2023-04-11 06:56

Resolved:: 2023-04-11 06:56

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration