Checking supported features... MariaDB Version 10.4.9-MariaDB-debug - SSL connections supported - binaries are debug compiled - binaries built with wsrep patch Using suites: galera Collecting tests... Installing system database... worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- 191029 20:02:50 +17.374 galera.GCF-1081 [ disabled ] MDEV-18283 Galera test failure on galera.GCF-1081 191029 20:02:50 +0.000 galera.MW-329 [ disabled ] MDEV-19962 Galera test failure on MW-329 191029 20:02:50 +0.000 galera.MW-360 [ disabled ] needs rewrite to be MariaDB gtid compatible 191029 20:02:50 +0.000 galera.MW-388 [ disabled ] MDEV-19803 Long semaphore wait error on galera.MW-388 191029 20:02:50 +0.000 galera.galera_account_management [ disabled ] MariaDB 10.0 does not support ALTER USER 191029 20:02:50 +0.000 galera.galera_as_master_gtid [ disabled ] Requires MySQL GTID 191029 20:02:50 +0.000 galera.galera_as_master_gtid_change_master [ disabled ] Requires MySQL GTID 191029 20:02:50 +0.000 galera.galera_as_slave_gtid_replicate_do_db_cc [ disabled ] Requires MySQL GTID 191029 20:02:50 +0.000 galera.galera_as_slave_preordered [ disabled ] wsrep-preordered feature not merged to MariaDB 191029 20:02:50 +0.000 galera.galera_as_slave_replication_bundle [ disabled ] MDEV-15785 OPTION_GTID_BEGIN is set in Gtid_log_event::do_apply_event() 191029 20:02:50 +0.000 galera.galera_bf_abort_group_commit [ disabled ] MDEV-18282 Galera test failure on galera.galera_bf_abort_group_commit 191029 20:02:50 +0.000 galera.galera_binlog_rows_query_log_events [ disabled ] MariaDB does not support binlog_rows_query_log_events 191029 20:02:50 +0.000 galera.galera_binlog_stmt_autoinc [ disabled ] MDEV-19959 Galera test failure on galera_binlog_stmt_autoinc 191029 20:02:50 +0.000 galera.galera_concurrent_ctas [ disabled ] MDEV-18180 Galera test failure on galera.galera_concurrent_ctas 191029 20:02:50 +0.000 galera.galera_encrypt_tmp_files [ disabled ] Get error failed to enable encryption of temporary files 191029 20:02:50 +0.000 galera.galera_flush [ disabled ] MariaDB does not have global.thread_statistics 191029 20:02:50 +0.000 galera.galera_gcache_recover_manytrx [ disabled ] MDEV-18834 Galera test failure 191029 20:02:50 +0.000 galera.galera_ist_mariabackup [ disabled ] MDEV-18829 test leaves port open 191029 20:02:50 +0.000 galera.galera_ist_progress [ disabled ] MDEV-15236 fails when trying to read transfer status 191029 20:02:50 +0.000 galera.galera_kill_largechanges [ disabled ] MDEV-18179 Galera test failure on galera.galera_kill_largechanges 191029 20:02:50 +0.000 galera.galera_kill_nochanges [ disabled ] MDEV-18280 Galera test failure on galera_split_brain and galera_kill_nochanges 191029 20:02:50 +0.000 galera.galera_many_tables_nopk [ disabled ] MDEV-18182 Galera test failure on galera.galera_many_tables_nopk 191029 20:02:50 +0.000 galera.galera_migrate [ disabled ] MariaDB does not support START SLAVE USER 191029 20:02:50 +0.000 galera.galera_split_brain [ disabled ] MDEV-18280 Galera test failure on galera_split_brain and galera_kill_nochanges 191029 20:02:50 +0.000 galera.galera_ssl_upgrade [ disabled ] MDEV-19950 Galera test failure on galera_ssl_upgrade 191029 20:02:50 +0.000 galera.galera_var_node_address [ disabled ] MDEV-20485 Galera test failure 191029 20:02:50 +0.000 galera.galera_var_notify_cmd [ disabled ] MDEV-20600 Galera test galera_var_notify_cmd causes hang 191029 20:02:50 +0.000 galera.galera_var_reject_queries [ disabled ] assertion in inline_mysql_socket_send 191029 20:02:50 +0.000 galera.galera_var_retry_autocommit [ disabled ] MDEV-18181 Galera test failure on galera.galera_var_retry_autocommit 191029 20:02:50 +0.000 galera.galera_wan [ disabled ] MDEV-17259 Test failure on galera.galera_wan 191029 20:02:50 +0.000 galera.mysql-wsrep#198 [ disabled ] MDEV-18935 Galera test mysql-wsrep#198 sporaric assertion transaction.cpp:362: int wsrep::transaction::before_commit(): Assertion `state() == s_executing || state() == s_committing || state() == s_must_abort || state() == s_replaying' failed. 191029 20:02:50 +0.000 galera.partition [ disabled ] MDEV-19958 Galera test failure on galera.partition 191029 20:02:50 +0.000 galera.query_cache [ disabled ] MDEV-15805 Test failure on galera.query_cache 191029 20:03:05 +14.728 galera.galera_binlog_checksum 'innodb' [ pass ] 4577 191029 20:03:28 +22.927 galera.MW-313 'innodb' [ pass ] 4340 191029 20:03:32 +3.986 galera.MW-86-wait1 'innodb' [ pass ] 3490 191029 20:03:38 +6.512 galera.MW-86-wait8 'innodb' [ pass ] 6130 191029 20:03:59 +21.058 galera.galera_binlog_event_max_size_min 'innodb' [ pass ] 3152 191029 20:05:07 +67.497 galera.galera_binlog_event_max_size_max 'innodb' [ pass ] 49588 191029 20:05:30 +23.305 galera.enforce_storage_engine2 'innodb' [ pass ] 4586 191029 20:05:54 +24.098 galera.galera_log_output_csv 'innodb' [ pass ] 3650 191029 20:06:19 +24.584 galera.MW-44 'innodb' [ pass ] 6329 191029 20:06:43 +23.893 galera.galera_mdev_13787 'innodb' [ pass ] 4095 191029 20:07:12 +29.653 galera.galera_applier_ftwrl_table_alter 'innodb' [ pass ] 10719 191029 20:07:53 +40.369 galera.galera_bf_background_statistics 'innodb' [ pass ] 20507 191029 20:08:15 +22.258 galera.galera_gtid 'innodb' [ pass ] 3785 191029 20:08:40 +24.573 galera.galera_forced_binlog_format 'innodb' [ pass ] 6671 191029 20:09:01 +21.607 galera.galera_sbr_binlog 'innodb' [ pass ] 3792 191029 20:09:25 +24.167 galera.galera_log_bin 'innodb' [ pass ] 6419 191029 20:09:46 +20.875 galera.galera_v1_row_events 'innodb' [ pass ] 3248 191029 20:10:41 +55.136 galera.galera_var_innodb_disallow_writes 'innodb' [ fail ] Test ended at 2019-10-29 20:10:41 CURRENT_TEST: galera.galera_var_innodb_disallow_writes --- /home/stepan/mariadb/10.4/github/mysql-test/suite/galera/r/galera_var_innodb_disallow_writes.result 2019-10-17 14:30:27.382278020 +0300 +++ /home/stepan/mariadb/10.4/github/mysql-test/suite/galera/r/galera_var_innodb_disallow_writes.reject 2019-10-29 20:10:41.229513794 +0200 @@ -10,6 +10,18 @@ SELECT COUNT(*) = 1 FROM t1; COUNT(*) = 1 0 +Timeout in wait_condition.inc for SELECT 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE INFO = 'INSERT INTO t1 VALUES (1)' AND State = 'Commit' +Id User Host db Command Time State Info Progress +1 system user NULL Sleep 43 wsrep aborter idle NULL 0.000 +2 system user NULL Sleep 43 Closing tables NULL 0.000 +3 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000 +4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +6 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000 +18 root localhost test Sleep 35 NULL 0.000 +19 root localhost:48696 test Query 31 Update INSERT INTO t1 VALUES (1) 0.000 +20 root localhost:48698 test Query 0 Init show full processlist 0.000 SELECT COUNT(*) = 1 FROM t1; COUNT(*) = 1 0 mysqltest: Result length mismatch - saving '/home/stepan/mariadb/10.4/github/mysql-test/var/log/galera.galera_var_innodb_disallow_writes-innodb/' to '/home/stepan/mariadb/10.4/github/mysql-test/var/log/galera.galera_var_innodb_disallow_writes-innodb/' 191029 20:10:57 +15.265 galera.mdev_18730 'innodb' [ pass ] 6715 191029 20:11:50 +53.682 galera.galera_flush_local 'innodb' [ pass ] 34790 191029 20:12:17 +26.936 galera.galera_query_cache 'innodb' [ pass ] 6568 191029 20:12:26 +8.785 galera.galera_query_cache_sync_wait 'innodb' [ pass ] 8258 191029 20:14:08 +102.033 galera.mysql-wsrep#201 'innodb' [ pass ] 83503 191029 20:14:31 +23.066 galera.galera_var_auto_inc_control_on 'innodb' [ pass ] 4367 191029 20:14:55 +23.410 galera.galera_sync_wait_upto 'innodb' [ pass ] 5361 191029 20:15:19 +24.026 galera.galera_wsrep_new_cluster 'innodb' [ pass ] 4831 191029 20:15:34 +15.160 galera.galera_wsrep_log_conficts 'innodb' [ pass ] 3870 191029 20:15:54 +19.870 galera.galera_var_sst_auth 'innodb' [ pass ] 2041 191029 20:16:33 +39.303 galera.GAL-419 'innodb' [ pass ] 20411 191029 20:25:33 +540.623 galera.MW-328A 'innodb' [ pass ] 539866 191029 20:30:53 +319.504 galera.MW-328B 'innodb' [ pass ] 318249 191029 20:38:17 +444.424 galera.MW-328C 'innodb' [ pass ] 443269 191029 20:40:09 +111.330 galera.galera_bf_lock_wait 'innodb' [ pass ] 107883 191029 20:40:52 +43.364 galera.galera_fulltext 'innodb' [ pass ] 42506 191029 20:40:58 +6.097 galera.galera_many_columns 'innodb' [ pass ] 5295 191029 20:43:50 +172.156 galera.galera_many_tables_pk 'innodb' [ pass ] 169992 191029 20:44:29 +38.398 galera.galera_parallel_autoinc_largetrx 'innodb' [ pass ] 27986 191029 20:51:20 +411.244 galera.galera_parallel_autoinc_manytrx 'innodb' [ pass ] 392278 191029 20:51:44 +23.697 galera.galera_pc_recovery 'innodb' [ pass ] 15116 191029 20:54:17 +153.422 galera.galera_rsu_add_pk 'innodb' [ pass ] 135277 191029 20:58:41 +263.970 galera.galera_rsu_drop_pk 'innodb' [ pass ] 262971 191029 20:59:30 +48.594 galera.galera_toi_ddl_error 'innodb' [ pass ] 48034 191029 21:00:13 +42.953 galera.galera_toi_ddl_fk_insert 'innodb' [ pass ] 42437 191029 21:00:50 +37.786 galera.galera_toi_ddl_fk_update 'innodb' [ pass ] 37307 191029 21:01:22 +31.894 galera.galera_var_load_data_splitting 'innodb' [ pass ] 30381 191029 21:03:29 +126.354 galera.galera_wsrep_desync_wsrep_on 'innodb' [ pass ] 125517 191029 21:03:40 +10.924 galera.GAL-382 'innodb' [ pass ] 9734 191029 21:04:02 +22.469 galera.GAL-401 'innodb' [ pass ] 21979 191029 21:04:33 +30.453 galera.GAL-480 'innodb' [ pass ] 29766 191029 21:04:38 +5.578 galera.GCF-939 'innodb' [ pass ] 5072 191029 21:04:46 +7.415 galera.MDEV-16509 'innodb' [ pass ] 6784 191029 21:04:56 +10.300 galera.MDEV-20225 'innodb' [ pass ] 9550 191029 21:05:40 +44.566 galera.MW-252 'innodb' [ pass ] 43773 191029 21:05:54 +13.882 galera.MW-258 'innodb' [ pass ] 13258 191029 21:06:02 +7.641 galera.MW-259 'innodb' [ pass ] 7043 191029 21:06:14 +11.863 galera.MW-285 'innodb' [ pass ] 10597 191029 21:06:19 +5.476 galera.MW-286 'innodb' [ pass ] 4820 191029 21:06:29 +10.032 galera.MW-292 'innodb' [ pass ] 9567 191029 21:06:34 +4.484 galera.MW-309 'innodb' [ pass ] 4074 191029 21:06:41 +6.802 galera.MW-328D 'innodb' [ pass ] 6247 191029 21:06:47 +6.837 galera.MW-328E 'innodb' [ pass ] 6412 191029 21:06:51 +3.694 galera.MW-357 'innodb' [ pass ] 3142 191029 21:07:23 +31.926 galera.MW-369 'innodb' [ pass ] 31277 191029 21:07:52 +29.044 galera.MW-402 'innodb' [ pass ] 28346 191029 21:07:56 +3.741 galera.MW-416 'innodb' [ pass ] 3282 191029 21:08:00 +4.535 galera.basic 'innodb' [ pass ] 3861 191029 21:08:04 +4.035 galera.binlog_checksum 'innodb' [ pass ] 3383 191029 21:08:20 +15.801 galera.create 'innodb' [ pass ] 15009 191029 21:08:25 +4.356 galera.enforce_storage_engine 'innodb' [ pass ] 3767 191029 21:08:48 +23.878 galera.ev51914 'innodb' [ pass ] 23379 191029 21:08:59 +10.904 galera.fk 'innodb' [ pass ] 10319 191029 21:09:20 +20.784 galera.galera#500 'innodb' [ pass ] 20279 191029 21:09:23 +2.507 galera.galera#505 'innodb' [ pass ] 2047 191029 21:10:07 +44.762 galera.galera_FK_duplicate_client_insert 'innodb' [ pass ] 44120 191029 21:10:28 +20.357 galera.galera_admin 'innodb' [ pass ] 19823 191029 21:10:34 +6.657 galera.galera_alter_engine_innodb 'innodb' [ pass ] 6107 191029 21:10:39 +4.991 galera.galera_alter_engine_myisam 'innodb' [ pass ] 4481 191029 21:10:45 +5.833 galera.galera_alter_table_force 'innodb' [ pass ] 5404 191029 21:10:50 +5.088 galera.galera_applier_ftwrl_table 'innodb' [ pass ] 4122 191029 21:10:54 +3.927 galera.galera_bf_abort 'innodb' [ pass ] 3426 191029 21:10:58 +3.920 galera.galera_bf_abort_at_after_statement 'innodb' [ pass ] 3460 191029 21:11:02 +4.112 galera.galera_bf_abort_flush_for_export 'innodb' [ pass ] 3594 191029 21:11:07 +4.555 galera.galera_bf_abort_for_update 'innodb' [ pass ] 4103 191029 21:11:11 +4.065 galera.galera_bf_abort_ftwrl 'innodb' [ pass ] 3538 191029 21:11:16 +5.410 galera.galera_bf_abort_get_lock 'innodb' [ pass ] 4451 191029 21:11:21 +5.018 galera.galera_bf_abort_lock_table 'innodb' [ pass ] 4338 191029 21:11:33 +11.895 galera.galera_bf_abort_shutdown 'innodb' [ pass ] 11440 191029 21:11:38 +4.395 galera.galera_bf_abort_sleep 'innodb' [ pass ] 3908 191029 21:11:44 +6.565 galera.galera_binlog_cache_size 'innodb' [ pass ] 5946 191029 21:11:55 +11.305 galera.galera_binlog_row_image 'innodb' [ pass ] 10880 191029 21:12:00 +4.717 galera.galera_change_user 'innodb' [ pass ] 4000 191029 21:12:03 +2.463 galera.galera_commit_empty 'innodb' [ pass ] 2039 191029 21:12:07 +4.834 galera.galera_create_function 'innodb' [ pass ] 4330 191029 21:12:14 +6.469 galera.galera_create_procedure 'innodb' [ pass ] 6010 191029 21:12:34 +20.275 galera.galera_create_table_as_select 'innodb' [ pass ] 19701 191029 21:12:45 +10.474 galera.galera_create_table_like 'innodb' [ pass ] 9980 191029 21:12:59 +14.011 galera.galera_create_trigger 'innodb' [ pass ] 13028 191029 21:13:12 +13.523 galera.galera_ddl_multiline 'innodb' [ pass ] 12814 191029 21:13:15 +3.077 galera.galera_defaults 'innodb' [ pass ] 2113 191029 21:13:26 +10.987 galera.galera_delete_limit 'innodb' [ pass ] 10178 191029 21:13:38 +11.606 galera.galera_desync_overlapped 'innodb' [ pass ] 11038 191029 21:14:16 +38.532 galera.galera_drop_database 'innodb' [ pass ] 37623 191029 21:14:22 +5.297 galera.galera_drop_multi 'innodb' [ pass ] 4770 191029 21:14:28 +5.914 galera.galera_enum 'innodb' [ pass ] 5516 191029 21:14:33 +4.912 galera.galera_events 'innodb' [ pass ] 4392 191029 21:14:59 +26.461 galera.galera_events2 'innodb' [ pass ] 25266 191029 21:15:07 +7.826 galera.galera_fk_cascade_delete 'innodb' [ pass ] 7222 191029 21:15:16 +8.688 galera.galera_fk_cascade_update 'innodb' [ pass ] 8174 191029 21:15:21 +5.228 galera.galera_fk_conflict 'innodb' [ pass ] 4724 191029 21:15:27 +6.409 galera.galera_fk_mismatch 'innodb' [ pass ] 5880 191029 21:15:35 +7.488 galera.galera_fk_multicolumn 'innodb' [ pass ] 6960 191029 21:15:41 +6.220 galera.galera_fk_multitable 'innodb' [ pass ] 5729 191029 21:15:47 +6.424 galera.galera_fk_no_pk 'innodb' [ pass ] 5914 191029 21:15:52 +4.549 galera.galera_fk_selfreferential 'innodb' [ pass ] 4057 191029 21:15:57 +5.489 galera.galera_fk_setnull 'innodb' [ pass ] 4991 191029 21:16:03 +5.992 galera.galera_ftwrl 'innodb' [ pass ] 5466 191029 21:16:10 +6.694 galera.galera_ftwrl_drain 'innodb' [ pass ] 6207 191029 21:16:16 +6.436 galera.galera_gcs_fc_limit 'innodb' [ pass ] 5698 191029 21:16:20 +3.902 galera.galera_gra_log 'innodb' [ pass ] 3457 191029 21:16:28 +7.739 galera.galera_insert_ignore 'innodb' [ pass ] 7218 191029 21:16:39 +11.136 galera.galera_insert_multi 'innodb' [ pass ] 10504 191029 21:16:53 +13.849 galera.galera_kill_applier 'innodb' [ pass ] 3384 191029 21:17:21 +28.229 galera.galera_kill_ddl 'innodb' [ pass ] 20489 191029 21:17:42 +20.806 galera.galera_kill_smallchanges 'innodb' [ pass ] 20387 191029 21:17:46 +3.655 galera.galera_last_committed_id 'innodb' [ pass ] 3329 191029 21:17:53 +7.388 galera.galera_lock_table 'innodb' [ pass ] 7038 191029 21:18:49 +55.342 galera.galera_many_indexes 'innodb' [ pass ] 55006 191029 21:18:57 +8.520 galera.galera_mdev_10812 'innodb' [ pass ] 8163 191029 21:19:03 +6.119 galera.galera_mdl_race 'innodb' [ pass ] 5455 191029 21:19:10 +6.833 galera.galera_multi_database 'innodb' [ pass ] 6457 191029 21:19:15 +4.678 galera.galera_myisam_autocommit 'innodb' [ pass ] 4199 191029 21:19:19 +4.547 galera.galera_myisam_transactions 'innodb' [ pass ] 4212 191029 21:19:25 +5.858 galera.galera_nopk_bit 'innodb' [ pass ] 5478 191029 21:19:32 +7.089 galera.galera_nopk_blob 'innodb' [ pass ] 6763 191029 21:19:38 +5.597 galera.galera_nopk_large_varchar 'innodb' [ pass ] 5154 191029 21:19:42 +4.380 galera.galera_nopk_unicode 'innodb' [ pass ] 4051 191029 21:19:49 +7.177 galera.galera_parallel_apply_lock_table 'innodb' [ pass ] 6684 191029 21:19:58 +8.307 galera.galera_parallel_simple 'innodb' [ pass ] 7823 191029 21:20:20 +22.238 galera.galera_pc_ignore_sb 'innodb' [ pass ] 21924 191029 21:20:25 +5.137 galera.galera_performance_schema 'innodb' [ pass ] 4735 191029 21:20:29 +4.006 galera.galera_pk_bigint_signed 'innodb' [ pass ] 3672 191029 21:20:34 +5.021 galera.galera_pk_bigint_unsigned 'innodb' [ pass ] 4638 191029 21:20:44 +9.879 galera.galera_prepared_statement 'innodb' [ pass ] 9571 191029 21:20:49 +5.065 galera.galera_read_only 'innodb' [ pass ] 4686 191029 21:20:56 +6.730 galera.galera_repl_key_format_flat16 'innodb' [ pass ] 6312 191029 21:21:00 +4.000 galera.galera_repl_max_ws_size 'innodb' [ pass ] 3670 191029 21:21:13 +13.467 galera.galera_restart_nochanges 'innodb' [ pass ] 13120 191029 21:22:39 +85.869 galera.galera_restart_on_unknown_option 'innodb' [ pass ] 85460 191029 21:22:57 +18.337 galera.galera_roles 'innodb' [ pass ] 17911 191029 21:23:02 +4.543 galera.galera_rsu_error 'innodb' [ pass ] 4203 191029 21:23:06 +3.888 galera.galera_rsu_simple 'innodb' [ pass ] 3619 191029 21:23:14 +7.984 galera.galera_rsu_wsrep_desync 'innodb' [ pass ] 7493 191029 21:23:18 +4.154 galera.galera_sbr 'innodb' [ pass ] 3832 191029 21:23:20 +2.361 galera.galera_schema_dirty_reads 'innodb' [ pass ] 2043 191029 21:23:30 +9.838 galera.galera_serializable 'innodb' [ pass ] 9582 191029 21:23:34 +3.464 galera.galera_server 'innodb' [ pass ] 3159 191029 21:23:53 +19.750 galera.galera_shutdown_nonprim 'innodb' [ pass ] 19397 191029 21:24:10 +16.221 galera.galera_sp_bf_abort 'innodb' [ pass ] 15731 191029 21:29:59 +349.474 galera.galera_sp_insert_parallel 'innodb' [ pass ] 348448 191029 21:30:03 +4.271 galera.galera_sql_log_bin_zero 'innodb' [ pass ] 3787 191029 21:30:06 +2.413 galera.galera_status_cluster 'innodb' [ pass ] 2079 191029 21:30:09 +3.747 galera.galera_status_local_index 'innodb' [ pass ] 3416 191029 21:30:12 +2.519 galera.galera_status_local_state 'innodb' [ pass ] 2072 191029 21:30:40 +27.825 galera.galera_suspend_slave 'innodb' [ pass ] 27333 191029 21:30:48 +8.389 galera.galera_sync_wait_show 'innodb' [ pass ] 7927 191029 21:31:00 +12.155 galera.galera_toi_alter_auto_increment 'innodb' [ pass ] 11769 191029 21:31:10 +9.845 galera.galera_toi_ddl_locking 'innodb' [ pass ] 9300 191029 21:31:16 +5.713 galera.galera_toi_ddl_nonconflicting 'innodb' [ pass ] 5290 191029 21:31:21 +5.112 galera.galera_toi_ddl_sequential 'innodb' [ pass ] 4756 191029 21:34:05 +164.453 galera.galera_toi_drop_database 'innodb' [ pass ] 164038 191029 21:34:10 +4.397 galera.galera_toi_ftwrl 'innodb' [ pass ] 4062 191029 21:34:15 +5.330 galera.galera_toi_lock_exclusive 'innodb' [ pass ] 4933 191029 21:34:20 +4.578 galera.galera_toi_lock_shared 'innodb' [ pass ] 4189 191029 21:34:57 +36.957 galera.galera_toi_truncate 'innodb' [ pass ] 36376 191029 21:35:00 +3.689 galera.galera_transaction_read_only 'innodb' [ pass ] 3300 191029 21:35:10 +9.073 galera.galera_transaction_replay 'innodb' [ pass ] 8740 191029 21:35:26 +16.800 galera.galera_truncate 'innodb' [ pass ] 16360 191029 21:35:35 +8.693 galera.galera_truncate_temporary 'innodb' [ pass ] 8290 191029 21:35:46 +11.194 galera.galera_unicode_identifiers 'innodb' [ pass ] 10804 191029 21:35:51 +4.809 galera.galera_unicode_pk 'innodb' [ pass ] 4442 191029 21:35:58 +7.039 galera.galera_update_limit 'innodb' [ pass ] 6619 191029 21:36:03 +5.143 galera.galera_var_OSU_method 'innodb' [ pass ] 4723 191029 21:36:08 +4.496 galera.galera_var_OSU_method2 'innodb' [ pass ] 4125 191029 21:36:14 +6.035 galera.galera_var_auto_inc_control_off 'innodb' [ pass ] 5620 191029 21:36:20 +6.553 galera.galera_var_certify_nonPK_off 'innodb' [ pass ] 6146 191029 21:36:28 +7.846 galera.galera_var_cluster_address 'innodb' [ pass ] 7404 191029 21:36:35 +7.184 galera.galera_var_desync_on 'innodb' [ pass ] 6849 191029 21:36:42 +7.147 galera.galera_var_dirty_reads 'innodb' [ pass ] 6751 191029 21:36:49 +6.398 galera.galera_var_fkchecks 'innodb' [ pass ] 5883 191029 21:37:16 +27.587 galera.galera_var_ignore_apply_errors 'innodb' [ pass ] 27216 191029 21:38:07 +50.599 galera.galera_var_max_ws_rows 'innodb' [ pass ] 50023 191029 21:38:11 +3.963 galera.galera_var_max_ws_size 'innodb' [ pass ] 3595 191029 21:38:15 +4.123 galera.galera_var_mysql_replication_bundle 'innodb' [ pass ] 3756 191029 21:38:18 +3.238 galera.galera_var_replicate_myisam_off 'innodb' [ pass ] 2575 191029 21:38:34 +15.425 galera.galera_var_replicate_myisam_on 'innodb' [ pass ] 14958 191029 21:38:42 +7.795 galera.galera_var_sync_wait 'innodb' [ pass ] 7356 191029 21:38:46 +4.126 galera.galera_var_wsrep_on_off 'innodb' [ pass ] 3756 191029 21:38:48 +2.405 galera.galera_wsrep_provider_options_syntax 'innodb' [ pass ] 2087 191029 21:38:57 +8.670 galera.galera_wsrep_provider_unset_set 'innodb' [ pass ] 8288 191029 21:39:02 +5.610 galera.galera_zero_length_column 'innodb' [ pass ] 5294 191029 21:39:05 +3.098 galera.grant 'innodb' [ pass ] 2786 191029 21:39:10 +4.163 galera.lp1276424 'innodb' [ pass ] 3729 191029 21:39:14 +4.527 galera.lp1347768 'innodb' [ pass ] 4170 191029 21:39:21 +6.928 galera.lp1376747 'innodb' [ pass ] 6482 191029 21:39:27 +5.420 galera.lp1376747-2 'innodb' [ pass ] 4925 191029 21:39:32 +5.412 galera.lp1376747-3 'innodb' [ pass ] 4927 191029 21:39:43 +11.271 galera.lp1376747-4 'innodb' [ pass ] 10876 191029 21:39:51 +8.160 galera.lp1438990 'innodb' [ pass ] 7809 191029 21:39:58 +6.765 galera.lp959512 'innodb' [ pass ] 6357 191029 21:40:02 +3.797 galera.mdev_9290 'innodb' [ pass ] 3453 191029 21:40:10 +7.905 galera.mysql-wsrep#110 'innodb' [ pass ] 7465 191029 21:40:15 +5.142 galera.mysql-wsrep#237 'innodb' [ pass ] 4705 191029 21:40:19 +3.940 galera.mysql-wsrep#247 'innodb' [ pass ] 3613 191029 21:40:33 +14.092 galera.mysql-wsrep#31 'innodb' [ pass ] 13767 191029 21:41:08 +34.824 galera.mysql-wsrep#332 'innodb' [ pass ] 24649 191029 21:41:15 +6.749 galera.mysql-wsrep#90 'innodb' [ pass ] 6303 191029 21:41:24 +9.402 galera.pxc-421 'innodb' [ pass ] 9011 191029 21:41:30 +6.450 galera.rename 'innodb' [ pass ] 5849 191029 21:41:38 +7.403 galera.sql_log_bin 'innodb' [ pass ] 6970 191029 21:41:43 +5.006 galera.unique_key 'innodb' [ pass ] 4507 191029 21:41:50 +7.576 galera.view 'innodb' [ pass ] 6781 191029 21:41:53 +2.445 galera.wsrep_trx_fragment_size_sr 'innodb' [ pass ] 2085 191029 21:42:24 +30.780 galera.MDEV-15443 'innodb' [ pass ] 12721 191029 21:42:48 +24.563 galera.MDEV-18832 'innodb' [ pass ] 6514 191029 21:45:35 +167.083 galera.MDEV-6860 'innodb' [ pass ] 147476 191029 21:45:58 +22.999 galera.MW-284 'innodb' [ pass ] 12564 191029 21:46:24 +25.427 galera.MW-336 'innodb' [ pass ] 6175 191029 21:46:42 +17.918 galera.galera#414 'innodb' [ pass ] 10235 191029 21:47:06 +24.366 galera.galera_as_master 'innodb' [ pass ] 8525 191029 21:47:22 +16.092 galera.galera_as_master_large 'innodb' [ pass ] 5397 191029 21:47:37 +14.638 galera.galera_as_slave 'innodb' [ pass ] 4582 191029 21:47:52 +14.968 galera.galera_as_slave_autoinc 'innodb' [ pass ] 4602 191029 21:48:06 +14.130 galera.galera_as_slave_gtid 'innodb' [ pass ] 4592 191029 21:48:27 +21.314 galera.galera_as_slave_gtid_replicate_do_db 'innodb' [ pass ] 10942 191029 21:48:59 +31.728 galera.galera_as_slave_nonprim 'innodb' [ pass ] 20061 191029 21:50:18 +78.914 galera.galera_autoinc_sst_mariabackup 'innodb' [ pass ] 57170 191029 21:50:56 +38.565 galera.galera_gcache_recover 'innodb' [ pass ] 24401 191029 21:52:08 +71.401 galera.galera_gcache_recover_full_gcache 'innodb' [ pass ] 53381 191029 21:52:30 +22.545 galera.galera_gcs_fragment 'innodb' [ pass ] 7727 191029 21:52:58 +27.388 galera.galera_gcs_max_packet_size 'innodb' [ pass ] 11915 191029 21:53:21 +23.359 galera.galera_gtid_slave 'innodb' [ pass ] 7094 191029 21:53:54 +32.535 galera.galera_gtid_slave_sst_rsync 'innodb' [ pass ] 22171 191029 21:54:59 +64.929 galera.galera_ist_mariabackup_innodb_flush_logs 'debug,innodb' [ pass ] 44577 191029 21:57:04 +125.476 galera.galera_ist_mysqldump 'debug,innodb' [ pass ] 111276 191029 21:57:34 +30.507 galera.galera_ist_recv_bind 'innodb' [ pass ] 14712 191029 21:58:14 +39.561 galera.galera_ist_restart_joiner 'innodb' [ pass ] 23838 191029 21:59:32 +77.922 galera.galera_ist_rsync 'debug,innodb' [ pass ] 59027 191029 22:00:14 +42.499 galera.galera_load_data 'innodb' [ pass ] 25370 191029 22:06:16 +361.691 galera.galera_many_rows 'innodb' [ pass ] 341416 191029 22:07:06 +50.002 galera.galera_mdev_15611 'innodb' [ pass ] 31826 191029 22:07:30 +24.334 galera.galera_ssl 'innodb' [ pass ] 3785 191029 22:07:49 +18.987 galera.galera_ssl_compression 'innodb' [ pass ] 4058 191029 22:09:42 +112.781 galera.galera_sst_mariabackup 'debug,innodb' [ pass ] 85077 191029 22:11:36 +113.383 galera.galera_sst_mariabackup_data_dir 'debug,innodb' [ pass ] 86245 191029 22:12:05 +29.381 galera.galera_sst_mariabackup_encrypt_with_key 'innodb' [ pass ] 2055 191029 22:13:36 +91.450 galera.galera_sst_mariabackup_table_options '16k,clear,innodb' [ pass ] 33325 191029 22:15:02 +85.822 galera.galera_sst_mariabackup_table_options '16k,crypt,innodb' [ pass ] 32762 191029 22:16:29 +86.562 galera.galera_sst_mariabackup_table_options '4k,clear,innodb' [ pass ] 32158 191029 22:18:00 +91.629 galera.galera_sst_mariabackup_table_options '4k,crypt,innodb' [ pass ] 34894 191029 22:19:30 +89.222 galera.galera_sst_mariabackup_table_options '8k,clear,innodb' [ pass ] 34541 191029 22:20:57 +87.464 galera.galera_sst_mariabackup_table_options '8k,crypt,innodb' [ pass ] 31620 191029 22:23:59 +181.944 galera.galera_sst_mysqldump 'debug,innodb' [ pass ] 166382 191029 22:25:03 +64.073 galera.galera_sst_mysqldump_with_key 'debug,innodb' [ pass ] 47674 191029 22:26:19 +75.890 galera.galera_sst_rsync 'debug,innodb' [ pass ] 61477 191029 22:27:40 +81.121 galera.galera_sst_rsync2 'debug,innodb' [ pass ] 64735 191029 22:28:59 +78.578 galera.galera_sst_rsync_data_dir 'debug,innodb' [ pass ] 63477 191029 22:29:21 +22.461 galera.galera_var_gtid_domain_id 'innodb' [ pass ] 4719 191029 22:29:42 +20.548 galera.galera_var_log_bin 'innodb' [ pass ] 3048 191029 22:30:25 +43.701 galera.galera_var_slave_threads 'innodb' [ pass ] 15138 191029 22:31:38 +72.386 galera.galera_wan_restart_ist 'innodb' [ pass ] 59547 191029 22:32:55 +77.414 galera.galera_wan_restart_sst 'innodb' [ pass ] 60731 191029 22:33:10 +14.261 galera.mdev_10518 'innodb' [ pass ] 4656 191029 22:34:21 +71.321 galera.mysql-wsrep#33 'innodb' [ pass ] 52560 191029 22:34:39 +18.581 galera.rpl_row_annotate 'innodb' [ pass ] 3803 191029 22:35:06 +26.762 galera.versioning_trx_id 'innodb' [ fail ] Test ended at 2019-10-29 22:35:06 CURRENT_TEST: galera.versioning_trx_id --- /home/stepan/mariadb/10.4/github/mysql-test/suite/galera/r/versioning_trx_id.result 2019-10-25 14:52:04.615763493 +0300 +++ /home/stepan/mariadb/10.4/github/mysql-test/suite/galera/r/versioning_trx_id.reject 2019-10-29 22:35:06.338698930 +0200 @@ -50,8 +50,13 @@ select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0'; count(*) 0 +select * from mysql.transaction_registry; +transaction_id commit_id begin_timestamp commit_timestamp isolation_level +46 47 2019-10-29 22:35:04.541209 2019-10-29 22:35:04.550118 REPEATABLE-READ +49 50 2019-10-29 22:35:05.031665 2019-10-29 22:35:04.000000 READ-COMMITTED +52 53 2019-10-29 22:35:04.000000 2019-10-29 22:35:05.000000 READ-COMMITTED select count(*) from mysql.transaction_registry where begin_timestamp>=commit_timestamp; count(*) -0 +1 drop table t1; disconnect node_3; mysqltest: Result length mismatch - saving '/home/stepan/mariadb/10.4/github/mysql-test/var/log/galera.versioning_trx_id-innodb/' to '/home/stepan/mariadb/10.4/github/mysql-test/var/log/galera.versioning_trx_id-innodb/' -------------------------------------------------------------------------- The servers were restarted 83 times Spent 7338.602 of 9153 seconds executing testcases Completed: Failed 2/275 tests, 99.27% were successful. Failing test(s): galera.galera_var_innodb_disallow_writes galera.versioning_trx_id 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 191029 22:35:06 +0.035 mysql-test-run: *** ERROR: there were failing test cases