[MDEV-21515] Galera test sporadic failure on galera.galera_wsrep_new_cluster: Result content mismatch - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2.31, 10.3.21, 10.4.12
Fix Version/s: 10.5.4, 10.2.33, 10.3.24, 10.4.14
Component/s: Galera, Tests
Labels:
None
Environment:
TestTarball_2 rhel-8; kvm-zyp-sles123-amd64; kvm-rpm-centos74-amd64.

Description

galera.galera_wsrep_new_cluster sporadically fails on CI 10.3.21-5 ES and bb 10.4, bb 10.2.

10.4.12 983163209d026bfd979b4298053fcbdb373efa9d
galera.galera_wsrep_new_cluster 'innodb' w2 [ fail ]
Test ended at 2020-01-08 18:23:48

CURRENT_TEST: galera.galera_wsrep_new_cluster
--- /usr/share/mysql-test/suite/galera/r/galera_wsrep_new_cluster.result 2020-01-08 15:58:08.000000000 +0000
+++ /dev/shm/var/2/log/galera_wsrep_new_cluster.reject 2020-01-08 18:23:48.421388867 +0000
@@ -8,7 +8,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-1
+0
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1
@@ -27,7 +27,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-0
+1
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1

mysqltest: Result content mismatch

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

Retrying test galera.galera_wsrep_new_cluster, attempt(2/3)...

worker[2] > Restart - not started
worker[2] > Restart - not started

Attachments

Activity

Ascending order - Click to sort in descending order

Stepan Patryshev (Inactive) created issue - 2020-01-17 12:50

Stepan Patryshev (Inactive) made changes - 2020-01-17 12:50

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

Stepan Patryshev (Inactive) made changes - 2020-01-17 12:50

Link

This issue blocks MENT-565 [ MENT-565 ]

Stepan Patryshev (Inactive) made changes - 2020-01-17 12:51

Description

galera.galera_wsrep_new_cluster sporadically fails on [Azure 10.3.21-5|https://dev.azure.com/mariadbe/MariaDB%20Enterprise/_build/results?buildId=4098&view=logs&j=94f5bb79-c84f-5a90-82a1-c3eb3e61c2d8&t=7adbd942-163b-541b-1142-86f871f98ab5&l=444], on [bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663], [bb 10.2|http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64/builds/11388].

[bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663/steps/mtr-galera/logs/stdio]:
*[stdout.log|^.txt]*:
{code:title=10.4.12-MariaDB 983163209d026bfd979b4298053fcbdb373efa9d}
galera.galera_wsrep_new_cluster 'innodb' w2 [ fail ]
Test ended at 2020-01-08 18:23:48

CURRENT_TEST: galera.galera_wsrep_new_cluster
--- /usr/share/mysql-test/suite/galera/r/galera_wsrep_new_cluster.result 2020-01-08 15:58:08.000000000 +0000
+++ /dev/shm/var/2/log/galera_wsrep_new_cluster.reject 2020-01-08 18:23:48.421388867 +0000
@@ -8,7 +8,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-1
+0
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1
@@ -27,7 +27,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-0
+1
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1

mysqltest: Result content mismatch

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

Retrying test galera.galera_wsrep_new_cluster, attempt(2/3)...

worker[2] > Restart - not started
worker[2] > Restart - not started
{code}

galera.galera_wsrep_new_cluster sporadically fails on [Azure 10.3.21-5|https://dev.azure.com/mariadbe/MariaDB%20Enterprise/_build/results?buildId=4098&view=logs&j=94f5bb79-c84f-5a90-82a1-c3eb3e61c2d8&t=7adbd942-163b-541b-1142-86f871f98ab5&l=444], on [bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663], [bb 10.2|http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64/builds/11388].

[bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663/steps/mtr-galera/logs/stdio]:
{code:title=10.4.12-MariaDB 983163209d026bfd979b4298053fcbdb373efa9d}
galera.galera_wsrep_new_cluster 'innodb' w2 [ fail ]
Test ended at 2020-01-08 18:23:48

CURRENT_TEST: galera.galera_wsrep_new_cluster
--- /usr/share/mysql-test/suite/galera/r/galera_wsrep_new_cluster.result 2020-01-08 15:58:08.000000000 +0000
+++ /dev/shm/var/2/log/galera_wsrep_new_cluster.reject 2020-01-08 18:23:48.421388867 +0000
@@ -8,7 +8,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-1
+0
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1
@@ -27,7 +27,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-0
+1
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1

mysqltest: Result content mismatch

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

Retrying test galera.galera_wsrep_new_cluster, attempt(2/3)...

worker[2] > Restart - not started
worker[2] > Restart - not started
{code}

Stepan Patryshev (Inactive) made changes - 2020-01-17 12:52

Description

galera.galera_wsrep_new_cluster sporadically fails on [Azure 10.3.21-5|https://dev.azure.com/mariadbe/MariaDB%20Enterprise/_build/results?buildId=4098&view=logs&j=94f5bb79-c84f-5a90-82a1-c3eb3e61c2d8&t=7adbd942-163b-541b-1142-86f871f98ab5&l=444], on [bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663], [bb 10.2|http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64/builds/11388].

[bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663/steps/mtr-galera/logs/stdio]:
{code:title=10.4.12-MariaDB 983163209d026bfd979b4298053fcbdb373efa9d}
galera.galera_wsrep_new_cluster 'innodb' w2 [ fail ]
Test ended at 2020-01-08 18:23:48

CURRENT_TEST: galera.galera_wsrep_new_cluster
--- /usr/share/mysql-test/suite/galera/r/galera_wsrep_new_cluster.result 2020-01-08 15:58:08.000000000 +0000
+++ /dev/shm/var/2/log/galera_wsrep_new_cluster.reject 2020-01-08 18:23:48.421388867 +0000
@@ -8,7 +8,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-1
+0
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1
@@ -27,7 +27,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-0
+1
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1

mysqltest: Result content mismatch

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

Retrying test galera.galera_wsrep_new_cluster, attempt(2/3)...

worker[2] > Restart - not started
worker[2] > Restart - not started
{code}

galera.galera_wsrep_new_cluster sporadically fails on [Azure 10.3.21-5|https://dev.azure.com/mariadbe/MariaDB%20Enterprise/_build/results?buildId=4098&view=logs&j=94f5bb79-c84f-5a90-82a1-c3eb3e61c2d8&t=7adbd942-163b-541b-1142-86f871f98ab5&l=444], on [bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663], [bb 10.2|http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64/builds/11388].

[bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663/steps/mtr-galera/logs/stdio]:
{code:title=10.4.12 983163209d026bfd979b4298053fcbdb373efa9d}
galera.galera_wsrep_new_cluster 'innodb' w2 [ fail ]
Test ended at 2020-01-08 18:23:48

CURRENT_TEST: galera.galera_wsrep_new_cluster
--- /usr/share/mysql-test/suite/galera/r/galera_wsrep_new_cluster.result 2020-01-08 15:58:08.000000000 +0000
+++ /dev/shm/var/2/log/galera_wsrep_new_cluster.reject 2020-01-08 18:23:48.421388867 +0000
@@ -8,7 +8,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-1
+0
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1
@@ -27,7 +27,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-0
+1
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1

mysqltest: Result content mismatch

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

Retrying test galera.galera_wsrep_new_cluster, attempt(2/3)...

worker[2] > Restart - not started
worker[2] > Restart - not started
{code}

Stepan Patryshev (Inactive) made changes - 2020-01-17 12:53

Assignee

Stepan Patryshev [ stepan.patryshev ]

Jan Lindström [ jplindst ]

Stepan Patryshev (Inactive) made changes - 2020-01-17 13:12

Summary

Galera test sporadic failure on galera.galera_wsrep_new_cluster

Galera test sporadic failure on galera.galera_wsrep_new_cluster: Result content mismatch

Stepan Patryshev (Inactive) made changes - 2020-01-22 09:20

Labels

disabled

Jan Lindström (Inactive) made changes - 2020-02-13 10:59

Status

Open [ 1 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2020-02-17 08:45

Fix Version/s		10.5.2 [ 24030 ]
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-18 09:30

Link

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

Stepan Patryshev (Inactive) made changes - 2020-02-18 09:31

Link

This issue blocks MENT-565 [ MENT-565 ]

Julien Fritsch made changes - 2020-03-02 16:58

Labels

disabled

Test_disabled disabled

Julien Fritsch made changes - 2020-03-02 16:59

Labels

Test_disabled disabled

Test_disabled

Stepan Patryshev (Inactive) made changes - 2020-03-02 17:58

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Stepan Patryshev (Inactive) made changes - 2020-03-02 17:59

Link

This issue blocks MENT-565 [ MENT-565 ]

Stepan Patryshev (Inactive) made changes - 2020-03-02 17:59

Link

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

Julien Fritsch made changes - 2020-03-04 14:07

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s	10.5.2 [ 24030 ]
Fix Version/s	10.2.32 [ 24221 ]
Fix Version/s	10.3.23 [ 24222 ]
Fix Version/s	10.4.13 [ 24223 ]

Stepan Patryshev (Inactive) made changes - 2020-03-04 15:07

Labels

Test_disabled

Test_disabled test_disabled_ES

Stepan Patryshev (Inactive) made changes - 2020-04-15 10:44

Description

galera.galera_wsrep_new_cluster sporadically fails on [Azure 10.3.21-5|https://dev.azure.com/mariadbe/MariaDB%20Enterprise/_build/results?buildId=4098&view=logs&j=94f5bb79-c84f-5a90-82a1-c3eb3e61c2d8&t=7adbd942-163b-541b-1142-86f871f98ab5&l=444], on [bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663], [bb 10.2|http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64/builds/11388].

[bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663/steps/mtr-galera/logs/stdio]:
{code:title=10.4.12 983163209d026bfd979b4298053fcbdb373efa9d}
galera.galera_wsrep_new_cluster 'innodb' w2 [ fail ]
Test ended at 2020-01-08 18:23:48

CURRENT_TEST: galera.galera_wsrep_new_cluster
--- /usr/share/mysql-test/suite/galera/r/galera_wsrep_new_cluster.result 2020-01-08 15:58:08.000000000 +0000
+++ /dev/shm/var/2/log/galera_wsrep_new_cluster.reject 2020-01-08 18:23:48.421388867 +0000
@@ -8,7 +8,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-1
+0
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1
@@ -27,7 +27,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-0
+1
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1

mysqltest: Result content mismatch

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

Retrying test galera.galera_wsrep_new_cluster, attempt(2/3)...

worker[2] > Restart - not started
worker[2] > Restart - not started
{code}

galera.galera_wsrep_new_cluster sporadically fails on CI 10.3.21-5 ES and [bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663], [bb 10.2|http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64/builds/11388].

[bb 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/3663/steps/mtr-galera/logs/stdio]:
{code:title=10.4.12 983163209d026bfd979b4298053fcbdb373efa9d}
galera.galera_wsrep_new_cluster 'innodb' w2 [ fail ]
Test ended at 2020-01-08 18:23:48

CURRENT_TEST: galera.galera_wsrep_new_cluster
--- /usr/share/mysql-test/suite/galera/r/galera_wsrep_new_cluster.result 2020-01-08 15:58:08.000000000 +0000
+++ /dev/shm/var/2/log/galera_wsrep_new_cluster.reject 2020-01-08 18:23:48.421388867 +0000
@@ -8,7 +8,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-1
+0
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1
@@ -27,7 +27,7 @@
1
SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_index';
VARIABLE_VALUE = 0
-0
+1
SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
VARIABLE_VALUE = 'ON'
1

mysqltest: Result content mismatch

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

Retrying test galera.galera_wsrep_new_cluster, attempt(2/3)...

worker[2] > Restart - not started
worker[2] > Restart - not started
{code}

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

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2020-05-07 10:30

issue.field.resolutiondate

2020-05-07 10:30:39.0

2020-05-07 10:30:39.933

Jan Lindström (Inactive) made changes - 2020-05-07 10:30

Fix Version/s		10.2.33 [ 24307 ]
Fix Version/s		10.3.24 [ 24306 ]
Fix Version/s		10.4.14 [ 24305 ]
Fix Version/s		10.5.4 [ 24264 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Stepan Patryshev (Inactive) made changes - 2020-05-08 08:11

Link

This issue blocks MENT-565 [ MENT-565 ]

Stepan Patryshev (Inactive) made changes - 2020-05-08 08:11

Link

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

Julien Fritsch made changes - 2020-05-13 10:15

Labels

Test_disabled test_disabled_ES

test_disabled_ES

Julien Fritsch made changes - 2020-06-22 08:25

Labels

test_disabled_ES

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

Workflow

MariaDB v3 [ 103136 ]

MariaDB v4 [ 157214 ]

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Stepan Patryshev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2020-01-17 12:50

Updated:: 2020-06-22 08:25

Resolved:: 2020-05-07 10:30

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