[MDEV-20872] galera_sr.GCF-1008: Test failure: Result content mismatch Created: 2019-10-21  Updated: 2020-03-09  Resolved: 2020-02-10

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.9
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Stepan Patryshev (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: galera_4
Environment:

CentOS: 7.6.1810.


Attachments: Zip Archive 191020_galera_sr.GCF-1008.zip     HTML File bb_20486.html    

 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.



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-02-10 ]

Closing since it does not fail on CI.

Generated at Thu Feb 08 09:02:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.