[MDEV-25502] rpl.rpl_perfschema_applier_status_by_worker failed in bb with: Test assertion failed Created: 2021-04-23  Updated: 2021-07-01  Resolved: 2021-05-18

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.6
Fix Version/s: 10.6.1

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Sujatha Sivakumar (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-26071 rpl.rpl_perfschema_applier_status_by_... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-groovy-ppc64le/builds/643/steps/mtr/logs/stdio

10.6 bfc0110b9b4d8ed49

rpl.rpl_perfschema_applier_status_by_worker 'mix' w1 [ fail ]
        Test ended at 2021-04-22 17:54:51
 
CURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker
mysqltest: In included file "./include/assert.inc": 
included from /usr/share/mysql/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 98:
At line 168: Test assertion failed in assertion.inc
 
The result from queries just before the failure was:
< snip >
 
**** SHOW BINLOG EVENTS on server_1 ****
binlog_name = 'master-bin.000001'
SHOW BINLOG EVENTS IN 'master-bin.000001';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	4	Format_desc	1	256	Server ver: 10.6.0-MariaDB-1:10.6.0+maria~groovy-log, Binlog ver: 4
master-bin.000001	256	Gtid_list	1	285	[]
master-bin.000001	285	Binlog_checkpoint	1	329	master-bin.000001
master-bin.000001	329	Gtid	1	371	GTID 0-1-1
master-bin.000001	371	Query	1	461	use `test`; CREATE TABLE t1 (a INT)
 
**** SHOW RELAYLOG EVENTS on server_1 ****
relaylog_name = 'No such row'
SHOW RELAYLOG EVENTS IN 'No such row';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
connection slave;
Assertion text: 'Last_Seen_Transaction should show .'
Assertion condition: '"0-1-1" = ""'
Assertion condition, interpolated: '"0-1-1" = ""'
Assertion result: '0'
 
More results from queries before failure can be found in /dev/shm/var/1/log/rpl_perfschema_applier_status_by_worker.log



 Comments   
Comment by Alice Sherepa [ 2021-04-30 ]

10.6 aed8605dd1ec1b2909dafeb12c500
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-x86/builds/23313/steps/mtr/logs/stdio

Comment by Sujatha Sivakumar (Inactive) [ 2021-05-03 ]

Hello Andrei,

Please review the fix for MDEV-25502.

Patch: https://github.com/MariaDB/server/commit/1cc9bcb532d26ea9b03a6adf39c90101c6497c83

Testing: http://buildbot.askmonty.org/buildbot/grid?category=main&branch=bb-10.6-MDEV-25502

Thank you

Comment by Sujatha Sivakumar (Inactive) [ 2021-05-04 ]

Patch was approved by Alice.

Comment by Sujatha Sivakumar (Inactive) [ 2021-05-05 ]

The issue still happens on 10.6.

Comment by Sujatha Sivakumar (Inactive) [ 2021-05-12 ]

Hello Elkin,

Can you please review the following changes.

https://github.com/MariaDB/server/commit/7d6e8d59fe02b42184c3e53f7795b645269bdc0a
BuildBot testing: http://buildbot.askmonty.org/buildbot/grid?category=main&branch=bb-10.6-sujatha

Thank you.

Comment by Andrei Elkin [ 2021-05-17 ]

The commit looks fine, I only had a test related suggestion in https://github.com/MariaDB/server/commit/7d6e8d59fe02b42184c3e53f7795b645269bdc0a#r50722706

(did not bounce the ticket back you - doing it now).

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