From fee807f6d80af18bfbb276d79c5588e24a854a14 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Jan=20Lindstr=C3=B6m?= Date: Wed, 7 Oct 2020 08:10:36 +0300 Subject: MDEV-22148 : Assertion `state_ == s_exec || state_ == s_quitting' failed in optimized builds | SIGABRT in wsrep::client_state::disable_streaming Actual bug seems to be already fixed, just adding a test case. --- .../galera/r/galera_var_trx_fragment_size.result | 95 ++++++++++++++++++++++ .../galera/t/galera_var_trx_fragment_size.test | 43 ++++++++++ 2 files changed, 138 insertions(+) create mode 100644 mysql-test/suite/galera/r/galera_var_trx_fragment_size.result create mode 100644 mysql-test/suite/galera/t/galera_var_trx_fragment_size.test diff --git a/mysql-test/suite/galera/r/galera_var_trx_fragment_size.result b/mysql-test/suite/galera/r/galera_var_trx_fragment_size.result new file mode 100644 index 00000000000..be14c53548b --- /dev/null +++ b/mysql-test/suite/galera/r/galera_var_trx_fragment_size.result @@ -0,0 +1,95 @@ +connection node_2; +connection node_1; +SET SESSION wsrep_trx_fragment_size=DEFAULT; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SET SESSION wsrep_trx_fragment_size=0; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SET GLOBAL wsrep_trx_fragment_size=DEFAULT; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SET GLOBAL wsrep_trx_fragment_size=0; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SET GLOBAL wsrep_trx_fragment_size=-1; +Warnings: +Warning 1292 Truncated incorrect wsrep_trx_fragment_size value: '-1' +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SET SESSION wsrep_trx_fragment_size=-1; +Warnings: +Warning 1292 Truncated incorrect wsrep_trx_fragment_size value: '-1' +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SET GLOBAL wsrep_trx_fragment_size=100; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 0 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SET SESSION wsrep_trx_fragment_size=100; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SET GLOBAL wsrep_trx_fragment_size='A'; +ERROR 42000: Incorrect argument type to variable 'wsrep_trx_fragment_size' +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SET SESSION wsrep_trx_fragment_size='A'; +ERROR 42000: Incorrect argument type to variable 'wsrep_trx_fragment_size' +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SET GLOBAL wsrep_trx_fragment_size=NULL; +ERROR 42000: Incorrect argument type to variable 'wsrep_trx_fragment_size' +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SET SESSION wsrep_trx_fragment_size=NULL; +ERROR 42000: Incorrect argument type to variable 'wsrep_trx_fragment_size' +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +Variable_name Value +wsrep_trx_fragment_size 100 +SET GLOBAL wsrep_trx_fragment_size=DEFAULT; diff --git a/mysql-test/suite/galera/t/galera_var_trx_fragment_size.test b/mysql-test/suite/galera/t/galera_var_trx_fragment_size.test new file mode 100644 index 00000000000..f19152f37f1 --- /dev/null +++ b/mysql-test/suite/galera/t/galera_var_trx_fragment_size.test @@ -0,0 +1,43 @@ +--source include/galera_cluster.inc + +SET SESSION wsrep_trx_fragment_size=DEFAULT; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +SET SESSION wsrep_trx_fragment_size=0; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +SET GLOBAL wsrep_trx_fragment_size=DEFAULT; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +SET GLOBAL wsrep_trx_fragment_size=0; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +SET GLOBAL wsrep_trx_fragment_size=-1; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +SET SESSION wsrep_trx_fragment_size=-1; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +SET GLOBAL wsrep_trx_fragment_size=100; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +SET SESSION wsrep_trx_fragment_size=100; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +--error ER_WRONG_TYPE_FOR_VAR +SET GLOBAL wsrep_trx_fragment_size='A'; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +--error ER_WRONG_TYPE_FOR_VAR +SET SESSION wsrep_trx_fragment_size='A'; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +--error ER_WRONG_TYPE_FOR_VAR +SET GLOBAL wsrep_trx_fragment_size=NULL; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +--error ER_WRONG_TYPE_FOR_VAR +SET SESSION wsrep_trx_fragment_size=NULL; +SHOW SESSION VARIABLES LIKE 'wsrep_trx_fragment_size'; +SHOW GLOBAL VARIABLES LIKE 'wsrep_trx_fragment_size'; +SET GLOBAL wsrep_trx_fragment_size=DEFAULT; -- cgit v1.2.1