[MDEV-16022] galera_safe_to_bootstrap test from galera mtr test fails Created: 2018-04-25  Updated: 2020-01-15  Resolved: 2020-01-15

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

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

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]$



 Comments   
Comment by Jan Lindström (Inactive) [ 2019-12-12 ]

Does this still repeat?

Comment by Stepan Patryshev (Inactive) [ 2020-01-15 ]

Closed since it is not reproduced on bb or Azure.

Generated at Thu Feb 08 08:25:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.