[MDEV-22951] rpl.rpl_slave_alias_replica failed in buildbot with wrong result Created: 2020-06-19  Updated: 2021-02-09  Resolved: 2020-06-25

Status: Closed
Project: MariaDB Server
Component/s: Replication, Tests
Affects Version/s: 10.5
Fix Version/s: 10.5.5

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Sujatha Sivakumar (Inactive)
Resolution: Fixed Votes: 0
Labels: master-dump-thread


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-amd64/builds/17417

10.5 762bf7a03b6214f091a66ca8683df341

 
rpl.rpl_slave_alias_replica 'innodb,stmt' w4 [ fail ]
 
        Test ended at 2020-06-12 09:52:25
 
 
 
CURRENT_TEST: rpl.rpl_slave_alias_replica
 
--- /usr/local/mariadb-10.5.4-linux-x86_64/mysql-test/suite/rpl/r/rpl_slave_alias_replica.result	2020-06-12 08:30:32.000000000 +0000
 
+++ /usr/local/mariadb-10.5.4-linux-x86_64/mysql-test/suite/rpl/r/rpl_slave_alias_replica.reject	2020-06-12 09:52:25.191267945 +0000
 
@@ -22,6 +22,7 @@
 
 SHOW REPLICA HOSTS;
 
 Server_id	Host	Port	Master_id
 
 2	127.0.0.1	SLAVE_PORT	1
 
+2	127.0.0.1	SLAVE_PORT	1
 
 DROP USER 'repl_user';
 
 connection slave;
 
 "Command: SHOW SLAVE IO/SQL THREAD --> SHOW REPLICA IO/SQL THREAD"
 
 
 
mysqltest: Result length mismatch



 Comments   
Comment by Sujatha Sivakumar (Inactive) [ 2020-06-23 ]

The issue is not reproducible locally. The SHOW REPLICA HOSTS command reports an additional row for the same server occasionally.
This happens because of zombie dump threads on the master. SHOW REPLICA HOSTS goes through the list of dump threads and reports the corresponding hosts. Because of zombies it reports same host twice. Test needs to be improved.

Master's error log show this

2020-06-12  9:52:24 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'root' host: 'localhost' (A slave with the same server_uuid/server_id as this slave has co)

Comment by Sujatha Sivakumar (Inactive) [ 2020-06-24 ]

Hello Andrei,

Please review the fix for MDEV-22951.

Patch: https://github.com/MariaDB/server/commit/258a0fb47b74363d0919d6a18b9b2e67d45d4cf7

Build Bot: http://buildbot.askmonty.org/buildbot/grid?category=main&branch=bb-10.5-sujatha

Thank you

Comment by Andrei Elkin [ 2020-06-24 ]

The patch looks good. Thanks!

Generated at Thu Feb 08 09:18:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.