Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.3.6
-
CentOS 7.4.
Description
galera_safe_to_bootstrap test from the galera_3nodes mtr test suite is failing on mariadb-10.3.6-76-g461de7e
it's seen a deprecated wsrep_causal_reads option and also not relevant max_open_files;
wsrep_causal_reads option has been replaced by wsrep_sync_wait ;
wsrep_sync_wait to 1 is the same as wsrep_causal_reads to ON. This deprecates wsrep_causal_reads.
[qa-user1@t4w3 mysql-test]$ ./mysql-test-run.pl galera_3nodes.galera_safe_to_bootstrap
|
Logging: /home/qa-user1/rr/server/mysql-test/mysql-test-run.pl galera_3nodes.galera_safe_to_bootstrap
|
vardir: /home/qa-user1/rr/build-mariadb/mysql-test/var
|
Checking leftover processes...
|
Removing old var directory...
|
Creating var directory '/home/qa-user1/rr/build-mariadb/mysql-test/var'...
|
Checking supported features...
|
MariaDB Version 10.3.7-MariaDB
|
- SSL connections supported
|
Collecting tests...
|
Installing system database...
|
|
|
==============================================================================
|
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
|
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
|
galera_3nodes.galera_safe_to_bootstrap 'innodb' [ fail ]
|
Test ended at 2018-04-25 16:11:02
|
|
|
CURRENT_TEST: galera_3nodes.galera_safe_to_bootstrap
|
2018-04-25 16:10:38 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated
|
2018-04-25 16:10:38 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on
|
2018-04-25 16:10:38 0 [Note] /home/qa-user1/rr/build-mariadb/sql/mysqld (mysqld 10.3.7-MariaDB-log) starting as process 32340 ...
|
2018-04-25 16:10:38 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4182)
|
2018-04-25 16:10:38 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
|
2018-04-25 16:10:38 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16008' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.
|
2018-04-25 16:10:39 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated
|
2018-04-25 16:10:39 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on
|
2018-04-25 16:10:39 0 [Note] /home/qa-user1/rr/build-mariadb/sql/mysqld (mysqld 10.3.7-MariaDB-log) starting as process 32345 ...
|
2018-04-25 16:10:39 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4182)
|
2018-04-25 16:10:39 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
|
2018-04-25 16:10:39 0 [Warning] WSREP: wsrep_sst_receive_address is set to '127.0.0.1:16011' which makes it impossible for another host to reach this one. Please set it to the address which this node can be connected at by other cluster members.
|
--- /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_safe_to_bootstrap.result 2018-04-23 18:14:30.323304537 +0300
|
+++ /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_safe_to_bootstrap.reject 2018-04-25 16:11:02.705087084 +0300
|
@@ -2,21 +2,35 @@
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
+connection node_2;
|
+connection node_1;
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
+connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
|
+connection node_3;
|
+connection node_1;
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 1']
|
+connection node_2;
|
+connection node_1;
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
include/assert_grep.inc [grastate.dat does not have 'safe_to_bootstrap: 0']
|
+connection node_2;
|
+connection node_1;
|
SET SESSION wsrep_on = OFF;
|
Killing server ...
|
safe_to_bootstrap: 1
|
safe_to_bootstrap: 0
|
safe_to_bootstrap: 0
|
+connection node_1;
|
+connection node_2;
|
+connection node_3;
|
+connection node_2;
|
CALL mtr.add_suppression("Failed to prepare for incremental state transfer");
|
+connection node_3;
|
CALL mtr.add_suppression("Failed to prepare for incremental state transfer");
|
SHOW CREATE TABLE t1;
|
Table Create Table
|
|
|
mysqltest: Result length mismatch
|
|
|
- saving '/home/qa-user1/rr/build-mariadb/mysql-test/var/log/galera_3nodes.galera_safe_to_bootstrap-innodb/' to '/home/qa-user1/rr/build-mariadb/mysql-test/var/log/galera_3nodes.galera_safe_to_bootstrap-innodb/'
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 0.000 of 82 seconds executing testcases
|
|
|
Failure: Failed 1/1 tests, 0.00% were successful.
|
|
|
Failing test(s): galera_3nodes.galera_safe_to_bootstrap
|
|
|
The log files in var/log may give you some hint of what went wrong.
|
|
|
If you want to report this error, please read first the documentation
|
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
|
|
|
mysql-test-run: *** ERROR: there were failing test cases
|
[qa-user1@t4w3 mysql-test]$
|
|