Checking supported features... MariaDB Version 10.4.9-MariaDB-debug - SSL connections supported - binaries are debug compiled - binaries built with wsrep patch Using suites: galera Collecting tests... Installing system database... Using parallel: 4 worker[3] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059 worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039 worker[2] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 worker[4] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079 ============================================================================== TEST WORKER RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- 191026 15:20:04 +3.216 galera.GCF-1081 [ disabled ] MDEV-18283 Galera test failure on galera.GCF-1081 191026 15:20:04 +0.000 galera.MW-329 [ disabled ] MDEV-19962 Galera test failure on MW-329 191026 15:20:04 +0.000 galera.MW-360 [ disabled ] needs rewrite to be MariaDB gtid compatible 191026 15:20:04 +0.000 galera.MW-388 [ disabled ] MDEV-19803 Long semaphore wait error on galera.MW-388 191026 15:20:04 +0.000 galera.galera_account_management [ disabled ] MariaDB 10.0 does not support ALTER USER 191026 15:20:04 +0.000 galera.galera_as_master_gtid [ disabled ] Requires MySQL GTID 191026 15:20:04 +0.000 galera.galera_as_master_gtid_change_master [ disabled ] Requires MySQL GTID 191026 15:20:04 +0.000 galera.galera_as_slave_gtid_replicate_do_db_cc [ disabled ] Requires MySQL GTID 191026 15:20:04 +0.000 galera.galera_as_slave_preordered [ disabled ] wsrep-preordered feature not merged to MariaDB 191026 15:20:04 +0.000 galera.galera_as_slave_replication_bundle [ disabled ] MDEV-15785 OPTION_GTID_BEGIN is set in Gtid_log_event::do_apply_event() 191026 15:20:04 +0.000 galera.galera_bf_abort_group_commit [ disabled ] MDEV-18282 Galera test failure on galera.galera_bf_abort_group_commit 191026 15:20:04 +0.000 galera.galera_binlog_rows_query_log_events [ disabled ] MariaDB does not support binlog_rows_query_log_events 191026 15:20:04 +0.000 galera.galera_binlog_stmt_autoinc [ disabled ] MDEV-19959 Galera test failure on galera_binlog_stmt_autoinc 191026 15:20:04 +0.000 galera.galera_concurrent_ctas [ disabled ] MDEV-18180 Galera test failure on galera.galera_concurrent_ctas 191026 15:20:04 +0.000 galera.galera_encrypt_tmp_files [ disabled ] Get error failed to enable encryption of temporary files 191026 15:20:04 +0.000 galera.galera_flush [ disabled ] MariaDB does not have global.thread_statistics 191026 15:20:04 +0.000 galera.galera_gcache_recover_manytrx [ disabled ] MDEV-18834 Galera test failure 191026 15:20:04 +0.000 galera.galera_ist_mariabackup [ disabled ] MDEV-18829 test leaves port open 191026 15:20:04 +0.000 galera.galera_ist_progress [ disabled ] MDEV-15236 fails when trying to read transfer status 191026 15:20:04 +0.000 galera.galera_kill_largechanges [ disabled ] MDEV-18179 Galera test failure on galera.galera_kill_largechanges 191026 15:20:04 +0.000 galera.galera_kill_nochanges [ disabled ] MDEV-18280 Galera test failure on galera_split_brain and galera_kill_nochanges 191026 15:20:04 +0.000 galera.galera_many_tables_nopk [ disabled ] MDEV-18182 Galera test failure on galera.galera_many_tables_nopk 191026 15:20:04 +0.000 galera.galera_migrate [ disabled ] MariaDB does not support START SLAVE USER 191026 15:20:04 +0.000 galera.galera_split_brain [ disabled ] MDEV-18280 Galera test failure on galera_split_brain and galera_kill_nochanges 191026 15:20:04 +0.000 galera.galera_ssl_upgrade [ disabled ] MDEV-19950 Galera test failure on galera_ssl_upgrade 191026 15:20:04 +0.000 galera.galera_var_node_address [ disabled ] MDEV-20485 Galera test failure 191026 15:20:04 +0.000 galera.galera_var_notify_cmd [ disabled ] MDEV-20600 Galera test galera_var_notify_cmd causes hang 191026 15:20:04 +0.000 galera.galera_var_reject_queries [ disabled ] assertion in inline_mysql_socket_send 191026 15:20:04 +0.000 galera.galera_var_retry_autocommit [ disabled ] MDEV-18181 Galera test failure on galera.galera_var_retry_autocommit 191026 15:20:04 +0.000 galera.galera_wan [ disabled ] MDEV-17259 Test failure on galera.galera_wan 191026 15:20:04 +0.000 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. 191026 15:20:04 +0.000 galera.partition [ disabled ] MDEV-19958 Galera test failure on galera.partition 191026 15:20:04 +0.000 galera.query_cache [ disabled ] MDEV-15805 Test failure on galera.query_cache 191026 15:20:12 +7.864 galera.galera_binlog_checksum 'innodb' w2 [ pass ] 2134 191026 15:20:12 +0.076 galera.MW-313 'innodb' w1 [ pass ] 2153 191026 15:20:12 +0.055 galera.MW-86-wait1 'innodb' w3 [ pass ] 2119 191026 15:20:30 +17.749 galera.galera_binlog_event_max_size_min 'innodb' w2 [ pass ] 2073 191026 15:20:30 +0.313 galera.enforce_storage_engine2 'innodb' w3 [ pass ] 2154 191026 15:20:48 +17.746 galera.galera_log_output_csv 'innodb' w2 [ pass ] 2190 191026 15:20:49 +1.170 galera.galera_binlog_event_max_size_max 'innodb' w1 [ pass ] 21172 191026 15:20:51 +1.223 galera.MW-44 'innodb' w3 [ pass ] 4251 191026 15:21:05 +14.896 galera.galera_mdev_13787 'innodb' w2 [ pass ] 2084 191026 15:21:13 +7.539 galera.galera_bf_background_statistics 'innodb' w3 [ pass ] 7134 191026 15:21:13 +0.209 galera.galera_applier_ftwrl_table_alter 'innodb' w1 [ pass ] 8137 191026 15:21:23 +10.057 galera.galera_gtid 'innodb' w2 [ pass ] 2105 191026 15:21:31 +7.783 galera.galera_forced_binlog_format 'innodb' w3 [ pass ] 2206 191026 15:21:31 +0.215 galera.galera_sbr_binlog 'innodb' w1 [ pass ] 2125 191026 15:21:42 +10.536 galera.galera_log_bin 'innodb' w2 [ pass ] 2754 191026 15:21:49 +7.072 galera.galera_v1_row_events 'innodb' w3 [ pass ] 2080 191026 15:21:50 +1.300 galera.galera_var_innodb_disallow_writes 'innodb' w1 [ pass ] 3090 191026 15:21:56 +5.364 galera.mdev_18730 'innodb' w1 [ pass ] 5099 191026 15:22:07 +11.350 galera.galera_query_cache 'innodb' w3 [ pass ] 2197 191026 15:22:07 +0.315 galera.galera_flush_local 'innodb' w2 [ pass ] 9666 191026 15:22:11 +4.095 galera.galera_query_cache_sync_wait 'innodb' w3 [ pass ] 4130 191026 15:22:17 +5.794 galera.mysql-wsrep#201 'innodb' w1 [ pass ] 5859 191026 15:22:25 +8.169 galera.galera_var_auto_inc_control_on 'innodb' w2 [ pass ] 2084 191026 15:22:31 +5.815 galera.galera_wsrep_new_cluster 'innodb' w1 [ pass ] 2691 191026 15:22:31 +0.083 galera.galera_sync_wait_upto 'innodb' w3 [ pass ] 4112 191026 15:22:40 +9.231 galera.galera_var_sst_auth 'innodb' w1 [ pass ] 2015 191026 15:22:43 +2.729 galera.galera_wsrep_log_conficts 'innodb' w2 [ pass ] 2092 191026 15:22:58 +14.945 galera.galera_commit_empty 'innodb' w1 [ pass ] 2019 191026 15:22:58 +0.140 galera.GAL-419 'innodb' w3 [ pass ] 11208 191026 15:23:00 +2.210 galera.galera_create_function 'innodb' w1 [ pass ] 2090 191026 15:23:01 +0.388 galera.galera_performance_schema 'innodb' w2 [ pass ] 2189 191026 15:23:03 +2.099 galera.galera_create_procedure 'innodb' w1 [ pass ] 2193 191026 15:23:03 +0.310 galera.galera_pk_bigint_signed 'innodb' w2 [ pass ] 2129 191026 15:23:06 +2.337 galera.galera_pk_bigint_unsigned 'innodb' w2 [ pass ] 2100 191026 15:23:06 +0.649 galera.galera_create_table_as_select 'innodb' w1 [ pass ] 3011 191026 15:23:08 +1.978 galera.galera_prepared_statement 'innodb' w2 [ pass ] 2331 191026 15:23:09 +0.644 galera.galera_create_table_like 'innodb' w1 [ pass ] 2351 191026 15:23:11 +1.768 galera.galera_read_only 'innodb' w2 [ pass ] 2112 191026 15:23:11 +0.856 galera.galera_create_trigger 'innodb' w1 [ pass ] 2360 191026 15:23:12 +1.011 galera.MW-328A 'innodb' w3 [ pass ] 13949 191026 15:23:13 +0.557 galera.galera_repl_key_format_flat16 'innodb' w2 [ pass ] 2143 191026 15:23:14 +1.110 galera.galera_ddl_multiline 'innodb' w1 [ pass ] 2387 191026 15:23:15 +1.242 galera.galera_repl_max_ws_size 'innodb' w2 [ pass ] 2077 191026 15:23:16 +1.016 galera.galera_defaults 'innodb' w1 [ pass ] 2033 191026 15:23:19 +2.554 galera.galera_delete_limit 'innodb' w1 [ pass ] 2284 191026 15:23:23 +3.863 galera.galera_desync_overlapped 'innodb' w1 [ pass ] 3541 191026 15:23:25 +1.979 galera.MW-328B 'innodb' w3 [ pass ] 12047 191026 15:23:25 +0.219 galera.galera_restart_nochanges 'innodb' w2 [ pass ] 9332 191026 15:23:32 +7.073 galera.MW-328C 'innodb' w3 [ pass ] 6974 191026 15:23:37 +4.719 galera.galera_drop_database 'innodb' w1 [ pass ] 13685 191026 15:23:39 +2.406 galera.galera_drop_multi 'innodb' w1 [ pass ] 2165 191026 15:23:42 +2.491 galera.galera_enum 'innodb' w1 [ pass ] 2173 191026 15:23:45 +3.385 galera.galera_events 'innodb' w1 [ pass ] 3118 191026 15:24:02 +16.868 galera.galera_events2 'innodb' w1 [ pass ] 16562 191026 15:24:05 +2.694 galera.galera_fk_cascade_delete 'innodb' w1 [ pass ] 2402 191026 15:24:07 +2.753 galera.galera_fk_cascade_update 'innodb' w1 [ pass ] 2499 191026 15:24:10 +2.839 galera.galera_fk_conflict 'innodb' w1 [ pass ] 2587 191026 15:24:13 +2.698 galera.galera_fk_mismatch 'innodb' w1 [ pass ] 2377 191026 15:24:16 +2.897 galera.galera_fk_multicolumn 'innodb' w1 [ pass ] 2513 191026 15:24:18 +2.625 galera.galera_fk_multitable 'innodb' w1 [ pass ] 2319 191026 15:24:21 +2.679 galera.galera_fk_no_pk 'innodb' w1 [ pass ] 2392 191026 15:24:24 +2.475 galera.galera_fk_selfreferential 'innodb' w1 [ pass ] 2208 191026 15:24:26 +2.593 galera.galera_fk_setnull 'innodb' w1 [ pass ] 2331 191026 15:24:31 +4.482 galera.galera_ftwrl 'innodb' w1 [ pass ] 4187 191026 15:24:35 +4.486 galera.galera_ftwrl_drain 'innodb' w1 [ pass ] 4237 191026 15:24:39 +3.515 galera.galera_gcs_fc_limit 'innodb' w1 [ pass ] 3280 191026 15:24:41 +2.456 galera.galera_gra_log 'innodb' w1 [ pass ] 2217 191026 15:24:44 +2.498 galera.galera_restart_on_unknown_option 'innodb' w2 [ pass ] 78293 191026 15:24:44 +0.327 galera.galera_insert_ignore 'innodb' w1 [ pass ] 2553 191026 15:24:47 +3.184 galera.galera_insert_multi 'innodb' w1 [ pass ] 2897 191026 15:24:50 +3.158 galera.galera_roles 'innodb' w2 [ pass ] 6366 191026 15:24:53 +2.546 galera.galera_rsu_error 'innodb' w2 [ pass ] 2284 191026 15:24:56 +2.776 galera.galera_rsu_simple 'innodb' w2 [ pass ] 2499 191026 15:25:00 +3.921 galera.galera_kill_applier 'innodb' w1 [ pass ] 2167 191026 15:25:00 +0.892 galera.galera_rsu_wsrep_desync 'innodb' w2 [ pass ] 4526 191026 15:25:03 +2.638 galera.galera_sbr 'innodb' w2 [ pass ] 2340 191026 15:25:05 +2.289 galera.galera_schema_dirty_reads 'innodb' w2 [ pass ] 2019 191026 15:25:12 +6.548 galera.galera_serializable 'innodb' w2 [ pass ] 6264 191026 15:25:13 +1.205 galera.MW-86-wait8 'innodb' w4 [ pass ] 302245 191026 15:25:14 +1.215 galera.galera_server 'innodb' w2 [ pass ] 2119 191026 15:25:15 +0.710 galera.galera_bf_lock_wait 'innodb' w3 [ pass ] 102308 191026 15:25:25 +10.064 galera.galera_kill_ddl 'innodb' w1 [ pass ] 19600 191026 15:25:32 +7.212 galera.galera_transaction_replay 'innodb' w4 [ pass ] 2968 191026 15:25:33 +0.261 galera.galera_fulltext 'innodb' w3 [ pass ] 16922 191026 15:25:34 +1.142 galera.galera_shutdown_nonprim 'innodb' w2 [ pass ] 19053 191026 15:25:36 +2.244 galera.galera_truncate 'innodb' w4 [ pass ] 3256 191026 15:25:36 +0.539 galera.galera_many_columns 'innodb' w3 [ pass ] 3408 191026 15:25:39 +2.210 galera.galera_sp_bf_abort 'innodb' w2 [ pass ] 4636 191026 15:25:39 +0.511 galera.galera_truncate_temporary 'innodb' w4 [ pass ] 2904 191026 15:25:42 +3.274 galera.galera_unicode_identifiers 'innodb' w4 [ pass ] 2974 191026 15:25:45 +2.436 galera.galera_kill_smallchanges 'innodb' w1 [ pass ] 19442 191026 15:25:45 +0.341 galera.galera_unicode_pk 'innodb' w4 [ pass ] 2357 191026 15:25:48 +2.881 galera.galera_last_committed_id 'innodb' w1 [ pass ] 2875 191026 15:25:49 +0.405 galera.galera_update_limit 'innodb' w4 [ pass ] 2968 191026 15:25:51 +2.786 galera.galera_var_OSU_method 'innodb' w4 [ pass ] 2362 191026 15:25:53 +1.700 galera.galera_lock_table 'innodb' w1 [ pass ] 4544 191026 15:25:54 +1.274 galera.galera_var_OSU_method2 'innodb' w4 [ pass ] 2672 191026 15:25:59 +4.795 galera.galera_var_auto_inc_control_off 'innodb' w4 [ pass ] 4412 191026 15:26:02 +2.721 galera.galera_var_certify_nonPK_off 'innodb' w4 [ pass ] 2415 191026 15:26:02 +0.428 galera.galera_many_tables_pk 'innodb' w3 [ pass ] 25282 191026 15:26:03 +0.959 galera.galera_many_indexes 'innodb' w1 [ pass ] 9777 191026 15:26:09 +5.770 galera.galera_var_cluster_address 'innodb' w4 [ pass ] 6570 191026 15:26:10 +1.123 galera.galera_mdev_10812 'innodb' w1 [ pass ] 6475 191026 15:26:13 +2.911 galera.galera_mdl_race 'innodb' w1 [ pass ] 2500 191026 15:26:13 +0.251 galera.galera_var_desync_on 'innodb' w4 [ pass ] 3742 191026 15:26:17 +3.570 galera.galera_multi_database 'innodb' w1 [ pass ] 2974 191026 15:26:19 +2.052 galera.galera_var_dirty_reads 'innodb' w4 [ pass ] 4966 191026 15:26:19 +0.017 galera.galera_sp_insert_parallel 'innodb' w2 [ pass ] 39415 191026 15:26:20 +1.185 galera.galera_myisam_autocommit 'innodb' w1 [ pass ] 2477 191026 15:26:22 +1.587 galera.galera_sql_log_bin_zero 'innodb' w2 [ pass ] 2303 191026 15:26:22 +0.390 galera.galera_var_fkchecks 'innodb' w4 [ pass ] 2698 191026 15:26:23 +1.236 galera.galera_myisam_transactions 'innodb' w1 [ pass ] 2543 191026 15:26:24 +0.854 galera.galera_status_cluster 'innodb' w2 [ pass ] 2016 191026 15:26:26 +2.195 galera.galera_nopk_bit 'innodb' w1 [ pass ] 2576 191026 15:26:27 +0.695 galera.galera_status_local_index 'innodb' w2 [ pass ] 2457 191026 15:26:28 +1.201 galera.galera_var_ignore_apply_errors 'innodb' w4 [ pass ] 5722 191026 15:26:29 +1.109 galera.galera_nopk_blob 'innodb' w1 [ pass ] 2582 191026 15:26:29 +0.094 galera.galera_parallel_autoinc_largetrx 'innodb' w3 [ pass ] 16762 191026 15:26:29 +0.002 galera.galera_status_local_state 'innodb' w2 [ pass ] 2067 191026 15:26:32 +2.607 galera.galera_nopk_large_varchar 'innodb' w1 [ pass ] 2377 191026 15:26:35 +2.492 galera.galera_nopk_unicode 'innodb' w1 [ pass ] 2204 191026 15:26:39 +4.680 galera.galera_parallel_apply_lock_table 'innodb' w1 [ pass ] 4294 191026 15:26:42 +3.005 galera.galera_parallel_simple 'innodb' w1 [ pass ] 2703 191026 15:26:44 +2.135 galera.galera_var_max_ws_rows 'innodb' w4 [ pass ] 15729 191026 15:26:47 +2.422 galera.galera_var_max_ws_size 'innodb' w4 [ pass ] 2160 191026 15:26:49 +2.472 galera.galera_var_mysql_replication_bundle 'innodb' w4 [ pass ] 2179 191026 15:26:52 +2.360 galera.galera_var_replicate_myisam_off 'innodb' w4 [ pass ] 2082 191026 15:26:55 +3.621 galera.galera_var_replicate_myisam_on 'innodb' w4 [ pass ] 3305 191026 15:26:56 +0.370 galera.galera_suspend_slave 'innodb' w2 [ pass ] 25866 191026 15:26:58 +2.373 galera.galera_var_sync_wait 'innodb' w4 [ pass ] 2495 191026 15:26:59 +0.696 galera.galera_sync_wait_show 'innodb' w2 [ pass ] 2767 191026 15:27:00 +1.808 galera.galera_var_wsrep_on_off 'innodb' w4 [ pass ] 2192 191026 15:27:03 +2.298 galera.galera_wsrep_provider_options_syntax 'innodb' w4 [ pass ] 2022 191026 15:27:04 +0.996 galera.galera_toi_alter_auto_increment 'innodb' w2 [ pass ] 4806 191026 15:27:04 +0.057 galera.galera_pc_ignore_sb 'innodb' w1 [ pass ] 21229 191026 15:27:06 +2.496 galera.lp1347768 'innodb' w1 [ pass ] 2213 191026 15:27:09 +2.366 galera.galera_wsrep_provider_unset_set 'innodb' w4 [ pass ] 5589 191026 15:27:11 +1.867 galera.galera_toi_ddl_locking 'innodb' w2 [ pass ] 6454 191026 15:27:11 +0.546 galera.lp1376747 'innodb' w1 [ pass ] 4466 191026 15:27:11 +0.361 galera.galera_zero_length_column 'innodb' w4 [ pass ] 2531 191026 15:27:13 +1.680 galera.galera_toi_ddl_nonconflicting 'innodb' w2 [ pass ] 2285 191026 15:27:14 +0.517 galera.lp1376747-2 'innodb' w1 [ pass ] 2261 191026 15:27:14 +0.295 galera.grant 'innodb' w4 [ pass ] 2218 191026 15:27:16 +1.662 galera.galera_toi_ddl_sequential 'innodb' w2 [ pass ] 2233 191026 15:27:16 +0.593 galera.lp1376747-3 'innodb' w1 [ pass ] 2266 191026 15:27:17 +0.305 galera.lp1276424 'innodb' w4 [ pass ] 2258 191026 15:27:20 +3.939 galera.galera_parallel_autoinc_manytrx 'innodb' w3 [ pass ] 35033 191026 15:27:26 +5.386 galera.lp1376747-4 'innodb' w1 [ pass ] 9332 191026 15:27:29 +2.952 galera.lp1438990 'innodb' w1 [ pass ] 2647 191026 15:27:31 +2.695 galera.lp959512 'innodb' w1 [ pass ] 2421 191026 15:27:34 +2.481 galera.mdev_9290 'innodb' w1 [ pass ] 2178 191026 15:27:37 +2.907 galera.mysql-wsrep#110 'innodb' w1 [ pass ] 2512 191026 15:27:40 +2.683 galera.galera_pc_recovery 'innodb' w3 [ pass ] 13365 191026 15:27:41 +0.974 galera.mysql-wsrep#237 'innodb' w1 [ pass ] 3208 191026 15:27:42 +1.614 galera.MDEV-15443 'innodb' w4 [ pass ] 9846 191026 15:27:44 +2.167 galera.mysql-wsrep#247 'innodb' w1 [ pass ] 3216 191026 15:27:55 +10.956 galera.mysql-wsrep#31 'innodb' w1 [ pass ] 10680 191026 15:28:00 +5.150 galera.MDEV-18832 'innodb' w4 [ pass ] 2416 191026 15:28:07 +6.703 galera.mysql-wsrep#332 'innodb' w1 [ pass ] 4931 191026 15:28:11 +3.817 galera.mysql-wsrep#90 'innodb' w1 [ pass ] 3172 191026 15:28:18 +7.141 galera.pxc-421 'innodb' w1 [ pass ] 6484 191026 15:28:22 +3.462 galera.rename 'innodb' w1 [ pass ] 2907 191026 15:28:25 +3.882 galera.sql_log_bin 'innodb' w1 [ pass ] 3213 191026 15:28:28 +2.957 galera.unique_key 'innodb' w1 [ pass ] 2425 191026 15:28:32 +3.536 galera.view 'innodb' w1 [ pass ] 2921 191026 15:28:34 +2.381 galera.wsrep_trx_fragment_size_sr 'innodb' w1 [ pass ] 2026 191026 15:28:42 +7.887 galera.MDEV-6860 'innodb' w4 [ pass ] 23595 191026 15:28:58 +16.198 galera.galera_toi_drop_database 'innodb' w2 [ pass ] 102397 191026 15:29:00 +2.078 galera.MW-284 'innodb' w1 [ pass ] 9609 191026 15:29:02 +1.265 galera.galera_toi_ftwrl 'innodb' w2 [ pass ] 2574 191026 15:29:05 +3.583 galera.galera_toi_lock_exclusive 'innodb' w2 [ pass ] 3275 191026 15:29:08 +2.591 galera.galera_toi_lock_shared 'innodb' w2 [ pass ] 2294 191026 15:29:16 +8.197 galera.galera#414 'innodb' w1 [ pass ] 8436 191026 15:29:18 +2.145 galera.galera_rsu_add_pk 'innodb' w3 [ pass ] 82349 191026 15:29:31 +12.586 galera.galera_toi_truncate 'innodb' w2 [ pass ] 22480 191026 15:29:32 +1.377 galera.galera_as_master 'innodb' w1 [ pass ] 3444 191026 15:29:33 +1.102 galera.galera_transaction_read_only 'innodb' w2 [ pass ] 2142 191026 15:29:43 +9.738 galera.galera_as_master_large 'innodb' w1 [ pass ] 2424 191026 15:29:53 +10.170 galera.galera_as_slave 'innodb' w2 [ pass ] 3122 191026 15:29:54 +0.440 galera.galera_as_slave_autoinc 'innodb' w1 [ pass ] 3184 191026 15:29:56 +2.024 galera.MW-336 'innodb' w4 [ fail ] Test ended at 2019-10-26 15:29:56 CURRENT_TEST: galera.MW-336 --- /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/MW-336.result 2019-10-13 09:12:21.392670633 +0300 +++ /home/stepan/mariadb/10.4/git/mysql-test/suite/galera/r/MW-336.reject 2019-10-26 15:29:55.931500577 +0300 @@ -12,6 +12,40 @@ # Set slave threads to 10 step 2 SET GLOBAL wsrep_slave_threads = 20; # Set slave threads to 20 +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 20 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count'; +SELECT COUNT(*), 20 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist; +COUNT(*) EXPECTED_VALUE +21 20 +Id User Host db Command Time State Info Progress +1 system user NULL Sleep 38 wsrep aborter idle NULL 0.000 +3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +6 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000 +7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000 +16 root localhost test Sleep 33 NULL 0.000 +17 root localhost:51250 test Query 0 Init show processlist 0.000 +18 system user NULL Sleep 31 wsrep applier idle NULL 0.000 +19 system user NULL Sleep 31 wsrep applier idle NULL 0.000 +20 system user NULL Sleep 31 wsrep applier idle NULL 0.000 +21 system user NULL Sleep 31 wsrep applier idle NULL 0.000 +22 system user NULL Sleep 31 wsrep applier idle NULL 0.000 +23 system user NULL Sleep 31 wsrep applier idle NULL 0.000 +24 system user NULL Sleep 31 wsrep applier idle NULL 0.000 +25 system user NULL Sleep 31 wsrep applier idle NULL 0.000 +26 system user NULL Sleep 31 wsrep applier idle NULL 0.000 +27 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +28 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +29 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +30 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +31 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +32 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +33 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +34 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +35 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +36 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +37 system user NULL Sleep 30 wsrep applier idle NULL 0.000 +38 system user NULL Sleep 30 wsrep applier idle NULL 0.000 SET GLOBAL wsrep_slave_threads = 1; connection node_2; INSERT INTO t1 VALUES (1); @@ -30,6 +64,30 @@ COUNT(*) 11 # Set slave threads to 10 step 3 +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 10 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_applier_thread_count'; +SELECT COUNT(*), 10 as EXPECTED_VALUE FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND STATE = 'wsrep applier idle'; show processlist; +COUNT(*) EXPECTED_VALUE +11 10 +Id User Host db Command Time State Info Progress +1 system user NULL Sleep 70 wsrep aborter idle NULL 0.000 +3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +6 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000 +7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000 +16 root localhost test Sleep 64 NULL 0.000 +17 root localhost:51250 test Query 0 Init show processlist 0.000 +28 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +29 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +30 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +31 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +32 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +33 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +34 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +35 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +36 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +37 system user NULL Sleep 62 wsrep applier idle NULL 0.000 +38 system user NULL Sleep 62 wsrep applier idle NULL 0.000 connection node_2; INSERT INTO t1 VALUES (11); INSERT INTO t1 VALUES (12); mysqltest: Result length mismatch - saving '/home/stepan/mariadb/10.4/git/mysql-test/var/4/log/galera.MW-336-innodb/' to '/home/stepan/mariadb/10.4/git/mysql-test/var/log/galera.MW-336-innodb/' 191026 15:30:04 +8.825 galera.galera_as_slave_gtid 'innodb' w2 [ pass ] 3333 191026 15:30:07 +2.730 galera.galera_as_slave_gtid_replicate_do_db 'innodb' w1 [ pass ] 5498 191026 15:30:24 +16.752 galera.galera_as_slave_nonprim 'innodb' w4 [ pass ] 19449 191026 15:30:35 +10.801 galera.galera_gcache_recover 'innodb' w1 [ pass ] 20586 191026 15:30:53 +18.040 galera.galera_gcs_fragment 'innodb' w1 [ pass ] 5619 191026 15:31:11 +18.589 galera.galera_gcache_recover_full_gcache 'innodb' w4 [ pass ] 39042 191026 15:31:13 +1.397 galera.galera_gcs_max_packet_size 'innodb' w1 [ pass ] 6870 191026 15:31:15 +2.060 galera.galera_autoinc_sst_mariabackup 'innodb' w2 [ pass ] 51905 191026 15:31:28 +12.640 galera.galera_gtid_slave 'innodb' w4 [ pass ] 3317 191026 15:31:35 +7.572 galera.galera_rsu_drop_pk 'innodb' w3 [ pass ] 136065 191026 15:31:42 +6.894 galera.galera_gtid_slave_sst_rsync 'innodb' w1 [ pass ] 15891 191026 15:31:56 +13.544 galera.galera_toi_ddl_error 'innodb' w3 [ pass ] 20080 191026 15:32:01 +5.850 galera.galera_ist_recv_bind 'innodb' w1 [ pass ] 12572 191026 15:32:15 +13.314 galera.galera_toi_ddl_fk_insert 'innodb' w3 [ pass ] 18758 191026 15:32:21 +6.477 galera.galera_ist_mariabackup_innodb_flush_logs 'debug,innodb' w2 [ pass ] 42293 191026 15:32:32 +11.018 galera.galera_toi_ddl_fk_update 'innodb' w3 [ pass ] 17242 191026 15:32:33 +0.892 galera.galera_ist_restart_joiner 'innodb' w1 [ pass ] 19189 191026 15:32:46 +13.030 galera.galera_var_load_data_splitting 'innodb' w3 [ pass ] 13568 191026 15:33:08 +22.034 galera.galera_ist_mysqldump 'debug,innodb' w4 [ pass ] 93108 191026 15:33:12 +3.397 galera.galera_load_data 'innodb' w1 [ pass ] 22603 191026 15:33:22 +10.545 galera.galera_ist_rsync 'debug,innodb' w2 [ pass ] 47760 191026 15:33:35 +13.172 galera.galera_mdev_15611 'innodb' w1 [ pass ] 7174 191026 15:33:38 +2.320 galera.galera_ssl 'innodb' w2 [ pass ] 2298 191026 15:33:52 +14.519 galera.galera_wsrep_desync_wsrep_on 'innodb' w3 [ pass ] 65600 191026 15:33:54 +1.758 galera.galera_ssl_compression 'innodb' w1 [ pass ] 2224 191026 15:33:55 +1.155 galera.GAL-382 'innodb' w3 [ pass ] 2579 191026 15:34:13 +17.960 galera.GAL-401 'innodb' w3 [ pass ] 17626 191026 15:34:17 +3.808 galera.GAL-480 'innodb' w3 [ pass ] 3497 191026 15:34:19 +2.515 galera.GCF-939 'innodb' w3 [ pass ] 2181 191026 15:34:24 +4.614 galera.MDEV-16509 'innodb' w3 [ pass ] 4187 191026 15:34:29 +4.923 galera.MDEV-20225 'innodb' w3 [ pass ] 4588 191026 15:34:34 +5.171 galera.MW-252 'innodb' w3 [ pass ] 4844 191026 15:34:45 +10.621 galera.MW-258 'innodb' w3 [ pass ] 10190 191026 15:34:49 +4.579 galera.MW-259 'innodb' w3 [ pass ] 4255 191026 15:34:52 +2.716 galera.MW-285 'innodb' w3 [ pass ] 2411 191026 15:34:54 +2.476 galera.MW-286 'innodb' w3 [ pass ] 2193 191026 15:35:00 +5.852 galera.MW-292 'innodb' w3 [ pass ] 5478 191026 15:35:03 +2.587 galera.MW-309 'innodb' w3 [ pass ] 2228 191026 15:35:08 +4.860 galera.MW-328D 'innodb' w3 [ pass ] 4398 191026 15:35:09 +1.801 galera.galera_sst_mariabackup 'debug,innodb' w2 [ pass ] 66987 191026 15:35:13 +3.151 galera.MW-328E 'innodb' w3 [ pass ] 4541 191026 15:35:15 +2.444 galera.MW-357 'innodb' w3 [ pass ] 2149 191026 15:35:20 +5.186 galera.MW-369 'innodb' w3 [ pass ] 4833 191026 15:35:26 +5.327 galera.MW-402 'innodb' w3 [ pass ] 4926 191026 15:35:27 +1.080 galera.galera_sst_mariabackup_data_dir 'debug,innodb' w1 [ pass ] 68558 191026 15:35:28 +1.619 galera.MW-416 'innodb' w3 [ pass ] 2218 191026 15:35:31 +2.922 galera.basic 'innodb' w3 [ pass ] 2292 191026 15:35:34 +2.495 galera.binlog_checksum 'innodb' w3 [ pass ] 2164 191026 15:35:35 +1.640 galera.galera_sst_mariabackup_encrypt_with_key 'innodb' w2 [ pass ] 2018 191026 15:35:37 +2.126 galera.create 'innodb' w3 [ pass ] 3478 191026 15:35:40 +2.552 galera.enforce_storage_engine 'innodb' w3 [ pass ] 2240 191026 15:35:45 +5.163 galera.ev51914 'innodb' w3 [ pass ] 4831 191026 15:35:49 +3.336 galera.fk 'innodb' w3 [ pass ] 2981 191026 15:36:08 +19.492 galera.galera#500 'innodb' w3 [ pass ] 19108 191026 15:36:10 +2.394 galera.galera#505 'innodb' w3 [ pass ] 2021 191026 15:36:17 +6.925 galera.galera_FK_duplicate_client_insert 'innodb' w3 [ pass ] 6541 191026 15:36:24 +6.314 galera.galera_sst_mariabackup_table_options '16k,clear,innodb' w1 [ pass ] 23565 191026 15:36:26 +1.875 galera.galera_admin 'innodb' w3 [ pass ] 7889 191026 15:36:28 +2.671 galera.galera_alter_engine_innodb 'innodb' w3 [ pass ] 2352 191026 15:36:31 +2.512 galera.galera_alter_engine_myisam 'innodb' w3 [ pass ] 2207 191026 15:36:33 +1.922 galera.galera_sst_mariabackup_table_options '16k,crypt,innodb' w2 [ pass ] 22962 191026 15:36:34 +0.930 galera.galera_alter_table_force 'innodb' w3 [ pass ] 2372 191026 15:36:36 +2.765 galera.galera_applier_ftwrl_table 'innodb' w3 [ pass ] 2268 191026 15:36:37 +0.429 galera.galera_many_rows 'innodb' w4 [ pass ] 195636 191026 15:36:39 +2.370 galera.galera_bf_abort 'innodb' w3 [ pass ] 2189 191026 15:36:42 +2.423 galera.galera_bf_abort_at_after_statement 'innodb' w3 [ pass ] 2158 191026 15:36:44 +2.490 galera.galera_bf_abort_flush_for_export 'innodb' w3 [ pass ] 2198 191026 15:36:47 +2.514 galera.galera_bf_abort_for_update 'innodb' w3 [ pass ] 2184 191026 15:36:49 +2.503 galera.galera_bf_abort_ftwrl 'innodb' w3 [ pass ] 2203 191026 15:36:53 +3.585 galera.galera_bf_abort_get_lock 'innodb' w3 [ pass ] 3189 191026 15:36:55 +2.495 galera.galera_bf_abort_lock_table 'innodb' w3 [ pass ] 2203 191026 15:37:06 +10.787 galera.galera_bf_abort_shutdown 'innodb' w3 [ pass ] 10523 191026 15:37:08 +2.462 galera.galera_bf_abort_sleep 'innodb' w3 [ pass ] 2189 191026 15:37:12 +3.610 galera.galera_binlog_cache_size 'innodb' w3 [ pass ] 3291 191026 15:37:15 +3.030 galera.galera_binlog_row_image 'innodb' w3 [ pass ] 2793 191026 15:37:18 +2.492 galera.galera_change_user 'innodb' w3 [ pass ] 2210 191026 15:37:21 +3.001 galera.galera_sst_mariabackup_table_options '4k,clear,innodb' w1 [ pass ] 23790 191026 15:37:28 +7.400 galera.galera_sst_mariabackup_table_options '4k,crypt,innodb' w2 [ pass ] 23610 191026 15:37:34 +5.790 galera.galera_sst_mariabackup_table_options '8k,clear,innodb' w4 [ pass ] 23001 191026 15:38:12 +38.073 galera.galera_sst_mysqldump_with_key 'debug,innodb' w2 [ pass ] 31181 191026 15:38:13 +1.476 galera.galera_sst_mariabackup_table_options '8k,crypt,innodb' w3 [ pass ] 21528 191026 15:38:34 +20.776 galera.galera_sst_rsync 'debug,innodb' w4 [ pass ] 47784 191026 15:38:50 +15.745 galera.galera_var_gtid_domain_id 'innodb' w4 [ pass ] 2797 191026 15:39:08 +17.882 galera.galera_var_log_bin 'innodb' w4 [ pass ] 2152 191026 15:39:11 +3.457 galera.galera_sst_rsync2 'debug,innodb' w2 [ pass ] 47494 191026 15:39:13 +2.204 galera.galera_sst_rsync_data_dir 'debug,innodb' w3 [ pass ] 47309 191026 15:39:37 +24.101 galera.galera_var_slave_threads 'innodb' w4 [ pass ] 3629 191026 15:39:46 +8.479 galera.mdev_10518 'innodb' w4 [ pass ] 2751 191026 15:39:52 +5.840 galera.galera_sst_mysqldump 'debug,innodb' w1 [ pass ] 138184 191026 15:40:06 +14.205 galera.rpl_row_annotate 'innodb' w1 [ pass ] 2168 191026 15:40:22 +15.626 galera.galera_wan_restart_ist 'innodb' w2 [ pass ] 53112 191026 15:40:24 +2.349 galera.galera_wan_restart_sst 'innodb' w3 [ pass ] 55314 191026 15:40:28 +4.324 galera.versioning_trx_id 'innodb' w1 [ pass ] 2181 191026 15:40:48 +19.434 galera.mysql-wsrep#33 'innodb' w4 [ pass ] 45989 -------------------------------------------------------------------------- The servers were restarted 84 times Spent 3425.152 of 1253 seconds executing testcases Completed: Failed 1/275 tests, 99.64% were successful. Failing test(s): galera.MW-336 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 191026 15:40:54 +6.431 mysql-test-run: *** ERROR: there were failing test cases