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

Galera test failure on galera.MW-336: Result length mismatch

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 10.4.9
    • Fix Version/s: N/A
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      OS: CentOS Linux release 7.6.1810 (Core).

      Description

      It sporadically fails on bb and local suite runs.

      MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 2b5f4b3ed68585b310b7ebede474928ff90d9aa2; 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 --force --big-test --max-test-fail=0 --parallel=auto --timer --timestamp --timediff
      

      stdout.log (the whole file is attached: 191026_1520_SSD_stdout.log):

      mysqltest: Result length mismatch

      191026 15:29:56 +2.024 galera.MW-336 'innodb'                   w4 [ fail ]
              Test ended at 2019-10-26 15:29:56
       
      CURRENT_TEST: galera.MW-336
      --- /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/MW-336.result	2019-10-13 09:12:21.392670633 +0300
      +++ /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/MW-336.reject	2019-10-26 15:29:55.931500577 +0300
      @@ -12,6 +12,40 @@
       # Set slave threads to 10 step 2
       SET GLOBAL wsrep_slave_threads = 20;
       # Set slave threads to 20
      +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 20 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
      +SELECT COUNT(*), 20 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;
      +COUNT(*)	EXPECTED_VALUE
      +21	20
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +1	system user		NULL	Sleep	38	wsrep aborter idle	NULL	0.000
      +3	system user		NULL	Daemon	NULL	InnoDB purge worker	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 coordinator	NULL	0.000
      +7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
      +16	root	localhost	test	Sleep	33		NULL	0.000
      +17	root	localhost:51250	test	Query	0	Init	show processlist	0.000
      +18	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000
      +19	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000
      +20	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000
      +21	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000
      +22	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000
      +23	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000
      +24	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000
      +25	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000
      +26	system user		NULL	Sleep	31	wsrep applier idle	NULL	0.000
      +27	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +28	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +29	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +30	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +31	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +32	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +33	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +34	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +35	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +36	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +37	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +38	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
       SET GLOBAL wsrep_slave_threads = 1;
       connection node_2;
       INSERT INTO t1 VALUES (1);
      @@ -30,6 +64,30 @@
       COUNT(*)
       11
       # Set slave threads to 10 step 3
      +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count';
      +SELECT COUNT(*), 10 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist;
      +COUNT(*)	EXPECTED_VALUE
      +11	10
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +1	system user		NULL	Sleep	70	wsrep aborter idle	NULL	0.000
      +3	system user		NULL	Daemon	NULL	InnoDB purge worker	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 coordinator	NULL	0.000
      +7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
      +16	root	localhost	test	Sleep	64		NULL	0.000
      +17	root	localhost:51250	test	Query	0	Init	show processlist	0.000
      +28	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +29	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +30	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +31	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +32	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +33	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +34	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +35	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +36	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +37	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
      +38	system user		NULL	Sleep	62	wsrep applier idle	NULL	0.000
       connection node_2;
       INSERT INTO t1 VALUES (11);
       INSERT INTO t1 VALUES (12);
       
      mysqltest: Result length mismatch
      

      See also other logs attached: 191029_galera.MW-336.zip.

        Attachments

        1. 191026_1520_SSD_stdout.log
          33 kB
          Stepan Patryshev

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: