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

Galera test failure on galera.galera_var_innodb_disallow_writes: Result length mismatch

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.3.21, 10.4.9
    • Fix Version/s: 10.2.33, 10.3.24, 10.4.14, 10.5.5
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      OS: CentOS Linux release 7.6.1810 (Core). TestTarball_2 rhel-8.

      Description

      It sporadically fails on bb and local suite runs.

      MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 9afbb1069ab4178741b76adefacd3f6a0ed51369; debug built from sources.

      Galera lib 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.

      Run:

      ./mtr --suite galera --testcase-timeout=90 --force --big-test --max-test-fail=0 --timer --timestamp --timediff
      

      stdout.log (the whole file is attached: 191029_HDD_stdout.log):

      mysqltest: Result length mismatch

      191029 20:10:41 +55.136 galera.galera_var_innodb_disallow_writes 'innodb' [ fail ]
              Test ended at 2019-10-29 20:10:41
       
      CURRENT_TEST: galera.galera_var_innodb_disallow_writes
      --- /home/stepan/mariadb/10.4/github/mysql-test/suite/galera/r/galera_var_innodb_disallow_writes.result	2019-10-17 14:30:27.382278020 +0300
      +++ /home/stepan/mariadb/10.4/github/mysql-test/suite/galera/r/galera_var_innodb_disallow_writes.reject	2019-10-29 20:10:41.229513794 +0200
      @@ -10,6 +10,18 @@
       SELECT COUNT(*) = 1 FROM t1;
       COUNT(*) = 1
       0
      +Timeout in wait_condition.inc for SELECT 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE INFO = 'INSERT INTO t1 VALUES (1)' AND State = 'Commit'
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +1	system user		NULL	Sleep	43	wsrep aborter idle	NULL	0.000
      +2	system user		NULL	Sleep	43	Closing tables	NULL	0.000
      +3	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
      +4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
      +18	root	localhost	test	Sleep	35		NULL	0.000
      +19	root	localhost:48696	test	Query	31	Update	INSERT INTO t1 VALUES (1)	0.000
      +20	root	localhost:48698	test	Query	0	Init	show full processlist	0.000
       SELECT COUNT(*) = 1 FROM t1;
       COUNT(*) = 1
       0
       
      mysqltest: Result length mismatch
      

      See also other logs attached: 191030_galera_var_innodb_disallow_writes.zip.

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            stepan.patryshev Stepan Patryshev
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: