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

Test failure on galera.galera_var_slave_threads

    XMLWordPrintable

Details

    Description

      galera.galera_var_slave_threads 'innodb' w3 [ fail ]
              Test ended at 2018-08-24 01:33:13
       
      CURRENT_TEST: galera.galera_var_slave_threads
      --- /usr/share/mysql-test/suite/galera/r/galera_var_slave_threads.result	2018-08-24 00:47:16.000000000 +0000
      +++ /dev/shm/var/3/log/galera_var_slave_threads.reject	2018-08-24 01:33:13.213826500 +0000
      @@ -20,6 +20,80 @@
       connection node_1;
       INSERT INTO t1 VALUES (1);
       connection node_2;
      +Timeout in wait_condition.inc for SELECT COUNT(*) = @@wsrep_slave_threads + 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE IS NULL OR STATE NOT LIKE 'InnoDB%');
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +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
      +124	system user		NULL	Sleep	55	WSREP aborter idle	NULL	0.000
      +125	system user		NULL	Sleep	30	Committed 640	NULL	0.000
      +164	root	localhost:41185	test	Query	0	Init	show full processlist	0.000
      +165	system user		NULL	Sleep	30	NULL	NULL	0.000
      +167	system user		NULL	Sleep	30	NULL	NULL	0.000
      +166	system user		NULL	Sleep	30	NULL	NULL	0.000
      +168	system user		NULL	Sleep	30	NULL	NULL	0.000
      +227	system user		NULL	Sleep	30	NULL	NULL	0.000
      +226	system user		NULL	Sleep	30	NULL	NULL	0.000
      +170	system user		NULL	Sleep	30	NULL	NULL	0.000
      +171	system user		NULL	Sleep	30	NULL	NULL	0.000
      +172	system user		NULL	Sleep	30	NULL	NULL	0.000
      +173	system user		NULL	Sleep	30	NULL	NULL	0.000
      +174	system user		NULL	Sleep	30	NULL	NULL	0.000
      +176	system user		NULL	Sleep	30	NULL	NULL	0.000
      +177	system user		NULL	Sleep	30	NULL	NULL	0.000
      +178	system user		NULL	Sleep	30	NULL	NULL	0.000
      +179	system user		NULL	Sleep	30	NULL	NULL	0.000
      +175	system user		NULL	Sleep	30	NULL	NULL	0.000
      +180	system user		NULL	Sleep	30	NULL	NULL	0.000
      +181	system user		NULL	Sleep	30	NULL	NULL	0.000
      +182	system user		NULL	Sleep	30	NULL	NULL	0.000
      +183	system user		NULL	Sleep	30	NULL	NULL	0.000
      +184	system user		NULL	Sleep	30	NULL	NULL	0.000
      +185	system user		NULL	Sleep	30	NULL	NULL	0.000
      +186	system user		NULL	Sleep	30	NULL	NULL	0.000
      +187	system user		NULL	Sleep	30	NULL	NULL	0.000
      +188	system user		NULL	Sleep	30	NULL	NULL	0.000
      +189	system user		NULL	Sleep	30	NULL	NULL	0.000
      +190	system user		NULL	Sleep	30	NULL	NULL	0.000
      +191	system user		NULL	Sleep	30	NULL	NULL	0.000
      +192	system user		NULL	Sleep	30	NULL	NULL	0.000
      +193	system user		NULL	Sleep	30	NULL	NULL	0.000
      +194	system user		NULL	Sleep	30	NULL	NULL	0.000
      +196	system user		NULL	Sleep	30	NULL	NULL	0.000
      +195	system user		NULL	Sleep	30	NULL	NULL	0.000
      +197	system user		NULL	Sleep	30	NULL	NULL	0.000
      +198	system user		NULL	Sleep	30	NULL	NULL	0.000
      +199	system user		NULL	Sleep	30	NULL	NULL	0.000
      +200	system user		NULL	Sleep	30	NULL	NULL	0.000
      +201	system user		NULL	Sleep	30	NULL	NULL	0.000
      +203	system user		NULL	Sleep	30	NULL	NULL	0.000
      +202	system user		NULL	Sleep	30	NULL	NULL	0.000
      +205	system user		NULL	Sleep	30	NULL	NULL	0.000
      +204	system user		NULL	Sleep	30	NULL	NULL	0.000
      +206	system user		NULL	Sleep	30	NULL	NULL	0.000
      +208	system user		NULL	Sleep	30	NULL	NULL	0.000
      +210	system user		NULL	Sleep	30	NULL	NULL	0.000
      +209	system user		NULL	Sleep	30	NULL	NULL	0.000
      +207	system user		NULL	Sleep	30	NULL	NULL	0.000
      +211	system user		NULL	Sleep	30	NULL	NULL	0.000
      +212	system user		NULL	Sleep	30	NULL	NULL	0.000
      +213	system user		NULL	Sleep	30	NULL	NULL	0.000
      +218	system user		NULL	Sleep	30	NULL	NULL	0.000
      +215	system user		NULL	Sleep	30	NULL	NULL	0.000
      +214	system user		NULL	Sleep	30	NULL	NULL	0.000
      +216	system user		NULL	Sleep	30	NULL	NULL	0.000
      +219	system user		NULL	Sleep	30	NULL	NULL	0.000
      +217	system user		NULL	Sleep	30	NULL	NULL	0.000
      +220	system user		NULL	Sleep	30	NULL	NULL	0.000
      +221	system user		NULL	Sleep	30	NULL	NULL	0.000
      +222	system user		NULL	Sleep	30	NULL	NULL	0.000
      +223	system user		NULL	Sleep	30	NULL	NULL	0.000
      +225	system user		NULL	Sleep	30	NULL	NULL	0.000
      +224	system user		NULL	Sleep	30	NULL	NULL	0.000
      +169	system user		NULL	Sleep	30	NULL	NULL	0.000
      +228	system user		NULL	Sleep	30	NULL	NULL	0.000
       SET GLOBAL wsrep_slave_threads = 1;
       connection node_1;
       INSERT INTO t2 VALUES (DEFAULT);
      @@ -90,6 +164,17 @@
       SELECT COUNT(*) FROM t2;
       COUNT(*)
       64
      +Timeout in wait_condition.inc for SELECT COUNT(*) = @@wsrep_slave_threads + 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE IS NULL OR STATE NOT LIKE 'InnoDB%')
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +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
      +124	system user		NULL	Sleep	85	WSREP aborter idle	NULL	0.000
      +164	root	localhost:41185	test	Query	0	Init	show full processlist	0.000
      +225	system user		NULL	Sleep	30	Committed 704	NULL	0.000
      +228	system user		NULL	Sleep	60	NULL	NULL	0.000
       SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE LIKE '%wsrep aborter%';
       COUNT(*)
       1
      @@ -103,6 +188,20 @@
       CREATE TABLE t1 (i INT AUTO_INCREMENT PRIMARY KEY) ENGINE=INNODB;
       connection node_2;
       SET GLOBAL wsrep_slave_threads = 4;
      +Timeout in wait_condition.inc for SELECT COUNT(*) = @@wsrep_slave_threads + 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE IS NULL OR STATE NOT LIKE 'InnoDB%')
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +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
      +124	system user		NULL	Sleep	116	WSREP aborter idle	NULL	0.000
      +164	root	localhost:41185	test	Query	0	Init	show full processlist	0.000
      +225	system user		NULL	Sleep	60	Committed 704	NULL	0.000
      +228	system user		NULL	Sleep	30	Committed 707	NULL	0.000
      +229	system user		NULL	Sleep	30	NULL	NULL	0.000
      +230	system user		NULL	Sleep	30	NULL	NULL	0.000
      +231	system user		NULL	Sleep	30	NULL	NULL	0.000
       SET GLOBAL wsrep_slave_threads = 1;
       connection node_1;
       INSERT INTO t1 VALUES (DEFAULT);
      @@ -112,6 +211,17 @@
       connection node_2;
       SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
       NAME
      +Timeout in wait_condition.inc for SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE IS NULL OR STATE NOT LIKE 'InnoDB%')
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +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
      +124	system user		NULL	Sleep	146	WSREP aborter idle	NULL	0.000
      +164	root	localhost:41185	test	Query	0	Init	show full processlist	0.000
      +230	system user		NULL	Sleep	30	Committed 711	NULL	0.000
      +231	system user		NULL	Sleep	60	NULL	NULL	0.000
       SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE LIKE '%wsrep aborter%';
       COUNT(*) = 1
       1
       
      mysqltest: Result length mismatch
      

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.