[#MDEV-13877] galera.galera_gcs_fc_limit fails in buildbot with timeout or Interrupted system call

galera.galera_gcs_fc_limit 'innodb_plugin' w1 [ fail ]  timeout after 900 seconds

        Test ended at 2017-09-19 10:26:05

Test case timeout after 900 seconds

== /dev/shm/var/1/log/galera_gcs_fc_limit.log ==

CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1);

SELECT COUNT(*) = 1 FROM t1;

COUNT(*) = 1

SET GLOBAL wsrep_provider_options = 'gcs.fc_limit=1';

LOCK TABLE t1 WRITE;

INSERT INTO t1 VALUES (2);

INSERT INTO t1 VALUES (3);

INSERT INTO t1 VALUES (4);

 == /dev/shm/var/1/tmp/analyze-timeout-mysqld.1.err ==

mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/dev/shm/var/tmp/1/mysqld.1.sock' (111 "Connection refused")

 == /dev/shm/var/1/tmp/analyze-timeout-mysqld.2.err ==

mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/dev/shm/var/tmp/1/mysqld.2.sock' (111 "Connection refused")

galera.galera_gcs_fc_limit 'xtradb'      w2 [ fail ]  Found warnings/errors in server log file!

        Test ended at 2017-10-25 03:05:05

line

2017-10-25  3:05:01 2954881856 [Warning] WSREP: Failed to report last committed 1666, -4 (Interrupted system call)

^ Found warnings in /dev/shm/var/2/log/mysqld.1.err

ok

galera.galera_gcs_fc_limit 'innodb'      w1 [ fail ]

        Test ended at 2017-11-07 23:43:34

CURRENT_TEST: galera.galera_gcs_fc_limit

--- /usr/share/mysql-test/suite/galera/r/galera_gcs_fc_limit.result	2017-11-07 23:06:45.000000000 +0200

+++ /dev/shm/var/1/log/galera_gcs_fc_limit.reject	2017-11-07 23:43:33.873051981 +0200

@@ -12,6 +12,18 @@

 INSERT INTO t1 VALUES (4);

 INSERT INTO t1 VALUES (5);

 connection node_1a;

+Timeout in wait_condition.inc for SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = 'query end' AND INFO = 'INSERT INTO t1 VALUES (5)';

+Id	User	Host	db	Command	Time	State	Info	Progress

+1	system user		NULL	Sleep	45	committed 1945	NULL	0.000

+2	system user		NULL	Sleep	211	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

+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

+299	root	localhost	test	Sleep	43		NULL	0.000

+300	root	localhost:36908	test	Sleep	33		NULL	0.000

+301	root	localhost:37050	test	Query	0	init	show full processlist	0.000

 connection node_2;

 UNLOCK TABLES;

 connection node_1;

mysqltest: Result length mismatch

[MDEV-13877] galera.galera_gcs_fc_limit fails in buildbot with timeout or Interrupted system call Created: 2017-09-22 Updated: 2021-05-13 Resolved: 2018-09-06
Status:	Closed
Project:	MariaDB Server
Component/s:	Galera, Tests
Affects Version/s:	10.1, 10.2
Fix Version/s:	N/A

[MDEV-13877] galera.galera_gcs_fc_limit fails in buildbot with timeout or Interrupted system call Created: 2017-09-22 Updated: 2021-05-13 Resolved: 2018-09-06