[MDEV-23611] galera_sr.galera_sr_kill_query MTR failed: 15 instead of 0 on "SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;" - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4.15, 10.5.6
Fix Version/s: 10.4.16, 10.5.7, 10.6.0
Component/s: Galera, Tests
Labels:
None
Environment:
kvm-deb-sid-x86

Description

galera_sr.galera_sr_kill_query failed on BB 10.4 and BB 10.5: 15 instead of 0 on SELECT COUNT ( * ) AS EXPECT_0 FROM mysql.wsrep_streaming_log

stdio.log:

10.4.15 1e08e08ccb8896c1f0d2f673c16f5b92cdf7dc46
galera_sr.galera_sr_kill_query 'innodb' w2 [ fail ]
Test ended at 2020-08-26 07:11:47

CURRENT_TEST: galera_sr.galera_sr_kill_query
--- /usr/share/mysql/mysql-test/suite/galera_sr/r/galera_sr_kill_query.result 2020-08-26 04:34:01.000000000 -0400
+++ /dev/shm/var/2/log/galera_sr_kill_query.reject 2020-08-26 07:11:46.870787179 -0400
@@ -19,7 +19,7 @@
0
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
EXPECT_0
-0
+15
INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
SELECT COUNT(*) AS EXPECT_1000 FROM t1;
EXPECT_1000

mysqltest: Result length mismatch

Attachments

Activity

Ascending order - Click to sort in descending order

Stepan Patryshev (Inactive) created issue - 2020-08-27 17:35

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

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

Stepan Patryshev (Inactive) made changes - 2020-08-27 17:37

Description

galera_sr.galera_sr_kill_query failed on [BB 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032] and [BB 10.5|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/5432]: 15 instead of 0 on "SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;".

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032/steps/mtr-galera/logs/stdio]*:
{code:title=10.4.15 1e08e08ccb8896c1f0d2f673c16f5b92cdf7dc46}
galera_sr.galera_sr_kill_query 'innodb' w2 [ fail ]
Test ended at 2020-08-26 07:11:47

CURRENT_TEST: galera_sr.galera_sr_kill_query
--- /usr/share/mysql/mysql-test/suite/galera_sr/r/galera_sr_kill_query.result 2020-08-26 04:34:01.000000000 -0400
+++ /dev/shm/var/2/log/galera_sr_kill_query.reject 2020-08-26 07:11:46.870787179 -0400
@@ -19,7 +19,7 @@
0
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
EXPECT_0
-0
+15
INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
SELECT COUNT(*) AS EXPECT_1000 FROM t1;
EXPECT_1000

mysqltest: Result length mismatch
{code}

galera_sr.galera_sr_kill_query failed on [BB 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032] and [BB 10.5|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/5432]: 15 instead of 0 on
{noformat}"SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;".{noformat}

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032/steps/mtr-galera/logs/stdio]*:
{code:title=10.4.15 1e08e08ccb8896c1f0d2f673c16f5b92cdf7dc46}
galera_sr.galera_sr_kill_query 'innodb' w2 [ fail ]
Test ended at 2020-08-26 07:11:47

CURRENT_TEST: galera_sr.galera_sr_kill_query
--- /usr/share/mysql/mysql-test/suite/galera_sr/r/galera_sr_kill_query.result 2020-08-26 04:34:01.000000000 -0400
+++ /dev/shm/var/2/log/galera_sr_kill_query.reject 2020-08-26 07:11:46.870787179 -0400
@@ -19,7 +19,7 @@
0
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
EXPECT_0
-0
+15
INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
SELECT COUNT(*) AS EXPECT_1000 FROM t1;
EXPECT_1000

mysqltest: Result length mismatch
{code}

Stepan Patryshev (Inactive) made changes - 2020-08-27 17:39

Description

galera_sr.galera_sr_kill_query failed on [BB 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032] and [BB 10.5|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/5432]: 15 instead of 0 on
{noformat}"SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;".{noformat}

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032/steps/mtr-galera/logs/stdio]*:
{code:title=10.4.15 1e08e08ccb8896c1f0d2f673c16f5b92cdf7dc46}
galera_sr.galera_sr_kill_query 'innodb' w2 [ fail ]
Test ended at 2020-08-26 07:11:47

CURRENT_TEST: galera_sr.galera_sr_kill_query
--- /usr/share/mysql/mysql-test/suite/galera_sr/r/galera_sr_kill_query.result 2020-08-26 04:34:01.000000000 -0400
+++ /dev/shm/var/2/log/galera_sr_kill_query.reject 2020-08-26 07:11:46.870787179 -0400
@@ -19,7 +19,7 @@
0
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
EXPECT_0
-0
+15
INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
SELECT COUNT(*) AS EXPECT_1000 FROM t1;
EXPECT_1000

mysqltest: Result length mismatch
{code}

galera_sr.galera_sr_kill_query failed on [BB 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032] and [BB 10.5|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/5432]: 15 instead of 0 on
"SELECT COUNT (*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;".

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032/steps/mtr-galera/logs/stdio]*:
{code:title=10.4.15 1e08e08ccb8896c1f0d2f673c16f5b92cdf7dc46}
galera_sr.galera_sr_kill_query 'innodb' w2 [ fail ]
Test ended at 2020-08-26 07:11:47

CURRENT_TEST: galera_sr.galera_sr_kill_query
--- /usr/share/mysql/mysql-test/suite/galera_sr/r/galera_sr_kill_query.result 2020-08-26 04:34:01.000000000 -0400
+++ /dev/shm/var/2/log/galera_sr_kill_query.reject 2020-08-26 07:11:46.870787179 -0400
@@ -19,7 +19,7 @@
0
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
EXPECT_0
-0
+15
INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
SELECT COUNT(*) AS EXPECT_1000 FROM t1;
EXPECT_1000

mysqltest: Result length mismatch
{code}

Stepan Patryshev (Inactive) made changes - 2020-08-27 17:39

Description

galera_sr.galera_sr_kill_query failed on [BB 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032] and [BB 10.5|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/5432]: 15 instead of 0 on
"SELECT COUNT (*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;".

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032/steps/mtr-galera/logs/stdio]*:
{code:title=10.4.15 1e08e08ccb8896c1f0d2f673c16f5b92cdf7dc46}
galera_sr.galera_sr_kill_query 'innodb' w2 [ fail ]
Test ended at 2020-08-26 07:11:47

CURRENT_TEST: galera_sr.galera_sr_kill_query
--- /usr/share/mysql/mysql-test/suite/galera_sr/r/galera_sr_kill_query.result 2020-08-26 04:34:01.000000000 -0400
+++ /dev/shm/var/2/log/galera_sr_kill_query.reject 2020-08-26 07:11:46.870787179 -0400
@@ -19,7 +19,7 @@
0
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
EXPECT_0
-0
+15
INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
SELECT COUNT(*) AS EXPECT_1000 FROM t1;
EXPECT_1000

mysqltest: Result length mismatch
{code}

galera_sr.galera_sr_kill_query failed on [BB 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032] and [BB 10.5|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/5432]: 15 instead of 0 on
SELECT COUNT ( * ) AS EXPECT_0 FROM mysql.wsrep_streaming_log

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032/steps/mtr-galera/logs/stdio]*:
{code:title=10.4.15 1e08e08ccb8896c1f0d2f673c16f5b92cdf7dc46}
galera_sr.galera_sr_kill_query 'innodb' w2 [ fail ]
Test ended at 2020-08-26 07:11:47

CURRENT_TEST: galera_sr.galera_sr_kill_query
--- /usr/share/mysql/mysql-test/suite/galera_sr/r/galera_sr_kill_query.result 2020-08-26 04:34:01.000000000 -0400
+++ /dev/shm/var/2/log/galera_sr_kill_query.reject 2020-08-26 07:11:46.870787179 -0400
@@ -19,7 +19,7 @@
0
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
EXPECT_0
-0
+15
INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
SELECT COUNT(*) AS EXPECT_1000 FROM t1;
EXPECT_1000

mysqltest: Result length mismatch
{code}

Stepan Patryshev (Inactive) made changes - 2020-08-27 17:39

Description

galera_sr.galera_sr_kill_query failed on [BB 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032] and [BB 10.5|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/5432]: 15 instead of 0 on
SELECT COUNT ( * ) AS EXPECT_0 FROM mysql.wsrep_streaming_log

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032/steps/mtr-galera/logs/stdio]*:
{code:title=10.4.15 1e08e08ccb8896c1f0d2f673c16f5b92cdf7dc46}
galera_sr.galera_sr_kill_query 'innodb' w2 [ fail ]
Test ended at 2020-08-26 07:11:47

CURRENT_TEST: galera_sr.galera_sr_kill_query
--- /usr/share/mysql/mysql-test/suite/galera_sr/r/galera_sr_kill_query.result 2020-08-26 04:34:01.000000000 -0400
+++ /dev/shm/var/2/log/galera_sr_kill_query.reject 2020-08-26 07:11:46.870787179 -0400
@@ -19,7 +19,7 @@
0
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
EXPECT_0
-0
+15
INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
SELECT COUNT(*) AS EXPECT_1000 FROM t1;
EXPECT_1000

mysqltest: Result length mismatch
{code}

galera_sr.galera_sr_kill_query failed on [BB 10.4|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032] and [BB 10.5|http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/5432]: 15 instead of 0 on SELECT COUNT ( * ) AS EXPECT_0 FROM mysql.wsrep_streaming_log

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-x86/builds/11032/steps/mtr-galera/logs/stdio]*:
{code:title=10.4.15 1e08e08ccb8896c1f0d2f673c16f5b92cdf7dc46}
galera_sr.galera_sr_kill_query 'innodb' w2 [ fail ]
Test ended at 2020-08-26 07:11:47

CURRENT_TEST: galera_sr.galera_sr_kill_query
--- /usr/share/mysql/mysql-test/suite/galera_sr/r/galera_sr_kill_query.result 2020-08-26 04:34:01.000000000 -0400
+++ /dev/shm/var/2/log/galera_sr_kill_query.reject 2020-08-26 07:11:46.870787179 -0400
@@ -19,7 +19,7 @@
0
SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
EXPECT_0
-0
+15
INSERT INTO t1 SELECT 1 FROM ten AS t1, ten AS t2, ten AS t3;
SELECT COUNT(*) AS EXPECT_1000 FROM t1;
EXPECT_1000

mysqltest: Result length mismatch
{code}

Stepan Patryshev (Inactive) made changes - 2020-08-27 17:41

Assignee

Stepan Patryshev [ stepan.patryshev ]

Jan Lindström [ jplindst ]

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

Status

Open [ 1 ]

In Progress [ 3 ]

Jan Lindström (Inactive) made changes - 2020-09-10 06:12

Fix Version/s		10.4.15 [ 24507 ]
Fix Version/s		10.5.6 [ 24508 ]
Fix Version/s		10.6.0 [ 24431 ]
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-09-10 12:19

Link

This issue blocks MDEV-17728 [ MDEV-17728 ]

Ralf Gebhardt made changes - 2020-10-06 18:35

Fix Version/s

10.5.7 [ 25019 ]

Ralf Gebhardt made changes - 2020-10-06 18:38

Fix Version/s

10.5.6 [ 24508 ]

Ralf Gebhardt made changes - 2020-10-06 18:40

Fix Version/s

10.4.16 [ 25020 ]

Ralf Gebhardt made changes - 2020-10-06 18:42

Fix Version/s

10.4.15 [ 24507 ]

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

Workflow

MariaDB v3 [ 113013 ]

MariaDB v4 [ 158316 ]

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Stepan Patryshev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2020-08-27 17:35

Updated:: 2020-10-06 18:42

Resolved:: 2020-09-10 06:12

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