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

Galera test failure on MW-336

    XMLWordPrintable

    Details

      Description

      galera.MW-336 'innodb'                   w2 [ fail ]
              Test ended at 2020-02-05 09:58:15
       
      CURRENT_TEST: galera.MW-336
      --- /usr/share/mysql/mysql-test/suite/galera/r/MW-336.result	2020-02-05 07:41:16.000000000 -0500
      +++ /dev/shm/var/2/log/MW-336.reject	2020-02-05 09:58:15.531334676 -0500
      @@ -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	37	wsrep aborter idle	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
      +6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
      +15	root	localhost	test	Sleep	32		NULL	0.000
      +16	root	localhost:54312	test	Query	0	Init	show processlist	0.000
      +17	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +18	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +20	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +21	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +19	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +22	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +24	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +23	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +25	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
      +26	system user		NULL	Sleep	30	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
      +30	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +32	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +29	system user		NULL	Sleep	30	wsrep applier idle	NULL	0.000
      +31	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	67	wsrep aborter idle	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
      +6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
      +15	root	localhost	test	Sleep	63		NULL	0.000
      +16	root	localhost:54312	test	Query	0	Init	show processlist	0.000
      +34	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +35	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +36	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +37	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +26	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +27	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +28	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +30	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +32	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +29	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
      +31	system user		NULL	Sleep	61	wsrep applier idle	NULL	0.000
       connection node_2;
       INSERT INTO t1 VALUES (11);
       INSERT INTO t1 VALUES (12);
       
      mysqltest: Result length mismatch
       
       - saving '/dev/shm/var/2/log/galera.MW-336-innodb/' to '/dev/shm/var/log/galera.MW-336-innodb/'
       
      Retrying test galera.MW-336, attempt(2/3)...
      

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            jplindst Jan Lindström
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: