summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera_3nodes
Commit message (Collapse)AuthorAgeFilesLines
* Merge 10.3 into 10.4Marko Mäkelä2019-07-254-0/+103
|\
| * Fixed dependency checking in some Galera tests + remove duplicatesJulius Goryavsky2019-07-182-0/+2
| |
| * MDEV-18565: Galera mtr-suite fails if galera library is not installed (#1243)sysprg2019-07-097-52/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * MDEV-18565: Galera mtr-suite fails if galera library is not installed Currently, running mtr with an incorrect (for example, new or obsolete) version of wsrep_provider (for example, with the 26 version of libgalera_smm.so) leads to the failure of tests in several suites with vague error diagnostics. As for the galera_3nodes suite, the mtr also does not effectively check all the prerequisites after merge with MDEV-18426 fixes. For example, tests that using mariabackup do not check for presence of ss and socat/nc. This is due to improper handling of relative paths in mtr scripts. In addition, some tests in different suites can be run without setting the environment variables such as MTR_GALERA_TFMT, XBSTREAM, and so on. To eliminate all these issues, this patch makes the following changes: 1. Added auxiliary wsrep_mtr_check utility (which located in the mysql-test/lib/My/SafeProcess subdirectory), which compares the versions of the wsrep API that used by the server and by the wsrep provider library, and it does this comparison safely, without accessing the API if the versions do not match. 2. All checks related to the presence of mariabackup and utilities that necessary for its operation transferred from the local directories of different mtr suites (from the suite.pm files) to the main suite.pm file. This not only reduces the amount of code and eliminates duplication of identical code fragments, but also avoids problems due to the inability of mtr to consider relative paths to include files when checking skip combinations. 3. Setting the values of auxiliary environment variables that are necessary for Galera, SST scripts and mariabackup (to work properly) is moved to the main mysql-test-run.pl script, so as not to duplicate this code in different suites, and to avoid partial corrections of the same errors for different suites (while other suites remain uncorrected). 4. Fixed duplication of the have_file_key_management.inc and have_filekeymanagement.inc files between different suites, these checks are also transferred to the top level. https://jira.mariadb.org/browse/MDEV-18565 * Build without additional utility in configurations without wsrep support
* | Fixed dependency checking in some Galera tests + remove duplicatesJulius Goryavsky2019-07-182-0/+2
| |
* | MDEV-18565: Galera mtr-suite fails if galera library is not installedJulius Goryavsky2019-07-175-88/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Currently, running mtr with an incorrect (for example, new or obsolete) version of wsrep_provider (for example, with the 26 version of libgalera_smm.so) leads to the failure of tests in several suites with vague error diagnostics. As for the galera_3nodes suite, the mtr also does not effectively check all the prerequisites after merge with MDEV-18426 fixes. For example, tests that using mariabackup do not check for presence of ss and socat/nc. This is due to improper handling of relative paths in mtr scripts. In addition, some tests in different suites can be run without setting the environment variables such as MTR_GALERA_TFMT, XBSTREAM, and so on. To eliminate all these issues, this patch makes the following changes: 1. Added auxiliary wsrep_mtr_check utility (which located in the mysql-test/lib/My/SafeProcess subdirectory), which compares the versions of the wsrep API that used by the server and by the wsrep provider library, and it does this comparison safely, without accessing the API if the versions do not match. 2. All checks related to the presence of mariabackup and utilities that necessary for its operation transferred from the local directories of different mtr suites (from the suite.pm files) to the main suite.pm file. This not only reduces the amount of code and eliminates duplication of identical code fragments, but also avoids problems due to the inability of mtr to consider relative paths to include files when checking skip combinations. 3. Setting the values of auxiliary environment variables that are necessary for Galera, SST scripts and mariabackup (to work properly) is moved to the main mysql-test-run.pl script, so as not to duplicate this code in different suites, and to avoid partial corrections of the same errors for different suites (while other suites remain uncorrected). 4. Fixed duplication of the have_file_key_management.inc and have_filekeymanagement.inc files between different suites, these checks are also transferred to the top level. 5. Added garbd presence check and garbd path variable. https://jira.mariadb.org/browse/MDEV-18565
* | Merge 10.3 into 10.4Marko Mäkelä2019-05-292-25/+47
|\ \ | |/
| * Merge 10.2 into 10.3Marko Mäkelä2019-05-292-25/+48
| |\
| | * MDEV-16021: galera mtr test galera_evs_suspect_timeout crashedJan Lindström2019-05-172-25/+48
| | | | | | | | | | | | | | | Crash was timeout crash. Add correct waits for connections, wsrep sync waits and auto increment offset save and restore.
| * | Merge 10.2 into 10.3Marko Mäkelä2019-03-193-0/+164
| |\ \ | | |/
| | * MDEV-17262: mysql crashed on galera while node rejoined cluster (#895)sysprg2019-03-183-0/+164
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch contains a fix for the MDEV-17262/17243 issues and new mtr test. These issues (MDEV-17262/17243) have two reasons: 1) After an intermediate commit, a transaction loses its status of "transaction that registered in the MySQL for 2pc coordinator" (in the InnoDB) due to the fact that since version 10.2 the write_row() function (which located in the ha_innodb.cc) does not call trx_register_for_2pc(m_prebuilt->trx) during the processing of split transactions. It is necessary to restore this call inside the write_row() when an intermediate commit was made (for a split transaction). Similarly, we need to set the flag of the started transaction (m_prebuilt->sql_stat_start) after intermediate commit. The table->file->extra(HA_EXTRA_FAKE_START_STMT) called from the wsrep_load_data_split() function (which located in sql_load.cc) will also do this, but it will be too late. As a result, the call to the wsrep_append_keys() function from the InnoDB engine may be lost or function may be called with invalid transaction identifier. 2) If a transaction with the LOAD DATA statement is divided into logical mini-transactions (of the 10K rows) and binlog is rotated, then in rare cases due to the wsrep handler re-registration at the boundary of the split, the last portion of data may be lost. Since splitting of the LOAD DATA into mini-transactions is technical, I believe that we should not allow these mini-transactions to fall into separate binlogs. Therefore, it is necessary to prohibit the rotation of binlog in the middle of processing LOAD DATA statement. https://jira.mariadb.org/browse/MDEV-17262 and https://jira.mariadb.org/browse/MDEV-17243
* | | Adjust wsrep, galera, galera_3nodes, galera_sr and galera_3nodes_sr testsJan Lindström2019-04-024-1/+7
| | | | | | | | | | | | after commit b5615eff0d00cfb4c60b9d1bf67094da7c2258a6
* | | Merge 10.3 into 10.4Marko Mäkelä2019-03-118-0/+215
|\ \ \ | |/ /
| * | Merge 10.2 into 10.3Marko Mäkelä2019-03-118-0/+205
| |\ \ | | |/
| | * Merge 10.1 into 10.2Marko Mäkelä2019-03-118-0/+205
| | |\
| | | * Galera 3 versions of the result files recorded.Jan Lindström2019-03-093-15/+29
| | | |
| | | * galera: test cases for non [mysqld] section for configurationDaniel Black2019-03-097-0/+191
| | | |
* | | | Fixes to galera_gtid_2_cluster, galear_sr_mysqldump_sstTeemu Ollakka2019-03-041-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Timeout values in galera_2x3nodes.cnf made cluster startup unreliable. Tweaked timeout values for more reliable cluster start. Fixed restart_parameters in galera_sr_mysqldump_sst.
* | | | Merge branch '10.3' into 10.4Oleksandr Byelkin2019-02-219-11/+44
|\ \ \ \ | |/ / /
| * | | tempesta fixesOleksandr Byelkin2019-02-126-12/+2
| | | |
| * | | Merge branch '10.2' into 10.3Oleksandr Byelkin2019-02-128-57/+34
| |\ \ \ | | |/ /
| | * | Merge 10.1 into 10.2Marko Mäkelä2019-02-122-0/+2
| | |\ \ | | | |/
| | | * MDEV-18426: Most of the mtr tests in the galera_3nodes suite failJulius Goryavsky2019-02-1215-30/+102
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Most of the mtr tests in the galera_3nodes suite fail for a variety of reasons with a variety of errors. This patch fixes several substantial flaws in the galera_3nodes suite tests and in the mtr framework service files, adapting the tests from galera_3nodes for the current version of MariaDB. This patch also synchronizes some galera_3nodes-related files with the latest changes made for MDEV-17835 (v2 patch) and for MDEV-18379 in other branches (10.2 and 10.3). Closes #1161
| | * | MDEV-18426: Most of the mtr tests in the galera_3nodes suite failJulius Goryavsky2019-02-0612-27/+100
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Most of the mtr tests in the galera_3nodes suite fail for a variety of reasons with a variety of errors. Some tests simply need to add the missing "connection" lines to the result files, but many of them fail due to substantial errors that require reworking test files. This patch adds the missing "connection" lines to the result files and fixes several substantial flaws in the galera_3nodes suite tests and in the mtr framework service files, adapting the tests from galera_3nodes for the current version of MariaDB. https://jira.mariadb.org/browse/MDEV-18426
| * | | dirty mergeOleksandr Byelkin2019-02-075-1/+76
| |\ \ \ | | |/ /
| | * | Some more fixes for --suite=galera_3nodesMarko Mäkelä2019-02-025-1/+53
| | | |
| | * | MDEV-18379: IPv6 compatibility changes/Unification of check for IPv6Julius Goryavsky2019-02-0212-9/+37
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch contains the port of the MDEV-18379 patch for 10.2 branch, but also includes a number of changes made within MDEV-17835, which are necessary for the normal operation of tests that use IPv6: 1) Currently, the three-node mtr suite for Galera (galera_3nodes) uses a separate IPv6 availability check using the "have_ipv6.inc" file. This check duplicates a more accurate check at suite.pm level, which can be used by including the file "check_ipv6.inc". This patch removes this discrepancy between suites. 2) Fixed numerous bugs in the SST scripts and in the mtr test files (galera_3nodes mtr suite) that prevented the use of Galera with IPv6 addresses. 3) Fixed flaws in the galera_3nodes mtr suite control scripts, because of which they could not work with mariabackup. 4) Fixed flaws in the rsync and mysqldump tests (for galera_3nodes mtr tests suite). These tests were not performed successfully without these fixes. 5) GAL-501 test in the galera_3nodes suite does not contain the option "--bind-address=::" that is needed for the test to work correctly with IPv6 (at least on some systems), since without it the server will not wait for connections on the IPv6 interface. https://jira.mariadb.org/browse/MDEV-18379 and partially https://jira.mariadb.org/browse/MDEV-17835
| | * | Merge 10.1 into 10.2Marko Mäkelä2019-02-0220-57/+255
| | |\ \ | | | |/
| | | * MDEV-18379: Unification of check for IPv6Julius Goryavsky2019-01-2621-58/+255
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch contains the port of the MDEV-18379 patch for 10.1 branch, but also includes a number of changes made within MDEV-17835, which are necessary for the normal operation of tests that use IPv6: 1) Fixed flaws in the galera_3nodes mtr suite control scripts, because of which they could not work with mariabackup. 2) Fixed numerous bugs in the SST scripts and in the mtr test files (galera_3nodes mtr suite) that prevented the use of Galera with IPv6 addresses. 3) Fixed flaws in tests for rsync and mysqldump (for galera_3nodes mtr tests suite). These tests were not performed successfully without these fixes. 4) Currently, the three-node mtr suite for Galera (galera_3nodes) uses a separate IPv6 availability check using the "have_ipv6.inc" file. This check duplicates a more accurate check at suite.pm level, which can be used by including the file "check_ipv6.inc". This patch removes this discrepancy between suites. 5) GAL-501 test in the galera_3nodes suite does not contain the option "--bind-address=::" which is needed for the test to work correctly with IPv6 (at least on some systems), since without it the server will not wait for connections on the IPv6 interface. https://jira.mariadb.org/browse/MDEV-18379 and partially https://jira.mariadb.org/browse/MDEV-17835
* | | | Fix for galera_3nodes.galera_gtid_2_clustermkaruza2019-02-193-6/+127
| | | | | | | | | | | | | | | | Temporary disable WSREP while executing RESET MASTER. In situation when 2 nodes are both master/slave first stop slave on both and than reset master. Enforce stricter causality check with wsrep_sync_wait.
* | | | Fix for galera_3nodes.galera_garbdmkaruza2019-02-191-3/+27
| | | | | | | | | | | | | | | | Check for garbd executable on different paths. If not found terminate test.
* | | | Fixed and re-recorded tests for galeramkaruza2019-02-082-2/+1
| | | | | | | | | | | | | | | | | | | | Re-recorded: galera.galera_gcache_recover_manytrx Fixed: galera_3nodes.galera_evs_suspect_timeout
* | | | Merge 10.3 into 10.4Marko Mäkelä2019-02-059-22/+32
|\ \ \ \ | |/ / /
| * | | MDEV-18426: Most of the mtr tests in the galera_3nodes suite failJulius Goryavsky2019-01-3013-25/+109
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Most of the mtr tests in the galera_3nodes suite fail for a variety of reasons with a variety of errors. Some tests simply need to add the missing "connection" lines to the result files, but many of them fail due to substantial errors that require reworking test files. This patch adds the missing "connection" lines to the result files and fixes several substantial flaws in the galera_3nodes suite tests and in the mtr framework service files, adapting the tests from galera_3nodes for the current version of MariaDB. https://jira.mariadb.org/browse/MDEV-18426
* | | | Merge branch '10.3' into 10.4Sergei Golubchik2019-01-261-0/+1
|\ \ \ \ | |/ / /
| * | | MDEV-18379: Unification of check for IPv6Julius Goryavsky2019-01-257-19/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Currently, the three-node mtr suite for Galera (galera_3nodes) uses a separate IPv6 availability check using the "have_ipv6.inc" file. This check duplicates a more accurate check at suite.pm level, which can be used by including the file "check_ipv6.inc". This patch removes this discrepancy between suites. In addition, one of the files in the galera_3nodes suite does not contain the option "--bind-address=::" which is needed for the test to work correctly with IPv6 (at least on some systems), since without it the server will not wait for connections on the IPv6 interface. https://jira.mariadb.org/browse/MDEV-18379
* | | | Fixed Galera test regressions from 10.3 mergeTeemu Ollakka2019-01-255-12/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Made galera_3nodes.galera_ipv6_mariabackup deterministic with respect to donor selection, fixed assert grep definitions to match Galera 4 behavior and recorded. * Removed extra connection setup from galera_3nodes.galera_ipv6_mysqldump and recorded.
* | | | Merge 10.3 into 10.4Marko Mäkelä2019-01-2416-37/+222
|\ \ \ \ | |/ / /
| * | | MDEV-17835: Remove wsrep-sst-method=xtrabackupJulius Goryavsky2019-01-2219-41/+167
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The second line of changes related to replacing xtrabackup with mariabackup: 1) All unnecessary references to xtrabackup are removed from the documentation, from some comments, from the control files that are used to prepare the packages. 2) Made corrections of the tests from the galera_3nodes suite that mentioned xtrabackup or the old (associated with xtrabackup) version of innobackupex. 3) Fixed flaws in the galera_3nodes mtr suite control scripts, because of which they could not work with mariabackup. 4) Fixed numerous bugs in the SST scripts and in the mtr test files (galera_3nodes mtr suite) that prevented the use of Galera with IPv6 addresses. 5) Fixed flaws in tests for rsync and mysqldump (for galera_3nodes mtr tests suite). These tests were not performed successfully without these fixes. https://jira.mariadb.org/browse/MDEV-17835
* | | | Galera4Brave Galera Crew2019-01-2340-243/+401
|/ / /
* | | Merge 10.2 into 10.3Marko Mäkelä2018-11-261-1/+2
|\ \ \ | |/ / | | | | | | | | | The test galera_sst_mariabackup_table_options was disabled, because the server refuses to start up due to wrong parameters.
| * | MDEV-15522: Change galera suite MTR tests to use mariabackup instead of ↵Jan Lindström2018-11-221-1/+2
| | | | | | | | | | | | | | | | | | xtrabackup Disable galera_3nodes tests using xtrabackup.
* | | Merge branch '10.2' into 10.3Sergei Golubchik2018-09-282-28/+58
|\ \ \ | |/ /
| * | Merge branch '10.1' into 10.2Oleksandr Byelkin2018-09-142-28/+58
| |\ \ | | |/
| | * Merge branch '10.0-galera' into 10.1Sergei Golubchik2018-09-072-28/+58
| | |\
| | | * codership/galera#501 Check cluster weight in galera_pc_weight testTeemu Ollakka2018-08-032-32/+57
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Check that cluster weight have proper values in galera_pc_weight test. Removed sleeps from tests and added condition waits for expected cluster sizes. Replaced galera suspend/resume with gmcast.isolate in order to avoid breaking client connections to server which is isolated from the cluster and to avoid the need to reset wsrep_cluster_address. Re-recorded galera_defaults.
| * | | MDEV-16052 galera mtr galera_certification_double_failure fails with deadlockmkaruza2018-09-111-1/+1
| | | | | | | | | | | | | | | | There was change in error reporting from my_error to my_message so new recording is required.
* | | | MDEV-16052 galera mtr galera_certification_double_failure fails with deadlockmkaruza2018-08-311-1/+1
| | | | | | | | | | | | There was change in error reporting from my_error to my_message so new recording is required.
* | | | Merge branch '10.2' into 10.3Sergei Golubchik2018-06-302-0/+2
|\ \ \ \ | |/ / /
| * | | Merge branch '10.1' into 10.2Sergei Golubchik2018-06-212-0/+2
| |\ \ \ | | |/ /
| | * | Merge branch '10.0-galera' into 10.1Vicențiu Ciorbaru2018-06-122-0/+2
| | |\ \ | | | |/
View Lorry Controller Status