[MDEV-22008] rpl.rpl_semi_sync fails with wrong value for Rpl_semi_sync_master_clients - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.5.1, 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9
Component/s: Replication, Tests
Labels:
None
Environment:
kvm-rpm-centos73-amd64

Description

CURRENT_TEST: rpl.rpl_semi_sync

--- /usr/share/mysql-test/suite/rpl/r/rpl_semi_sync.result	2020-03-23 00:20:13.000000000 +0000

+++ /dev/shm/var/2/log/rpl_semi_sync.reject	2020-03-23 01:42:52.965487725 +0000

@@ -177,7 +177,7 @@

 Rpl_semi_sync_master_yes_tx	14

 show status like 'Rpl_semi_sync_master_clients';

 Variable_name	Value

-Rpl_semi_sync_master_clients	0

+Rpl_semi_sync_master_clients	1

 [ semi-sync replication of these transactions will fail ]

 insert into t1 values (500);

 [ master status should be OFF ]

Attachments

Issue Links

duplicates

MDEV-11220 rpl.rpl_semi_sync failed in buildbot, result mismatch, Rpl_semi_sync_master_status on/off

Closed

MDEV-21031 rpl_semi_sync_after_sync_row result mismatch

Closed

is duplicated by

MDEV-14366 rpl.rpl_semi_sync_after_sync, rpl.rpl_semi_sync_after_sync_row failed in buildbot with wrong result

Closed

Activity

Ascending order - Click to sort in descending order

Michael Widenius created issue - 2020-03-23 08:52

Andrei Elkin made changes - 2020-03-25 18:17

Field	Original Value	New Value
Link		This issue duplicates ~~MDEV-21031~~ [ ~~MDEV-21031~~ ]

Sergei Golubchik made changes - 2020-04-27 08:15

Description

CURRENT_TEST: rpl.rpl_semi_sync
--- /usr/share/mysql-test/suite/rpl/r/rpl_semi_sync.result 2020-03-23 00:20:13.000000000 +0000
+++ /dev/shm/var/2/log/rpl_semi_sync.reject 2020-03-23 01:42:52.965487725 +0000
@@ -177,7 +177,7 @@
Rpl_semi_sync_master_yes_tx 14
show status like 'Rpl_semi_sync_master_clients';
Variable_name Value
-Rpl_semi_sync_master_clients 0
+Rpl_semi_sync_master_clients 1
[ semi-sync replication of these transactions will fail ]
insert into t1 values (500);
[ master status should be OFF ]

{noformat}CURRENT_TEST: rpl.rpl_semi_sync
--- /usr/share/mysql-test/suite/rpl/r/rpl_semi_sync.result 2020-03-23 00:20:13.000000000 +0000
+++ /dev/shm/var/2/log/rpl_semi_sync.reject 2020-03-23 01:42:52.965487725 +0000
@@ -177,7 +177,7 @@
Rpl_semi_sync_master_yes_tx 14
show status like 'Rpl_semi_sync_master_clients';
Variable_name Value
-Rpl_semi_sync_master_clients 0
+Rpl_semi_sync_master_clients 1
[ semi-sync replication of these transactions will fail ]
insert into t1 values (500);
[ master status should be OFF ]
{noformat}

Sergei Golubchik made changes - 2020-04-27 08:15

Description

{code:diff}CURRENT_TEST: rpl.rpl_semi_sync
--- /usr/share/mysql-test/suite/rpl/r/rpl_semi_sync.result 2020-03-23 00:20:13.000000000 +0000
+++ /dev/shm/var/2/log/rpl_semi_sync.reject 2020-03-23 01:42:52.965487725 +0000
@@ -177,7 +177,7 @@
Rpl_semi_sync_master_yes_tx 14
show status like 'Rpl_semi_sync_master_clients';
Variable_name Value
-Rpl_semi_sync_master_clients 0
+Rpl_semi_sync_master_clients 1
[ semi-sync replication of these transactions will fail ]
insert into t1 values (500);
[ master status should be OFF ]
{code}

Sergei Golubchik made changes - 2020-04-27 08:15

Fix Version/s

10.5 [ 23123 ]

Julien Fritsch made changes - 2020-06-08 08:59

Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]

Alice Sherepa made changes - 2020-07-02 12:35

Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]

Alice Sherepa added a comment - 2020-07-02 12:39

on the current 10.3 1df1a6392477ad211b2 : http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-rhel8-ppc64le/builds/1358/steps/mtr/logs/stdio

rpl.rpl_semi_sync 'innodb,mix'           w2 [ fail ]

        Test ended at 2020-07-02 06:30:10

CURRENT_TEST: rpl.rpl_semi_sync

--- /usr/share/mysql-test/suite/rpl/r/rpl_semi_sync.result	2020-07-02 03:54:53.000000000 +0000

+++ /dev/shm/var/2/log/rpl_semi_sync.reject	2020-07-02 06:30:09.730420484 +0000

@@ -406,7 +406,7 @@

 [ Semi-sync status on master should be ON ]

 show status like 'Rpl_semi_sync_master_clients';

 Variable_name	Value

-Rpl_semi_sync_master_clients	0

+Rpl_semi_sync_master_clients	1

 show status like 'Rpl_semi_sync_master_status';

 Variable_name	Value

 Rpl_semi_sync_master_status	ON

mysqltest: Result content mismatch

Alice Sherepa added a comment - 2020-07-02 12:39 on the current 10.3 1df1a6392477ad211b2 : http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-rhel8-ppc64le/builds/1358/steps/mtr/logs/stdio rpl.rpl_semi_sync 'innodb,mix' w2 [ fail ] Test ended at 2020-07-02 06:30:10 CURRENT_TEST: rpl.rpl_semi_sync --- /usr/share/mysql-test/suite/rpl/r/rpl_semi_sync.result 2020-07-02 03:54:53.000000000 +0000 +++ /dev/shm/var/2/log/rpl_semi_sync.reject 2020-07-02 06:30:09.730420484 +0000 @@ -406,7 +406,7 @@ [ Semi-sync status on master should be ON ] show status like 'Rpl_semi_sync_master_clients'; Variable_name Value -Rpl_semi_sync_master_clients 0 +Rpl_semi_sync_master_clients 1 show status like 'Rpl_semi_sync_master_status'; Variable_name Value Rpl_semi_sync_master_status ON mysqltest: Result content mismatch

Alice Sherepa made changes - 2020-07-02 12:49

Link

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

Andrei Elkin made changes - 2020-07-02 13:06

Component/s

Tests [ 10800 ]

Andrei Elkin made changes - 2020-07-02 13:06

Priority

Major [ 3 ]

Critical [ 2 ]

Alice Sherepa added a comment - 2020-09-04 14:42

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-focal-amd64/builds/1311/steps/mtr/logs/stdio

Alice Sherepa added a comment - 2020-09-04 14:42 http://buildbot.askmonty.org/buildbot/builders/kvm-deb-focal-amd64/builds/1311/steps/mtr/logs/stdio

Alice Sherepa made changes - 2020-09-11 08:38

Link

This issue duplicates ~~MDEV-11220~~ [ ~~MDEV-11220~~ ]

Alice Sherepa made changes - 2020-09-11 08:40

Link

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

Alice Sherepa made changes - 2020-09-11 08:40

Link

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

Alice Sherepa made changes - 2020-11-04 09:21

Link

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

Alice Sherepa made changes - 2020-11-04 09:21

Link

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

Andrei Elkin made changes - 2020-12-14 15:36

Assignee

Andrei Elkin [ elkin ]

Alice Sherepa [ alice ]

Alice Sherepa added a comment - 2021-01-12 10:26

fixed by 4e43e2f92d1b418dcc84ab8a commit

Alice Sherepa added a comment - 2021-01-12 10:26 fixed by 4e43e2f92d1b418dcc84ab8a commit

Alice Sherepa made changes - 2021-01-12 10:26

Fix Version/s		10.2.37 [ 25112 ]
Fix Version/s		10.3.28 [ 25111 ]
Fix Version/s		10.4.18 [ 25110 ]
Fix Version/s		10.5.9 [ 25109 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]

Alice Sherepa made changes - 2021-01-12 10:27

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Alice Sherepa made changes - 2021-01-12 10:30

Link

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

Alice Sherepa made changes - 2021-01-12 10:30

Link

This issue is duplicated by ~~MDEV-14366~~ [ ~~MDEV-14366~~ ]

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

Workflow

MariaDB v3 [ 105923 ]

MariaDB v4 [ 157467 ]

People

Assignee:: Alice Sherepa

Reporter:: Michael Widenius

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2020-03-23 08:52

Updated:: 2021-01-12 10:30

Resolved:: 2021-01-12 10:27

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