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[2] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039 worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 worker[3] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059 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 304, with reserved ports 16080..16099 worker[6] 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.GCF-546 '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.MENT-644 '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_exclusive 'innodb' [ skipped ] Requires debug build galera.galera_nbo_alter_inplace '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_sync_wait_show 'innodb' [ skipped ] Requires debug build galera.galera_toi_ddl_locking 'innodb' [ skipped ] Requires debug build galera.mysql-wsrep-features#131 'innodb' [ skipped ] Requires debug build galera.mysql-wsrep-features#132 'innodb' [ skipped ] Requires debug build galera.galera_nbo_sst_slave [ skipped ] Requires debug build galera.GCF-421 [ skipped ] Requires debug build galera.galera_nbo_alter_copy [ skipped ] Requires debug build galera.galera_nbo_alter_nonconflicting [ skipped ] Requires debug build galera.galera_nbo_alter_toi [ skipped ] Requires debug build galera.galera_slave_replay [ skipped ] Requires debug build galera.MW-86-wait1 'innodb' w1 [ skipped ] debug_sync is not available galera.mdev_18730 'innodb' w5 [ skipped ] debug_sync is not available galera.galera_nbo_temporary_table 'innodb' w4 [ pass ] 2419 galera.galera_log_output_csv 'innodb' w2 [ pass ] 3171 galera.mysql-wsrep-features#128 'innodb' w6 [ pass ] 3139 galera.MW-44 'innodb' w8 [ pass ] 3163 galera.galera_forced_binlog_format 'innodb' w3 [ pass ] 4343 galera.galera_multirow_rollback 'binlogon,innodb' w7 [ pass ] 4156 galera.enforce_storage_engine 'innodb' w5 [ pass ] 3379 galera.galera_events 'innodb' w4 [ pass ] 4363 galera.galera_nbo_alter_multi 'innodb' w2 [ pass ] 2034 galera.galera_unicode_identifiers 'innodb' w8 [ pass ] 2067 galera.ev51914 'innodb' w5 [ pass ] 2118 galera.galera_schema_dirty_reads 'innodb' w6 [ pass ] 2008 galera.mysql-wsrep-features#127 'innodb' w7 [ pass ] 2032 galera.galera_nbo_alter_rename 'innodb' w2 [ pass ] 2034 galera.galera_unicode_pk 'innodb' w8 [ pass ] 2018 galera.fk 'innodb' w5 [ pass ] 2083 galera.galera_wsrep_provider_unset_set 'innodb' w3 [ pass ] 5428 galera.galera_nbo_create_index 'innodb' w2 [ pass ] 2033 galera.galera_update_limit 'innodb' w8 [ pass ] 2037 galera.galera#500 'innodb' w5 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_zero_length_column 'innodb' w3 [ pass ] 2031 galera.GAL-419 'innodb' w1 [ pass ] 13106 galera.galera_nbo_ddl_error 'innodb' w2 [ pass ] 2028 galera.galera_var_OSU_method 'innodb' w8 [ skipped ] debug_sync is not available galera.galera#505 'innodb' w5 [ pass ] 2008 galera.galera_serializable 'innodb' w6 [ pass ] 6027 galera.pxc-421 'innodb' w7 [ pass ] 5190 galera.grant 'innodb' w3 [ pass ] 2014 galera.galera_var_OSU_method2 'innodb' w8 [ skipped ] debug_sync is not available galera.galera_nbo_error_on_all 'innodb' w2 [ pass ] 2025 galera.galera_server 'innodb' w6 [ pass ] 2014 galera.galera_admin 'innodb' w5 [ pass ] 2240 galera.rename 'innodb' w7 [ pass ] 2030 galera.lp1276424 'innodb' w3 [ pass ] 2019 galera.galera_nbo_local_mdl 'innodb' w2 [ pass ] 2035 galera.galera_set_position_after_cert_failure 'innodb' w6 [ skipped ] debug_sync is not available galera.galera_alter_engine_innodb 'innodb' w5 [ pass ] 2025 galera.unique_key 'innodb' w7 [ pass ] 2034 galera.lp1347768 'innodb' w3 [ pass ] 2017 galera.galera_var_auto_inc_control_off 'innodb' w8 [ pass ] 4028 galera.galera_nbo_processlist 'innodb' w2 [ skipped ] debug_sync is not available galera.galera_set_position_after_dummy_writeset 'innodb' w6 [ skipped ] debug_sync is not available galera.galera_alter_engine_myisam 'innodb' w5 [ pass ] 2022 galera.view 'innodb' w7 [ pass ] 2034 galera.galera_events2 'innodb' w4 [ pass ] 15078 galera.galera_var_certify_nonPK_off 'innodb' w8 [ pass ] 2047 galera.galera_nopk_bit 'innodb' w2 [ pass ] 2033 galera.galera_sp_bf_abort 'innodb' w6 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_alter_table_force 'innodb' w5 [ pass ] 2025 galera.GCF-329A 'innodb' w1 [ pass ] 9176 galera.wsrep_strict_ddl 'innodb' w7 [ pass ] 2040 galera.lp1376747 'innodb' w3 [ pass ] 4032 galera.galera_fk_cascade_delete 'innodb' w4 [ pass ] 2042 galera.galera_nopk_blob 'innodb' w2 [ pass ] 2029 galera.galera_applier_ftwrl_table 'innodb' w5 [ pass ] 2025 galera.galera_sp_insert_parallel 'innodb' w6 [ pass ] 2877 galera.wsrep_trx_fragment_size_sr 'innodb' w7 [ pass ] 2007 galera.lp1376747-2 'innodb' w3 [ pass ] 2028 galera.galera_fk_cascade_update 'innodb' w4 [ pass ] 2043 galera.galera_nopk_large_varchar 'innodb' w2 [ pass ] 2030 galera.galera_bf_abort 'innodb' w5 [ pass ] 2026 galera.galera_sql_log_bin_zero 'innodb' w6 [ pass ] 2017 galera.lp1376747-3 'innodb' w3 [ pass ] 2028 galera.galera_fk_conflict 'innodb' w4 [ pass ] 2029 galera.galera_var_cluster_address 'innodb' w8 [ pass ] 6118 galera.galera_nopk_unicode 'innodb' w2 [ pass ] 2021 galera.galera_bf_abort_at_after_statement 'innodb' w5 [ skipped ] debug_sync is not available galera.galera_status_cluster 'innodb' w6 [ pass ] 2008 galera.lp1438990 'innodb' w3 [ pass ] 2037 galera.galera_fk_mismatch 'innodb' w4 [ pass ] 2029 galera.galera_bf_abort_flush_for_export 'innodb' w5 [ pass ] 2022 galera.galera_var_desync_on 'innodb' w8 [ pass ] 3034 galera.galera_status_local_index 'innodb' w6 [ pass ] 2018 galera.lp959512 'innodb' w3 [ pass ] 2028 galera.galera_fk_multicolumn 'innodb' w4 [ pass ] 2044 galera.galera_parallel_apply_lock_table 'innodb' w2 [ pass ] 4037 galera.galera_bf_abort_for_update 'innodb' w5 [ pass ] 2021 galera.galera_status_local_state 'innodb' w6 [ pass ] 2010 galera.mdev_9290 'innodb' w3 [ pass ] 2025 galera.galera_fk_multitable 'innodb' w4 [ pass ] 2029 galera.galera_performance_schema 'innodb' w2 [ pass ] 2031 galera.galera_bf_abort_ftwrl 'innodb' w5 [ pass ] 2018 galera.galera_var_dirty_reads 'innodb' w8 [ pass ] 4232 galera.mysql-wsrep#110 'innodb' w3 [ pass ] 2041 galera.galera_fk_no_pk 'innodb' w4 [ pass ] 2031 galera.galera_pk_bigint_signed 'innodb' w2 [ pass ] 2018 galera.galera_var_fkchecks 'innodb' w8 [ pass ] 2028 galera.mysql-wsrep#237 'innodb' w3 [ skipped ] debug_sync is not available galera.galera_fk_selfreferential 'innodb' w4 [ pass ] 2018 galera.galera_bf_abort_get_lock 'innodb' w5 [ pass ] 3021 galera.galera_pk_bigint_unsigned 'innodb' w2 [ pass ] 2019 galera.galera_var_ignore_apply_errors 'innodb' w8 [ pass ] 2157 galera.galera_fk_setnull 'innodb' w4 [ pass ] 2029 galera.galera_bf_abort_lock_table 'innodb' w5 [ pass ] 2019 galera.galera_prepared_statement 'innodb' w2 [ pass ] 2046 galera.mysql-wsrep#247 'innodb' w3 [ pass ] 3019 galera.galera_flush_local 'innodb' w4 [ skipped ] Test requires: 'have_wsrep_replicate_myisam' galera.galera_bf_abort_shutdown 'innodb' w5 [ skipped ] debug_sync is not available galera.GCF-329B 'innodb' w1 [ pass ] 20113 galera.galera_var_max_ws_rows 'innodb' w8 [ pass ] 2617 galera.galera_read_only 'innodb' w2 [ pass ] 2022 galera.galera_ftwrl_drain 'innodb' w4 [ skipped ] debug_sync is not available galera.galera_bf_abort_sleep 'innodb' w5 [ pass ] 2020 galera.galera_var_max_ws_size 'innodb' w8 [ pass ] 2019 galera.galera_repl_key_format_flat16 'innodb' w2 [ pass ] 2033 galera.galera_var_mysql_replication_bundle 'innodb' w8 [ pass ] 2018 galera.galera_repl_max_ws_size 'innodb' w2 [ pass ] 2017 galera.galera_binlog_cache_size 'innodb' w5 [ pass ] 3029 galera.galera_var_replicate_myisam_off 'innodb' w8 [ pass ] 2013 galera.galera_gra_log 'innodb' w4 [ fail ] Test ended at 2020-04-10 15:07:51 CURRENT_TEST: galera.galera_gra_log Server [mysqld.2 - pid: 17845, winpid: 17845, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2020-04-10 15:07:48 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:07:48 2 [Warning] WSREP: Event 1 Query apply failed: 1, seqno 109 2020-04-10 15:07:48 0 [Note] WSREP: Member 1(jw-xenial-1604-paiuhs) initiates vote on e80ccc91-7b3c-11ea-947c-4f2fa0a83401:109,83d3ac64c660f550: Table 't1' already exists, Error_code: 1050; 2020-04-10 15:07:48 0 [Note] WSREP: Votes over e80ccc91-7b3c-11ea-947c-4f2fa0a83401:109: 83d3ac64c660f550: 1/2 Waiting for more votes. 2020-04-10 15:07:48 0 [Note] WSREP: Member 0(jw-xenial-1604-paiuhs) responds to vote on e80ccc91-7b3c-11ea-947c-4f2fa0a83401:109,0000000000000000: Success 2020-04-10 15:07:48 0 [Note] WSREP: Votes over e80ccc91-7b3c-11ea-947c-4f2fa0a83401:109: 0000000000000000: 1/2 83d3ac64c660f550: 1/2 Winner: 0000000000000000 2020-04-10 15:07:48 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on e80ccc91-7b3c-11ea-947c-4f2fa0a83401:109 at galera/src/replicator_smm.cpp:process_apply_error():1343 2020-04-10 15:07:48 2 [Note] WSREP: Closing send monitor... 2020-04-10 15:07:48 2 [Note] WSREP: Closed send monitor. 2020-04-10 15:07:48 2 [Note] WSREP: gcomm: terminating thread 2020-04-10 15:07:48 2 [Note] WSREP: gcomm: joining thread 2020-04-10 15:07:48 2 [Note] WSREP: gcomm: closing backend 2020-04-10 15:07:49 2 [Note] WSREP: view(view_id(NON_PRIM,e80bdbc3-bf38,4) memb { f85dcba0-a156,0 } joined { } left { } partitioned { e80bdbc3-bf38,0 }) 2020-04-10 15:07:49 2 [Note] WSREP: PC protocol downgrade 1 -> 0 2020-04-10 15:07:49 2 [Note] WSREP: view((empty)) 2020-04-10 15:07:49 2 [Note] WSREP: gcomm: closed 2020-04-10 15:07:49 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 2020-04-10 15:07:49 0 [Note] WSREP: Flow-control interval: [16, 16] 2020-04-10 15:07:49 0 [Note] WSREP: Received NON-PRIMARY. 2020-04-10 15:07:49 0 [Note] WSREP: Shifting SYNCED -> OPEN (TO: 109) 2020-04-10 15:07:49 0 [Note] WSREP: New SELF-LEAVE. 2020-04-10 15:07:49 0 [Note] WSREP: Flow-control interval: [0, 0] 2020-04-10 15:07:49 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2020-04-10 15:07:49 0 [Note] WSREP: Shifting OPEN -> CLOSED (TO: -1) 2020-04-10 15:07:49 0 [Note] WSREP: RECV thread exiting 0: Success 2020-04-10 15:07:49 2 [Note] WSREP: recv_thread() joined. 2020-04-10 15:07:49 2 [Note] WSREP: Closing replication queue. 2020-04-10 15:07:49 2 [Note] WSREP: Closing slave action queue. 2020-04-10 15:07:49 2 [Note] WSREP: ================================================ View: id: e80ccc91-7b3c-11ea-947c-4f2fa0a83401:-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: f85dcba0-7b3c-11ea-a156-fff5783deb6c, jw-xenial-1604-paiuhs ================================================= 2020-04-10 15:07:49 2 [Note] WSREP: Non-primary view 2020-04-10 15:07:49 2 [Note] WSREP: Server status change synced -> connected 2020-04-10 15:07:49 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-10 15:07:49 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-10 15:07:49 2 [Note] WSREP: ================================================ View: id: e80ccc91-7b3c-11ea-947c-4f2fa0a83401:-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:07:49 2 [Note] WSREP: Non-primary view 2020-04-10 15:07:49 2 [Note] WSREP: Server status change connected -> disconnected 2020-04-10 15:07:49 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-10 15:07:49 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. 2020-04-10 15:07:49 0 [Note] WSREP: Service thread queue flushed. 2020-04-10 15:07:49 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: 5 2020-04-10 15:07:49 2 [Note] WSREP: Applier thread exiting ret: 0 thd: 2 2020-04-10 15:07:49 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) 2020-04-10 15:07:51 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated 2020-04-10 15:07:51 0 [Note] /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/RelWithDebInfo/label/ubuntu-1604/bin/mysqld (mysqld 10.5.2-0-MariaDB-enterprise-log) starting as process 17846 ... 2020-04-10 15:07:51 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32190) 2020-04-10 15:07:51 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2020-04-10 15:07:51 0 [Note] mysqld: Aria engine: starting recovery recovered pages: 0% Table ./mysql/event.MAD has wrong LSN: (1,0xaa4b) on page: 1 12% 24% 36% 46% 57% 68% Got error 175 when executing record redo_index 2020-04-10 15:07:51 0 [ERROR] mysqld: Aria engine: Redo phase failed tables to flush: 1 0 2020-04-10 15:07:51 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:07:51 0 [ERROR] Plugin 'Aria' init function returned error. 2020-04-10 15:07:51 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2020-04-10 15:07:51 0 [ERROR] Failed to initialize plugins. 2020-04-10 15:07:51 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/4/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:07:48 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on e80ccc91-7b3c-11ea-947c-4f2fa0a83401:109 2020-04-10 15:07:51 0 [ERROR] mysqld: Aria engine: Redo phase failed 2020-04-10 15:07:51 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:07:51 0 [ERROR] Plugin 'Aria' init function returned error. 2020-04-10 15:07:51 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2020-04-10 15:07:51 0 [ERROR] Failed to initialize plugins. 2020-04-10 15:07:51 0 [ERROR] Aborting galera.galera_binlog_row_image 'innodb' w5 [ pass ] 2061 galera.mysql-wsrep#31 'innodb' w3 [ pass ] 9060 galera.galera_var_replicate_myisam_on 'innodb' w8 [ pass ] 2075 galera.galera_change_user 'innodb' w5 [ pass ] 2020 galera.GCF-849 'innodb' w1 [ pass ] 10137 galera.galera_var_sync_wait 'innodb' w8 [ pass ] 2031 galera.galera_commit_empty 'innodb' w5 [ pass ] 2006 galera.galera_var_wsrep_on_off 'innodb' w8 [ pass ] 2022 galera.galera_insert_delayed 'innodb' w4 [ pass ] 2006 galera.galera_create_function 'innodb' w5 [ pass ] 2021 galera.galera_restart_nochanges 'innodb' w2 [ pass ] 9055 galera.galera_wsrep_provider_options_syntax 'innodb' w8 [ pass ] 2012 galera.galera_insert_ignore 'innodb' w4 [ pass ] 2046 galera.galera_create_procedure 'innodb' w5 [ pass ] 2030 galera.galera_suspend_slave 'innodb' w6 [ pass ] 25392 galera.GCF-360 'innodb' w7 [ pass ] 2954 galera.mysql-wsrep#332 'innodb' w3 [ skipped ] debug_sync is not available galera.galera_insert_multi 'innodb' w4 [ pass ] 2058 galera.galera_create_table_as_select 'innodb' w5 [ pass ] 2150 galera.mysql-wsrep#90 'innodb' w3 [ skipped ] debug_sync is not available galera.GCF-854 'innodb' w1 [ pass ] 10144 galera.galera_toi_alter_auto_increment 'innodb' w6 [ pass ] 4077 galera.galera_create_table_like 'innodb' w5 [ pass ] 2070 galera.galera_toi_ddl_sequential 'innodb' w6 [ pass ] 2030 galera.galera_create_trigger 'innodb' w5 [ pass ] 2102 galera.galera_ddl_multiline 'innodb' w5 [ pass ] 2131 galera.galera_delete_limit 'innodb' w5 [ pass ] 2046 galera.galera_kill_applier 'innodb' w4 [ pass ] 2023 galera.galera_desync_overlapped 'innodb' w5 [ skipped ] debug_sync is not available galera.MDEV-15443 'innodb' w7 [ pass ] 14544 galera.MDEV-10715 'innodb' w8 [ pass ] 2638 galera.galera_toi_drop_database 'innodb' w6 [ pass ] 18167 galera.MDEV-18832 'innodb' w3 [ pass ] 2134 galera.galera_toi_ftwrl 'innodb' w6 [ pass ] 2026 galera.galera_drop_database 'innodb' w5 [ pass ] 13131 galera.galera_drop_multi 'innodb' w5 [ pass ] 2033 galera.galera_toi_lock_exclusive 'innodb' w6 [ pass ] 3028 galera.galera_toi_lock_shared 'innodb' w6 [ pass ] 2060 galera.galera_enum 'innodb' w5 [ pass ] 2455 galera.galera_toi_truncate 'innodb' w6 [ skipped ] debug_sync is not available galera.galera_transaction_read_only 'innodb' w6 [ pass ] 2186 galera.galera_transaction_replay 'innodb' w6 [ skipped ] debug_sync is not available galera.galera_truncate 'innodb' w6 [ pass ] 4895 galera.galera_truncate_temporary 'innodb' w6 [ pass ] 3713 galera.galera_kill_ddl 'innodb' w4 [ pass ] 27845 galera.MDEV-6860 'innodb' w7 [ pass ] 11314 galera.MW-313 'innodb' w5 [ pass ] 2043 galera.MW-284 'innodb' w3 [ pass ] 12082 galera.MW-86-wait8 'innodb' w7 [ skipped ] debug_sync is not available galera.galera_kill_smallchanges 'innodb' w4 [ pass ] 28716 galera.MW-336 'innodb' w6 [ pass ] 3371 galera.enforce_storage_engine2 'innodb' w5 [ pass ] 9909 galera.galera_restart_on_unknown_option 'innodb' w2 [ pass ] 96259 galera.galera_lock_table 'innodb' w4 [ pass ] 10270 galera.galera#414 'innodb' w3 [ pass ] 16980 galera.galera_roles 'innodb' w2 [ pass ] 8919 galera.galera_rsu_error 'innodb' w2 [ pass ] 3020 galera.galera_bf_lock_wait 'innodb' w1 [ pass ] 103699 galera.galera_rsu_simple 'innodb' w2 [ pass ] 2432 galera.galera_applier_ftwrl_table_alter 'innodb' w6 [ pass ] 10734 galera.galera_rsu_wsrep_desync 'innodb' w2 [ skipped ] debug_sync is not available galera.galera_as_master 'innodb' w5 [ pass ] 4839 galera.galera-features#117 'innodb' w7 [ pass ] 19664 galera.galera_sbr 'innodb' w2 [ pass ] 3654 galera.galera_as_master_large 'innodb' w3 [ pass ] 2345 galera.galera_many_indexes 'innodb' w4 [ pass ] 27816 galera.MENT-432-B 'innodb' w8 [ fail ] Test ended at 2020-04-10 15:10:16 CURRENT_TEST: galera.MENT-432-B --- /home/jenkins/workspace/10.5e-MTR-GALERA/BuildType/RelWithDebInfo/label/ubuntu-1604/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/RelWithDebInfo/label/ubuntu-1604/mysql-test/suite/galera/r/MENT-432-B.reject 2020-04-10 15:10:14.848374730 +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/8/log/galera.MENT-432-B-innodb/' to '/var/tmp/mtr/log/galera.MENT-432-B-innodb/' galera.galera_mdev_10812 'innodb' w4 [ pass ] 14578 galera.galera_as_slave_autoinc 'innodb' w5 [ pass ] 10863 galera.galera_as_slave 'innodb' w6 [ pass ] 6178 galera.galera_multi_database 'innodb' w4 [ pass ] 2037 galera.galera_multirow_rollback 'binlogoff,innodb' w4 [ pass ] 2907 galera.galera_myisam_autocommit 'innodb' w4 [ pass ] 7365 galera.galera_as_slave_gtid_myisam 'innodb' w8 [ pass ] 8371 galera.galera_as_slave_gtid 'innodb' w2 [ pass ] 9410 galera.galera_as_slave_gtid_auto_engine 'innodb' w3 [ pass ] 10004 galera.galera_as_slave_ctas 'innodb' w7 [ pass ] 11101 galera.galera_myisam_transactions 'innodb' w4 [ pass ] 6644 galera.galera_nbo_alter_engine 'innodb' w4 [ pass ] 6949 galera.galera_bf_background_statistics 'innodb' w6 [ pass ] 7736 galera.galera_nbo_alter_error_duplicate 'innodb' w4 [ pass ] 3113 galera.galera_binlog_event_max_size_min 'innodb' w3 [ pass ] 2226 galera.galera_binlog_checksum 'innodb' w8 [ pass ] 2254 galera.galera_encryption 'innodb' w7 [ pass ] 3431 galera.galera_binlog_event_max_size_max 'innodb' w2 [ pass ] 6257 galera.galera_as_slave_nonprim 'innodb' w5 [ pass ] 21987 galera.galera_gcs_fragment 'innodb' w2 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.galera_gcs_max_packet_size 'innodb' w5 [ pass ] 2249 galera.galera_concurrent_ctas 'innodb' w1 [ pass ] 113272 galera.galera_fulltext 'innodb' w1 [ pass ] 2929 galera.galera_encryption_restart2 'innodb' w6 [ pass ] 35987 galera.galera_encryption_restart 'innodb' w4 [ pass ] 34327 galera.galera_gcache_recover 'innodb' w8 [ pass ] 35239 galera.galera_gcs_fc_limit 'innodb' w1 [ pass ] 3973 galera.galera_encryption_restart4 'innodb' w3 [ pass ] 39682 galera.galera_gtid 'innodb' w2 [ pass ] 3351 galera.galera_gtid_slave 'innodb' w5 [ pass ] 3571 galera.galera_gcache_recover_full_gcache 'innodb' w7 [ pass ] 49872 galera.galera_many_columns 'innodb' w1 [ pass ] 2749 galera.galera_many_tables_pk 'innodb' w1 [ pass ] 6583 galera.galera_gtid_slave_sst_rsync 'innodb' w6 [ pass ] 27911 galera.galera_ist_restart_joiner 'innodb' w7 [ skipped ] debug_sync is not available galera.galera_ist_recv_bind 'innodb' w5 [ pass ] 14317 galera.galera_encryption_restart3 'innodb' w4 [ pass ] 23315 galera.galera_ist_mariabackup_innodb_flush_logs 'innodb,release' w3 [ pass ] 14327 galera.galera_parallel_autoinc_manytrx 'innodb' w1 [ pass ] 11172 galera.galera_last_committed_id 'binlogon,innodb' w7 [ pass ] 2038 galera.galera_last_committed_id 'binlogoff,innodb' w5 [ pass ] 2041 galera.galera_gtid_trx_conflict 'innodb' w4 [ pass ] 2045 galera.galera_ist_mariabackup 'innodb,release' w8 [ pass ] 30413 galera.galera_pc_recovery 'innodb' w1 [ pass ] 12534 galera.galera_mdev_13787 'innodb' w7 [ pass ] 5501 galera.galera_ist_rsync 'innodb,release' w6 [ pass ] 36776 galera.galera_mdev_15611 'innodb' w5 [ pass ] 5409 galera.galera_many_rows 'innodb' w3 [ pass ] 27201 galera.galera_query_cache 'innodb' w8 [ pass ] 2320 galera.galera_log_bin 'innodb' w4 [ pass ] 2432 galera.galera_query_cache_sync_wait 'innodb' w7 [ skipped ] debug_sync is not available galera.galera_sbr_binlog 'innodb' w6 [ pass ] 3782 galera.galera_ist_mysqldump 'innodb,release' w2 [ pass ] 84752 galera.galera_ssl 'innodb' w5 [ pass ] 3932 galera.galera_ssl_compression 'innodb' w3 [ pass ] 2229 galera.galera_rsu_add_pk 'innodb' w1 [ pass ] 35031 galera.galera_partition 'innodb' w4 [ pass ] 9302 galera.galera_rsu_drop_pk 'innodb' w1 [ pass ] 24774 galera.galera_toi_ddl_error 'innodb' w1 [ pass ] 3024 galera.galera_sst_mysqldump_with_key 'innodb,release' w6 [ pass ] 19659 galera.galera_toi_ddl_fk_insert 'innodb' w1 [ pass ] 5228 galera.galera_toi_ddl_fk_update 'innodb' w1 [ pass ] 4360 galera.galera_var_load_data_splitting 'innodb' w1 [ pass ] 2603 galera.galera_sst_rsync2 'innodb,release' w5 [ pass ] 33432 galera.galera_sst_rsync 'innodb,release' w2 [ pass ] 33445 galera.galera_wsrep_desync_wsrep_on 'innodb' w1 [ pass ] 4950 galera.galera_sync_wait_upto 'binlogoff,innodb' w6 [ skipped ] debug_sync is not available galera.GAL-382 'innodb' w1 [ pass ] 2031 galera.galera_sst_rsync_data_dir 'innodb,release' w3 [ pass ] 28873 galera.galera_sst_mariabackup 'innodb,release' w8 [ pass ] 43625 galera.galera_v1_row_events 'innodb' w5 [ pass ] 2035 galera.galera_var_auto_inc_control_on 'innodb' w2 [ pass ] 2034 galera.galera_var_gtid_domain_id 'innodb' w6 [ pass ] 2045 galera.galera_var_log_bin 'innodb' w3 [ pass ] 2046 galera.GAL-401 'innodb' w1 [ pass ] 19271 galera.GAL-480 'innodb' w1 [ pass ] 2117 galera.galera_sst_mariabackup_data_dir 'innodb,release' w4 [ pass ] 39200 galera.MW-252 'innodb' w1 [ pass ] 2154 galera.galera_var_sst_auth 'innodb' w5 [ pass ] 2007 galera.galera_var_slave_threads 'innodb' w8 [ pass ] 2247 galera.MW-258 'innodb' w1 [ pass ] 13539 galera.MW-259 'innodb' w1 [ skipped ] debug_sync is not available galera.mdev_10518 'innodb' w8 [ pass ] 3423 galera.MW-285 'innodb' w1 [ pass ] 3095 galera.MW-292 'innodb' w1 [ skipped ] debug_sync is not available galera.MW-309 'innodb' w1 [ pass ] 2022 galera.galera_sync_wait_upto 'binlogon,innodb' w4 [ skipped ] debug_sync is not available galera.MW-328D 'innodb' w1 [ pass ] 6049 galera.galera_wsrep_log_conficts 'innodb' w5 [ pass ] 2351 galera.MW-328E 'innodb' w1 [ pass ] 4473 galera.MW-357 'innodb' w1 [ pass ] 2016 galera.mysql-wsrep#201 'innodb' w8 [ pass ] 2537 galera.MW-369 'innodb' w1 [ skipped ] debug_sync is not available galera.MW-388 'innodb' w1 [ skipped ] debug_sync is not available galera.MW-402 'innodb' w1 [ skipped ] "Test requires Galera debug library with debug_sync functionality" galera.MW-416 'innodb' w1 [ pass ] 2523 wsrep.pool_of_threads 'innodb' w8 [ pass ] 1 galera.rpl_row_annotate 'innodb' w5 [ pass ] 2040 wsrep.foreign_key 'innodb' w8 [ pass ] 34 galera.basic 'innodb' w1 [ pass ] 2037 galera.galera_vote_rejoin_ddl 'innodb' w2 [ pass ] 21975 galera.binlog_checksum 'innodb' w1 [ pass ] 2673 wsrep.mysql_tzinfo_to_sql_symlink 'innodb' w8 [ pass ] 13 wsrep.mysql_tzinfo_to_sql_symlink_skip 'innodb' w8 [ pass ] 14 wsrep.trans 'innodb' w8 [ pass ] 1 wsrep.MDEV-20625 'innodb' w2 [ pass ] 9 galera.galera_vote_rejoin_dml 'innodb' w6 [ pass ] 24481 galera.create 'innodb' w1 [ pass ] 3263 wsrep.binlog_format 'innodb' w2 [ pass ] 26 wsrep.alter_table_innodb 'innodb' w8 [ pass ] 2246 wsrep.mdev_10186 'innodb' w6 [ pass ] 1 wsrep.plugin 'innodb' w5 [ pass ] 1 wsrep.wsrep-recover-v25 'binlogon,innodb' w8 [ skipped ] debug_sync is not available wsrep.wsrep-recover-v25 'binlogoff,innodb' w6 [ skipped ] debug_sync is not available wsrep.wsrep-recover 'binlogon,innodb' w5 [ skipped ] debug_sync is not available wsrep.mdev_7798 'innodb' w2 [ pass ] 5076 wsrep.wsrep-recover 'binlogoff,innodb' w8 [ skipped ] debug_sync is not available wsrep.wsrep_rpl 'innodb,mix' w6 [ pass ] 393 galera.galera_sst_mysqldump 'innodb,release' w7 [ pass ] 139615 wsrep.wsrep_rpl 'innodb,stmt' w2 [ pass ] 837 wsrep.wsrep_rpl 'innodb,row' w5 [ pass ] 838 wsrep.mdev_6832 'innodb' w1 [ pass ] 2240 galera.galera_wan_restart_ist 'innodb' w3 [ pass ] 62204 galera.galera_wan_restart_sst 'innodb' w4 [ pass ] 43810 galera.mysql-wsrep#33 'innodb,release' w4 [ pass ] 68089 -------------------------------------------------------------------------- The servers were restarted 113 times Spent 2416.433 of 748 seconds executing testcases Completed: Failed 2/269 tests, 99.26% were successful. Failing test(s): galera.galera_gra_log galera.MENT-432-B 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 57 tests were skipped, 35 by the test itself. mysql-test-run: *** ERROR: there were failing test cases