Details
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.