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[8] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139 worker[3] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039 worker[6] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099 worker[5] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079 worker[4] Using MTR_BUILD_THREAD 307, with reserved ports 16140..16159 worker[2] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059 worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 worker[7] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119 ============================================================================== 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.galera_multirow_rollback 'binlogon,innodb' w5 [ pass ] 2192 galera.galera_nbo_temporary_table 'innodb' w8 [ pass ] 2022 galera.galera_forced_binlog_format 'innodb' w6 [ pass ] 2060 galera.MW-86-wait1 'innodb' w2 [ pass ] 2065 galera.galera_log_output_csv 'innodb' w3 [ pass ] 2046 galera.MW-44 'innodb' w4 [ pass ] 2072 galera.galera_nbo_alter_partition 'innodb' w7 [ pass ] 2307 galera.mdev_18730 'innodb' w1 [ pass ] 5085 galera.mysql-wsrep-features#128 'innodb' w5 [ pass ] 5293 galera.MW-402 'innodb' w6 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_desync_overlapped 'innodb' w2 [ pass ] 3274 galera.MW-416 'innodb' w6 [ pass ] 2033 galera.galera_nbo_alter_copy 'innodb' w3 [ pass ] 4262 galera.basic 'innodb' w6 [ pass ] 2060 galera.galera_nbo_alter_engine 'innodb' w3 [ pass ] 2061 galera.binlog_checksum 'innodb' w6 [ pass ] 2059 galera.galera_nbo_alter_error_duplicate 'innodb' w3 [ pass ] 2081 galera.galera_restart_nochanges 'innodb' w4 [ pass ] 9372 galera.galera_var_max_ws_rows 'innodb' w1 [ pass ] 9239 galera.create 'innodb' w6 [ pass ] 2107 galera.galera_var_max_ws_size 'innodb' w1 [ pass ] 2028 galera.galera_drop_database 'innodb' w2 [ pass ] 9406 galera.enforce_storage_engine 'innodb' w6 [ pass ] 2027 galera.galera_var_mysql_replication_bundle 'innodb' w1 [ pass ] 2027 galera.galera_drop_multi 'innodb' w2 [ pass ] 2042 galera.galera_nbo_alter_exclusive 'innodb' w3 [ pass ] 6237 galera.mdev_9290 'innodb' w5 [ pass ] 2038 galera.ev51914 'innodb' w6 [ pass ] 2156 galera.galera_var_replicate_myisam_off 'innodb' w1 [ pass ] 2017 galera.GAL-419 'innodb' w8 [ pass ] 16900 galera.galera_enum 'innodb' w2 [ pass ] 2046 galera.mysql-wsrep#110 'innodb' w5 [ pass ] 2059 galera.fk 'innodb' w6 [ pass ] 2117 galera.galera_var_replicate_myisam_on 'innodb' w1 [ pass ] 2103 galera.galera_nbo_alter_inplace 'innodb' w3 [ pass ] 4280 galera.galera#500 'innodb' w6 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_events 'innodb' w2 [ pass ] 3030 galera.galera_var_sync_wait 'innodb' w1 [ pass ] 2053 galera.mysql-wsrep#237 'innodb' w5 [ pass ] 3136 galera.galera_nbo_alter_multi 'innodb' w3 [ pass ] 2040 galera.galera#505 'innodb' w6 [ pass ] 2014 galera.galera_var_wsrep_on_off 'innodb' w1 [ pass ] 2025 galera.mysql-wsrep#247 'innodb' w5 [ pass ] 3025 galera.galera_nbo_alter_nonconflicting 'innodb' w3 [ pass ] 2336 galera.galera_FK_duplicate_client_insert 'innodb' w6 [ pass ] 2426 galera.galera_wsrep_provider_options_syntax 'innodb' w1 [ pass ] 2018 galera.GCF-329A 'innodb' w8 [ pass ] 9222 galera.galera_nbo_alter_parallel 'innodb' w3 [ pass ] 2255 galera.galera_admin 'innodb' w6 [ pass ] 3630 galera.galera_nbo_alter_rename 'innodb' w3 [ pass ] 2045 galera.galera_wsrep_provider_unset_set 'innodb' w1 [ pass ] 5281 galera.galera_alter_engine_innodb 'innodb' w6 [ pass ] 2036 galera.galera_nbo_alter_toi 'innodb' w3 [ pass ] 2254 galera.galera_zero_length_column 'innodb' w1 [ pass ] 2048 galera.galera_alter_engine_myisam 'innodb' w6 [ pass ] 2034 galera.galera_nbo_create_index 'innodb' w3 [ pass ] 2043 galera.mysql-wsrep#31 'innodb' w5 [ pass ] 10139 galera.grant 'innodb' w1 [ pass ] 2020 galera.galera_alter_table_force 'innodb' w6 [ pass ] 2036 galera.galera_events2 'innodb' w2 [ pass ] 15909 galera.galera_nbo_ddl_error 'innodb' w3 [ pass ] 2041 galera.lp1276424 'innodb' w1 [ pass ] 2027 galera.galera_applier_ftwrl_table 'innodb' w6 [ pass ] 2029 galera.galera_fk_cascade_delete 'innodb' w2 [ pass ] 2051 galera.galera_nbo_error_on_all 'innodb' w3 [ pass ] 2031 galera.lp1347768 'innodb' w1 [ pass ] 2025 galera.galera_bf_abort 'innodb' w6 [ pass ] 2027 galera.galera_fk_cascade_update 'innodb' w2 [ pass ] 2055 galera.galera_nbo_local_mdl 'innodb' w3 [ pass ] 2054 galera.galera_bf_abort_at_after_statement 'innodb' w6 [ pass ] 2028 galera.galera_fk_conflict 'innodb' w2 [ pass ] 2040 galera.galera_nbo_processlist 'innodb' w3 [ pass ] 2048 galera.mysql-wsrep#332 'innodb' w5 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.lp1376747 'innodb' w1 [ pass ] 4044 galera.galera_bf_abort_flush_for_export 'innodb' w6 [ pass ] 2035 galera.galera_fk_mismatch 'innodb' w2 [ pass ] 2044 galera.galera_nbo_unsupported 'innodb' w3 [ pass ] 2025 galera.mysql-wsrep#90 'innodb' w5 [ pass ] 2060 galera.lp1376747-2 'innodb' w1 [ pass ] 2038 galera.GCF-329B 'innodb' w8 [ pass ] 20059 galera.galera_bf_abort_for_update 'innodb' w6 [ pass ] 2032 galera.galera_fk_multicolumn 'innodb' w2 [ pass ] 2051 galera.galera_nopk_bit 'innodb' w3 [ pass ] 2037 galera.mysql-wsrep-features#127 'innodb' w5 [ pass ] 2026 galera.lp1376747-3 'innodb' w1 [ pass ] 2046 galera.galera_bf_abort_ftwrl 'innodb' w6 [ pass ] 2030 galera.galera_fk_multitable 'innodb' w2 [ pass ] 2045 galera.galera_nopk_blob 'innodb' w3 [ pass ] 2039 galera.mysql-wsrep-features#131 'innodb' w5 [ pass ] 2138 galera.lp1438990 'innodb' w1 [ pass ] 2062 galera.galera_bf_abort_get_lock 'innodb' w6 [ pass ] 3028 galera.galera_fk_no_pk 'innodb' w2 [ pass ] 2049 galera.galera_nopk_large_varchar 'innodb' w3 [ pass ] 2042 galera.mysql-wsrep-features#132 'innodb' w5 [ pass ] 2052 galera.lp959512 'innodb' w1 [ pass ] 2039 galera.galera_bf_abort_lock_table 'innodb' w6 [ pass ] 2029 galera.galera_fk_selfreferential 'innodb' w2 [ pass ] 2031 galera.galera_nopk_unicode 'innodb' w3 [ pass ] 2029 galera.GCF-849 'innodb' w8 [ pass ] 10186 galera.galera_fk_setnull 'innodb' w2 [ pass ] 2055 galera.galera_toi_drop_database 'innodb' w7 [ pass ] 57890 galera.pxc-421 'innodb' w5 [ pass ] 5239 galera.galera_parallel_apply_lock_table 'innodb' w3 [ pass ] 4045 galera.galera_flush_local 'innodb' w2 [ skipped ] Test requires: 'have_wsrep_replicate_myisam' galera.galera_toi_ftwrl 'innodb' w7 [ pass ] 2034 galera.rename 'innodb' w5 [ pass ] 2039 galera.galera_ftwrl_drain 'innodb' w2 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_performance_schema 'innodb' w3 [ pass ] 2042 galera.galera_bf_abort_shutdown 'innodb' w6 [ pass ] 8246 galera.unique_key 'innodb' w5 [ pass ] 2053 galera.galera_toi_lock_exclusive 'innodb' w7 [ pass ] 3035 galera.galera_pk_bigint_signed 'innodb' w3 [ pass ] 2028 galera.galera_bf_abort_sleep 'innodb' w6 [ pass ] 2025 galera.galera_toi_lock_shared 'innodb' w7 [ pass ] 2028 galera.view 'innodb' w5 [ pass ] 2045 galera.galera_pk_bigint_unsigned 'innodb' w3 [ pass ] 2139 galera.GCF-854 'innodb' w8 [ pass ] 9281 galera.galera_toi_truncate 'innodb' w7 [ pass ] 2058 galera.wsrep_strict_ddl 'innodb' w5 [ pass ] 2050 galera.galera_binlog_cache_size 'innodb' w6 [ pass ] 3040 galera.galera_prepared_statement 'innodb' w3 [ pass ] 2064 galera.galera_transaction_read_only 'innodb' w7 [ pass ] 2027 galera.wsrep_trx_fragment_size_sr 'innodb' w5 [ pass ] 2015 galera.galera_read_only 'innodb' w3 [ pass ] 2038 galera.galera_binlog_row_image 'innodb' w6 [ pass ] 2113 galera.galera_gra_log 'innodb' w2 [ pass ] 9111 galera.galera_transaction_replay 'innodb' w7 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_repl_key_format_flat16 'innodb' w3 [ pass ] 2042 galera.galera_insert_delayed 'innodb' w2 [ pass ] 2013 galera.galera_change_user 'innodb' w6 [ pass ] 2039 galera.galera_truncate 'innodb' w7 [ pass ] 2103 galera.galera_repl_max_ws_size 'innodb' w3 [ pass ] 2035 galera.galera_commit_empty 'innodb' w6 [ pass ] 2018 galera.galera_insert_ignore 'innodb' w2 [ pass ] 2070 galera.galera_truncate_temporary 'innodb' w7 [ pass ] 2098 galera.GCF-360 'innodb' w1 [ pass ] 3459 galera.galera_create_function 'innodb' w6 [ pass ] 2039 galera.galera_insert_multi 'innodb' w2 [ pass ] 2136 galera.galera_unicode_identifiers 'innodb' w7 [ pass ] 2085 galera.galera_create_procedure 'innodb' w6 [ pass ] 2061 galera.galera_unicode_pk 'innodb' w7 [ pass ] 2047 galera.galera_create_table_as_select 'innodb' w6 [ pass ] 2248 galera.galera_update_limit 'innodb' w7 [ pass ] 2087 galera.galera_create_table_like 'innodb' w6 [ pass ] 2084 galera.MDEV-18832 'innodb' w1 [ pass ] 2065 galera.galera_var_OSU_method 'innodb' w7 [ pass ] 2151 galera.galera_restart_on_unknown_option 'innodb' w4 [ pass ] 77864 galera.MDEV-10715 'innodb' w5 [ pass ] 2042 galera.galera_create_trigger 'innodb' w6 [ pass ] 2123 galera.galera_var_OSU_method2 'innodb' w7 [ pass ] 2150 galera.galera_ddl_multiline 'innodb' w6 [ pass ] 2181 galera.galera_kill_applier 'innodb' w2 [ pass ] 2036 galera.galera_roles 'innodb' w4 [ pass ] 5194 galera.galera_delete_limit 'innodb' w6 [ pass ] 2068 galera.galera_var_auto_inc_control_off 'innodb' w7 [ pass ] 4053 galera.galera_rsu_error 'innodb' w4 [ pass ] 2044 galera.galera_var_certify_nonPK_off 'innodb' w7 [ pass ] 2051 galera.galera_rsu_simple 'innodb' w4 [ pass ] 2036 galera.MDEV-15443 'innodb' w3 [ pass ] 9274 galera.galera_rsu_wsrep_desync 'innodb' w4 [ pass ] 4081 galera.galera_var_cluster_address 'innodb' w7 [ pass ] 6145 galera.galera_sbr 'innodb' w4 [ pass ] 2031 galera.MDEV-6860 'innodb' w1 [ pass ] 3333 galera.galera_var_desync_on 'innodb' w7 [ pass ] 3071 galera.galera_schema_dirty_reads 'innodb' w4 [ pass ] 2017 galera.galera_var_dirty_reads 'innodb' w7 [ pass ] 4295 galera.galera_var_fkchecks 'innodb' w7 [ pass ] 2181 galera.galera_serializable 'innodb' w4 [ pass ] 6076 galera.galera_server 'innodb' w4 [ pass ] 2067 galera.galera_var_ignore_apply_errors 'innodb' w7 [ pass ] 2907 galera.galera_kill_ddl 'innodb' w2 [ pass ] 19885 galera.MW-313 'innodb' w3 [ pass ] 2125 galera.MW-284 'innodb' w6 [ pass ] 11425 galera.MW-336 'innodb' w1 [ pass ] 2275 galera.galera_set_position_after_cert_failure 'innodb' w4 [ pass ] 10649 galera.galera_kill_smallchanges 'innodb' w2 [ pass ] 19963 galera.MW-86-wait8 'innodb' w7 [ pass ] 4418 galera.galera#414 'innodb' w6 [ pass ] 8572 galera.enforce_storage_engine2 'innodb' w3 [ pass ] 2057 galera.galera_lock_table 'innodb' w2 [ pass ] 4081 galera.galera-features#117 'innodb' w1 [ pass ] 10888 galera.galera_set_position_after_dummy_writeset 'innodb' w4 [ fail ] Test ended at 2020-04-10 15:12:57 CURRENT_TEST: galera.galera_set_position_after_dummy_writeset sh: line 1: 21114 Segmentation fault (core dumped) /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/Debug/label/sles-12/bin/mysqld --defaults-group-suffix=.2 --defaults-file=/var/tmp/mtr/4/my.cnf --log-error=/var/tmp/mtr/tmp/4/galera_wsrep_recover.log --innodb --wsrep-recover > /var/tmp/mtr/tmp/4/galera_wsrep_recover.log 2>&1 mysqltest: In included file "./suite/galera/include/galera_wsrep_recover.inc": included from /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/Debug/label/sles-12/mysql-test/suite/galera/t/galera_set_position_after_dummy_writeset.test at line 78: At line 2: exec of '/home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/Debug/label/sles-12/bin/mysqld --defaults-group-suffix=.2 --defaults-file=/var/tmp/mtr/4/my.cnf --log-error=/var/tmp/mtr/tmp/4/galera_wsrep_recover.log --innodb --wsrep-recover > /var/tmp/mtr/tmp/4/galera_wsrep_recover.log 2>&1' failed, error: 35584, status: 139, errno: 2 Output from before failure: Performing --wsrep-recover ... The result from queries just before the failure was: < snip > connection node_2; INSERT INTO t1 VALUES (1, 'node_2');; connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1; connection node_1a; SET SESSION wsrep_sync_wait=0; SET DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached"; connection node_1; SET SESSION wsrep_sync_wait = 0; SET SESSION wsrep_retry_autocommit = 0; INSERT INTO t1 VALUES (1, 'node_1');; connection node_1a; SET GLOBAL DEBUG_DBUG = ""; SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb"; connection node_1; ERROR 40001: Deadlock found when trying to get lock; try restarting transaction connection node_2; connection node_2; connection node_1; SET SESSION wsrep_sync_wait = 0; Performing --wsrep-recover ... More results from queries before failure can be found in /var/tmp/mtr/4/log/galera_set_position_after_dummy_writeset.log - saving '/var/tmp/mtr/4/log/galera.galera_set_position_after_dummy_writeset-innodb/' to '/var/tmp/mtr/log/galera.galera_set_position_after_dummy_writeset-innodb/' galera.galera_many_indexes 'innodb' w2 [ pass ] 3428 galera.galera_mdev_10812 'innodb' w2 [ pass ] 8668 galera.galera_multi_database 'innodb' w2 [ pass ] 2172 galera.galera_slave_replay 'innodb' w4 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_sp_bf_abort 'innodb' w4 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_multirow_rollback 'binlogoff,innodb' w2 [ pass ] 3129 galera.galera_as_master 'innodb' w6 [ pass ] 3173 galera.galera_myisam_autocommit 'innodb' w2 [ pass ] 2054 galera.galera_bf_lock_wait 'innodb' w8 [ pass ] 102148 galera.galera_myisam_transactions 'innodb' w2 [ pass ] 2425 galera.galera_as_master_large 'innodb' w3 [ pass ] 3273 galera.galera_as_slave 'innodb' w1 [ pass ] 2734 galera.galera_applier_ftwrl_table_alter 'innodb' w7 [ pass ] 10114 galera.galera_nbo_alter_conflicting 'innodb' w2 [ pass ] 3209 galera.galera_as_slave_autoinc 'innodb' w6 [ pass ] 2718 galera.galera_as_slave_ctas 'innodb' w3 [ pass ] 11238 galera.galera_sp_insert_parallel 'innodb' w4 [ pass ] 31859 galera.galera_as_slave_gtid 'innodb' w1 [ pass ] 9391 galera.galera_sql_log_bin_zero 'innodb' w4 [ pass ] 4216 galera.galera_status_cluster 'innodb' w4 [ pass ] 2013 galera.galera_as_slave_gtid_myisam 'innodb' w2 [ pass ] 5425 galera.galera_as_slave_gtid_auto_engine 'innodb' w7 [ pass ] 5867 galera.galera_status_local_index 'innodb' w4 [ pass ] 2062 galera.galera_status_local_state 'innodb' w4 [ pass ] 2019 galera.galera_binlog_checksum 'innodb' w1 [ pass ] 2074 galera.galera_bf_background_statistics 'innodb' w3 [ pass ] 8162 galera.galera_binlog_event_max_size_min 'innodb' w7 [ pass ] 2082 galera.galera_as_slave_nonprim 'innodb' w6 [ pass ] 19682 galera.galera_encryption 'innodb' w1 [ pass ] 2694 galera.galera_concurrent_ctas 'innodb' w8 [ pass ] 62112 galera.galera_suspend_slave 'innodb' w4 [ pass ] 26770 galera.galera_sync_wait_show 'innodb' w4 [ pass ] 2077 galera.MENT-432-B 'innodb' w5 [ fail ] Test ended at 2020-04-10 15:14:35 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-10 05:57:27.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-10 15:14:34.774842624 +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,11 @@ CALL p_I(10000, 'tl');; connection node_2; connection node_1; +KILL CONNECTION 15; +KILL CONNECTION 16; +KILL CONNECTION 17; +KILL CONNECTION 18; +KILL CONNECTION 19; KILL CONNECTION 20; KILL CONNECTION 21; KILL CONNECTION 22; @@ -102,11 +109,6 @@ KILL CONNECTION 24; 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/5/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-10 15:14:06 0 [Warning] WSREP: Failed to report last committed a72e2b5a-7b3d-11ea-a3d3-6a1897c6ac01:57, -110 (Connection timed out) 2020-04-10 15:13:10 2 [Warning] WSREP: no THD for trx: 107 2020-04-10 15:13:26 2 [Warning] WSREP: no THD for trx: 107 2020-04-10 15:13:27 2 [Warning] WSREP: no THD for trx: 111 2020-04-10 15:13:35 0 [Warning] WSREP: Failed to report last committed a72e2b5a-7b3d-11ea-a3d3-6a1897c6ac01:43, -110 (Connection timed out) 2020-04-10 15:13:37 2 [Warning] WSREP: no THD for trx: 111 2020-04-10 15:13:41 2 [Warning] WSREP: no THD for trx: 109 2020-04-10 15:13:54 0 [Warning] WSREP: Failed to report last committed a72e2b5a-7b3d-11ea-a3d3-6a1897c6ac01:44, -110 (Connection timed out) 2020-04-10 15:13:55 2 [Warning] WSREP: no THD for trx: 109 galera.galera_fulltext 'innodb' w8 [ pass ] 9003 galera.galera_toi_alter_auto_increment 'innodb' w4 [ pass ] 4088 galera.galera_binlog_event_max_size_max 'innodb' w2 [ pass ] 27474 galera.galera_encryption_restart 'innodb' w3 [ pass ] 11536 galera.galera_toi_ddl_locking 'innodb' w4 [ pass ] 6074 galera.galera_encryption_restart3 'innodb' w6 [ pass ] 20436 galera.galera_toi_ddl_sequential 'innodb' w4 [ pass ] 2051 galera.galera_gcs_fc_limit 'innodb' w8 [ pass ] 3156 galera.galera_encryption_restart2 'innodb' w7 [ pass ] 19971 galera.galera_gcs_fragment 'innodb' w2 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_many_columns 'innodb' w8 [ pass ] 2539 galera.galera_gcs_max_packet_size 'innodb' w3 [ pass ] 3888 galera.galera_encryption_restart4 'innodb' w1 [ pass ] 18779 galera.galera_many_tables_pk 'innodb' w8 [ pass ] 4528 galera.galera_gtid 'innodb' w6 [ pass ] 2060 galera.galera_gtid_slave 'innodb' w4 [ pass ] 3174 galera.galera_gcache_recover 'innodb' w5 [ pass ] 25369 galera.galera_gtid_trx_conflict 'innodb' w2 [ pass ] 2043 galera.galera_nbo_sst_slave 'innodb' w8 [ fail ] Test ended at 2020-04-10 15:15:17 CURRENT_TEST: galera.galera_nbo_sst_slave 2020-04-10 15:15:10 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated 2020-04-10 15:15: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 2593 ... 2020-04-10 15:15:10 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190) 2020-04-10 15:15: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/8/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_nbo_sst_slave galera.galera_many_tables_pk galera.galera_many_columns 2020-04-10 15:15:12 2 [Warning] WSREP: Non-blocking operation in progress, cannot donate SST 2020-04-10 15:15:12 0 [Warning] WSREP: 0.0 (jw-sles-12-hffu5v): State transfer to 1.0 (jw-sles-12-hffu5v) failed: -11 (Resource temporarily unavailable) 2020-04-10 15:15:12 0 [Warning] WSREP: 0.0 (jw-sles-12-hffu5v): State transfer to 1.0 (jw-sles-12-hffu5v) failed: -11 (Resource temporarily unavailable) 2020-04-10 15:15:12 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:2593) terminated unexpectedly. (20200410 15:15:13.352) galera.galera_gtid_slave_sst_rsync 'innodb' w7 [ pass ] 18190 galera.galera_ist_recv_bind 'innodb' w4 [ pass ] 16471 galera.galera_last_committed_id 'binlogon,innodb' w7 [ pass ] 2043 galera.galera_last_committed_id 'binlogoff,innodb' w4 [ pass ] 2356 galera.galera_parallel_autoinc_manytrx 'innodb' w8 [ pass ] 13520 galera.galera_log_bin 'innodb' w7 [ pass ] 3405 galera.galera_ist_mariabackup_innodb_flush_logs 'debug,innodb' w1 [ pass ] 44231 galera.galera_gcache_recover_full_gcache 'innodb' w5 [ pass ] 41031 galera.galera_mdev_13787 'innodb' w7 [ pass ] 2037 galera.galera_pc_recovery 'innodb' w8 [ pass ] 21727 galera.galera_ist_mariabackup 'debug,innodb' w3 [ pass ] 61940 galera.galera_ist_rsync 'debug,innodb' w2 [ pass ] 56095 galera.galera_ist_restart_joiner 'innodb' w5 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_mdev_15611 'innodb' w1 [ pass ] 2878 galera.galera_query_cache 'innodb' w7 [ pass ] 2079 galera.galera_ssl_compression 'innodb' w1 [ pass ] 3346 galera.galera_sbr_binlog 'innodb' w2 [ pass ] 3382 galera.galera_query_cache_sync_wait 'innodb' w3 [ pass ] 5847 galera.galera_partition 'innodb' w5 [ pass ] 4107 galera.galera_ist_mysqldump 'debug,innodb' w6 [ pass ] 112388 galera.galera_ssl 'innodb' w5 [ pass ] 2081 galera.galera_rsu_add_pk 'innodb' w8 [ pass ] 54314 galera.galera_sst_mysqldump_with_key 'debug,innodb' w3 [ pass ] 27559 galera.galera_many_rows 'innodb' w4 [ pass ] 102882 galera.galera_sync_wait_upto 'binlogon,innodb' w3 [ pass ] 3034 galera.galera_sync_wait_upto 'binlogoff,innodb' w4 [ pass ] 3036 galera.galera_sst_rsync2 'debug,innodb' w6 [ pass ] 44488 galera.galera_sst_rsync 'debug,innodb' w5 [ pass ] 44458 galera.galera_sst_mariabackup 'debug,innodb' w7 [ pass ] 66585 galera.galera_v1_row_events 'innodb' w3 [ pass ] 2054 galera.galera_sst_mariabackup_data_dir 'debug,innodb' w1 [ pass ] 62907 galera.galera_var_auto_inc_control_on 'innodb' w4 [ pass ] 2040 galera.galera_var_gtid_domain_id 'innodb' w6 [ pass ] 2757 galera.galera_var_sst_auth 'innodb' w3 [ pass ] 2015 galera.galera_var_slave_threads 'innodb' w7 [ pass ] 2311 galera.galera_wsrep_log_conficts 'innodb' w7 [ pass ] 2062 galera.galera_rsu_drop_pk 'innodb' w8 [ pass ] 80832 galera.galera_toi_ddl_error 'innodb' w8 [ pass ] 10903 galera.galera_vote_rejoin_ddl 'innodb' w1 [ pass ] 20825 galera.mdev_10518 'innodb' w7 [ pass ] 2836 galera.galera_toi_ddl_fk_insert 'innodb' w8 [ pass ] 7789 galera.galera_sst_rsync_data_dir 'debug,innodb' w5 [ pass ] 44409 galera.mysql-wsrep#201 'innodb' w1 [ pass ] 2988 galera.galera_vote_rejoin_dml 'innodb' w4 [ pass ] 23576 galera.galera_toi_ddl_fk_update 'innodb' w8 [ pass ] 8483 wsrep.foreign_key 'innodb' w4 [ pass ] 35 wsrep.plugin 'innodb' w4 [ pass ] 5 wsrep.pool_of_threads 'innodb' w1 [ pass ] 9 wsrep.mysql_tzinfo_to_sql_symlink 'innodb' w4 [ pass ] 29 wsrep.mysql_tzinfo_to_sql_symlink_skip 'innodb' w4 [ pass ] 24 wsrep.trans 'innodb' w4 [ pass ] 3 wsrep.MDEV-20625 'innodb' w1 [ pass ] 10 galera.galera_sst_mysqldump 'debug,innodb' w2 [ pass ] 134683 galera.galera_var_load_data_splitting 'innodb' w8 [ pass ] 7265 wsrep.binlog_format 'innodb' w1 [ pass ] 36 galera.galera_var_log_bin 'innodb' w5 [ pass ] 2049 wsrep.mdev_6832 'innodb' w1 [ pass ] 129 wsrep.alter_table_innodb 'innodb' w4 [ pass ] 6212 wsrep.mdev_10186 'innodb' w2 [ pass ] 3 wsrep.wsrep-recover-v25 'binlogoff,innodb' w4 [ pass ] 9489 galera.galera_wan_restart_ist 'innodb' w6 [ pass ] 50084 wsrep.wsrep-recover-v25 'binlogon,innodb' w1 [ pass ] 12942 galera.galera_wan_restart_sst 'innodb' w3 [ fail ] Found warnings/errors in server log file! Test ended at 2020-04-10 15:19:47 line 2020-04-10 15:18:59 2 [Warning] WSREP: Sending JOIN failed: -107 (Transport endpoint is not connected). Will retry in new primary component. ^ Found warnings in /var/tmp/mtr/3/log/mysqld.3.err ok - saving '/var/tmp/mtr/3/log/galera.galera_wan_restart_sst-innodb/' to '/var/tmp/mtr/log/galera.galera_wan_restart_sst-innodb/' wsrep.wsrep_rpl 'innodb,mix' w6 [ pass ] 239 wsrep.wsrep_rpl 'innodb,stmt' w3 [ pass ] 210 wsrep.wsrep_rpl 'innodb,row' w1 [ pass ] 244 galera.rpl_row_annotate 'innodb' w5 [ pass ] 2070 galera.GAL-480 'innodb' w3 [ pass ] 2150 wsrep.wsrep-recover 'binlogon,innodb' w2 [ pass ] 16105 galera.GCF-563 'innodb' w3 [ pass ] 2249 galera.MDEV-20793 'innodb' w3 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_wsrep_desync_wsrep_on 'innodb' w8 [ pass ] 31941 wsrep.mdev_7798 'innodb' w5 [ pass ] 2628 galera.MENT-644 'innodb' w3 [ pass ] 2048 wsrep.wsrep-recover 'binlogoff,innodb' w4 [ pass ] 16141 galera.GAL-382 'innodb' w8 [ pass ] 2050 galera.MW-252 'innodb' w8 [ pass ] 2180 galera.MW-259 'innodb' w3 [ pass ] 4133 galera.MW-292 'innodb' w8 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.GCF-421 'innodb' w1 [ pass ] 14064 galera.GAL-401 'innodb' w6 [ pass ] 16468 galera.MW-309 'innodb' w8 [ pass ] 2033 galera.MW-357 'innodb' w1 [ pass ] 2020 galera.MW-328D 'innodb' w3 [ pass ] 4037 galera.MW-285 'innodb' w4 [ pass ] 2070 galera.MW-369 'innodb' w6 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.MDEV-20616 'innodb' w2 [ pass ] 11090 galera.MW-328E 'innodb' w8 [ pass ] 4050 galera.GCF-546 'innodb' w5 [ pass ] 8158 galera.MW-388 'innodb' w8 [ pass ] 2193 galera.MW-258 'innodb' w5 [ pass ] 10061 galera.mysql-wsrep#33 'debug,innodb' w7 [ pass ] 82928 -------------------------------------------------------------------------- The servers were restarted 122 times Spent 2768.279 of 705 seconds executing testcases Completed: Failed 4/313 tests, 98.72% were successful. Failing test(s): galera.galera_set_position_after_dummy_writeset galera.MENT-432-B galera.galera_nbo_sst_slave galera.galera_wan_restart_sst 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_nbo_sst_slave galera.galera_many_tables_pk galera.galera_many_columns 13 tests were skipped, 13 by the test itself. mysql-test-run: *** ERROR: there were failing test cases