Checking supported features... MariaDB Version 10.5.2-0-MariaDB-enterprise - SSL connections supported - binaries built with wsrep patch Using suites: galera,wsrep Collecting tests... Installing system database... Using parallel: 8 worker[1] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059 worker[2] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 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[4] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079 worker[7] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119 worker[8] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139 worker[5] 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.galera_nbo_alter_partition 'innodb' [ skipped ] Requires debug build galera.galera_nbo_sst_slave 'innodb' [ skipped ] Requires debug build galera.GCF-563 'innodb' [ skipped ] Requires debug build galera.MDEV-20616 'innodb' [ skipped ] Requires debug build galera.MDEV-20793 'innodb' [ skipped ] Requires debug build galera.galera_FK_duplicate_client_insert 'innodb' [ skipped ] Requires debug build galera.galera_nbo_alter_conflicting 'innodb' [ skipped ] Requires debug build galera.galera_nbo_alter_copy 'innodb' [ skipped ] Requires debug build galera.galera_nbo_alter_exclusive 'innodb' [ skipped ] Requires debug build galera.galera_nbo_alter_nonconflicting 'innodb' [ skipped ] Requires debug build galera.galera_nbo_alter_parallel 'innodb' [ skipped ] Requires debug build galera.galera_nbo_unsupported 'innodb' [ skipped ] Requires debug build galera.galera_slave_replay 'innodb' [ skipped ] Requires debug build galera.galera_sync_wait_show 'innodb' [ skipped ] Requires debug build galera.galera_toi_ddl_locking 'innodb' [ skipped ] Requires debug build galera.mysql-wsrep-features#132 'innodb' [ skipped ] Requires debug build galera.GCF-421 [ skipped ] Requires debug build galera.GCF-546 [ skipped ] Requires debug build galera.MENT-644 [ skipped ] Requires debug build galera.galera_nbo_alter_inplace [ skipped ] Requires debug build galera.galera_nbo_alter_toi [ skipped ] Requires debug build galera.mysql-wsrep-features#131 [ skipped ] Requires debug build galera.MW-86-wait1 'innodb' w1 [ skipped ] debug_sync is not available galera.mdev_18730 'innodb' w7 [ skipped ] debug_sync is not available galera.galera_nbo_temporary_table 'innodb' w3 [ pass ] 2011 galera.galera_forced_binlog_format 'innodb' w4 [ pass ] 2043 galera.galera_multirow_rollback 'binlogon,innodb' w2 [ pass ] 2089 galera.galera_log_output_csv 'innodb' w6 [ pass ] 2060 galera.mysql-wsrep-features#128 'innodb' w8 [ pass ] 2075 galera.MW-44 'innodb' w5 [ pass ] 2049 galera.galera_nbo_alter_multi 'innodb' w4 [ pass ] 3227 galera.galera_schema_dirty_reads 'innodb' w2 [ pass ] 2006 galera.galera_nbo_alter_rename 'innodb' w4 [ pass ] 2956 galera.enforce_storage_engine 'innodb' w7 [ pass ] 2964 galera.galera_events 'innodb' w3 [ pass ] 4112 galera.galera_nbo_create_index 'innodb' w4 [ pass ] 2034 galera.galera_unicode_identifiers 'innodb' w6 [ pass ] 2066 galera.mysql-wsrep-features#127 'innodb' w5 [ pass ] 2028 galera.ev51914 'innodb' w7 [ pass ] 2113 galera.galera_wsrep_provider_unset_set 'innodb' w8 [ pass ] 6310 galera.galera_nbo_ddl_error 'innodb' w4 [ pass ] 2026 galera.galera_unicode_pk 'innodb' w6 [ pass ] 2020 galera.fk 'innodb' w7 [ pass ] 2078 galera.galera_zero_length_column 'innodb' w8 [ pass ] 2025 galera.galera_serializable 'innodb' w2 [ pass ] 6026 galera.galera_nbo_error_on_all 'innodb' w4 [ pass ] 2024 galera.galera_update_limit 'innodb' w6 [ pass ] 2037 galera.galera#500 'innodb' w7 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.grant 'innodb' w8 [ pass ] 2011 galera.pxc-421 'innodb' w5 [ pass ] 5186 galera.galera_server 'innodb' w2 [ pass ] 2012 galera.galera_var_OSU_method 'innodb' w6 [ skipped ] debug_sync is not available galera.galera_nbo_local_mdl 'innodb' w4 [ pass ] 2136 galera.galera#505 'innodb' w7 [ pass ] 2008 galera.lp1276424 'innodb' w8 [ pass ] 2015 galera.rename 'innodb' w5 [ pass ] 2025 galera.galera_set_position_after_cert_failure 'innodb' w2 [ skipped ] debug_sync is not available galera.galera_var_OSU_method2 'innodb' w6 [ skipped ] debug_sync is not available galera.galera_nbo_processlist 'innodb' w4 [ skipped ] debug_sync is not available galera.galera_admin 'innodb' w7 [ pass ] 2200 galera.lp1347768 'innodb' w8 [ pass ] 2024 galera.unique_key 'innodb' w5 [ pass ] 2037 galera.galera_set_position_after_dummy_writeset 'innodb' w2 [ skipped ] debug_sync is not available galera.galera_nopk_bit 'innodb' w4 [ pass ] 2031 galera.galera_alter_engine_innodb 'innodb' w7 [ pass ] 2053 galera.view 'innodb' w5 [ pass ] 2035 galera.galera_sp_bf_abort 'innodb' w2 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.GAL-419 'innodb' w1 [ pass ] 17874 galera.galera_var_auto_inc_control_off 'innodb' w6 [ pass ] 4022 galera.galera_nopk_blob 'innodb' w4 [ pass ] 2026 galera.galera_alter_engine_myisam 'innodb' w7 [ pass ] 2021 galera.lp1376747 'innodb' w8 [ pass ] 4028 galera.wsrep_strict_ddl 'innodb' w5 [ pass ] 2033 galera.galera_events2 'innodb' w3 [ pass ] 15247 galera.galera_var_certify_nonPK_off 'innodb' w6 [ pass ] 2025 galera.galera_sp_insert_parallel 'innodb' w2 [ pass ] 2816 galera.galera_nopk_large_varchar 'innodb' w4 [ pass ] 2028 galera.galera_alter_table_force 'innodb' w7 [ pass ] 2026 galera.lp1376747-2 'innodb' w8 [ pass ] 2026 galera.wsrep_trx_fragment_size_sr 'innodb' w5 [ pass ] 2006 galera.galera_fk_cascade_delete 'innodb' w3 [ pass ] 2038 galera.galera_sql_log_bin_zero 'innodb' w2 [ pass ] 2019 galera.galera_nopk_unicode 'innodb' w4 [ pass ] 2019 galera.galera_applier_ftwrl_table 'innodb' w7 [ pass ] 2023 galera.lp1376747-3 'innodb' w8 [ pass ] 2027 galera.galera_fk_cascade_update 'innodb' w3 [ pass ] 2038 galera.galera_status_cluster 'innodb' w2 [ pass ] 2006 galera.galera_bf_abort 'innodb' w7 [ pass ] 2018 galera.lp1438990 'innodb' w8 [ pass ] 2033 galera.galera_fk_conflict 'innodb' w3 [ pass ] 2025 galera.galera_var_cluster_address 'innodb' w6 [ pass ] 6116 galera.galera_status_local_index 'innodb' w2 [ pass ] 2016 galera.galera_parallel_apply_lock_table 'innodb' w4 [ pass ] 4030 galera.GCF-329A 'innodb' w1 [ pass ] 9076 galera.galera_bf_abort_at_after_statement 'innodb' w7 [ skipped ] debug_sync is not available galera.lp959512 'innodb' w8 [ pass ] 2029 galera.galera_fk_mismatch 'innodb' w3 [ pass ] 2028 galera.galera_status_local_state 'innodb' w2 [ pass ] 2008 galera.galera_performance_schema 'innodb' w4 [ pass ] 2031 galera.galera_bf_abort_flush_for_export 'innodb' w7 [ pass ] 2021 galera.galera_var_desync_on 'innodb' w6 [ pass ] 3033 galera.mdev_9290 'innodb' w8 [ pass ] 2016 galera.galera_fk_multicolumn 'innodb' w3 [ pass ] 2033 galera.galera_pk_bigint_signed 'innodb' w4 [ pass ] 2018 galera.galera_bf_abort_for_update 'innodb' w7 [ pass ] 2019 galera.mysql-wsrep#110 'innodb' w8 [ pass ] 2041 galera.galera_fk_multitable 'innodb' w3 [ pass ] 2025 galera.galera_pk_bigint_unsigned 'innodb' w4 [ pass ] 2018 galera.galera_bf_abort_ftwrl 'innodb' w7 [ pass ] 2019 galera.galera_var_dirty_reads 'innodb' w6 [ pass ] 4232 galera.mysql-wsrep#237 'innodb' w8 [ skipped ] debug_sync is not available galera.galera_fk_no_pk 'innodb' w3 [ pass ] 2026 galera.galera_prepared_statement 'innodb' w4 [ pass ] 2043 galera.galera_var_fkchecks 'innodb' w6 [ pass ] 2026 galera.galera_bf_abort_get_lock 'innodb' w7 [ pass ] 3019 galera.galera_fk_selfreferential 'innodb' w3 [ pass ] 2017 galera.mysql-wsrep#247 'innodb' w8 [ pass ] 3015 galera.galera_read_only 'innodb' w4 [ pass ] 2021 galera.galera_var_ignore_apply_errors 'innodb' w6 [ pass ] 2152 galera.galera_bf_abort_lock_table 'innodb' w7 [ pass ] 2018 galera.galera_fk_setnull 'innodb' w3 [ pass ] 2029 galera.galera_repl_key_format_flat16 'innodb' w4 [ pass ] 2026 galera.galera_bf_abort_shutdown 'innodb' w7 [ skipped ] debug_sync is not available galera.galera_var_max_ws_rows 'innodb' w6 [ pass ] 2500 galera.galera_flush_local 'innodb' w3 [ skipped ] Test requires: 'have_wsrep_replicate_myisam' galera.galera_repl_max_ws_size 'innodb' w4 [ pass ] 2016 galera.galera_bf_abort_sleep 'innodb' w7 [ pass ] 2021 galera.galera_ftwrl_drain 'innodb' w3 [ skipped ] debug_sync is not available galera.galera_var_max_ws_size 'innodb' w6 [ pass ] 2017 galera.galera_var_mysql_replication_bundle 'innodb' w6 [ pass ] 2020 galera.galera_binlog_cache_size 'innodb' w7 [ pass ] 3027 galera.mysql-wsrep#31 'innodb' w8 [ pass ] 9038 galera.GCF-329B 'innodb' w1 [ pass ] 19587 galera.galera_var_replicate_myisam_off 'innodb' w6 [ pass ] 2011 galera.galera_gra_log 'innodb' w3 [ fail ] Test ended at 2020-04-10 15:09:15 CURRENT_TEST: galera.galera_gra_log Server [mysqld.2 - pid: 12937, winpid: 12937, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2020-04-10 15:09:12 2 [ERROR] Slave SQL: Error 'Table 't1' already exists' on query. Default database: 'test'. Query: 'CREATE TABLE t1 (f1 INTEGER)', Internal MariaDB error code: 1050 2020-04-10 15:09:12 2 [Warning] WSREP: Event 1 Query apply failed: 1, seqno 109 2020-04-10 15:09:12 0 [Note] WSREP: Member 1(jw-buster-10-tbu3ro) initiates vote on 1b4ad73c-7b3d-11ea-9306-038a09a8d932:109,8f57841974492470: Table 't1' already exists, Error_code: 1050; 2020-04-10 15:09:12 0 [Note] WSREP: Votes over 1b4ad73c-7b3d-11ea-9306-038a09a8d932:109: 8f57841974492470: 1/2 Waiting for more votes. 2020-04-10 15:09:12 0 [Note] WSREP: Member 0(jw-buster-10-tbu3ro) responds to vote on 1b4ad73c-7b3d-11ea-9306-038a09a8d932:109,0000000000000000: Success 2020-04-10 15:09:12 0 [Note] WSREP: Votes over 1b4ad73c-7b3d-11ea-9306-038a09a8d932:109: 0000000000000000: 1/2 8f57841974492470: 1/2 Winner: 0000000000000000 2020-04-10 15:09:12 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on 1b4ad73c-7b3d-11ea-9306-038a09a8d932:109 at galera/src/replicator_smm.cpp:process_apply_error():1343 2020-04-10 15:09:12 2 [Note] WSREP: Closing send monitor... 2020-04-10 15:09:12 2 [Note] WSREP: Closed send monitor. 2020-04-10 15:09:12 2 [Note] WSREP: gcomm: terminating thread 2020-04-10 15:09:12 2 [Note] WSREP: gcomm: joining thread 2020-04-10 15:09:12 2 [Note] WSREP: gcomm: closing backend 2020-04-10 15:09:13 2 [Note] WSREP: view(view_id(NON_PRIM,1b4a792c-ad24,4) memb { 2a74c25d-82c0,0 } joined { } left { } partitioned { 1b4a792c-ad24,0 }) 2020-04-10 15:09:13 2 [Note] WSREP: PC protocol downgrade 1 -> 0 2020-04-10 15:09:13 2 [Note] WSREP: view((empty)) 2020-04-10 15:09:13 2 [Note] WSREP: gcomm: closed 2020-04-10 15:09:13 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-04-10 15:09:13 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-04-10 15:09:13 0 [Note] WSREP: Received NON-PRIMARY. 2020-04-10 15:09:13 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 109) 2020-04-10 15:09:13 0 [Note] WSREP: New SELF-LEAVE. 2020-04-10 15:09:13 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-04-10 15:09:13 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-04-10 15:09:13 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) 2020-04-10 15:09:13 0 [Note] WSREP: RECV thread exiting 0: Success 2020-04-10 15:09:13 2 [Note] WSREP: recv_thread() joined. 2020-04-10 15:09:13 2 [Note] WSREP: Closing replication queue. 2020-04-10 15:09:13 2 [Note] WSREP: Closing slave action queue. 2020-04-10 15:09:13 2 [Note] WSREP: ================================================ View: id: 1b4ad73c-7b3d-11ea-9306-038a09a8d932:-1 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: no own_index: 0 members(1): 0: 2a74c25d-7b3d-11ea-82c0-5a9b57ea375a, jw-buster-10-tbu3ro ================================================= 2020-04-10 15:09:13 2 [Note] WSREP: Non-primary view 2020-04-10 15:09:13 2 [Note] WSREP: Server status change synced -> connected 2020-04-10 15:09:13 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-10 15:09:13 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-10 15:09:13 2 [Note] WSREP: ================================================ View: id: 1b4ad73c-7b3d-11ea-9306-038a09a8d932:-1 status: non-primary protocol_version: 4 capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO final: yes own_index: -1 members(0): ================================================= 2020-04-10 15:09:13 2 [Note] WSREP: Non-primary view 2020-04-10 15:09:13 2 [Note] WSREP: Server status change connected -> disconnected 2020-04-10 15:09:13 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-10 15:09:13 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-10 15:09:13 0 [Note] WSREP: Service thread queue flushed. 2020-04-10 15:09:13 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: 5 2020-04-10 15:09:13 2 [Note] WSREP: Applier thread exiting ret: 0 thd: 2 2020-04-10 15:09:13 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-04-10 15:09:15 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated 2020-04-10 15:09:15 0 [Note] /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/RelWithDebInfo/label/debian-10/bin/mysqld (mysqld 10.5.2-0-MariaDB-enterprise-log) starting as process 12938 ... 2020-04-10 15:09:15 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190) 2020-04-10 15:09:15 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2020-04-10 15:09:15 0 [Note] mysqld: Aria engine: starting recovery recovered pages: 0% Table ./mysql/event.MAD has wrong LSN: (1,0xaa39) on page: 1 12% 24% 36% 46% 57% 68% Got error 175 when executing record redo_index 2020-04-10 15:09:15 0 [ERROR] mysqld: Aria engine: Redo phase failed tables to flush: 1 0 2020-04-10 15:09:15 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files 2020-04-10 15:09:15 0 [ERROR] Plugin 'Aria' init function returned error. 2020-04-10 15:09:15 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2020-04-10 15:09:15 0 [ERROR] Failed to initialize plugins. 2020-04-10 15:09:15 0 [ERROR] Aborting ----------SERVER LOG END------------- mysqltest failed but provided no output The result from queries just before the failure was: < snip > ROLLBACK/*!*/; ROLLBACK/*!*/; use `test`/*!*/; SET TIMESTAMP=/*!*/; SET @@session.pseudo_thread_id=/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0/*!*/; SET @@session.sql_mode=1411383296/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; CREATE TABLE t1 (f1 INTEGER) /*!*/; DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; Killing server ... - saving '/var/tmp/mtr/3/log/galera.galera_gra_log-innodb/' to '/var/tmp/mtr/log/galera.galera_gra_log-innodb/' ***Warnings generated in error logs during shutdown after running tests: galera.galera_gra_log 2020-04-10 15:09:12 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on 1b4ad73c-7b3d-11ea-9306-038a09a8d932:109 2020-04-10 15:09:15 0 [ERROR] mysqld: Aria engine: Redo phase failed 2020-04-10 15:09:15 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files 2020-04-10 15:09:15 0 [ERROR] Plugin 'Aria' init function returned error. 2020-04-10 15:09:15 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2020-04-10 15:09:15 0 [ERROR] Failed to initialize plugins. 2020-04-10 15:09:15 0 [ERROR] Aborting galera.galera_binlog_row_image 'innodb' w7 [ pass ] 2238 galera.galera_var_replicate_myisam_on 'innodb' w6 [ pass ] 2075 galera.galera_change_user 'innodb' w7 [ pass ] 2020 galera.galera_restart_nochanges 'innodb' w4 [ pass ] 9037 galera.galera_var_sync_wait 'innodb' w6 [ pass ] 2033 galera.galera_commit_empty 'innodb' w7 [ pass ] 2006 galera.galera_var_wsrep_on_off 'innodb' w6 [ pass ] 2019 galera.GCF-360 'innodb' w5 [ pass ] 2781 galera.galera_suspend_slave 'innodb' w2 [ pass ] 25269 galera.galera_insert_delayed 'innodb' w3 [ pass ] 2005 galera.galera_create_function 'innodb' w7 [ pass ] 2018 galera.mysql-wsrep#332 'innodb' w8 [ skipped ] debug_sync is not available galera.galera_wsrep_provider_options_syntax 'innodb' w6 [ pass ] 2010 galera.galera_insert_ignore 'innodb' w3 [ pass ] 2038 galera.GCF-849 'innodb' w1 [ pass ] 10142 galera.galera_create_procedure 'innodb' w7 [ pass ] 2033 galera.mysql-wsrep#90 'innodb' w8 [ skipped ] debug_sync is not available galera.galera_toi_alter_auto_increment 'innodb' w2 [ pass ] 4058 galera.galera_insert_multi 'innodb' w3 [ pass ] 2059 galera.galera_create_table_as_select 'innodb' w7 [ pass ] 2158 galera.galera_toi_ddl_sequential 'innodb' w2 [ pass ] 2023 galera.galera_create_table_like 'innodb' w7 [ pass ] 2055 galera.MDEV-10715 'innodb' w5 [ pass ] 2031 galera.galera_create_trigger 'innodb' w7 [ pass ] 2066 galera.galera_ddl_multiline 'innodb' w7 [ pass ] 2101 galera.GCF-854 'innodb' w1 [ pass ] 10151 galera.galera_toi_drop_database 'innodb' w2 [ pass ] 7471 galera.galera_delete_limit 'innodb' w7 [ pass ] 2044 galera.galera_toi_ftwrl 'innodb' w2 [ pass ] 2024 galera.galera_desync_overlapped 'innodb' w7 [ skipped ] debug_sync is not available galera.galera_kill_applier 'innodb' w3 [ pass ] 2018 galera.galera_toi_lock_exclusive 'innodb' w2 [ pass ] 4186 galera.MDEV-18832 'innodb' w8 [ pass ] 2209 galera.galera_toi_lock_shared 'innodb' w2 [ pass ] 5218 galera.galera_toi_truncate 'innodb' w2 [ skipped ] debug_sync is not available galera.galera_transaction_read_only 'innodb' w2 [ pass ] 2915 galera.galera_transaction_replay 'innodb' w2 [ skipped ] debug_sync is not available galera.MDEV-15443 'innodb' w6 [ pass ] 16482 galera.galera_drop_database 'innodb' w7 [ pass ] 17883 galera.galera_truncate 'innodb' w2 [ pass ] 3311 galera.galera_drop_multi 'innodb' w7 [ pass ] 2030 galera.MDEV-6860 'innodbworker[3] mysql-test-run: WARNING: Waited 60 seconds for /var/tmp/mtr/3/run/mysqld.2.pid to be created, still waiting for 120 seconds... worker[3] mysql-test-run: WARNING: Waited 120 seconds for /var/tmp/mtr/3/run/mysqld.2.pid to be created, still waiting for 60 seconds... worker[3] mysql-test-run: WARNING: Timeout after mysql-test-run waited 180 seconds for the process [mysqld.2 - pid: 32713, winpid: 32713] to create a pid file. ' w5 [ pass ] 8656 galera.galera_truncate_temporary 'innodb' w2 [ pass ] 2685 galera.galera_enum 'innodb' w7 [ pass ] 2040 galera.MW-313 'innodb' w5 [ pass ] 3260 galera.galera_kill_ddl 'innodb' w3 [ pass ] 24399 galera.MW-86-wait8 'innodb' w7 [ skipped ] debug_sync is not available galera.MW-284 'innodb' w6 [ pass ] 11585 galera.MW-336 'innodb' w2 [ pass ] 2060 galera.enforce_storage_engine2 'innodb' w5 [ pass ] 2782 galera.galera_restart_on_unknown_option 'innodb' w4 [ pass ] 88231 galera.galera_kill_smallchanges 'innodb' w3 [ pass ] 38640 galera.galera_roles 'innodb' w4 [ pass ] 14079 galera.galera_lock_table 'innodb' w3 [ pass ] 8945 galera.galera_rsu_error 'innodb' w4 [ pass ] 4446 galera.galera#414 'innodb' w7 [ pass ] 10604 galera.galera-features#117 'innodb' w6 [ pass ] 14798 galera.galera_rsu_simple 'innodb' w4 [ pass ] 2252 galera.galera_as_master 'innodb' w5 [ pass ] 4206 galera.galera_applier_ftwrl_table_alter 'innodb' w2 [ pass ] 9185 galera.galera_rsu_wsrep_desync 'innodb' w4 [ skipped ] debug_sync is not available galera.galera_sbr 'innodb' w4 [ pass ] 2840 galera.galera_bf_lock_wait 'innodb' w1 [ pass ] 103941 galera.MENT-432-B 'innodb' w8 [ fail ] Test ended at 2020-04-10 15:11:22 CURRENT_TEST: galera.MENT-432-B mysqltest: At line 189: query 'reap' failed with wrong errno 1180: 'Got error 6 "No such device or address" during COMMIT', instead of 0... The result from queries just before the failure was: < snip > connection node_1k; CALL p_I(10000, 'tk');; connection node_1l; 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; KILL CONNECTION 23; KILL CONNECTION 24; KILL CONNECTION 25; KILL CONNECTION 26; connection node_1a; connection node_1b; More results from queries before failure can be found in /var/tmp/mtr/8/log/MENT-432-B.log - saving '/var/tmp/mtr/8/log/galera.MENT-432-B-innodb/' to '/var/tmp/mtr/log/galera.MENT-432-B-innodb/' galera.galera_many_indexes 'innodb' w3 [ pass ] 29039 galera.galera_as_slave_autoinc 'innodb' w5 [ pass ] 11394 galera.galera_as_master_large 'innodb' w7 [ pass ] 2633 galera.galera_as_slave_ctas 'innodb' w2 [ pass ] 2443 galera.galera_as_slave 'innodb' w6 [ pass ] 2436 galera.galera_mdev_10812 'innodb' w3 [ pass ] 17576 galera.galera_as_slave_gtid 'innodb' w4 [ pass ] 3128 galera.galera_as_slave_gtid_auto_engine 'innodb' w8 [ pass ] 4884 galera.galera_multi_database 'innodb' w3 [ pass ] 9273 galera.galera_multirow_rollback 'binlogoff,innodb' w3 [ pass ] 4940 galera.galera_as_slave_gtid_myisam 'innodb' w5 [ pass ] 8378 galera.galera_binlog_checksum 'innodb' w6 [ pass ] 2360 galera.galera_myisam_autocommit 'innodb' w3 [ pass ] 2297 galera.galera_myisam_transactions 'innodb' w3 [ pass ] 2258 galera.galera_binlog_event_max_size_min 'innodb' w8 [ pass ] 3593 galera.galera_nbo_alter_engine 'innodb' w3 [ pass ] 3599 galera.galera_bf_background_statistics 'innodb' w2 [ pass ] 8958 galera.galera_nbo_alter_error_duplicate 'innodb' w3 [ pass ] 2880 galera.galera_encryption 'innodb' w5 [ pass ] 3520 galera.galera_binlog_event_max_size_max 'innodb' w4 [ pass ] 11078 galera.galera_as_slave_nonprim 'innodb' w7 [ pass ] 17378 galera.galera_gcs_max_packet_size 'innodb' w7 [ pass ] 9805 galera.galera_encryption_restart 'innodb' w6 [ pass ] 25312 galera.galera_gcs_fragment 'innodb' w4 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_encryption_restart4 'innodb' w2 [ pass ] 30317 galera.galera_encryption_restart3 'innodb' w3 [ pass ] 30289 galera.galera_gtid 'innodb' w7 [ pass ] 2037 galera.galera_concurrent_ctas 'innodb' w1 [ pass ] 122361 galera.galera_fulltext 'innodb' w1 [ pass ] 2594 galera.galera_gtid_slave 'innodb' w6 [ pass ] 3151 galera.galera_encryption_restart2 'innodb' w8 [ pass ] 55077 galera.galera_gcache_recover_full_gcache 'innodb' w5 [ pass ] 47613 galera.galera_gtid_trx_conflict 'innodb' w2 [ pass ] 3168 galera.galera_gtid_slave_sst_rsync 'innodb' w4 [ pass ] 29716 galera.galera_gcs_fc_limit 'innodb' w1 [ pass ] 16856 galera.galera_ist_restart_joiner 'innodb' w5 [ skipped ] debug_sync is not available galera.galera_many_columns 'innodb' w1 [ pass ] 4309 galera.galera_last_committed_id 'binlogon,innodb' w4 [ pass ] 3808 galera.galera_ist_recv_bind 'innodb' w8 [ pass ] 12222 galera.galera_many_tables_pk 'innodb' w1 [ pass ] 3265 galera.galera_ist_mariabackup_innodb_flush_logs 'innodb,release' w7 [ pass ] 13664 galera.galera_last_committed_id 'binlogoff,innodb' w5 [ pass ] 2030 galera.galera_parallel_autoinc_manytrx 'innodb' w1 [ pass ] 5560 galera.galera_log_bin 'innodb' w4 [ pass ] 2077 galera.galera_mdev_13787 'innodb' w7 [ pass ] 2836 galera.galera_ist_rsync 'innodb,release' w2 [ pass ] 38608 galera.galera_pc_recovery 'innodb' w1 [ pass ] 19618 galera.galera_many_rows 'innodb' w8 [ pass ] 29561 galera.galera_mdev_15611 'innodb' w5 [ pass ] 2190 galera.galera_partition 'innodb' w4 [ pass ] 2629 galera.galera_query_cache 'innodb' w7 [ pass ] 2047 galera.galera_query_cache_sync_wait 'innodb' w2 [ skipped ] debug_sync is not available galera.galera_ssl_compression 'innodb' w4 [ pass ] 2302 galera.galera_ssl 'innodb' w5 [ pass ] 2354 galera.galera_sbr_binlog 'innodb' w8 [ pass ] 2306 galera.galera_ist_mysqldump 'innodb,release' w6 [ pass ] 92018 galera.galera_rsu_add_pk 'innodb' w1 [ pass ] 9169 galera.galera_rsu_drop_pk 'innodb' w1 [ pass ] 21665 galera.galera_toi_ddl_error 'innodb' w1 [ pass ] 2984 galera.galera_toi_ddl_fk_insert 'innodb' w1 [ pass ] 5143 galera.galera_toi_ddl_fk_update 'innodb' w1 [ pass ] 4310 galera.galera_sst_mysqldump_with_key 'innodb,release' w5 [ pass ] 15628 galera.galera_var_load_data_splitting 'innodb' w1 [ pass ] 2536 galera.galera_wsrep_desync_wsrep_on 'innodb' w1 [ pass ] 4085 galera.GAL-382 'innodb' w1 [ pass ] 2026 galera.galera_sst_rsync 'innodb,release' w8 [ pass ] 28700 galera.galera_sst_mariabackup 'innodb,release' w7 [ pass ] 45479 galera.galera_sst_rsync2 'innodb,release' w6 [ pass ] 29772 galera.galera_sst_mariabackup_data_dir 'innodb,release' w2 [ pass ] 40828 galera.GAL-401 'innodb' w1 [ pass ] 17173 galera.GAL-480 'innodb' w1 [ pass ] 2092 galera.galera_gcache_recover 'innodb' w3 [ fail ] Test ended at 2020-04-10 15:16:26 CURRENT_TEST: galera.galera_gcache_recover Failed to start mysqld.2 mysqltest failed but provided no output - saving '/var/tmp/mtr/3/log/galera.galera_gcache_recover-innodb/' to '/var/tmp/mtr/log/galera.galera_gcache_recover-innodb/' ***Warnings generated in error logs during shutdown after running tests: galera.galera_gcache_recover 2020-04-10 15:13:34 0 [Warning] WSREP: No re-merged primary component found. 2020-04-10 15:13:34 0 [Warning] WSREP: No bootstrapped primary component found. 2020-04-10 15:13:34 0 [ERROR] WSREP: gcs/src/gcs_state_msg.cpp:gcs_state_msg_get_quorum():947: Failed to establish quorum. galera.galera_sync_wait_upto 'binlogon,innodb' w8 [ skipped ] debug_sync is not available galera.MW-252 'innodb' w1 [ pass ] 2135 galera.galera_sync_wait_upto 'binlogoff,innodb' w7 [ skipped ] debug_sync is not available galera.galera_v1_row_events 'innodb' w6 [ pass ] 2027 galera.galera_var_auto_inc_control_on 'innodb' w2 [ pass ] 2029 galera.MW-258 'innodb' w1 [ pass ] 10035 galera.MW-259 'innodb' w1 [ skipped ] debug_sync is not available galera.MW-285 'innodb' w1 [ pass ] 2045 galera.galera_sst_rsync_data_dir 'innodb,release' w5 [ pass ] 29903 galera.MW-292 'innodb' w1 [ skipped ] debug_sync is not available galera.MW-309 'innodb' w1 [ pass ] 2023 galera.galera_var_sst_auth 'innodb' w7 [ pass ] 2006 galera.MW-328D 'innodb' w1 [ pass ] 4029 galera.galera_var_slave_threads 'innodb' w8 [ pass ] 2228 galera.MW-328E 'innodb' w1 [ pass ] 4030 galera.MW-357 'innodb' w1 [ pass ] 2062 galera.MW-369 'innodb' w1 [ skipped ] debug_sync is not available galera.MW-388 'innodb' w1 [ skipped ] debug_sync is not available galera.galera_wsrep_log_conficts 'innodb' w8 [ pass ] 2036 galera.MW-402 'innodb' w1 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.MW-416 'innodb' w1 [ pass ] 2721 galera.basic 'innodb' w1 [ pass ] 2627 galera.galera_ist_mariabackup 'innodb,release' w3 [ pass ] 29493 galera.binlog_checksum 'innodb' w1 [ pass ] 2373 galera.galera_vote_rejoin_ddl 'innodb' w6 [ pass ] 23515 galera.create 'innodb' w1 [ pass ] 2091 galera.mdev_10518 'innodb' w8 [ pass ] 3465 galera.galera_var_gtid_domain_id 'innodb' w3 [ pass ] 2425 galera.galera_vote_rejoin_dml 'innodb' w2 [ pass ] 25231 wsrep.plugin 'innodb' w2 [ pass ] 1 galera.rpl_row_annotate 'innodb' w1 [ pass ] 2042 wsrep.pool_of_threads 'innodb' w8 [ pass ] 1 wsrep.mysql_tzinfo_to_sql_symlink 'innodb' w2 [ pass ] 25 wsrep.mysql_tzinfo_to_sql_symlink_skip 'innodb' w2 [ pass ] 19 wsrep.trans 'innodb' w2 [ pass ] 1 wsrep.alter_table_innodb 'innodb' w8 [ pass ] 255 wsrep.binlog_format 'innodb' w2 [ pass ] 19 wsrep.mdev_10186 'innodb' w8 [ pass ] 1 galera.galera_sst_mysqldump 'innodb,release' w4 [ pass ] 132570 wsrep.mdev_6832 'innodb' w2 [ pass ] 413 wsrep.wsrep-recover-v25 'binlogoff,innodb' w2 [ skipped ] debug_sync is not available wsrep.mdev_7798 'innodb' w8 [ pass ] 4456 wsrep.MDEV-20625 'innodb' w1 [ pass ] 10 wsrep.wsrep-recover 'binlogoff,innodb' w8 [ skipped ] debug_sync is not available wsrep.wsrep-recover 'binlogon,innodb' w2 [ skipped ] debug_sync is not available wsrep.wsrep_rpl 'innodb,mix' w1 [ pass ] 165 wsrep.wsrep-recover-v25 'binlogon,innodb' w4 [ skipped ] debug_sync is not available galera.galera_var_log_bin 'innodb' w3 [ pass ] 3564 wsrep.wsrep_rpl 'innodb,stmt' w2 [ pass ] 177 wsrep.wsrep_rpl 'innodb,row' w8 [ pass ] 176 galera.galera_wan_restart_sst 'innodb' w7 [ pass ] 47700 galera.mysql-wsrep#201 'innodb' w3 [ pass ] 2469 galera.galera_wan_restart_ist 'innodb' w5 [ pass ] 58281 wsrep.foreign_key 'innodb' w3 [ pass ] 24 galera.mysql-wsrep#33 'innodb,release' w6 [ pass ] 69302 -------------------------------------------------------------------------- The servers were restarted 113 times Spent 2309.400 of 699 seconds executing testcases Completed: Failed 3/269 tests, 98.88% were successful. Failing test(s): galera.galera_gra_log galera.MENT-432-B galera.galera_gcache_recover 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.galera_gra_log galera.galera_gcache_recover 57 tests were skipped, 35 by the test itself. mysql-test-run: *** ERROR: there were failing test cases