PRETTY_NAME="Debian GNU/Linux 11 (bullseye)" NAME="Debian GNU/Linux" VERSION_ID="11" VERSION="11 (bullseye)" VERSION_CODENAME=bullseye ID=debian HOME_URL="https://www.debian.org/" SUPPORT_URL="https://www.debian.org/support" BUG_REPORT_URL="https://bugs.debian.org/" Linux mdbci-xpsburev-1691453554-build 5.10.0-23-cloud-amd64 #1 SMP Debian 5.10.179-1 (2023-05-12) x86_64 GNU/Linux Filesystem Type 1K-blocks Used Available Use% Mounted on /dev/sdb1 ext4 515794480 3302120 491406708 1% / cp: cannot stat '/usr/share/mysql/not_supported/*': No such file or directory cp: cannot stat '/usr/share/mysql/not_supported/*': No such file or directory su: warning: cannot change directory to /nonexistent: No such file or directory Logging: mysql-test-run.pl --suite=galera,wsrep,galera_3nodes,galera_sr,galera_3nodes_sr --testcase-timeout=20 --big-test --max-test-fail=0 --parallel=1 --xml-report=/tmp/mtr.xml --max-save-core=0 --max-save-datadir=1 --force --vardir=/var/tmp/mtr VS config: vardir: /var/tmp/mtr Removing old var directory... Creating var directory '/var/tmp/mtr'... Checking supported features... MariaDB Version 23.07.0-MariaDB-enterprise - SSL connections supported Using suites: galera,wsrep,galera_3nodes,galera_sr,galera_3nodes_sr Collecting tests... - binaries built with wsrep patch Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 galera.galera_as_slave_ctas [ disabled ] MDEV-28378 timeout galera.galera_bf_abort_at_after_statement [ disabled ] Unstable galera.galera_bf_abort_group_commit [ disabled ] temporary disabled due MDEV-30855 galera.galera_bf_abort_shutdown [ disabled ] MDEV-29773 Assertion failure on sql/wsrep_mysqld.cc:2893 in wsrep_bf_abort_shutdown galera.galera_binlog_checksum [ disabled ] MDEV-29861 Galera test case hangs galera.galera_parallel_simple [ disabled ] timeout related to wsrep_sync_wait galera.galera_pc_recovery [ disabled ] MDEV-25199 cluster fails to start up galera.galera_ssl_mode_server_x509 [ disabled ] hangs on connection galera.galera_ssl_upgrade [ disabled ] [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 130: Incorrect file format 'gtid_slave_pos' galera.galera_sst_encrypted [ disabled ] MDEV-29876 Galera test failure on galera_sst_encrypted galera.galera_truncate_temporary [ disabled ] Unstable galera.galera_var_ignore_apply_errors [ disabled ] MDEV-20451: "Server did not transition to READY state" galera.galera_var_node_address [ disabled ] MDEV-20485 Galera test failure galera.partition [ disabled ] MDEV-19958 Galera test failure on galera.partition galera.versioning_trx_id [ disabled ] MDEV-18590: galera.versioning_trx_id: Test failure: mysqltest: Result content mismatch galera_3nodes.galera_2_cluster [ disabled ] MDEV-29877 Galera test failure on galera_2_cluster galera_3nodes.galera_gtid_2_cluster [ disabled ] MDEV-29877 Galera test failure on galera_2_cluster galera_3nodes.galera_ipv6_mariabackup [ disabled ] MDEV-24097 galera_3nodes.galera_ipv6_mariabackup_section [ disabled ] MDEV-24097, MDEV-22195 galera_3nodes.galera_nbo_master_non_prim_failure [ disabled ] 10.5.10-7 rebase galera_3nodes.galera_ssl_reload [ disabled ] MDEV-30172 At line 50: mysql_shutdown failed galera_3nodes.galera_vote_rejoin_mysqldump [ disabled ] MDEV-24481: galera_3nodes.galera_vote_rejoin_mysqldump MTR failed: mysql_shutdown failed galera_3nodes_sr.galera_sr_kill_slave_after_apply_rollback2 [ disabled ] MDEV-29892 Galera test failure on galera_sr_kill_slave_after_apply_rollback2 galera_sr.GCF-1060 [ disabled ] MDEV-26528 wrong usage of mutex LOCK_thd_kill and LOCK_thd_kill galera_sr.MDEV-25718 [ disabled ] timeout related to wsrep_sync_wait and DEBUG_SYNC galera_sr.galera_sr_cc_master [ disabled ] MDEV-29882 Galera test failure on galera_sr_cc_master galera_sr.mysql-wsrep-features#138 [ disabled ] At line 25: query 'DROP TABLE t1' failed: 2013: Lost connection to MySQL server during query wsrep.MDEV-22443 [ disabled ] it is no longer allowed enable wsrep_on if wsrep_provider is 'none' wsrep.MDEV-23092 [ disabled ] wsrep_provider is read-only for security reasons wsrep.mdev_6832 [ disabled ] wsrep_provider is read-only for security reasons wsrep.wsrep_variables_no_provider [ disabled ] wsrep_provider is read-only for security reasons galera.MW-86-wait1 [ skipped ] Requires debug build galera.mysql-wsrep-bugs-607 'innodb' [ skipped ] Requires debug build galera.galera_nbo_sst_slave 'innodb' [ skipped ] Requires debug build galera.GCF-546 'innodb' [ skipped ] Requires debug build galera.GCF-563 'innodb' [ skipped ] Requires debug build galera.MDEV-20225 'innodb' [ skipped ] Requires debug build galera.MDEV-20616 'innodb' [ skipped ] Requires debug build galera.MENT-644 'innodb' [ skipped ] Requires debug build galera.MW-388 'innodb' [ skipped ] Requires debug build galera.galera_FK_duplicate_client_insert 'innodb' [ skipped ] Requires debug build galera.galera_fk_cascade_delete_debug '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_nonconflicting 'innodb' [ skipped ] Requires debug build galera.galera_nbo_alter_parallel 'innodb' [ skipped ] Requires debug build galera.galera_nbo_alter_toi '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.mdev-22543 'innodb' [ skipped ] Requires debug build galera.galera_nbo_alter_partition [ skipped ] Requires debug build galera.MDEV-27713 [ skipped ] Requires debug build galera.GCF-421 [ skipped ] Requires debug build galera.MDEV-16509 [ skipped ] Requires debug build galera.MDEV-20793 [ skipped ] Requires debug build galera.MDEV-25389 [ skipped ] Requires debug build galera.MENT-1160 [ skipped ] Requires debug build galera.galera_inject_bf_long_wait [ skipped ] Requires debug build galera.galera_nbo_alter_exclusive [ skipped ] Requires debug build galera.galera_nbo_alter_inplace [ skipped ] Requires debug build galera.galera_set_position_after_dummy_writeset [ skipped ] Requires debug build galera.galera_toi_truncate [ skipped ] Requires debug build galera.galera_var_retry_autocommit [ skipped ] Requires debug build galera.lp1376747-4 [ skipped ] Requires debug build galera.mysql-wsrep-features#131 [ skipped ] Requires debug build galera.mysql-wsrep-features#132 [ skipped ] Requires debug build galera.MW-86-wait8 'innodb' [ skipped ] Requires debug build galera.galera_as_slave_replay 'innodb' [ skipped ] Requires debug build galera.galera_bf_kill_debug 'innodb' [ skipped ] Requires debug build galera.galera_query_cache_sync_wait [ skipped ] Requires debug build galera.galera_slave_replay 'innodb' [ skipped ] Requires debug build galera.galera_sst_mariabackup_qpress 'innodb' [ skipped ] Need 'qpress' utility galera.galera_sst_rsync_encrypt_with_capath [ skipped ] Need 'stunnel' utility galera.galera_sst_rsync_encrypt_with_key [ skipped ] Need 'stunnel' utility galera.galera_sst_rsync_encrypt_with_server 'innodb,release' [ skipped ] Requires debug build galera.mdev_21718 [ skipped ] Requires debug build galera_3nodes.galera_nbo_shutdown_slave_ist 'innodb' [ skipped ] Requires debug build galera_3nodes.galera_nbo_master_non_prim_success 'innodb' [ skipped ] Requires debug build galera_3nodes.galera_parallel_apply_3nodes 'innodb' [ skipped ] Requires debug build galera_3nodes.galera_nbo_kill_slave_ist [ skipped ] Requires debug build galera_3nodes.galera_nbo_master_phase_two_crash [ skipped ] Requires debug build galera_3nodes.galera_nbo_slave_non_prim [ skipped ] Requires debug build galera_3nodes.mysql-wsrep-features#131 [ skipped ] Requires debug build galera_3nodes.galera_garbd_backup 'innodb' [ skipped ] Requires debug build galera_3nodes.galera_nbo_kill_slave_sst 'innodb' [ skipped ] Requires debug build galera_3nodes.galera_nbo_master_minority_success 'innodb' [ skipped ] Requires debug build galera_3nodes.inconsistency_shutdown 'innodb' [ skipped ] Requires debug build galera_sr.MDEV-27553 'innodb' [ skipped ] Requires debug build galera_sr.galera_xa_recover_master_crash 'innodb' [ skipped ] Requires debug build galera_sr.galera_xa_cert_failure [ skipped ] Requires debug build wsrep.variables_debug 'innodb' [ skipped ] Requires debug build galera.MDEV-27123 'innodb' [ pass ] 2044 galera.galera_log_output_csv 'innodb' [ pass ] 2057 galera.galera_forced_binlog_format 'innodb' [ pass ] 2075 galera.galera_nbo_temporary_table 'innodb' [ pass ] 2022 galera.MDEV-22227 'innodb' [ pass ] 2054 galera.mdev_18730 'innodb' [ skipped ] debug_sync is not available galera.MDEV-22021 'binlogon,innodb' [ pass ] 2051 galera.MDEV-27862 'binlogon,innodb' [ pass ] 2085 galera.galera_multirow_rollback 'binlogon,innodb' [ pass ] 2093 galera.mariadb_tzinfo_to_sql 'innodb' [ fail ] Test ended at 2023-08-08 02:20:52 CURRENT_TEST: galera.mariadb_tzinfo_to_sql --- /usr/share/mariadb/mariadb-test/suite/galera/r/mariadb_tzinfo_to_sql.result 2023-07-26 20:42:10.000000000 +0200 +++ /usr/share/mariadb/mariadb-test/suite/galera/r/mariadb_tzinfo_to_sql.reject 2023-08-08 02:20:42.013204563 +0200 @@ -138,19 +138,21 @@ connection node_1; Warnings: Warning 1478 Table storage engine 'MyISAM' does not support the create option 'TRANSACTIONAL=1' +Warnings: +Warning 1478 Table storage engine 'MyISAM' does not support the create option 'TRANSACTIONAL=1' 'binlog advanced as expected' SELECT @wsrep_is_on, @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN; @wsrep_is_on @wsrep_cannot_replicate_tz @save_wsrep_on @save_sql_log_bin @@WSREP_ON @@SQL_LOG_BIN -1 0 1 1 1 1 +1 1 1 1 1 1 SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff FROM information_schema.global_status g JOIN baseline b USING (VARIABLE_NAME) ORDER BY g.VARIABLE_NAME; VARIABLE_NAME diff -COM_ALTER_TABLE 2 -COM_BEGIN 0 +COM_ALTER_TABLE 8 +COM_BEGIN 1 COM_INSERT 6 -COM_LOCK_TABLES 1 +COM_LOCK_TABLES 0 COM_TRUNCATE 4 SELECT COUNT(*) FROM time_zone; COUNT(*) @@ -176,13 +178,13 @@ 2 SELECT COUNT(*) FROM time_zone_name; COUNT(*) -0 +2 SELECT COUNT(*) FROM time_zone_transition; COUNT(*) 0 SELECT COUNT(*) FROM time_zone_transition_type; COUNT(*) -0 +2 SELECT COUNT(*) FROM time_zone_leap_second; COUNT(*) 0 mysqltest: Result length mismatch - saving '/var/tmp/mtr/log/galera.mariadb_tzinfo_to_sql-innodb/' to '/var/tmp/mtr/log/galera.mariadb_tzinfo_to_sql-innodb/' galera.mysql_tzinfo_to_sql 'innodb' [ pass ] 2260 galera.MW-44 'innodb' [ pass ] 2051 galera.galera_backup_stage 'innodb' [ pass ] 2120 galera.MDEV-24143 'innodb' [ pass ] 2070 galera.MDEV-29142 'innodb' [ pass ] 13364 galera.MDEV-27001 'innodb' [ pass ] 2057 galera.galera_var_notify_cmd 'innodb' [ pass ] 2028 galera.mysql-wsrep-features#128 'innodb' [ pass ] 2055 galera.GAL-419 'innodb' [ pass ] 12476 galera.GCF-329A 'innodb' [ pass ] 9307 galera.GCF-329B 'innodb' [ pass ] 20282 galera.GCF-849 'innodb' [ pass ] 8179 galera.GCF-854 'innodb' [ pass ] 8288 galera.galera_concurrent_ctas 'innodb' [ pass ] 30243 galera.galera_gcs_fc_limit 'innodb' [ pass ] 3054 galera.galera_many_columns 'innodb' [ pass ] 2132 galera.galera_many_tables_nopk 'innodb' [ pass ] 3520 galera.galera_many_tables_pk 'innodb' [ pass ] 4195 galera.galera_parallel_autoinc_largetrx 'innodb' [ pass ] 3329 galera.galera_parallel_autoinc_manytrx 'innodb' [ pass ] 6069 galera.galera_rsu_add_pk 'innodb' [ pass ] 5700 galera.galera_rsu_drop_pk 'innodb' [ pass ] 7899 galera.galera_toi_ddl_error 'innodb' [ pass ] 2998 galera.galera_toi_ddl_fk_insert 'innodb' [ pass ] 5283 galera.galera_toi_ddl_fk_update 'innodb' [ pass ] 4255 galera.galera_var_load_data_splitting 'innodb' [ pass ] 2575 galera.galera_wsrep_desync_wsrep_on 'innodb' [ pass ] 4608 galera.GAL-382 'innodb' [ pass ] 2139 galera.GAL-401 'innodb' [ pass ] 17581 galera.GAL-480 'innodb' [ pass ] 2724 galera.GCF-939 'innodb' [ pass ] 2175 galera.MDEV-22021 'binlogoff,innodb' [ pass ] 2251 galera.MDEV-22051 'innodb' [ pass ] 2046 galera.MDEV-22055 'innodb' [ pass ] 2157 galera.MDEV-22421 'innodb' [ pass ] 2160 galera.MDEV-22458 'innodb' [ pass ] 2085 galera.MDEV-24063 'innodb' [ pass ] 8683 galera.MDEV-25494 'innodb' [ pass ] 2034 galera.MDEV-25562 'innodb' [ pass ] 2019 galera.MDEV-25740 'innodb' [ pass ] 2031 galera.MDEV-26597 'innodb' [ pass ] 28329 galera.MDEV-27276 'innodb' [ skipped ] debug_sync is not available galera.MDEV-27862 'binlogoff,innodb' [ pass ] 2084 galera.MDEV-29293 'innodb' [ skipped ] debug_sync is not available galera.MDEV-30955 'innodb' [ pass ] 2070 galera.MENT-1144 'innodb' [ pass ] 2054 galera.MENT-1147 'innodb' [ pass ] 2088 galera.MENT-1202 'innodb' [ skipped ] debug_sync is not available galera.MENT-1429 'innodb' [ pass ] 2054 galera.MENT-1462 'innodb' [ pass ] 9327 galera.MW-252 'innodb' [ pass ] 2281 galera.MW-258 'innodb' [ pass ] 10065 galera.MW-259 'innodb' [ skipped ] debug_sync is not available galera.MW-285 'innodb' [ pass ] 2095 galera.MW-286 'innodb' [ skipped ] debug_sync is not available galera.MW-292 'innodb' [ skipped ] debug_sync is not available galera.MW-309 'innodb' [ pass ] 2042 galera.MW-357 'innodb' [ pass ] 2035 galera.MW-369 'innodb' [ skipped ] debug_sync is not available galera.MW-402 'innodb' [ skipped ] Test requires Galera debug library with debug_sync functionality galera.MW-416 'innodb' [ pass ] 2037 galera.basic 'innodb' [ pass ] 2063 galera.binlog_checksum 'innodb' [ pass ] 2062 galera.create 'innodb' [ pass ] 2109 galera.enforce_storage_engine 'innodb' [ pass ] 2036 galera.ev51914 'innodb' [ pass ] 2245 galera.fk 'innodb' [ pass ] 2134 galera.galera#500 'innodb' [ skipped ] Test requires Galera debug library with debug_sync functionality galera.galera#505 'innodb' [ pass ] 2020 galera.galera_UK_conflict 'innodb' [ skipped ] debug_sync is not available galera.galera_admin 'innodb' [ pass ] 2451 galera.galera_alter_engine_innodb 'innodb' [ pass ] 2044 galera.galera_alter_engine_myisam 'innodb' [ pass ] 2068 galera.galera_alter_table_force 'innodb' [ pass ] 2043 galera.galera_applier_ftwrl_table 'innodb' [ pass ] 2046 galera.galera_backup_start 'innodb' [ pass ] 2018 galera.galera_bf_abort 'innodb' [ pass ] 2044 galera.galera_bf_abort_flush_for_export 'innodb' [ pass ] 2038 galera.galera_bf_abort_for_update 'innodb' [ pass ] 2043 galera.galera_bf_abort_ftwrl 'innodb' [ pass ] 2038 galera.galera_bf_abort_get_lock 'innodb' [ pass ] 3051 galera.galera_bf_abort_lock_table 'innodb' [ pass ] 2045 galera.galera_bf_abort_sleep 'innodb' [ pass ] 2035 galera.galera_binlog_cache_size 'innodb' [ pass ] 3056 galera.galera_binlog_row_image 'innodb' [ pass ] 2204 galera.galera_can_run_toi 'innodb' [ pass ] 2046 galera.galera_change_user 'innodb' [ pass ] 2052 galera.galera_commit_empty 'innodb' [ pass ] 2019 galera.galera_create_function 'innodb' [ pass ] 2042 galera.galera_create_procedure 'innodb' [ pass ] 2056 galera.galera_create_table_as_select 'innodb' [ pass ] 2217 galera.galera_create_table_like 'innodb' [ pass ] 2101 galera.galera_create_trigger 'innodb' [ pass ] 2123 galera.galera_create_view 'innodb' [ pass ] 2028 galera.galera_ctas 'innodb' [ pass ] 2073 galera.galera_ddl_fk_conflict 'innodb' [ skipped ] debug_sync is not available galera.galera_ddl_fk_no_conflict 'innodb' [ pass ] 2780 galera.galera_ddl_multiline 'innodb' [ pass ] 2462 galera.galera_delete_limit 'innodb' [ pass ] 2072 galera.galera_desync_overlapped 'innodb' [ skipped ] debug_sync is not available galera.galera_disallow_local_gtid 'innodb' [ pass ] 2095 galera.galera_drop_database 'innodb' [ pass ] 7943 galera.galera_drop_multi 'innodb' [ pass ] 2104 galera.galera_enum 'innodb' [ pass ] 2093 galera.galera_events 'innodb' [ pass ] 3039 galera.galera_events2 'innodb' [ pass ] 16402 galera.galera_fk_cascade_delete 'innodb' [ pass ] 3816 galera.galera_fk_cascade_update 'innodb' [ pass ] 2113 galera.galera_fk_conflict 'innodb' [ pass ] 2053 galera.galera_fk_lock_wait 'innodb' [ pass ] 4056 galera.galera_fk_mismatch 'innodb' [ pass ] 2056 galera.galera_fk_multibyte 'innodb' [ pass ] 2062 galera.galera_fk_multicolumn 'innodb' [ pass ] 2136 galera.galera_fk_multitable 'innodb' [ pass ] 2056 galera.galera_fk_no_pk 'innodb' [ pass ] 2109 galera.galera_fk_selfreferential 'innodb' [ pass ] 2059 galera.galera_fk_setnull 'innodb' [ pass ] 2049 galera.galera_fk_truncate 'innodb' [ pass ] 2081 galera.galera_flush_local 'innodb' [ pass ] 2440 galera.galera_ftwrl 'innodb' [ pass ] 4049 galera.galera_ftwrl_drain 'innodb' [ skipped ] debug_sync is not available galera.galera_fulltext 'innodb' [ pass ] 2668 galera.galera_gra_log 'innodb' [ pass ] 9511 galera.galera_insert_bulk 'innodb' [ pass ] 2194 galera.galera_insert_delayed 'innodb' [ pass ] 2017 galera.galera_insert_ignore 'innodb' [ pass ] 2102 galera.galera_insert_multi 'innodb' [ pass ] 2099 galera.galera_kill_ddl 'innodb' [ pass ] 19194 galera.galera_kill_nochanges 'innodb' [ pass ] 19486 galera.galera_kill_smallchanges 'innodb' [ pass ] 19516 galera.galera_lock_table 'innodb' [ pass ] 4061 galera.galera_lock_tables_in_transaction 'innodb' [ pass ] 2034 galera.galera_many_indexes 'innodb' [ pass ] 2604 galera.galera_mdev_10812 'innodb' [ pass ] 6049 galera.galera_mdl_race 'innodb' [ skipped ] debug_sync is not available galera.galera_multi_database 'innodb' [ pass ] 2213 galera.galera_multirow_rollback 'binlogoff,innodb' [ pass ] 2210 galera.galera_myisam_autocommit 'innodb' [ pass ] 2051 galera.galera_myisam_transactions 'innodb' [ pass ] 2178 galera.galera_nbo_alter 'innodb' [ pass ] 2032 galera.galera_nbo_alter_engine 'innodb' [ pass ] 2332 galera.galera_nbo_alter_error_duplicate 'innodb' [ pass ] 2171 galera.galera_nbo_alter_multi 'innodb' [ pass ] 2116 galera.galera_nbo_alter_rename 'innodb' [ pass ] 2069 galera.galera_nbo_create_index 'innodb' [ pass ] 2073 galera.galera_nbo_ddl_error 'innodb' [ pass ] 2085 galera.galera_nbo_error_on_all 'innodb' [ pass ] 2060 galera.galera_nbo_processlist 'innodb' [ skipped ] debug_sync is not available galera.galera_nonPK_and_PA 'innodb' [ skipped ] debug_sync is not available galera.galera_nopk_bit 'innodb' [ pass ] 2131 galera.galera_nopk_blob 'innodb' [ pass ] 2169 galera.galera_nopk_large_varchar 'innodb' [ pass ] 2084 galera.galera_nopk_unicode 'innodb' [ pass ] 2054 galera.galera_parallel_apply_lock_table 'innodb' [ pass ] 4060 galera.galera_password 'innodb' [ pass ] 2033 galera.galera_performance_schema 'innodb' [ pass ] 2074 galera.galera_pk_bigint_signed 'innodb' [ pass ] 2035 galera.galera_pk_bigint_unsigned 'innodb' [ pass ] 2037 galera.galera_prepared_statement 'innodb' [ pass ] 2148 galera.galera_provider_services 'innodb' [ pass ] 2019 galera.galera_read_only 'innodb' [ pass ] 2125 galera.galera_repair_view 'innodb' [ pass ] 2053 galera.galera_repl_key_format_flat16 'innodb' [ pass ] 2095 galera.galera_repl_max_ws_size 'innodb' [ pass ] 2035 galera.galera_restart_nochanges 'innodb' [ pass ] 8596 galera.galera_restart_on_unknown_option 'innodb' [ pass ] 76688 galera.galera_roles 'innodb' [ pass ] 5152 galera.galera_rsu_error 'innodb' [ pass ] 2043 galera.galera_rsu_simple 'innodb' [ pass ] 2042 galera.galera_rsu_wsrep_desync 'innodb' [ skipped ] debug_sync is not available galera.galera_savepoint_replay 'innodb' [ skipped ] debug_sync is not available galera.galera_sbr 'innodb' [ pass ] 2034 galera.galera_schema 'innodb' [ pass ] 2075 galera.galera_schema_dirty_reads 'innodb' [ pass ] 2018 galera.galera_serializable 'innodb' [ pass ] 6046 galera.galera_server 'innodb' [ pass ] 2033 galera.galera_set_position_after_cert_failure 'innodb' [ skipped ] debug_sync is not available galera.galera_shutdown_nonprim 'innodb' [ pass ] 17749 galera.galera_sp_insert_parallel 'innodb' [ pass ] 3224 galera.galera_split_brain 'innodb' [ pass ] 18934 galera.galera_sql_log_bin_zero 'innodb' [ pass ] 2036 galera.galera_status_cluster 'innodb' [ pass ] 2020 galera.galera_status_local_index 'innodb' [ pass ] 2037 galera.galera_status_local_state 'innodb' [ pass ] 2021 galera.galera_strict_require_innodb 'innodb' [ pass ] 2118 galera.galera_strict_require_primary_key 'innodb' [ pass ] 2200 galera.galera_suspend_slave 'innodb' [ pass ] 25402 galera.galera_toi_alter_auto_increment 'innodb' [ pass ] 4103 galera.galera_toi_ddl_nonconflicting 'innodb' [ pass ] 2048 galera.galera_toi_ddl_sequential 'innodb' [ pass ] 2048 galera.galera_toi_drop_database 'innodb' [ pass ] 9370 galera.galera_toi_ftwrl 'innodb' [ pass ] 2045 galera.galera_toi_lock_exclusive 'innodb' [ pass ] 3050 galera.galera_toi_lock_shared 'innodb' [ pass ] 2045 galera.galera_transaction_read_only 'innodb' [ pass ] 2035 galera.galera_transaction_replay 'innodb' [ skipped ] debug_sync is not available galera.galera_trigger 'innodb' [ pass ] 2140 galera.galera_truncate 'innodb' [ pass ] 2306 galera.galera_unicode_identifiers 'innodb' [ pass ] 2148 galera.galera_var_OSU_method 'innodb' [ skipped ] debug_sync is not available galera.galera_var_OSU_method2 'innodb' [ skipped ] debug_sync is not available galera.galera_var_auto_inc_control_off 'innodb' [ pass ] 4158 galera.galera_var_certify_nonPK_off 'innodb' [ pass ] 2051 galera.galera_var_cluster_address 'innodb' [ pass ] 6233 galera.galera_var_cluster_conf_id 'innodb' [ pass ] 2017 galera.galera_var_desync_on 'innodb' [ pass ] 3314 galera.galera_var_dirty_reads 'innodb' [ pass ] 4201 galera.galera_var_fkchecks 'innodb' [ pass ] 2069 galera.galera_var_max_ws_rows 'innodb' [ pass ] 2582 galera.galera_var_max_ws_size 'innodb' [ pass ] 2035 galera.galera_var_mysql_replication_bundle 'innodb' [ pass ] 2036 galera.galera_var_reject_queries 'innodb' [ skipped ] disabled until new C/C galera.galera_var_replicate_aria_off 'innodb' [ pass ] 2031 galera.galera_var_replicate_aria_on 'innodb' [ pass ] 2222 galera.galera_var_replicate_myisam_off 'innodb' [ pass ] 2030 galera.galera_var_replicate_myisam_on 'innodb' [ pass ] 2205 galera.galera_var_sync_wait 'innodb' [ pass ] 2055 galera.galera_var_trx_fragment_size 'innodb' [ pass ] 2027 galera.galera_var_wsrep_mode 'innodb' [ pass ] 2020 galera.galera_var_wsrep_on_off 'innodb' [ pass ] 2090 galera.galera_var_wsrep_provider_options 'innodb' [ pass ] 2018 galera.galera_var_wsrep_start_position 'innodb' [ pass ] 2022 galera.galera_view 'innodb' [ pass ] 2027 galera.galera_virtual_blob 'innodb' [ pass ] 2030 galera.galera_virtual_column 'innodb' [ pass ] 2058 galera.galera_wsrep_mode 'innodb' [ pass ] 2044 galera.galera_wsrep_new_cluster 'innodb' [ pass ] 12179 galera.galera_wsrep_provider_options_syntax 'innodb' [ pass ] 2027 galera.galera_zero_length_column 'innodb' [ pass ] 2057 galera.grant 'innodb' [ pass ] 2033 galera.lp1276424 'innodb' [ pass ] 2035 galera.lp1347768 'innodb' [ pass ] 2042 galera.lp1376747 'innodb' [ pass ] 4058 galera.lp1376747-2 'innodb' [ pass ] 2048 galera.lp1376747-3 'innodb' [ pass ] 2054 galera.lp1438990 'innodb' [ pass ] 2067 galera.lp959512 'innodb' [ pass ] 2062 galera.mdev-26175 'innodb' [ pass ] 2051 galera.mdev_21025 'innodb' [ pass ] 2035 galera.mdev_9290 'innodb' [ pass ] 2038 galera.mysql-wsrep#110 'innodb' [ pass ] 2079 galera.mysql-wsrep#237 'innodb' [ skipped ] debug_sync is not available galera.mysql-wsrep#247 'innodb' [ pass ] 3038 galera.mysql-wsrep#31 'innodb' [ pass ] 7991 galera.mysql-wsrep#332 'innodb' [ skipped ] debug_sync is not available galera.mysql-wsrep#90 'innodb' [ skipped ] debug_sync is not available galera.mysql-wsrep-features#127 'innodb' [ pass ] 2040 galera.rename 'innodb' [ pass ] 2064 galera.sql_log_bin 'innodb' [ pass ] 2059 galera.unique_key 'innodb' [ pass ] 2064 galera.view 'innodb' [ pass ] 2070 galera.wsrep_mode_strict_replication 'innodb' [ pass ] 2070 galera.wsrep_slave_threads_basic 'innodb' [ pass ] 2020 galera.wsrep_trx_fragment_size_sr 'innodb' [ pass ] 2019 galera.GCF-360 'innodb' [ pass ] 4513 galera.MDEV-10715 'innodb' [ pass ] 2049 galera.MDEV-15443 'innodb' [ pass ] 8372 galera.MDEV-18832 'innodb' [ pass ] 2073 galera.MDEV-22708 'innodb' [ pass ] 3037 galera.MDEV-24327 'innodb' [ skipped ] debug_sync is not available galera.MDEV-28053 'innodb' [ pass ] 2183 galera.MDEV-29512 'innodb' [ skipped ] debug_sync is not available galera.MDEV-30804 'innodb' [ pass ] 2045 galera.MDEV-6860 'innodb' [ pass ] 2815 galera.MW-284 'innodb' [ pass ] 15656 galera.MW-313 'innodb' [ pass ] 2054 galera.MW-329 'innodb' [ pass ] 2381 galera.MW-336 'innodb' [ pass ] 2094 galera.enforce_storage_engine2 'innodb' [ pass ] 2050 galera.galera#414 'innodb' [ pass ] 7373 galera.galera-features#117 'innodb' [ pass ] 7619 galera.galera_MDEV-29512 'innodb' [ skipped ] debug_sync is not available galera.galera_applier_ftwrl_table_alter 'innodb' [ pass ] 2064 galera.galera_as_master 'innodb' [ pass ] 2091 galera.galera_as_master_large 'innodb' [ pass ] 2071 galera.galera_as_slave 'innodb' [ pass ] 2259 galera.galera_as_slave_autoinc 'innodb' [ pass ] 2154 galera.galera_as_slave_gtid 'innodb' [ pass ] 3904 galera.galera_as_slave_gtid_auto_engine 'innodb' [ pass ] 3901 galera.galera_as_slave_gtid_myisam 'innodb' [ pass ] 3906 galera.galera_as_slave_nonprim 'innodb' [ pass ] 23245 galera.galera_autoinc_sst_mariabackup 'innodb' [ pass ] 22091 galera.galera_bad_wsrep_new_cluster 'innodb' [ pass ] 12774 galera.galera_bf_abort_ps 'innodb' [ pass ] 2058 galera.galera_bf_abort_ps_bind 'innodb' [ pass ] 2068 galera.galera_bf_abort_ps_threadpool 'innodb' [ skipped ] debug_sync is not available galera.galera_bf_background_statistics 'innodb' [ pass ] 2212 galera.galera_bf_kill 'innodb' [ pass ] 2118 galera.galera_bf_lock_wait 'innodb' [ pass ] 102175 galera.galera_binlog_event_max_size_max 'innodb' [ pass ] 2536 galera.galera_binlog_event_max_size_min 'innodb' [ pass ] 2052 galera.galera_binlog_stmt_autoinc 'innodb' [ pass ] 2115 galera.galera_defaults 'innodb' [ pass ] 2022 galera.galera_encrypt_tmp_files 'innodb' [ pass ] 2084 galera.galera_encryption 'innodb' [ pass ] 2088 galera.galera_encryption_restart 'innodb' [ pass ] 7636 galera.galera_encryption_restart2 'innodb' [ pass ] 12920 galera.galera_encryption_restart3 'innodb' [ pass ] 12822 galera.galera_encryption_restart4 'innodb' [ pass ] 12842 galera.galera_event_node_evict 'innodb' [ pass ] 29954 galera.galera_gcache_recover 'innodb' [ pass ] 16649 galera.galera_gcache_recover_full_gcache 'innodb' [ pass ] 22728 galera.galera_gcache_recover_manytrx 'innodb' [ pass ] 39920 galera.galera_gcs_fragment 'innodb' [ skipped ] Test requires Galera debug library with debug_sync functionality galera.galera_gcs_max_packet_size 'innodb' [ pass ] 2149 galera.galera_gtid 'innodb' [ pass ] 2050 galera.galera_gtid_server_id 'innodb' [ pass ] 2052 galera.galera_gtid_slave 'innodb' [ pass ] 3884 galera.galera_gtid_slave_sst_rsync 'innodb' [ pass ] 14432 galera.galera_gtid_trx_conflict 'innodb' [ pass ] 2057 galera.galera_ist_MDEV-28423 'innodb,release' [ pass ] 24352 galera.galera_ist_MDEV-28583 'innodb,release' [ pass ] 27344 galera.galera_ist_mariabackup 'innodb,release' [ pass ] 25311 galera.galera_ist_mariabackup_innodb_flush_logs 'innodb,release' [ pass ] 10895 galera.galera_ist_mysqldump 'innodb,release' [ pass ] 76334 galera.galera_ist_progress 'innodb' [ pass ] 15200 galera.galera_ist_recv_bind 'innodb' [ pass ] 12374 galera.galera_ist_restart_joiner 'innodb' [ skipped ] debug_sync is not available galera.galera_ist_rsync 'innodb,release' [ pass ] 28499 galera.galera_kill_applier 'innodb' [ pass ] 2057 galera.galera_kill_group_commit 'innodb' [ skipped ] debug_sync is not available galera.galera_last_committed_id 'binlogon,innodb' [ pass ] 2055 galera.galera_last_committed_id 'binlogoff,innodb' [ pass ] 2057 galera.galera_load_data 'innodb' [ pass ] 22105 galera.galera_log_bin 'innodb' [ pass ] 2114 galera.galera_log_bin_ext 'innodb' [ pass ] 9282 galera.galera_log_bin_ext_mariabackup 'innodb' [ pass ] 19194 galera.galera_log_bin_opt 'innodb' [ pass ] 2117 galera.galera_many_rows 'innodb' [ pass ] 2614 galera.galera_mdev_13787 'innodb' [ pass ] 2043 galera.galera_mdev_15611 'innodb' [ pass ] 2209 galera.galera_nbo_local_mdl 'innodb' [ pass ] 2089 galera.galera_partition 'innodb' [ pass ] 2637 galera.galera_pc_ignore_sb 'innodb' [ pass ] 14568 galera.galera_query_cache 'innodb' [ pass ] 2072 galera.galera_query_cache_invalidate 'innodb' [ pass ] 3009 galera.galera_sbr_binlog 'innodb' [ pass ] 2047 galera.galera_sequences 'innodb' [ pass ] 2124 galera.galera_sp_bf_abort 'innodb' [ skipped ] Test requires Galera debug library with debug_sync functionality galera.galera_ssl 'innodb' [ pass ] 2048 galera.galera_ssl_compression 'innodb' [ pass ] 2051 galera.galera_ssl_mode_server 'innodb' [ pass ] 2012 galera.galera_sst_mariabackup 'innodb,release' [ pass ] 32586 galera.galera_sst_mariabackup_data_dir 'innodb,release' [ pass ] 32650 galera.galera_sst_mariabackup_encrypt_with_key-openssl 'innodb' [ pass ] 2017 galera.galera_sst_mariabackup_encrypt_with_key 'innodb' [ pass ] 2068 galera.galera_sst_mariabackup_encrypt_with_key_server 'innodb' [ pass ] 2069 galera.galera_sst_mariabackup_force_recovery 'innodb,release' [ pass ] 32696 galera.galera_sst_mariabackup_logarchive 'innodb,release' [ pass ] 33581 galera.galera_sst_mariabackup_lost_found 'innodb' [ pass ] 18847 galera.galera_sst_mariabackup_table_options '16k,clear,innodb' [ pass ] 18937 galera.galera_sst_mariabackup_table_options '16k,crypt,innodb' [ pass ] 19089 galera.galera_sst_mariabackup_table_options '4k,clear,innodb' [ pass ] 18832 galera.galera_sst_mariabackup_table_options '4k,crypt,innodb' [ pass ] 19032 galera.galera_sst_mariabackup_table_options '8k,clear,innodb' [ pass ] 18937 galera.galera_sst_mariabackup_table_options '8k,crypt,innodb' [ pass ] 18832 galera.galera_sst_mysqldump 'innodb,release' [ pass ] 114779 galera.galera_sst_mysqldump_with_key 'innodb,release' [ pass ] 14697 galera.galera_sst_rsync 'innodb,release' [ pass ] 26161 galera.galera_sst_rsync2 'innodb,release' [ pass ] 26050 galera.galera_sst_rsync_binlogname 'innodb' [ pass ] 8306 galera.galera_sst_rsync_data_dir 'innodb,release' [ pass ] 25368 galera.galera_sst_rsync_logbasename 'innodb' [ pass ] 8191 galera.galera_sst_rsync_recv_auto 'innodb,release' [ pass ] 25852 galera.galera_sync_wait_upto 'binlogon,innodb' [ skipped ] debug_sync is not available line 2023-08-08 3:50:05 0 [Warning] WSREP: Ignoring server id for non bootstrap node. ^ Found warnings in /var/tmp/mtr/log/mysqld.2.err ok galera.galera_sync_wait_upto 'binlogoff,innodb' [ skipped ] debug_sync is not available line 2023-08-08 3:50:33 0 [Warning] WSREP: Ignoring server id for non bootstrap node. ^ Found warnings in /var/tmp/mtr/log/mysqld.2.err ok galera.galera_unicode_pk 'innodb' [ pass ] 2051 galera.galera_update_limit 'innodb' [ pass ] 2075 galera.galera_v1_row_events 'innodb' [ pass ] 2053 galera.galera_var_auto_inc_control_on 'innodb' [ pass ] 2052 galera.galera_var_gtid_domain_id 'innodb' [ pass ] 2069 galera.galera_var_log_bin 'innodb' [ pass ] 2054 galera.galera_var_notify_ssl_ipv6 'innodb' [ pass ] 2033 galera.galera_var_slave_threads 'innodb' [ pass ] 2160 galera.galera_var_sst_auth 'innodb' [ pass ] 8142 galera.galera_var_wsrep_certificate_expiration_hours_warning 'innodb' [ pass ] 7290 galera.galera_vote_rejoin_ddl 'innodb' [ fail ] Found warnings/errors in server log file! Test ended at 2023-08-08 03:56:33 line 2023-08-08 3:55:51 2 [Warning] WSREP: server: mdbci-xpsburev-1691453554-build unallowed state transition: donor -> synced 2023-08-08 3:55:55 0 [ERROR] WSREP: sst sent called when not SST donor, state SYNCED 2023-08-08 3:55:55 0 [Warning] WSREP: wsrep::sst_sent() returned an error: Not connected to Primary Component ^ Found warnings in /var/tmp/mtr/log/mysqld.1.err ok - skipping '/var/tmp/mtr/log/galera.galera_vote_rejoin_ddl-innodb/' galera.galera_vote_rejoin_dml 'innodb' [ pass ] 28815 galera.galera_wan 'innodb' [ fail ] Found warnings/errors in server log file! Test ended at 2023-08-08 03:57:58 line 2023-08-08 3:57:45 2 [Warning] WSREP: server: mdbci-xpsburev-1691453554-build unallowed state transition: donor -> synced 2023-08-08 3:57:49 0 [ERROR] WSREP: sst sent called when not SST donor, state SYNCED 2023-08-08 3:57:49 0 [Warning] WSREP: wsrep::sst_sent() returned an error: Not connected to Primary Component ^ Found warnings in /var/tmp/mtr/log/mysqld.1.err ok - skipping '/var/tmp/mtr/log/galera.galera_wan-innodb/' galera.galera_wan_restart_ist 'innodb' [ pass ] 23809 galera.galera_wan_restart_sst 'innodb' [ fail ] Test ended at 2023-08-08 04:02:33 WSREP did not transition to state READY - skipping '/var/tmp/mtr/log/galera.galera_wan_restart_sst-innodb/' ***Warnings generated in error logs during shutdown after running tests: galera.galera_wan_restart_sst 2023-08-08 3:59:03 0 [ERROR] WSREP: IST didn't contain all write sets, expected last: 3 last received: -1 2023-08-08 3:59:03 2 [ERROR] WSREP: Receiving IST failed, node restart required: IST receiver reported failure: 71 (Protocol error) 2023-08-08 3:59:03 2 [ERROR] WSREP: ./gcs/src/gcs.cpp:s_join():960: Sending JOIN failed: -103 (Software caused connection abort). 2023-08-08 3:59:03 2 [Warning] WSREP: Failed to JOIN the cluster after SST gcs_join(1eb2cb40-358f-11ee-ad9c-b32babc71a32:3) failed: 103 (Software caused connection abort) 2023-08-08 3:59:03 2 [Warning] WSREP: Cert position -1 less than last committed 3 2023-08-08 3:59:03 2 [Warning] WSREP: Cert position -1 less than last committed 3 galera.galera_wsrep_log_conficts 'innodb' [ pass ] 2119 galera.mdev_10518 'innodb' [ pass ] 2052 galera.mysql-wsrep#198 'innodb' [ pass ] 2177 galera.mysql-wsrep#201 'innodb' [ pass ] 2622 galera.mysql-wsrep#33 'innodb,release' [ pass ] 61061 galera.rpl_row_annotate 'innodb' [ pass ] 2052 galera_3nodes.galera-features#79 'innodb' [ skipped ] debug_sync is not available galera_3nodes.galera_garbd 'innodb' [ skipped ] Needs garbd galera_3nodes.galera-features#119 'innodb' [ pass ] 25286 galera_3nodes.galera_certification_ccc 'innodb' [ pass ] 16068 galera_3nodes.galera_certification_double_failure 'innodb' [ pass ] 3056 galera_3nodes.galera_evs_suspect_timeout 'innodb' [ pass ] 22836 galera_3nodes.galera_join_with_cc_A 'innodb' [ skipped ] Test requires Galera debug library with debug_sync functionality galera_3nodes.galera_join_with_cc_B 'innodb' [ skipped ] Test requires Galera debug library with debug_sync functionality galera_3nodes.galera_join_with_cc_C 'innodb' [ skipped ] Test requires Galera debug library with debug_sync functionality galera_3nodes.galera_nbo_kill_master 'innodb' [ skipped ] debug_sync is not available galera_3nodes.galera_var_dirty_reads2 'innodb' [ pass ] 19427 galera_3nodes.galera_wsrep_schema 'innodb' [ pass ] 8357 galera_3nodes.GAL-501 'innodb' [ pass ] 14698 galera_3nodes.GCF-354 'innodb' [ pass ] 12593 galera_3nodes.GCF-361 'innodb' [ pass ] 11344 galera_3nodes.GCF-363 'innodb' [ pass ] 11435 galera_3nodes.GCF-376 'innodb' [ pass ] 28931 galera_3nodes.MDEV-29171 'innodb' [ pass ] 33667 galera_3nodes.galera-features#115 'innodb' [ pass ] 15646 galera_3nodes.galera_allowlist 'innodb' [ pass ] 20013 galera_3nodes.galera_dynamic_protocol 'innodb' [ pass ] 8428 galera_3nodes.galera_ipv6_mysqldump 'innodb' [ pass ] 17612 galera_3nodes.galera_ipv6_rsync 'innodb' [ pass ] 13683 galera_3nodes.galera_ipv6_rsync_section 'innodb' [ pass ] 13693 galera_3nodes.galera_ist_gcache_rollover 'innodb' [ skipped ] debug_sync is not available galera_3nodes.galera_nbo_master_majority_failure 'innodb' [ pass ] 14457 galera_3nodes.galera_nbo_master_majority_success 'innodb' [ pass ] 16369 galera_3nodes.galera_nbo_master_minority_failure 'innodb' [ pass ] 14349 galera_3nodes.galera_pc_bootstrap 'innodb' [ pass ] 35570 galera_3nodes.galera_pc_weight 'innodb' [ pass ] 17633 galera_3nodes.galera_safe_to_bootstrap 'innodb' [ pass ] 44870 galera_3nodes.galera_sst_donor_non_prim 'innodb' [ skipped ] debug_sync is not available galera_3nodes.galera_toi_vote 'innodb' [ pass ] 10409 galera_3nodes.galera_wsrep_schema_init 'innodb' [ pass ] 2031 galera_3nodes_sr.galera_vote_sr 'innodb' [ pass ] 27010 galera_3nodes_sr.GCF-336 'innodb' [ pass ] 18670 galera_3nodes_sr.GCF-582 'innodb' [ pass ] 8381 galera_3nodes_sr.GCF-606 'innodb' [ pass ] 18234 galera_3nodes_sr.GCF-609 'innodb' [ pass ] 2074 galera_3nodes_sr.GCF-817 'innodb' [ pass ] 20465 galera_3nodes_sr.GCF-832 'innodb' [ skipped ] debug_sync is not available galera_3nodes_sr.MDEV-26707 'innodb' [ skipped ] debug_sync is not available galera_3nodes_sr.galera_sr_isolate_master 'innodb' [ pass ] 17494 galera_3nodes_sr.galera_sr_join_slave 'innodb' [ pass ] 9703 galera_3nodes_sr.galera_sr_kill_master 'innodb' [ pass ] 18077 galera_3nodes_sr.galera_sr_kill_slave_after_apply 'innodb' [ pass ] 18889 galera_3nodes_sr.galera_sr_kill_slave_after_apply_rollback 'innodb' [ pass ] 20008 galera_3nodes_sr.galera_sr_kill_slave_before_apply 'innodb' [ pass ] 37710 galera_3nodes_sr.galera_sr_threeway_split_no_primary 'innodb' [ pass ] 15249 galera_3nodes_sr.galera_sr_threeway_split 'innodb' [ pass ] 19609 galera_sr.galera_sr_large_fragment 'innodb' [ pass ] 22113 galera_sr.mysql-wsrep-features#32 'innodb' [ pass ] 3062 galera_sr.galera_sr_gtid 'innodb' [ pass ] 2061 galera_sr.galera_sr_log_bin 'innodb' [ pass ] 2950 galera_sr.mysql-wsrep-features#136 'innodb' [ pass ] 2039 galera_sr.galera_sr_v1_row_events 'innodb' [ pass ] 2063 galera_sr.galera_sr_multirow_rollback 'binlogon,innodb' [ pass ] 2232 galera_sr.galera_xa_rollback 'binlogon,innodb' [ pass ] 2095 galera_sr.galera_xa_simple 'binlogon,innodb' [ pass ] 2169 galera_sr.MDEV-30862 'innodb' [ pass ] 2046 galera_sr.galera_xa_multi_se 'innodb' [ pass ] 2089 galera_sr.GCF-1018B 'innodb' [ pass ] 3353 galera_sr.galera_sr_kill_all_nobootstrap 'innodb' [ pass ] 12227 galera_sr.galera_sr_kill_all_pcrecovery 'innodb' [ pass ] 16353 galera_sr.galera_sr_load_data_splitting 'innodb' [ pass ] 2691 galera_sr.galera_sr_many_fragments 'innodb' [ pass ] 11616 galera_sr.mysql-wsrep-features#8 'innodb' [ pass ] 12533 galera_sr.mysql-wsrep-features#9 'innodb' [ pass ] 20632 galera_sr.GCF-1008 'innodb' [ skipped ] debug_sync is not available galera_sr.GCF-1018 'innodb' [ skipped ] debug_sync is not available galera_sr.GCF-1051 'innodb' [ skipped ] debug_sync is not available galera_sr.GCF-561 'innodb' [ pass ] 2064 galera_sr.GCF-571 'innodb' [ pass ] 2185 galera_sr.GCF-572 'innodb' [ pass ] 2222 galera_sr.GCF-580 'innodb' [ pass ] 2037 galera_sr.GCF-585 'innodb' [ pass ] 4313 galera_sr.GCF-597 'innodb' [ pass ] 2055 galera_sr.GCF-620 'innodb' [ pass ] 2040 galera_sr.GCF-623 'innodb' [ pass ] 2050 galera_sr.GCF-627 'innodb' [ pass ] 2055 galera_sr.GCF-845 'innodb' [ pass ] 4129 galera_sr.GCF-851 'innodb' [ pass ] 2040 galera_sr.GCF-867 'innodb' [ pass ] 2517 galera_sr.GCF-889 'innodb' [ pass ] 2041 galera_sr.GCF-900 'innodb' [ pass ] 2056 galera_sr.MDEV-22616 'innodb' [ pass ] 2035 galera_sr.MDEV-23623 'innodb' [ skipped ] debug_sync is not available galera_sr.MDEV-25226 'innodb' [ pass ] 2039 galera_sr.MDEV-25717 'innodb' [ skipped ] debug_sync is not available galera_sr.MDEV-27615 'innodb' [ skipped ] debug_sync is not available galera_sr.MDEV-30838 'innodb' [ skipped ] debug_sync is not available galera_sr.MENT-1151 'innodb' [ fail ] Found warnings/errors in server log file! Test ended at 2023-08-08 04:33:55 line 2023-08-08 4:33:44 2 [Warning] WSREP: CREATE SEQUENCES declared without `NOCACHE` will not behave correctly in galera cluster. ^ Found warnings in /var/tmp/mtr/log/mysqld.2.err ok line 2023-08-08 4:33:44 244 [Warning] WSREP: CREATE SEQUENCES declared without `NOCACHE` will not behave correctly in galera cluster. ^ Found warnings in /var/tmp/mtr/log/mysqld.1.err ok - skipping '/var/tmp/mtr/log/galera_sr.MENT-1151-innodb/' galera_sr.MENT-1278 'innodb' [ fail ] Test ended at 2023-08-08 04:34:12 CURRENT_TEST: galera_sr.MENT-1278 mysqltest: At line 17: query 'CALL sys.statement_performance_analyzer ('overALL', NULL, 'with_full_table_scans')' failed with wrong errno ER_UNKNOWN_ERROR (1105): 'Maximum writeset size exceeded', instead of ER_LOCK_DEADLOCK (1213)... The result from queries just before the failure was: connection node_2; connection node_1; XA START 'a'; SET GLOBAL wsrep_provider_options='repl.max_ws_size=512'; SET max_session_mem_used=50000; XA END 'a'; XA PREPARE 'a'; ERROR XA102: XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detected CALL sys.statement_performance_analyzer ('overALL', NULL, 'with_full_table_scans'); - skipping '/var/tmp/mtr/log/galera_sr.MENT-1278-innodb/' galera_sr.MENT-1418 'innodb' [ pass ] 2060 galera_sr.MENT-1733 'innodb' [ pass ] 2018 galera_sr.MENT-1737 'innodb' [ pass ] 3064 galera_sr.galera-features#56 'innodb' [ pass ] 3270 galera_sr.galera_sr_bf_abort 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_sr_blob 'innodb' [ pass ] 2039 galera_sr.galera_sr_cc_no_primary 'innodb' [ pass ] 14537 galera_sr.galera_sr_cc_slave 'innodb' [ pass ] 4206 galera_sr.galera_sr_concurrent 'innodb' [ pass ] 2088 galera_sr.galera_sr_conflict 'innodb' [ pass ] 2050 galera_sr.galera_sr_conflict_on_commit 'innodb' [ pass ] 2049 galera_sr.galera_sr_conflict_on_commit2 'innodb' [ pass ] 3097 galera_sr.galera_sr_conflict_with_rollback_master 'innodb' [ pass ] 2043 galera_sr.galera_sr_create_drop 'innodb' [ pass ] 2094 galera_sr.galera_sr_ddl_master 'innodb' [ pass ] 2080 galera_sr.galera_sr_ddl_schema 'innodb' [ pass ] 2064 galera_sr.galera_sr_ddl_slave 'innodb' [ pass ] 2059 galera_sr.galera_sr_ddl_unrelated 'innodb' [ pass ] 2283 galera_sr.galera_sr_dupkey_error 'innodb' [ pass ] 2096 galera_sr.galera_sr_fk_conflict 'innodb' [ pass ] 4529 galera_sr.galera_sr_insert_select 'innodb' [ pass ] 11422 galera_sr.galera_sr_kill_connection 'innodb' [ pass ] 2098 galera_sr.galera_sr_kill_query 'innodb' [ pass ] 2441 galera_sr.galera_sr_load_data 'innodb' [ pass ] 2221 galera_sr.galera_sr_multirow_rollback 'binlogoff,innodb' [ pass ] 2353 galera_sr.galera_sr_myisam 'innodb' [ pass ] 2032 galera_sr.galera_sr_nonPK_and_PA 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_sr_parallel_apply 'innodb' [ pass ] 2053 galera_sr.galera_sr_rollback 'innodb' [ pass ] 2061 galera_sr.galera_sr_rollback_retry 'innodb' [ pass ] 2040 galera_sr.galera_sr_rollback_savepoint 'innodb' [ pass ] 2052 galera_sr.galera_sr_rollback_statement 'innodb' [ pass ] 2052 galera_sr.galera_sr_shutdown_master 'innodb' [ pass ] 9112 galera_sr.galera_sr_shutdown_slave 'innodb' [ pass ] 9249 galera_sr.galera_sr_slow 'innodb' [ pass ] 12018 galera_sr.galera_sr_transaction_replay 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_sr_unit_statements 'innodb' [ pass ] 2076 galera_sr.galera_sr_ws_size 'innodb' [ pass ] 2408 galera_sr.galera_sr_ws_size2 'innodb' [ pass ] 4065 galera_sr.galera_var_ignore_apply_errors_sr 'innodb' [ pass ] 2042 galera_sr.galera_xa_bf_abort 'innodb' [ pass ] 2143 galera_sr.galera_xa_bf_abort_after_prepare 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_xa_bf_abort_after_replay 'innodb' [ pass ] 2045 galera_sr.galera_xa_bf_abort_before_prepare 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_xa_bf_abort_certifying_prepare 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_xa_bf_abort_one_phase 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_xa_client_disconnect 'innodb' [ fail ] Test ended at 2023-08-08 04:37:10 CURRENT_TEST: galera_sr.galera_xa_client_disconnect --- /usr/share/mariadb/mariadb-test/suite/galera_sr/r/galera_xa_client_disconnect.result 2023-07-26 20:42:10.000000000 +0200 +++ /usr/share/mariadb/mariadb-test/suite/galera_sr/r/galera_xa_client_disconnect.reject 2023-08-08 04:37:00.841244205 +0200 @@ -252,7 +252,7 @@ SET GLOBAL wsrep_provider_options='repl.max_ws_size=0'; XA END 'a'; XA PREPARE 'a'; -ERROR HY000: Got error 0 "Internal error/check (Not system error)" during COMMIT +ERROR HY000: Error while appending streaming replication fragment disconnect trx1; connection node_1; XA RECOVER; mysqltest: Result length mismatch - skipping '/var/tmp/mtr/log/galera_sr.galera_xa_client_disconnect-innodb/' galera_sr.galera_xa_concurrent 'innodb' [ pass ] 2812 galera_sr.galera_xa_concurrent_prepare 'innodb' [ pass ] 4042 galera_sr.galera_xa_ddl_conflict 'innodb' [ pass ] 2232 galera_sr.galera_xa_ddl_conflict_committing 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_xa_deadlock 'innodb' [ pass ] 3095 galera_sr.galera_xa_kill_replay 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_xa_recover_master_kill 'innodb' [ pass ] 18972 galera_sr.galera_xa_recover_master_shutdown 'innodb' [ pass ] 7939 galera_sr.galera_xa_replay_before_commit 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_xa_replay_commit 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_xa_replay_idle 'innodb' [ pass ] 2046 galera_sr.galera_xa_restart_wsrep_off 'innodb' [ pass ] 8935 galera_sr.galera_xa_rollback 'binlogoff,innodb' [ pass ] 2075 galera_sr.galera_xa_server_disconnect 'innodb' [ fail ] Test ended at 2023-08-08 04:38:32 CURRENT_TEST: galera_sr.galera_xa_server_disconnect mysqltest: At line 67: query 'XA COMMIT 't1'' failed with wrong errno ER_UNKNOWN_COM_ERROR (1047): 'WSREP has not yet prepared node for application use', instead of ER_ERROR_DURING_COMMIT (1180)... The result from queries just before the failure was: < snip > connection t2; XA START 't2'; INSERT INTO t1 VALUES (2); XA END 't2'; XA PREPARE 't2'; connect t3, 127.0.0.1, root, , test, $NODE_MYPORT_2; connection t3; XA START 't3'; INSERT INTO t1 VALUES (3); XA END 't3'; XA PREPARE 't3'; connection node_1; SELECT COUNT(*) AS expect_3 FROM mysql.wsrep_streaming_log; expect_3 3 connection node_2; SET SESSION wsrep_sync_wait = 0; SET GLOBAL wsrep_provider_options = 'gmcast.isolate=1'; connection t1; XA COMMIT 't1'; More results from queries before failure can be found in /var/tmp/mtr/log/galera_xa_server_disconnect.log - skipping '/var/tmp/mtr/log/galera_sr.galera_xa_server_disconnect-innodb/' galera_sr.galera_xa_shutdown_wsrep_off 'innodb' [ pass ] 7301 galera_sr.galera_xa_simple 'binlogoff,innodb' [ pass ] 2185 galera_sr.galera_xa_streaming 'innodb' [ pass ] 2050 galera_sr.galera_xa_terminate 'innodb' [ pass ] 17501 galera_sr.galera_xa_terminate_rollback 'innodb' [ pass ] 17937 galera_sr.galera_xa_xid 'innodb' [ pass ] 2065 galera_sr.mysql-wsrep#215 'innodb' [ skipped ] debug_sync is not available galera_sr.mysql-wsrep-bugs-900 'innodb' [ pass ] 2042 galera_sr.mysql-wsrep-features#14 'innodb' [ pass ] 2042 galera_sr.mysql-wsrep-features#148 'innodb' [ skipped ] debug_sync is not available galera_sr.mysql-wsrep-features#15 'innodb' [ pass ] 2035 galera_sr.mysql-wsrep-features#165 'innodb' [ skipped ] debug_sync is not available galera_sr.mysql-wsrep-features#22 'innodb' [ pass ] 2052 galera_sr.mysql-wsrep-features#27 'innodb' [ pass ] 4057 galera_sr.mysql-wsrep-features#35 'innodb' [ skipped ] debug_sync is not available galera_sr.mysql-wsrep-features#93 'innodb' [ pass ] 2039 galera_sr.mysql-wsrep-features#96 'innodb' [ pass ] 2058 galera_sr.MDEV-18585 'innodb' [ pass ] 2052 galera_sr.MDEV-21613 'innodb' [ skipped ] debug_sync is not available galera_sr.galera_sr_kill_all_norecovery 'innodb' [ pass ] 17761 galera_sr.galera_sr_kill_slave 'innodb' [ pass ] 13696 galera_sr.galera_sr_mysqldump_sst 'innodb' [ pass ] 7064 galera_sr.galera_sr_small_gcache 'innodb' [ pass ] 9886 galera_sr.mdev_18631 'innodb' [ pass ] 2052 wsrep.pool_of_threads 'innodb' [ pass ] 1 wsrep.foreign_key 'innodb' [ pass ] 43 wsrep.plugin 'innodb' [ pass ] 2 wsrep.MENT-1159 'innodb' [ pass ] 1140 wsrep.trans 'innodb' [ pass ] 1 wsrep.wsrep_on_basic 'innodb' [ pass ] 3 wsrep.MDEV-20625 'innodb' [ pass ] 12 wsrep.MDEV-23081 'binlogon,innodb' [ skipped ] debug_sync is not available wsrep.MDEV-23081 'binlogoff,innodb' [ skipped ] debug_sync is not available wsrep.MDEV-23466 'innodb' [ pass ] 1 wsrep.alter_table_innodb 'innodb' [ pass ] 182 wsrep.binlog_format 'innodb' [ pass ] 30 wsrep.mdev_10186 'innodb' [ pass ] 1 wsrep.mdev_22681 'innodb' [ pass ] 30 wsrep.mdev_7798 'innodb' [ pass ] 1514 wsrep.variables 'innodb' [ pass ] 6 wsrep.wsrep-recover-v25 'binlogon,innodb' [ skipped ] debug_sync is not available wsrep.wsrep-recover-v25 'binlogoff,innodb' [ skipped ] debug_sync is not available wsrep.wsrep-recover 'binlogon,innodb' [ skipped ] debug_sync is not available wsrep.wsrep-recover 'binlogoff,innodb' [ skipped ] debug_sync is not available wsrep.wsrep_expired_cert_warning 'innodb' [ pass ] 68 wsrep.wsrep_provider_plugin 'innodb' [ pass ] 26 wsrep.wsrep_provider_plugin_basic 'innodb' [ pass ] 17 wsrep.wsrep_provider_plugin_defaults 'innodb' [ pass ] 6 wsrep.wsrep_provider_plugin_wsrep_off 'innodb' [ pass ] 1 wsrep.wsrep_rpl 'innodb,mix' [ pass ] 933 wsrep.wsrep_rpl 'innodb,row' [ pass ] 892 wsrep.wsrep_rpl 'innodb,stmt' [ pass ] 928 wsrep.wsrep_variables_wsrep_off 'innodb' [ pass ] 2 -------------------------------------------------------------------------- The servers were restarted 229 times Spent 3585.537 of 8841 seconds executing testcases mysql-test-run: WARNING: Got errors/warnings while running tests, please examine '/var/tmp/mtr/log/warnings' for details. Completed: Failed 8/528 tests, 98.48% were successful. Failing test(s): galera.mariadb_tzinfo_to_sql galera.galera_vote_rejoin_ddl galera.galera_wan galera.galera_wan_restart_sst galera_sr.MENT-1151 galera_sr.MENT-1278 galera_sr.galera_xa_client_disconnect galera_sr.galera_xa_server_disconnect 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_wan_restart_sst 137 tests were skipped, 76 by the test itself. mysql-test-run: *** ERROR: there were failing test cases install.db log my.cnf my.cnf.bak mysqld.1 run std_data tmp tar: Removing leading `/' from member names columnstore tar: Removing leading `/' from member names ls: cannot access '/usr/share/mysql/mysql-test/logs.tar.gz': No such file or directory /var/log/syslog tar: Removing leading `/' from member names /var/log/messages tar: Removing leading `/' from member names ls: cannot access '/tmp/core*': No such file or directory ls: cannot access '/filesystem_mount': No such file or directory