Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26071

rpl.rpl_perfschema_applier_status_by_worker failed in bb with: Test assertion failed

Details

    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
      

      Attachments

        Issue Links

          Activity

            sujatha.sivakumar Sujatha Sivakumar (Inactive) added a comment - 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

            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'
            

            otto Otto Kekäläinen added a comment - 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'
            otto Otto Kekäläinen added a comment - 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

            People

              Elkin Andrei Elkin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.