Details
Description
galera_3nodes.galera_vote_rejoin_mysqldump failed on BB 10.5 CS and BB 10.6 CS: "mysql_shutdown failed".
It seems to be a sporadic issue.
[stdio.log|url2log]:
10.5.9, 8677c14e65f436db00be5aedb1f644fcffc70f7e, kvm-zyp-opensuse150-amd64 |
galera_3nodes.galera_vote_rejoin_mysqldump 'innodb' w1 [ fail ]
|
Test ended at 2020-12-11 17:06:52
|
|
CURRENT_TEST: galera_3nodes.galera_vote_rejoin_mysqldump
|
mysqltest: In included file "./include/shutdown_mysqld.inc":
|
included from ./include/restart_mysqld.inc at line 10:
|
included from /usr/share/mysql-test/suite/galera_3nodes/t/galera_vote_rejoin_mysqldump.test at line 78:
|
At line 50: mysql_shutdown failed
|
|
The result from queries just before the failure was:
|
< snip >
|
expect_Primary
|
Primary
|
connection node_2;
|
SET SESSION wsrep_on=OFF;
|
SELECT VARIABLE_VALUE AS expect_Disconnected FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
|
expect_Disconnected
|
Disconnected
|
SET SESSION wsrep_on=ON;
|
SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
|
expect_Primary
|
Primary
|
connection node_1;
|
SHOW CREATE TABLE t1;
|
Table Create Table
|
t1 CREATE TABLE `t1` (
|
`f1` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1
|
connection node_2;
|
SET SESSION wsrep_on=OFF;
|
SET SESSION wsrep_on=ON;
|
|
More results from queries before failure can be found in /dev/shm/var/1/log/galera_vote_rejoin_mysqldump.log
|
|
- saving '/dev/shm/var/1/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/' to '/dev/shm/var/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/'
|
|
Retrying test galera_3nodes.galera_vote_rejoin_mysqldump, 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.galera_vote_rejoin_mysqldump
|
|
2020-12-11 17:06:48 2 [ERROR] WSREP: Vote 0 (success) on 3a0023f3-3bd3-11eb-827e-fb59270527e2:7 is inconsistent with group. Leaving cluster.
|
|
Attachments
Issue Links
- blocks
-
MDEV-22122 Galera test failures on 10.5
-
- Open
-
-
MDEV-30172 Galera test case cleanup
-
- Stalled
-
- relates to
-
MDEV-23595 galera_3nodes.galera_wsrep_schema MTR failed: mysql_shutdown failed
-
- Closed
-
-
MDEV-23605 galera_3nodes.galera_vote_rejoin_mysqldump MTR failed: WSREP_SST: [ERROR] rsync daemon port '16008' has been taken
-
- Closed
-
-
MDEV-24097 galera_3nodes suite tests in MTR sporadically fails: Failed to start mysqld or mysql_shutdown failed
-
- Closed
-
-
MDEV-32635 galera_shutdown_nonprim: mysql_shutdown failed
-
- Closed
-
-
MDEV-33786 galera_3nodes.galera_vote_rejoin_mysqldump mysql_shutdown failed at line 85:
-
- Open
-
-
MDEV-26499 galera_3nodes.galera_ipv6_mysqldump MTR failed: mysql_shutdown failed
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Link | This issue blocks MDEV-17728 [ MDEV-17728 ] |
Attachment | MDEV-24481_105_logs_201211.zip [ 55452 ] |
Description |
galera_3nodes.galera_vote_rejoin_mysqldump failed on [BB 10.5 CS|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-opensuse150-amd64/builds/4710] and [BB 10.6 CS|http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos8-amd64/builds/2023]: "mysql_shutdown failed".
It seems to be a sporadic issue. [stdio.log|url2log]: {code:title=10.5.9, 8677c14e65f436db00be5aedb1f644fcffc70f7e, kvm-zyp-opensuse150-amd64} galera_3nodes.galera_vote_rejoin_mysqldump 'innodb' w1 [ fail ] Test ended at 2020-12-11 17:06:52 CURRENT_TEST: galera_3nodes.galera_vote_rejoin_mysqldump mysqltest: In included file "./include/shutdown_mysqld.inc": included from ./include/restart_mysqld.inc at line 10: included from /usr/share/mysql-test/suite/galera_3nodes/t/galera_vote_rejoin_mysqldump.test at line 78: At line 50: mysql_shutdown failed The result from queries just before the failure was: < snip > expect_Primary Primary connection node_2; SET SESSION wsrep_on=OFF; SELECT VARIABLE_VALUE AS expect_Disconnected FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'; expect_Disconnected Disconnected SET SESSION wsrep_on=ON; SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'; expect_Primary Primary connection node_1; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f1` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 connection node_2; SET SESSION wsrep_on=OFF; SET SESSION wsrep_on=ON; More results from queries before failure can be found in /dev/shm/var/1/log/galera_vote_rejoin_mysqldump.log - saving '/dev/shm/var/1/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/' to '/dev/shm/var/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/' Retrying test galera_3nodes.galera_vote_rejoin_mysqldump, 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.galera_vote_rejoin_mysqldump 2020-12-11 17:06:48 2 [ERROR] WSREP: Vote 0 (success) on 3a0023f3-3bd3-11eb-827e-fb59270527e2:7 is inconsistent with group. Leaving cluster. {code} |
galera_3nodes.galera_vote_rejoin_mysqldump failed on [BB 10.5 CS|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-opensuse150-amd64/builds/4710] and [BB 10.6 CS|http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos8-amd64/builds/2023]: "mysql_shutdown failed".
It seems to be a sporadic issue. [stdio.log|url2log]: {code:title=10.5.9, 8677c14e65f436db00be5aedb1f644fcffc70f7e, kvm-zyp-opensuse150-amd64} galera_3nodes.galera_vote_rejoin_mysqldump 'innodb' w1 [ fail ] Test ended at 2020-12-11 17:06:52 CURRENT_TEST: galera_3nodes.galera_vote_rejoin_mysqldump mysqltest: In included file "./include/shutdown_mysqld.inc": included from ./include/restart_mysqld.inc at line 10: included from /usr/share/mysql-test/suite/galera_3nodes/t/galera_vote_rejoin_mysqldump.test at line 78: At line 50: mysql_shutdown failed The result from queries just before the failure was: < snip > expect_Primary Primary connection node_2; SET SESSION wsrep_on=OFF; SELECT VARIABLE_VALUE AS expect_Disconnected FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'; expect_Disconnected Disconnected SET SESSION wsrep_on=ON; SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'; expect_Primary Primary connection node_1; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `f1` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 connection node_2; SET SESSION wsrep_on=OFF; SET SESSION wsrep_on=ON; More results from queries before failure can be found in /dev/shm/var/1/log/galera_vote_rejoin_mysqldump.log - saving '/dev/shm/var/1/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/' to '/dev/shm/var/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/' Retrying test galera_3nodes.galera_vote_rejoin_mysqldump, 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.galera_vote_rejoin_mysqldump 2020-12-11 17:06:48 2 [ERROR] WSREP: Vote 0 (success) on 3a0023f3-3bd3-11eb-827e-fb59270527e2:7 is inconsistent with group. Leaving cluster. {code} *[Server logs|^ |
Link |
This issue relates to |
Link |
This issue relates to |
Link |
This issue relates to |
Assignee | Stepan Patryshev [ stepan.patryshev ] | Jan Lindström [ jplindst ] |
Link | This issue blocks MDEV-17728 [ MDEV-17728 ] |
Link | This issue blocks MDEV-22122 [ MDEV-22122 ] |
Fix Version/s | 10.6 [ 24028 ] |
Workflow | MariaDB v3 [ 117346 ] | MariaDB v4 [ 142453 ] |
Assignee | Jan Lindström [ jplindst ] | Julius Goryavsky [ sysprg ] |
Link |
This issue relates to |
Link |
This issue relates to |
Link | This issue blocks MDEV-30172 [ MDEV-30172 ] |
Priority | Major [ 3 ] | Critical [ 2 ] |
Assignee | Julius Goryavsky [ sysprg ] | Jan Lindström [ JIRAUSER53125 ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Assignee | Jan Lindström [ JIRAUSER53125 ] | Julius Goryavsky [ sysprg ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
issue.field.resolutiondate | 2023-12-21 09:41:37.0 | 2023-12-21 09:41:36.799 |
Fix Version/s | 10.5.24 [ 29517 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Fix Version/s | 10.6.17 [ 29518 ] | |
Fix Version/s | 10.11.7 [ 29519 ] | |
Fix Version/s | 11.0.5 [ 29520 ] | |
Fix Version/s | 11.1.4 [ 29024 ] | |
Fix Version/s | 11.2.3 [ 29521 ] |
Link | This issue relates to MDEV-33786 [ MDEV-33786 ] |
https://github.com/MariaDB/server/pull/2945