Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Cannot Reproduce
- 
    10.4.9
- 
    CentOS: 7.6.1810.
Description
MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 421d52e89627d85794d7e8e4b70216b14f384178; debug built from sources.
Galera 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.
Run:
| ./mtr --suite galera_sr --force --big-test --max-test-fail=0 --testcase-timeout=90 --mysqld=--wsrep-debug=server --timer --timestamp --timediff
 | 
stdout.log:
| 191021  1:42:20 +11.421 galera_sr.GCF-1008 'innodb'              [ fail ] | 
|         Test ended at 2019-10-21 01:42:20 | 
|  | 
| CURRENT_TEST: galera_sr.GCF-1008 | 
| --- /home/stepan/mariadb/10.4/github/mysql-test/suite/galera_sr/r/GCF-1008.result	2019-10-17 14:30:27.414277938 +0300 | 
| +++ /home/stepan/mariadb/10.4/github/mysql-test/suite/galera_sr/r/GCF-1008.reject	2019-10-21 01:42:19.813464441 +0300 | 
| @@ -54,7 +54,7 @@ | 
|  SET SESSION wsrep_trx_fragment_size = 1; | 
|  SELECT COUNT(*) = 1 FROM t1; | 
|  COUNT(*) = 1 | 
| -1 | 
| +0 | 
|  REPLACE INTO t1 VALUES (1,'y'); | 
|  connection node_2b; | 
|  SELECT COUNT(*) = 0 FROM t1; | 
|  | 
| mysqltest: Result content mismatch
 | 
All logs are attached: 191020_galera_sr.GCF-1008.zip .
.
Note: This test is failed sporadically on HDD, but is passed on SSD.
On bb it was failed with another error:
http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/20486/steps/mtr_ps_emb/logs/stdio :
| galera_sr.GCF-1008 'innodb'              w4 [ fail ] | 
|         Test ended at 2019-10-16 09:05:31 | 
|  | 
| CURRENT_TEST: galera_sr.GCF-1008 | 
| Got ERROR: "InnoDB: Operating system error number 2 in a file operation." errno: 2000 | 
| Got ERROR: "InnoDB: The error means the system cannot find the path specified." errno: 2000 | 
| Got ERROR: "InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them." errno: 2000 | 
| Got ERROR: "InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 71" errno: 2000 | 
| Got ERROR: "InnoDB: Operating system error number 2 in a file operation." errno: 2000 | 
| Got ERROR: "InnoDB: The error means the system cannot find the path specified." errno: 2000 | 
| Got ERROR: "InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them." errno: 2000 | 
| Got ERROR: "InnoDB: Cannot open datafile for read-only: './mysql/innodb_table_stats.ibd' OS error: 71" errno: 2000 | 
| Got ERROR: "InnoDB: Operating system error number 2 in a file operation." errno: 2000 | 
| Got ERROR: "InnoDB: The error means the system cannot find the path specified." errno: 2000 | 
| Got ERROR: "InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them." errno: 2000 | 
| Got ERROR: "InnoDB: Cannot open datafile for read-only: './mysql/transaction_registry.ibd' OS error: 71" errno: 2000 | 
| Got ERROR: "/mnt/buildbot/build/mariadb-10.4.9/libmysqld/examples/mysqltest_embedded: unknown variable 'wsrep-provider=none'" errno: 2000 | 
| mysqltest: Can't initialize MariaDB server
 | 
The full output is attached: bb_20486.html .
.