[MDEV-26071] rpl.rpl_perfschema_applier_status_by_worker failed in bb with: Test assertion failed Created: 2021-07-01  Updated: 2023-10-07  Resolved: 2023-03-24

Status: Closed
Project: MariaDB Server
Component/s: Replication, Tests
Affects Version/s: 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0
Fix Version/s: 10.11.3, 10.6.13, 10.8.8, 10.9.6, 10.10.4

Type: Bug Priority: Critical
Reporter: Alice Sherepa Assignee: Andrei Elkin
Resolution: Fixed Votes: 0
Labels: None

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

 Description   

10.6 ff9150f3c50f3cb3ab89bcce8
http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos8-amd64/builds/2917/steps/mtr/logs/stdio

rpl.rpl_perfschema_applier_status_by_worker 'innodb,mix' w1 [ fail ]
        Test ended at 2021-06-30 10:01:57
 
CURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker
mysqltest: In included file "./include/assert.inc": 
included from /usr/share/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 172:
At line 168: Test assertion failed in assertion.inc
 
The result from queries just before the failure was:
< snip >
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	484	use `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB
master-bin.000001	484	Gtid	1	526	GTID 0-1-2
master-bin.000001	526	Query	1	643	use `test`; DROP TABLE `t1` /* generated by server */
master-bin.000001	643	Gtid	1	685	GTID 0-1-3
master-bin.000001	685	Query	1	794	use `test`; create table t(a int primary key)
master-bin.000001	794	Gtid	1	836	BEGIN GTID 0-1-4
master-bin.000001	836	Query	1	926	use `test`; insert into t values(1)
master-bin.000001	926	Query	1	999	COMMIT
 
**** 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: 'Value returned by SSS and PS table for Last_Error_Number should be same.'
Assertion condition: '"1146" = "0"'
Assertion condition, interpolated: '"1146" = "0"'
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 Sujatha Sivakumar (Inactive) [ 2021-09-06 ]

Hello Elkin

Please review the following fix.

https://github.com/MariaDB/server/commit/72009016a6f1f2e978abc466c84ad3623d829ff5

BuildBot: http://buildbot.askmonty.org/buildbot/grid?category=main&branch=bb-10.6-sujatha

Thank you

Comment by Otto Kekäläinen [ 2023-03-23 ]

Very similar failure on recent 10.11.2 build on https://launchpadlibrarian.net/656785756/buildlog_ubuntu-lunar-s390x.mariadb_1%3A10.11.2-2~ubuntu23.04.1~1679287945.48be213fe75.dev.otto_BUILDING.txt.gz

rpl.rpl_perfschema_applier_status_by_worker 'innodb,mix' w2 [ fail ]
        Test ended at 2023-03-20 15:11:44
 
CURRENT_TEST: rpl.rpl_perfschema_applier_status_by_worker
mysqltest: In included file "./include/assert.inc": 
included from /<<PKGBUILDDIR>>/mysql-test/suite/rpl/t/rpl_perfschema_applier_status_by_worker.test at line 172:
At line 168: Test assertion failed in assertion.inc
 
The result from queries just before the failure was:
< snip >
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	484	use `test`; CREATE TABLE t1 (a INT) ENGINE=InnoDB
master-bin.000001	484	Gtid	1	526	GTID 0-1-2
master-bin.000001	526	Query	1	643	use `test`; DROP TABLE `t1` /* generated by server */
master-bin.000001	643	Gtid	1	685	GTID 0-1-3
master-bin.000001	685	Query	1	794	use `test`; create table t(a int primary key)
master-bin.000001	794	Gtid	1	836	BEGIN GTID 0-1-4
master-bin.000001	836	Query	1	926	use `test`; insert into t values(1)
master-bin.000001	926	Query	1	999	COMMIT
 
**** 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: 'Value returned by SSS and PS table for Last_Error_Number should be same.'
Assertion condition: '"1146" = "0"'
Assertion condition, interpolated: '"1146" = "0"'
Assertion result: '0'

Comment by Otto Kekäläinen [ 2023-10-07 ]

Latest build at https://launchpadlibrarian.net/690752267/buildlog_ubuntu-mantic-s390x.mariadb_1%3A10.11.5-2~bpo23.10.1~1696620362.87d091ed5f9+feature.re.enable.all.tests_BUILDING.txt.gz showa the test passed

rpl.rpl_perfschema_applier_status_by_worker 'innodb,mix' w1 [ pass ]   2429

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