[MDEV-25625] Test sys_vars.wsrep_on_without_provider fails: mysqltest: At line 8: query 'SET GLOBAL wsrep_on=ON' failed with wrong errno 1193: 'Unknown system variable 'wsrep_on'', instead of 1210... Created: 2021-05-09  Updated: 2022-11-16  Resolved: 2022-11-16

Status: Closed
Project: MariaDB Server
Component/s: Tests, wsrep
Affects Version/s: 10.5.10
Fix Version/s: 10.5.19

Type: Bug Priority: Major
Reporter: Thomas Deutschmann Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: tests


 Description   

$ ./mtr sys_vars.wsrep_on_without_provider
Logging: /var/tmp/portage/dev-db/mariadb-10.5.10/work/mysql/mysql-test/mysql-test-run.pl  sys_vars.wsrep_on_without_provider
vardir: /var/tmp/portage/dev-db/mariadb-10.5.10/work/mariadb-10.5.10_build/mysql-test/var
Removing old var directory...
Creating var directory '/var/tmp/portage/dev-db/mariadb-10.5.10/work/mariadb-10.5.10_build/mysql-test/var'...
Checking supported features...
MariaDB Version 10.5.10-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
sys_vars.wsrep_on_without_provider       [ fail ]
        Test ended at 2021-05-09 12:12:52
 
CURRENT_TEST: sys_vars.wsrep_on_without_provider
mysqltest: At line 8: query 'SET GLOBAL wsrep_on=ON' failed with wrong errno 1193: 'Unknown system variable 'wsrep_on'', instead of 1210...
 
The result from queries just before the failure was:
SET GLOBAL wsrep_on=ON;
 
 - saving '/var/tmp/portage/dev-db/mariadb-10.5.10/work/mariadb-10.5.10_build/mysql-test/var/log/sys_vars.wsrep_on_without_provider/' to '/var/tmp/portage/dev-db/mariadb-10.5.10/work/mariadb-10.5.10_build/mysql-test/var/log/sys_vars.wsrep_on_without_provider/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 1 seconds executing testcases
 
Failure: Failed 1/1 tests, 0.00% were successful.
 
Failing test(s): sys_vars.wsrep_on_without_provider



 Comments   
Comment by Sergei Golubchik [ 2021-05-13 ]

You must've compiled without wsrep, like -DWITH_WSREP=OFF, was it intentional?

Comment by Chris Ross [ 2022-11-14 ]

Apologies for commenting on a closed bug, but I am seeing this same problem, and this issue looks to have been abandoned by the original submitter.
I am seeing this with 10.5.16, and yes I purposely compiled without WSREP. Other wsrep tests show skipped, but this one does not. I assume it should be skipped like the others, shouldn't it?

sys_vars.wsrep_node_address_basic [ skipped ] Test requires wsrep plugin.
sys_vars.wsrep_node_incoming_address_basic [ skipped ] Test requires wsrep plugin.
sys_vars.wsrep_node_name_basic [ skipped ] Test requires wsrep plugin.
sys_vars.wsrep_on_without_provider [ fail ]
Test ended at 2022-11-14 22:39:24

CURRENT_TEST: sys_vars.wsrep_on_without_provider
mysqltest: At line 8: query 'SET GLOBAL wsrep_on=ON' failed with wrong errno 1193: 'Unknown system variable 'wsrep_on'', instead of 1210...

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