Checking supported features... MariaDB Version 10.5.2-0-MariaDB-enterprise-debug - SSL connections supported - binaries are debug compiled - binaries built with wsrep patch Using suites: galera,wsrep Collecting tests... Installing system database... Using parallel: 8 worker[3] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039 worker[2] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059 worker[4] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079 worker[5] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099 worker[6] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119 worker[8] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139 worker[7] Using MTR_BUILD_THREAD 307, with reserved ports 16140..16159 ============================================================================== TEST WORKER RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- galera.GCF-1081 [ disabled ] MDEV-18283 Galera test failure on galera.GCF-1081 galera.GCF-939 [ disabled ] MDEV-21520 galera.GCF-939 galera.MDEV-16509 [ disabled ] MDEV-21523 galera.MDEV-16509 galera.MDEV-20225 [ disabled ] MDEV-20886 galera.MDEV-20225 galera.MW-286 [ disabled ] MDEV-18464 Killing thread can cause mutex deadlock if done concurrently with Galera/replication victim kill galera.MW-328A [ disabled ] MDEV-21483 galera.MW-328A galera.MW-328B galera.MW-328B [ disabled ] MDEV-21483 galera.MW-328A galera.MW-328B galera.MW-329 [ disabled ] MDEV-19962 Galera test failure on MW-329 galera.galera_autoinc_sst_mariabackup [ disabled ] Known issue, may require porting MDEV-17458 from later versions galera.galera_bf_abort_group_commit [ disabled ] MDEV-18282 Galera test failure on galera.galera_bf_abort_group_commit galera.galera_binlog_stmt_autoinc [ disabled ] MDEV-19959 Galera test failure on galera_binlog_stmt_autoinc galera.galera_defaults [ disabled ] MDEV-21494 Galera test sporadic failure on galera.galera_defaults galera.galera_encrypt_tmp_files [ disabled ] Get error failed to enable encryption of temporary files galera.galera_ftwrl [ disabled ] MDEV-21525 galera.galera_ftwrl galera.galera_gcache_recover_manytrx [ disabled ] MDEV-18834 Galera test failure galera.galera_ist_progress [ disabled ] MDEV-15236 fails when trying to read transfer status galera.galera_kill_largechanges [ disabled ] MDEV-18179 Galera test failure on galera.galera_kill_largechanges galera.galera_kill_nochanges [ disabled ] MDEV-18280 Galera test failure on galera_split_brain and galera_kill_nochanges galera.galera_load_data [ disabled ] MDEV-19968 galera.galera_load_data galera.galera_many_tables_nopk [ disabled ] MDEV-18182 Galera test failure on galera.galera_many_tables_nopk galera.galera_mdl_race [ disabled ] MDEV-21524 galera.galera_mdl_race galera.galera_parallel_autoinc_largetrx [ disabled ] MDEV-20916 galera.galera_parallel_autoinc_largetrx galera.galera_parallel_simple [ disabled ] MDEV-20318 galera.galera_parallel_simple fails galera.galera_pc_ignore_sb [ disabled ] MDEV-20888 galera.galera_pc_ignore_sb galera.galera_shutdown_nonprim [ disabled ] MDEV-21493 galera.galera_shutdown_nonprim galera.galera_split_brain [ disabled ] MDEV-18280 Galera test failure on galera_split_brain and galera_kill_nochanges galera.galera_ssl_upgrade [ disabled ] MDEV-19950 Galera test failure on galera_ssl_upgrade galera.galera_sst_mariabackup_encrypt_with_key [ disabled ] MDEV-21484 galera_sst_mariabackup_encrypt_with_key galera.galera_sst_mariabackup_table_options [ disabled ] MDEV-19741 Galera test failure on galera.galera_sst_mariabackup_table_options galera.galera_toi_ddl_nonconflicting [ disabled ] MDEV-21518 galera.galera_toi_ddl_nonconflicting galera.galera_var_innodb_disallow_writes [ disabled ] MDEV-20928 galera.galera_var_innodb_disallow_writes galera.galera_var_node_address [ disabled ] MDEV-20485 Galera test failure galera.galera_var_notify_cmd [ disabled ] MDEV-21905 Galera test galera_var_notify_cmd causes hang galera.galera_var_reject_queries [ disabled ] assertion in inline_mysql_socket_send galera.galera_var_retry_autocommit [ disabled ] MDEV-18181 Galera test failure on galera.galera_var_retry_autocommit galera.galera_wan [ disabled ] MDEV-17259 Test failure on galera.galera_wan galera.galera_wsrep_new_cluster [ disabled ] MDEV-21515 galera.galera_wsrep_new_cluster galera.lp1376747-4 [ disabled ] MDEV-21911 Galera test failure on lp1376747-4 galera.mysql-wsrep#198 [ disabled ] MDEV-18935 Galera test mysql-wsrep#198 sporaric assertion transaction.cpp:362: int wsrep::transaction::before_commit(): Assertion `state() == s_executing || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed. galera.partition [ disabled ] MDEV-19958 Galera test failure on galera.partition galera.query_cache [ disabled ] MDEV-15805 Test failure on galera.query_cache galera.sql_log_bin [ disabled ] MDEV-21491 galera.sql_log_bin galera.versioning_trx_id [ disabled ] MDEV-18590 galera.versioning_trx_id wsrep.variables [ disabled ] MDEV-17585,MDEV-20581 Crash on wsrep.variables test case galera.MW-86-wait1 'innodb' w3 [ pass ] 2725 galera.galera_nbo_temporary_table 'innodb' w6 [ pass ] 2017 galera.galera_forced_binlog_format 'innodb' w1 [ pass ] 2062 galera.MW-44 'innodb' w8 [ pass ] 2036 galera.galera_log_output_csv 'innodb' w2 [ pass ] 2054 galera.galera_nbo_alter_partition 'innodb' w7 [ pass ] 2141 galera.galera_multirow_rollback 'binlogon,innodb' w5 [ pass ] 2155 galera.mdev_18730 'innodb' w4 [ pass ] 5079 galera.MW-402 'innodb' w1 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.mysql-wsrep-features#128 'innodb' w3 [ pass ] 3815 galera.MW-416 'innodb' w1 [ pass ] 2029 galera.basic 'innodb' w1 [ pass ] 2042 galera.galera_desync_overlapped 'innodb' w8 [ pass ] 3276 galera.galera_nbo_alter_copy 'innodb' w2 [ pass ] 4256 galera.binlog_checksum 'innodb' w1 [ pass ] 2053 galera.galera_nbo_alter_engine 'innodb' w2 [ pass ] 2060 galera.create 'innodb' w1 [ pass ] 2131 galera.galera_nbo_alter_error_duplicate 'innodb' w2 [ pass ] 2118 galera.enforce_storage_engine 'innodb' w1 [ pass ] 2030 galera.galera_restart_nochanges 'innodb' w7 [ pass ] 9480 galera.galera_var_max_ws_rows 'innodb' w4 [ pass ] 9014 galera.ev51914 'innodb' w1 [ pass ] 2136 galera.galera_var_max_ws_size 'innodb' w4 [ pass ] 2030 galera.galera_drop_database 'innodb' w8 [ pass ] 9175 galera.GAL-419 'innodb' w6 [ pass ] 18810 galera.fk 'innodb' w1 [ pass ] 2122 galera.galera_var_mysql_replication_bundle 'innodb' w4 [ pass ] 2028 galera.galera_nbo_alter_exclusive 'innodb' w2 [ pass ] 6237 galera.galera_drop_multi 'innodb' w8 [ pass ] 2046 galera.mdev_9290 'innodb' w3 [ pass ] 2037 galera.galera#500 'innodb' w1 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_var_replicate_myisam_off 'innodb' w4 [ pass ] 2019 galera.galera_enum 'innodb' w8 [ pass ] 2045 galera.mysql-wsrep#110 'innodb' w3 [ pass ] 2053 galera.galera#505 'innodb' w1 [ pass ] 2013 galera.galera_var_replicate_myisam_on 'innodb' w4 [ pass ] 2092 galera.galera_nbo_alter_inplace 'innodb' w2 [ pass ] 4175 galera.galera_events 'innodb' w8 [ pass ] 3028 galera.galera_FK_duplicate_client_insert 'innodb' w1 [ pass ] 2398 galera.mysql-wsrep#237 'innodb' w3 [ pass ] 3030 galera.galera_var_sync_wait 'innodb' w4 [ pass ] 2058 galera.galera_nbo_alter_multi 'innodb' w2 [ pass ] 2032 galera.GCF-329A 'innodb' w6 [ pass ] 9193 galera.galera_var_wsrep_on_off 'innodb' w4 [ pass ] 2025 galera.galera_nbo_alter_nonconflicting 'innodb' w2 [ pass ] 2334 galera.mysql-wsrep#247 'innodb' w3 [ pass ] 3024 galera.galera_admin 'innodb' w1 [ pass ] 3238 galera.galera_wsrep_provider_options_syntax 'innodb' w4 [ pass ] 2012 galera.galera_alter_engine_innodb 'innodb' w1 [ pass ] 2037 galera.galera_nbo_alter_parallel 'innodb' w2 [ pass ] 2247 galera.galera_alter_engine_myisam 'innodb' w1 [ pass ] 2038 galera.galera_nbo_alter_rename 'innodb' w2 [ pass ] 2040 galera.galera_alter_table_force 'innodb' w1 [ pass ] 2032 galera.galera_wsrep_provider_unset_set 'innodb' w4 [ pass ] 5253 galera.galera_nbo_alter_toi 'innodb' w2 [ pass ] 2253 galera.galera_applier_ftwrl_table 'innodb' w1 [ pass ] 2033 galera.galera_zero_length_column 'innodb' w4 [ pass ] 2044 galera.galera_nbo_create_index 'innodb' w2 [ pass ] 2039 galera.mysql-wsrep#31 'innodb' w3 [ pass ] 10114 galera.galera_bf_abort 'innodb' w1 [ pass ] 2028 galera.grant 'innodb' w4 [ pass ] 2019 galera.galera_nbo_ddl_error 'innodb' w2 [ pass ] 2034 galera.galera_events2 'innodb' w8 [ pass ] 15774 galera.galera_bf_abort_at_after_statement 'innodb' w1 [ pass ] 2024 galera.lp1276424 'innodb' w4 [ pass ] 2024 galera.galera_nbo_error_on_all 'innodb' w2 [ pass ] 2032 galera.galera_fk_cascade_delete 'innodb' w8 [ pass ] 2050 galera.galera_bf_abort_flush_for_export 'innodb' w1 [ pass ] 2032 galera.lp1347768 'innodb' w4 [ pass ] 2024 galera.galera_nbo_local_mdl 'innodb' w2 [ pass ] 2043 galera.galera_fk_cascade_update 'innodb' w8 [ pass ] 2049 galera.galera_bf_abort_for_update 'innodb' w1 [ pass ] 2029 galera.GCF-329B 'innodb' w6 [ pass ] 20159 galera.galera_nbo_processlist 'innodb' w2 [ pass ] 2051 galera.galera_fk_conflict 'innodb' w8 [ pass ] 2042 galera.mysql-wsrep#332 'innodb' w3 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.lp1376747 'innodb' w4 [ pass ] 4040 galera.galera_bf_abort_ftwrl 'innodb' w1 [ pass ] 2030 galera.galera_nbo_unsupported 'innodb' w2 [ pass ] 2024 galera.galera_fk_mismatch 'innodb' w8 [ pass ] 2045 galera.mysql-wsrep#90 'innodb' w3 [ pass ] 2059 galera.lp1376747-2 'innodb' w4 [ pass ] 2040 galera.galera_nopk_bit 'innodb' w2 [ pass ] 2034 galera.galera_bf_abort_get_lock 'innodb' w1 [ pass ] 3026 galera.galera_fk_multicolumn 'innodb' w8 [ pass ] 2048 galera.mysql-wsrep-features#127 'innodb' w3 [ pass ] 2023 galera.lp1376747-3 'innodb' w4 [ pass ] 2039 galera.galera_nopk_blob 'innodb' w2 [ pass ] 2036 galera.galera_bf_abort_lock_table 'innodb' w1 [ pass ] 2028 galera.galera_fk_multitable 'innodb' w8 [ pass ] 2038 galera.mysql-wsrep-features#131 'innodb' w3 [ pass ] 2139 galera.lp1438990 'innodb' w4 [ pass ] 2050 galera.galera_nopk_large_varchar 'innodb' w2 [ pass ] 2038 galera.galera_fk_no_pk 'innodb' w8 [ pass ] 2044 galera.mysql-wsrep-features#132 'innodb' w3 [ pass ] 2046 galera.GCF-849 'innodb' w6 [ pass ] 10157 galera.lp959512 'innodb' w4 [ pass ] 2036 galera.galera_nopk_unicode 'innodb' w2 [ pass ] 2029 galera.galera_fk_selfreferential 'innodb' w8 [ pass ] 2026 galera.galera_toi_drop_database 'innodb' w5 [ pass ] 55499 galera.galera_toi_ftwrl 'innodb' w5 [ pass ] 2032 galera.galera_fk_setnull 'innodb' w8 [ pass ] 2045 galera.pxc-421 'innodb' w3 [ pass ] 5227 galera.galera_parallel_apply_lock_table 'innodb' w2 [ pass ] 4041 galera.galera_bf_abort_shutdown 'innodb' w1 [ pass ] 8250 galera.galera_flush_local 'innodb' w8 [ skipped ] Test requires: 'have_wsrep_replicate_myisam' galera.galera_toi_lock_exclusive 'innodb' w5 [ pass ] 3033 galera.rename 'innodb' w3 [ pass ] 2045 galera.galera_performance_schema 'innodb' w2 [ pass ] 2042 galera.galera_bf_abort_sleep 'innodb' w1 [ pass ] 2026 galera.galera_ftwrl_drain 'innodb' w8 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_toi_lock_shared 'innodb' w5 [ pass ] 2027 galera.unique_key 'innodb' w3 [ pass ] 2061 galera.galera_pk_bigint_signed 'innodb' w2 [ pass ] 2023 galera.GCF-854 'innodb' w6 [ pass ] 10204 galera.galera_binlog_cache_size 'innodb' w1 [ pass ] 3038 galera.galera_toi_truncate 'innodb' w5 [ pass ] 2058 galera.galera_pk_bigint_unsigned 'innodb' w2 [ pass ] 2022 galera.view 'innodb' w3 [ pass ] 2040 galera.galera_binlog_row_image 'innodb' w1 [ pass ] 2094 galera.galera_transaction_read_only 'innodb' w5 [ pass ] 2032 galera.galera_prepared_statement 'innodb' w2 [ pass ] 2081 galera.wsrep_strict_ddl 'innodb' w3 [ pass ] 2062 galera.galera_change_user 'innodb' w1 [ pass ] 2033 galera.galera_transaction_replay 'innodb' w5 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_read_only 'innodb' w2 [ pass ] 2035 galera.wsrep_trx_fragment_size_sr 'innodb' w3 [ pass ] 2016 galera.galera_commit_empty 'innodb' w1 [ pass ] 2016 galera.galera_gra_log 'innodb' w8 [ pass ] 9189 galera.galera_truncate 'innodb' w5 [ pass ] 2104 galera.galera_repl_key_format_flat16 'innodb' w2 [ pass ] 2041 galera.galera_create_function 'innodb' w1 [ pass ] 2032 galera.galera_insert_delayed 'innodb' w8 [ pass ] 2010 galera.galera_truncate_temporary 'innodb' w5 [ pass ] 2069 galera.galera_repl_max_ws_size 'innodb' w2 [ pass ] 2030 galera.galera_create_procedure 'innodb' w1 [ pass ] 2047 galera.galera_insert_ignore 'innodb' w8 [ pass ] 2076 galera.galera_unicode_identifiers 'innodb' w5 [ pass ] 2114 galera.GCF-360 'innodb' w4 [ pass ] 3418 galera.galera_create_table_as_select 'innodb' w1 [ pass ] 2230 galera.galera_insert_multi 'innodb' w8 [ pass ] 2129 galera.galera_unicode_pk 'innodb' w5 [ pass ] 2044 galera.galera_create_table_like 'innodb' w1 [ pass ] 2078 galera.galera_update_limit 'innodb' w5 [ pass ] 2061 galera.galera_create_trigger 'innodb' w1 [ pass ] 2101 galera.galera_var_OSU_method 'innodb' w5 [ pass ] 2033 galera.galera_ddl_multiline 'innodb' w1 [ pass ] 2162 galera.galera_var_OSU_method2 'innodb' w5 [ pass ] 2040 galera.MDEV-18832 'innodb' w4 [ pass ] 2058 galera.MDEV-10715 'innodb' w3 [ pass ] 2041 galera.galera_delete_limit 'innodb' w1 [ pass ] 2067 galera.galera_restart_on_unknown_option 'innodb' w7 [ pass ] 77993 galera.galera_var_auto_inc_control_off 'innodb' w5 [ pass ] 4041 galera.galera_kill_applier 'innodb' w8 [ pass ] 2044 galera.galera_var_certify_nonPK_off 'innodb' w5 [ pass ] 2059 galera.galera_roles 'innodb' w7 [ pass ] 5176 galera.galera_rsu_error 'innodb' w7 [ pass ] 2048 galera.galera_rsu_simple 'innodb' w7 [ pass ] 2050 galera.MDEV-15443 'innodb' w2 [ pass ] 9566 galera.galera_var_cluster_address 'innodb' w5 [ pass ] 6547 galera.galera_rsu_wsrep_desync 'innodb' w7 [ pass ] 4187 galera.galera_var_desync_on 'innodb' w5 [ pass ] 3080 galera.galera_sbr 'innodb' w7 [ pass ] 2115 galera.galera_schema_dirty_reads 'innodb' w7 [ pass ] 2010 galera.galera_var_dirty_reads 'innodb' w5 [ pass ] 4325 galera.MDEV-6860 'innodb' w4 [ pass ] 5771 galera.galera_var_fkchecks 'innodb' w5 [ pass ] 2200 galera.galera_var_ignore_apply_errors 'innodb' w5 [ pass ] 3127 galera.galera_serializable 'innodb' w7 [ pass ] 6424 galera.MW-284 'innodb' w1 [ pass ] 11815 galera.galera_kill_ddl 'innodb' w8 [ pass ] 20343 galera.galera_server 'innodb' w7 [ pass ] 2257 galera.MW-313 'innodb' w2 [ pass ] 2088 galera.enforce_storage_engine2 'innodb' w1 [ pass ] 2080 galera.MW-336 'innodb' w4 [ pass ] 2595 galera.galera_set_position_after_cert_failure 'innodb' w7 [ pass ] 11883 galera.MW-86-wait8 'innodb' w5 [ pass ] 4389 galera.galera_kill_smallchanges 'innodb' w8 [ pass ] 20821 galera.galera_applier_ftwrl_table_alter 'innodb' w4 [ pass ] 9099 galera.galera_lock_table 'innodb' w8 [ pass ] 5254 galera.galera#414 'innodb' w2 [ pass ] 9436 galera.galera_many_indexes 'innodb' w8 [ pass ] 3018 galera.galera_set_position_after_dummy_writeset 'innodb' w7 [ pass ] 10671 galera.galera_mdev_10812 'innodb' w8 [ pass ] 6115 galera.galera_multi_database 'innodb' w8 [ pass ] 2370 galera.galera_as_master 'innodb' w5 [ pass ] 4868 galera.galera_slave_replay 'innodb' w7 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_sp_bf_abort 'innodb' w7 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_multirow_rollback 'binlogoff,innodb' w8 [ pass ] 6861 galera.galera-features#117 'innodb' w1 [ pass ] 11772 MTR's internal check of the test case 'galera.galera-features#117' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/var/tmp/mtr/1/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/var/tmp/mtr/1/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:16020 (socket /var/tmp/mtr/tmp/1/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /var/tmp/mtr/1/tmp/check-mysqld_1.result 2020-04-17 02:27:35.533130618 +0000 +++ /var/tmp/mtr/1/tmp/check-mysqld_1.reject 2020-04-17 02:27:47.537898682 +0000 @@ -79,7 +79,7 @@ AUTOCOMMIT ON AUTOMATIC_SP_PRIVILEGES ON AUTO_INCREMENT_INCREMENT 2 -AUTO_INCREMENT_OFFSET 1 +AUTO_INCREMENT_OFFSET 2 BACK_LOG 80 BASEDIR /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/Debug/label/sles-12 BIG_TABLES OFF mysqltest: Result content mismatch not ok galera.galera_bf_lock_wait 'innodb' w6 [ pass ] 102324 galera.galera_myisam_autocommit 'innodb' w8 [ pass ] 5935 galera.galera_as_slave 'innodb' w2 [ pass ] 4571 galera.galera_as_master_large 'innodb' w4 [ pass ] 2089 galera.galera_myisam_transactions 'innodb' w8 [ pass ] 4477 galera.galera_as_slave_autoinc 'innodb' w5 [ pass ] 7950 galera.galera_nbo_alter_conflicting 'innodb' w8 [ pass ] 8481 galera.galera_as_slave_ctas 'innodb' w1 [ pass ] 2561 galera.galera_sp_insert_parallel 'innodb' w7 [ pass ] 31895 galera.galera_as_slave_gtid_auto_engine 'innodb' w4 [ pass ] 6701 galera.galera_as_slave_gtid 'innodb' w2 [ pass ] 7254 galera.galera_sql_log_bin_zero 'innodb' w7 [ pass ] 3793 galera.galera_status_cluster 'innodb' w7 [ pass ] 2015 galera.galera_as_slave_gtid_myisam 'innodb' w5 [ pass ] 7688 galera.galera_status_local_index 'innodb' w7 [ pass ] 2030 galera.galera_bf_background_statistics 'innodb' w1 [ pass ] 11155 galera.galera_status_local_state 'innodb' w7 [ pass ] 2087 galera.galera_binlog_checksum 'innodb' w4 [ pass ] 3413 galera.MENT-432-B 'innodb' w3 [ fail ] Test ended at 2020-04-17 02:28:47 CURRENT_TEST: galera.MENT-432-B --- /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/Debug/label/sles-12/mysql-test/suite/galera/r/MENT-432-B.result 2020-04-17 01:57:26.000000000 +0000 +++ /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/Debug/label/sles-12/mysql-test/suite/galera/r/MENT-432-B.reject 2020-04-17 02:28:46.997696292 +0000 @@ -1,3 +1,5 @@ +connection node_2; +connection node_1; connection node_1; CREATE PROCEDURE p_I (count int, tab varchar(40)) BEGIN @@ -95,6 +97,10 @@ CALL p_I(10000, 'tl');; connection node_2; connection node_1; +KILL CONNECTION 16; +KILL CONNECTION 17; +KILL CONNECTION 18; +KILL CONNECTION 19; KILL CONNECTION 20; KILL CONNECTION 21; KILL CONNECTION 22; @@ -103,10 +109,6 @@ KILL CONNECTION 25; KILL CONNECTION 26; KILL CONNECTION 27; -KILL CONNECTION 28; -KILL CONNECTION 29; -KILL CONNECTION 30; -KILL CONNECTION 31; connection node_1a; connection node_1b; connection node_1c; mysqltest: Result length mismatch - saving '/var/tmp/mtr/3/log/galera.MENT-432-B-innodb/' to '/var/tmp/mtr/log/galera.MENT-432-B-innodb/' ***Warnings generated in error logs during shutdown after running tests: galera.MENT-432-B 2020-04-17 2:27:43 1 [Warning] WSREP: no THD for trx: 131 2020-04-17 2:27:44 1 [Warning] WSREP: no THD for trx: 131 2020-04-17 2:27:46 1 [Warning] WSREP: no THD for trx: 137 2020-04-17 2:28:02 1 [Warning] WSREP: no THD for trx: 137 2020-04-17 2:28:15 1 [Warning] WSREP: no THD for trx: 141 2020-04-17 2:28:16 1 [Warning] WSREP: no THD for trx: 141 galera.galera_binlog_event_max_size_min 'innodb' w5 [ pass ] 2041 galera.galera_encryption 'innodb' w1 [ pass ] 2586 galera.galera_binlog_event_max_size_max 'innodb' w2 [ pass ] 18436 galera.galera_as_slave_nonprim 'innodb' w8 [ pass ] 18195 galera.galera_concurrent_ctas 'innodb' w6 [ pass ] 61097 galera.galera_fulltext 'innodb' w6 [ pass ] 6647 galera.galera_suspend_slave 'innodb' w7 [ pass ] 26226 galera.galera_gcs_fragment 'innodb' w8 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_encryption_restart 'innodb' w4 [ pass ] 9990 galera.galera_encryption_restart2 'innodb' w3 [ pass ] 19735 galera.galera_sync_wait_show 'innodb' w7 [ pass ] 2076 galera.galera_toi_alter_auto_increment 'innodb' w7 [ pass ] 9240 galera.galera_gcs_fc_limit 'innodb' w6 [ pass ] 3331 galera.galera_toi_ddl_locking 'innodb' w7 [ pass ] 10300 galera.galera_gtid 'innodb' w4 [ pass ] 2036 galera.galera_encryption_restart4 'innodb' w5 [ pass ] 27779 galera.galera_toi_ddl_sequential 'innodb' w7 [ pass ] 2039 galera.galera_gcs_max_packet_size 'innodb' w8 [ pass ] 3451 galera.galera_many_columns 'innodb' w6 [ pass ] 2578 galera.galera_gcache_recover 'innodb' w1 [ pass ] 33316 galera.galera_many_tables_pk 'innodb' w6 [ pass ] 15518 galera.galera_gtid_trx_conflict 'innodb' w5 [ pass ] 3308 galera.galera_encryption_restart3 'innodb' w3 [ pass ] 38580 galera.galera_gcache_recover_full_gcache 'innodb' w2 [ fail ] Test ended at 2020-04-17 02:30:13 CURRENT_TEST: galera.galera_gcache_recover_full_gcache mysqltest: In included file "./include/assert_grep.inc": included from /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/Debug/label/sles-12/mysql-test/suite/galera/t/galera_gcache_recover_full_gcache.test at line 65: At line 152: assert_grep.inc failed. The result from queries just before the failure was: < snip > connection node_1; Performing --wsrep-recover ... Using --wsrep-start-position when starting mysqld ... connection node_2; Performing --wsrep-recover ... Using --wsrep-start-position when starting mysqld ... connection node_1; include/diff_servers.inc [servers=1 2] connection node_1; DROP TABLE t1; CALL mtr.add_suppression("Skipped GCache ring buffer recovery"); include/assert_grep.inc [IST first seqno [24] not found from cache, falling back to SST] include/assert_grep.inc failed! assert_text: 'IST first seqno [24] not found from cache, falling back to SST' assert_file: '/var/tmp/mtr/2/log/mysqld.1.err' assert_select: 'IST first seqno [24] not found from cache, falling back to SST' assert_match: '' assert_count: '1' assert_only_after: 'starting as process' number of matching lines: 0 More results from queries before failure can be found in /var/tmp/mtr/2/log/galera_gcache_recover_full_gcache.log - saving '/var/tmp/mtr/2/log/galera.galera_gcache_recover_full_gcache-innodb/' to '/var/tmp/mtr/log/galera.galera_gcache_recover_full_gcache-innodb/' galera.galera_nbo_sst_slave 'innodb' w6 [ fail ] Test ended at 2020-04-17 02:30:14 CURRENT_TEST: galera.galera_nbo_sst_slave 2020-04-17 2:30:10 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated 2020-04-17 2:30:10 0 [Note] /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/Debug/label/sles-12/bin/mysqld (mysqld 10.5.2-0-MariaDB-enterprise-debug-log) starting as process 2577 ... 2020-04-17 2:30:10 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190) 2020-04-17 2:30:10 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) mysqltest: At line 46: command "$MYSQLD --defaults-group-suffix=.2 --defaults-file=$MYSQLTEST_VARDIR/my.cnf" failed with wrong error: 0 The result from queries just before the failure was: connection node_2; connection node_1; connection node_1; connection node_2; connection node_2; connection node_1; CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; SET GLOBAL debug_dbug = 'd,sync.wsrep_alter_locked_tables'; SET SESSION wsrep_osu_method=NBO; ALTER TABLE t1 LOCK=SHARED, ADD COLUMN f2 INTEGER;; connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1; connection node_1a; SET SESSION wsrep_sync_wait = 0; connection node_2; restart node_2, should fail - saving '/var/tmp/mtr/6/log/galera.galera_nbo_sst_slave-innodb/' to '/var/tmp/mtr/log/galera.galera_nbo_sst_slave-innodb/' ***Warnings generated in error logs during shutdown after running tests: galera.galera_many_tables_pk galera.galera_nbo_sst_slave galera.galera_many_columns 2020-04-17 2:30:11 2 [Warning] WSREP: Non-blocking operation in progress, cannot donate SST 2020-04-17 2:30:11 0 [Warning] WSREP: 0.0 (jw-sles-12-6xc0fr): State transfer to 1.0 (jw-sles-12-6xc0fr) failed: -11 (Resource temporarily unavailable) 2020-04-17 2:30:11 0 [Warning] WSREP: 0.0 (jw-sles-12-6xc0fr): State transfer to 1.0 (jw-sles-12-6xc0fr) failed: -11 (Resource temporarily unavailable) 2020-04-17 2:30:11 0 [ERROR] WSREP: gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1178: Will never receive state. Need to abort. WSREP_SST: [ERROR] Parent mysqld process (PID:2577) terminated unexpectedly. (20200417 02:30:14.469) galera.galera_gtid_slave_sst_rsync 'innodb' w4 [ pass ] 25209 galera.galera_last_committed_id 'binlogon,innodb' w4 [ pass ] 2039 galera.galera_gtid_slave 'innodb' w3 [ pass ] 3165 galera.galera_ist_recv_bind 'innodb' w5 [ pass ] 11552 galera.galera_ist_restart_joiner 'innodb' w3 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_parallel_autoinc_manytrx 'innodb' w6 [ pass ] 16434 galera.galera_last_committed_id 'binlogoff,innodb' w4 [ pass ] 2039 galera.galera_ist_mariabackup_innodb_flush_logs 'debug,innodb' w8 [ pass ] 42644 galera.galera_ist_rsync 'debug,innodb' w2 [ pass ] 43117 galera.galera_pc_recovery 'innodb' w6 [ pass ] 12438 galera.galera_ist_mariabackup 'debug,innodb' w7 [ pass ] 56261 galera.galera_mdev_15611 'innodb' w4 [ pass ] 2522 galera.galera_log_bin 'innodb' w3 [ pass ] 2569 galera.galera_mdev_13787 'innodb' w3 [ pass ] 2046 galera.galera_partition 'innodb' w8 [ pass ] 3202 galera.galera_query_cache 'innodb' w2 [ pass ] 2091 galera.galera_query_cache_sync_wait 'innodb' w7 [ pass ] 4064 galera.galera_sbr_binlog 'innodb' w4 [ pass ] 2043 galera.galera_ssl 'innodb' w3 [ pass ] 2081 galera.galera_ist_mysqldump 'debug,innodb' w1 [ pass ] 93382 galera.galera_ssl_compression 'innodb' w3 [ pass ] 2063 galera.galera_rsu_add_pk 'innodb' w6 [ pass ] 45807 galera.galera_sst_mysqldump_with_key 'debug,innodb' w4 [ pass ] 27333 galera.galera_many_rows 'innodb' w5 [ pass ] 88660 galera.galera_sync_wait_upto 'binlogon,innodb' w4 [ pass ] 3039 galera.galera_sst_mariabackup 'debug,innodb' w8 [ pass ] 62479 galera.galera_sync_wait_upto 'binlogoff,innodb' w5 [ pass ] 3037 galera.galera_v1_row_events 'innodb' w4 [ pass ] 2047 galera.galera_sst_rsync2 'debug,innodb' w1 [ pass ] 44555 galera.galera_sst_mariabackup_data_dir 'debug,innodb' w2 [ pass ] 62670 galera.galera_sst_rsync 'debug,innodb' w3 [ pass ] 44712 galera.galera_var_auto_inc_control_on 'innodb' w8 [ pass ] 2076 galera.galera_var_gtid_domain_id 'innodb' w5 [ pass ] 2699 galera.galera_var_log_bin 'innodb' w4 [ pass ] 2044 galera.galera_var_sst_auth 'innodb' w2 [ pass ] 2013 galera.galera_var_slave_threads 'innodb' w1 [ pass ] 2330 galera.mdev_10518 'innodb' w1 [ pass ] 2823 galera.galera_wsrep_log_conficts 'innodb' w2 [ pass ] 2060 galera.galera_rsu_drop_pk 'innodb' w6 [ pass ] 78584 galera.galera_toi_ddl_error 'innodb' w6 [ pass ] 11585 galera.galera_vote_rejoin_dml 'innodb' w8 [ pass ] 24722 galera.mysql-wsrep#201 'innodb' w1 [ pass ] 2838 galera.galera_toi_ddl_fk_insert 'innodb' w6 [ pass ] 8800 galera.rpl_row_annotate 'innodb' w8 [ pass ] 2048 wsrep.pool_of_threads 'innodb' w1 [ pass ] 6 galera.galera_toi_ddl_fk_update 'innodb' w6 [ pass ] 7578 galera.galera_sst_rsync_data_dir 'debug,innodb' w3 [ pass ] 44788 wsrep.plugin 'innodb' w1 [ pass ] 8 wsrep.MDEV-20625 'innodb' w1 [ pass ] 11 galera.galera_sst_mysqldump 'debug,innodb' w7 [ pass ] 136034 wsrep.foreign_key 'innodb' w8 [ pass ] 47 galera.galera_var_load_data_splitting 'innodb' w6 [ pass ] 7176 wsrep.mdev_10186 'innodb' w8 [ pass ] 4 wsrep.mdev_6832 'innodb' w8 [ pass ] 132 galera.galera_wan_restart_sst 'innodb' w4 [ pass ] 38198 wsrep.alter_table_innodb 'innodb' w1 [ pass ] 6690 wsrep.mdev_7798 'innodb' w8 [ pass ] 2728 wsrep.binlog_format 'innodb' w7 [ pass ] 33 galera.galera_wan_restart_ist 'innodb' w5 [ pass ] 52196 wsrep.wsrep_rpl 'innodb,mix' w5 [ pass ] 197 wsrep.wsrep_rpl 'innodb,row' w5 [ pass ] 207 wsrep.wsrep_rpl 'innodb,stmt' w5 [ pass ] 241 wsrep.wsrep-recover-v25 'binlogoff,innodb' w1 [ pass ] 9263 wsrep.wsrep-recover-v25 'binlogon,innodb' w4 [ pass ] 12853 wsrep.wsrep-recover 'binlogon,innodb' w8 [ pass ] 15947 galera.GAL-480 'innodb' w1 [ pass ] 2168 wsrep.wsrep-recover 'binlogoff,innodb' w7 [ pass ] 16066 galera.GCF-563 'innodb' w1 [ pass ] 2265 galera.MDEV-20793 'innodb' w1 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_wsrep_desync_wsrep_on 'innodb' w6 [ pass ] 31518 galera.MENT-644 'innodb' w1 [ pass ] 2043 galera.galera_vote_rejoin_ddl 'innodb' w3 [ pass ] 20843 galera.GAL-382 'innodb' w6 [ pass ] 2047 wsrep.mysql_tzinfo_to_sql_symlink 'innodb' w3 [ pass ] 27 wsrep.mysql_tzinfo_to_sql_symlink_skip 'innodb' w3 [ pass ] 24 wsrep.trans 'innodb' w3 [ pass ] 2 galera.MW-252 'innodb' w6 [ pass ] 2171 galera.GAL-401 'innodb' w5 [ pass ] 16639 galera.GCF-546 'innodb' w8 [ pass ] 8149 galera.GCF-421 'innodb' w4 [ pass ] 14213 galera.MW-259 'innodb' w6 [ pass ] 4133 galera.MW-258 'innodb' w1 [ pass ] 10042 galera.MW-357 'innodb' w4 [ pass ] 2022 galera.MW-309 'innodb' w6 [ pass ] 2037 galera.MW-328D 'innodb' w5 [ pass ] 4035 galera.MW-328E 'innodb' w8 [ pass ] 4040 galera.MDEV-20616 'innodb' w7 [ pass ] 10732 galera.MW-285 'innodb' w3 [ pass ] 2093 galera.MW-388 'innodb' w1 [ pass ] 2165 galera.MW-369 'innodb' w6 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.MW-292 'innodb' w3 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.mysql-wsrep#33 'debug,innodb' w2 [ pass ] 81709 -------------------------------------------------------------------------- The servers were restarted 122 times Spent 2763.702 of 682 seconds executing testcases Check of testcase failed for: galera.galera-features#117 Completed: Failed 3/313 tests, 99.04% were successful. Failing test(s): galera.MENT-432-B galera.galera_gcache_recover_full_gcache galera.galera_nbo_sst_slave 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 Errors/warnings were found in logfiles during server shutdown after running the following sequence(s) of tests: galera.MENT-432-B galera.galera_many_tables_pk galera.galera_nbo_sst_slave galera.galera_many_columns 13 tests were skipped, 13 by the test itself. mysql-test-run: *** ERROR: there were failing test cases