Logging: ./mysql-test-run vardir: /share/HDA_DATA/mariadb/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/share/HDA_DATA/mariadb/mysql-test/var'... Checking supported features... Using suites: main-,archive-,binlog-,csv-,federated-,funcs_1-,funcs_2-,handler-,heap-,innodb-,innodb_zip-,maria-,optimizer_unfixed_bugs-,oqgraph-,parts-,percona-,perfschema-,plugins-,rpl-,sphinx-,sys_vars-,unit-,vcol- MariaDB Version 5.5.51-MariaDB Installing system database... - SSL connections supported Collecting tests... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019 oqgraph.basic [ skipped ] No OQGraph oqgraph.binlog [ skipped ] No OQGraph sphinx.sphinx [ skipped ] No Sphinx sphinx.union-5539 [ skipped ] No Sphinx archive.archive-big [ skipped ] Test needs --big-test binlog.binlog_multi_engine [ skipped ] ndbcluster disabled binlog.binlog_spurious_ddl_errors [ disabled ] BUG#11761680 2013-01-18 astha Fixed on mysql-5.6 and trunk binlog.binlog_truncate_innodb [ disabled ] BUG#11764459 2010-10-20 anitha Originally disabled due to BUG#42643. Product bug fixed, but test changes needed federated.federated_server [ skipped ] Test needs --big-test funcs_1.myisam_views-big [ skipped ] Test needs --big-test innodb.innodb_simulate_comp_failures [ skipped ] Test needs --big-test innodb.sp_temp_table [ skipped ] Test needs --big-test main.alter_table-big [ skipped ] Test needs --big-test main.count_distinct3 [ skipped ] Test needs --big-test main.create-big [ skipped ] Test needs --big-test main.create_delayed [ skipped ] Test needs --big-test main.events_stress [ skipped ] Test needs --big-test main.events_time_zone [ disabled ] Test is not predictable as it depends on precise timing. main.file_contents [ disabled ] MDEV-6526 these files are not installed anymore main.information_schema-big [ skipped ] Test needs --big-test main.log_tables-big [ disabled ] Bug#11756699 2010-11-15 mattiasj report already exists main.lowercase_fs_on [ disabled ] lower_case_table_names=0 is not an error until 10.1 main.merge-big [ skipped ] Test needs --big-test main.myisam-big [ skipped ] Test needs --big-test main.myisam-metadata [ skipped ] Test needs --big-test main.mysql_embedded [ disabled ] Bug#12561297 2011-05-14 Anitha Dependent on PB2 changes - eventum#41836 main.mysqlbinlog_row_big [ skipped ] Test needs --big-test main.read_many_rows_innodb [ disabled ] Bug#11748886 2010-11-15 mattiasj report already exists main.ssl-big [ skipped ] Test needs --big-test main.sum_distinct-big [ skipped ] Test needs --big-test main.tablespace [ disabled ] disabled in MariaDB (no TABLESPACE table attribute) main.type_newdecimal-big [ skipped ] Test needs --big-test maria.maria-big [ skipped ] Test needs --big-test maria.maria-big2 [ skipped ] Test needs --big-test maria.maria-purge [ skipped ] Test needs --big-test maria.maria-recovery-big [ skipped ] Test needs --big-test maria.max_length [ skipped ] Test needs --big-test parts.part_supported_sql_func_innodb [ skipped ] Test needs --big-test parts.partition_alter1_1_2_innodb [ skipped ] Test needs --big-test parts.partition_alter1_2_innodb [ skipped ] Test needs --big-test parts.partition_alter2_1_1_innodb [ skipped ] Test needs --big-test parts.partition_alter2_1_2_innodb [ skipped ] Test needs --big-test parts.partition_alter2_1_maria [ skipped ] Test needs --big-test parts.partition_alter2_2_1_innodb [ skipped ] Test needs --big-test parts.partition_alter2_2_2_innodb [ skipped ] Test needs --big-test parts.partition_alter2_2_maria [ skipped ] Test needs --big-test parts.partition_alter4_innodb [ skipped ] Test needs --big-test parts.partition_alter4_myisam [ skipped ] Test needs --big-test parts.partition_basic_innodb [ skipped ] Test needs --big-test parts.partition_decimal_innodb [ skipped ] Test needs --big-test parts.partition_decimal_myisam [ skipped ] Test needs --big-test parts.partition_value_innodb [ disabled ] CAST() in partitioning function is currently not supported parts.partition_value_myisam [ disabled ] CAST() in partitioning function is currently not supported parts.rpl_partition [ skipped ] Test needs --big-test percona.innodb_sys_index [ skipped ] Test needs --big-test percona.percona_flush_contiguous_neighbors [ skipped ] Test needs --big-test percona.percona_innodb_buffer_pool_shm [ disabled ] Requires big shmmax not default on many systems percona.percona_innodb_expand_fast_index_creation [ disabled ] Feature not merged into MariaDB percona.percona_innodb_kill_idle_trx [ disabled ] Feature not merged into MariaDB percona.percona_innodb_kill_idle_trx_locks [ disabled ] Feature not merged into MariaDB percona.percona_log_warnings_suppress [ disabled ] Feature not merged into MariaDB percona.percona_processlist_row_stats [ disabled ] Feature not merged into MariaDB percona.percona_query_response_time [ disabled ] Feature not merged into MariaDB percona.percona_query_response_time-replication [ disabled ] Feature not merged into MariaDB percona.percona_query_response_time-stored [ disabled ] Feature not merged into MariaDB percona.percona_server_variables_debug [ disabled ] Feature not merged into MariaDB percona.percona_server_variables_release [ disabled ] Feature not merged into MariaDB percona.percona_show_temp_tables [ disabled ] Feature not merged into MariaDB percona.percona_slow_extended-slow_query_log_timestamp_always-cl [ disabled ] Feature not merged into MariaDB percona.percona_slow_extended-use_global_control [ disabled ] Feature not merged into MariaDB percona.percona_sync_flush [ disabled ] removed from XtraDB-26.0 percona.userstat_bug602047 [ disabled ] Feature not merged into MariaDB rpl.rpl_get_master_version_and_clock [ disabled ] Bug#11766137 Jan 05 2011 joro Valgrind warnings rpl_get_master_version_and_clock rpl.rpl_innodb_bug28430 [ skipped ] Test needs --big-test rpl.rpl_row_create_table [ disabled ] Bug#11759274 2010-02-27 andrei failed different way than earlier with bug#45576 rpl.rpl_spec_variables [ disabled ] BUG#11755836 2009-10-27 jasonh rpl_spec_variables fails on PB2 hpux sys_vars.innodb_flush_checkpoint_debug_basic [ disabled ] removed from XtraDB-26.0 sys_vars.transaction_prealloc_size_bug27322 [ skipped ] Test needs --big-test federated.federated_debug 'X' [ skipped ] Requires debug build rpl.rpl_checksum [ skipped ] Requires debug build rpl.rpl_corruption 'mix' [ skipped ] Requires debug build rpl.rpl_corruption 'row' [ skipped ] Requires debug build rpl.rpl_corruption 'stmt' [ skipped ] Requires debug build rpl.rpl_stop_slave 'innodb_plugin,mix' [ skipped ] Requires debug build rpl.rpl_bug26395 'innodb_plugin,mix' [ skipped ] Requires debug build rpl.rpl_stop_slave 'mix,xtradb' [ skipped ] Requires debug build rpl.rpl_bug26395 'mix,xtradb' [ skipped ] Requires debug build rpl.rpl_init_slave_errors 'mix' [ skipped ] Requires debug build rpl.rpl_killed_ddl 'mix' [ skipped ] Requires debug build rpl.rpl_bug41902 'mix' [ skipped ] Requires debug build rpl.rpl_bug33931 'mix' [ skipped ] Requires debug build rpl.rpl_lost_events_on_rotate 'mix' [ skipped ] Requires debug build rpl.rpl_show_slave_running 'mix' [ skipped ] Requires debug build rpl.rpl_row_index_choice 'innodb_plugin' [ skipped ] Requires debug build rpl.rpl_stop_slave 'innodb_plugin,row' [ skipped ] Requires debug build rpl.rpl_bug26395 'innodb_plugin,row' [ skipped ] Requires debug build rpl.rpl_row_index_choice 'xtradb' [ skipped ] Requires debug build rpl.rpl_stop_slave 'row,xtradb' [ skipped ] Requires debug build rpl.rpl_bug26395 'row,xtradb' [ skipped ] Requires debug build rpl.rpl_row_4_bytes 'row' [ skipped ] Requires debug build rpl.rpl_row_corruption [ skipped ] Requires debug build rpl.rpl_init_slave_errors 'row' [ skipped ] Requires debug build rpl.rpl_row_find_row_debug 'row' [ skipped ] Requires debug build rpl.rpl_killed_ddl 'row' [ skipped ] Requires debug build rpl.rpl_bug41902 'row' [ skipped ] Requires debug build rpl.rpl_bug33931 'row' [ skipped ] Requires debug build rpl.rpl_lost_events_on_rotate 'row' [ skipped ] Requires debug build rpl.rpl_show_slave_running 'row' [ skipped ] Requires debug build rpl.rpl_slave_load_remove_tmpfile 'innodb_plugin,stmt' [ skipped ] Requires debug build rpl.rpl_stm_stop_middle_group 'innodb_plugin,stmt' [ skipped ] Requires debug build rpl.rpl_stop_slave 'innodb_plugin,stmt' [ skipped ] Requires debug build rpl.rpl_bug26395 'innodb_plugin,stmt' [ skipped ] Requires debug build rpl.rpl_slave_load_remove_tmpfile 'stmt,xtradb' [ skipped ] Requires debug build rpl.rpl_stm_stop_middle_group 'stmt,xtradb' [ skipped ] Requires debug build rpl.rpl_stop_slave 'stmt,xtradb' [ skipped ] Requires debug build rpl.rpl_bug26395 'stmt,xtradb' [ skipped ] Requires debug build rpl.rpl_known_bugs_detection 'stmt' [ skipped ] Requires debug build rpl.rpl_loaddata_fatal 'stmt' [ skipped ] Requires debug build rpl.rpl_init_slave_errors 'stmt' [ skipped ] Requires debug build rpl.rpl_killed_ddl 'stmt' [ skipped ] Requires debug build rpl.rpl_bug41902 'stmt' [ skipped ] Requires debug build rpl.rpl_bug33931 'stmt' [ skipped ] Requires debug build rpl.rpl_lost_events_on_rotate 'stmt' [ skipped ] Requires debug build rpl.rpl_show_slave_running 'stmt' [ skipped ] Requires debug build rpl.rpl_sync 'innodb_plugin' [ skipped ] Requires debug build rpl.rpl_sync 'xtradb' [ skipped ] Requires debug build rpl.rpl_binlog_errors 'innodb_plugin' [ skipped ] Requires debug build rpl.rpl_binlog_errors 'xtradb' [ skipped ] Requires debug build rpl.rpl_incident [ skipped ] Requires debug build rpl.rpl_binlog_corruption [ skipped ] Requires debug build rpl.rpl_heartbeat_debug [ skipped ] Requires debug build rpl.rpl_ip_mix [ skipped ] No IPv6 rpl.rpl_ip_mix2 [ skipped ] No IPv6 rpl.rpl_ipv6 [ skipped ] No IPv6 main.ipv6 [ skipped ] No IPv6 binlog.binlog_stm_binlog 'innodb_plugin,mix' [ skipped ] Requires debug build binlog.binlog_stm_binlog 'mix,xtradb' [ skipped ] Requires debug build binlog.binlog_ioerr 'innodb_plugin,mix' [ skipped ] Requires debug build binlog.binlog_ioerr 'mix,xtradb' [ skipped ] Requires debug build binlog.binlog_index 'mix' [ skipped ] Requires debug build binlog.binlog_write_error 'mix' [ skipped ] Requires debug build binlog.binlog_incident 'mix' [ skipped ] Requires debug build binlog.binlog_reset_master 'mix' [ skipped ] Requires debug build binlog.binlog_row_binlog 'innodb_plugin,row' [ skipped ] Requires debug build binlog.binlog_row_binlog 'row,xtradb' [ skipped ] Requires debug build binlog.binlog_ioerr 'innodb_plugin,row' [ skipped ] Requires debug build binlog.binlog_mdev342 'innodb_plugin,row' [ skipped ] Requires debug build binlog.binlog_ioerr 'row,xtradb' [ skipped ] Requires debug build binlog.binlog_mdev342 'row,xtradb' [ skipped ] Requires debug build binlog.binlog_index 'row' [ skipped ] Requires debug build binlog.binlog_write_error 'row' [ skipped ] Requires debug build binlog.binlog_incident 'row' [ skipped ] Requires debug build binlog.binlog_reset_master 'row' [ skipped ] Requires debug build binlog.binlog_ioerr 'innodb_plugin,stmt' [ skipped ] Requires debug build binlog.binlog_ioerr 'stmt,xtradb' [ skipped ] Requires debug build binlog.binlog_index 'stmt' [ skipped ] Requires debug build binlog.binlog_write_error 'stmt' [ skipped ] Requires debug build binlog.binlog_incident 'stmt' [ skipped ] Requires debug build binlog.binlog_killed_simulate 'stmt' [ skipped ] Requires debug build binlog.binlog_reset_master 'stmt' [ skipped ] Requires debug build innodb.group_commit_binlog_pos_no_optimize_thread 'innodb_plugin' [ skipped ] Requires debug build innodb.group_commit_crash_no_optimize_thread 'innodb_plugin' [ skipped ] Requires debug build innodb.group_commit_binlog_pos_no_optimize_thread 'xtradb' [ skipped ] Requires debug build innodb.group_commit_crash_no_optimize_thread 'xtradb' [ skipped ] Requires debug build main.crash_commit_before 'innodb_plugin' [ skipped ] Requires debug build main.crash_commit_before 'xtradb' [ skipped ] Requires debug build parts.partition_debug_innodb 'innodb_plugin' [ skipped ] Requires debug build innodb.insert_debug 'innodb_plugin' [ skipped ] Requires debug build parts.partition_debug_innodb 'xtradb' [ skipped ] Requires debug build innodb.insert_debug 'xtradb' [ skipped ] Requires debug build parts.partition_debug_myisam [ skipped ] Requires debug build main.partition_sync [ skipped ] Requires debug build innodb.innodb_bug14147491 'innodb_plugin' [ skipped ] Requires debug build innodb.group_commit_binlog_pos 'innodb_plugin' [ skipped ] Requires debug build innodb.group_commit_crash 'innodb_plugin' [ skipped ] Requires debug build innodb.innodb-change-buffer-recovery 'innodb_plugin' [ skipped ] Requires debug build innodb.innodb_bug14676111 'innodb_plugin' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug41029 'innodb_plugin' [ skipped ] Requires debug build innodb.innodb_bug53756 'innodb_plugin' [ skipped ] Requires debug build innodb.blob-update-debug 'innodb_plugin' [ skipped ] Requires debug build innodb.foreign-keys 'innodb_plugin' [ skipped ] Requires debug build innodb.innodb_bug11754376 'innodb_plugin' [ skipped ] Requires debug build innodb.innodb_bug14007649 'innodb_plugin' [ skipped ] Requires debug build innodb.innodb_corrupt_bit 'innodb_plugin' [ skipped ] Requires debug build main.flush_read_lock_kill 'innodb_plugin' [ skipped ] Requires debug build main.innodb_mysql_sync 'innodb_plugin' [ skipped ] Requires debug build main.uniques_crash-7912 'innodb_plugin' [ skipped ] Requires debug build main.warnings_debug 'innodb_plugin' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug36981 'innodb_plugin' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug40992 'innodb_plugin' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug41996 'innodb_plugin' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug42991 'innodb_plugin' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43249 'innodb_plugin' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43360 'innodb_plugin' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43448 'innodb_plugin' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43617 'innodb_plugin' [ skipped ] Requires debug build sys_vars.innodb_buffer_pool_evict_basic 'innodb_plugin' [ skipped ] Requires debug build sys_vars.innodb_change_buffering_debug_basic 'innodb_plugin' [ skipped ] Requires debug build sys_vars.innodb_limit_optimistic_insert_debug_basic 'innodb_plugin' [ skipped ] Requires debug build sys_vars.innodb_trx_purge_view_update_only_debug_basic 'innodb_plugin' [ skipped ] Requires debug build sys_vars.innodb_trx_rseg_n_slots_debug_basic 'innodb_plugin' [ skipped ] Requires debug build innodb.innodb_bug14147491 'xtradb' [ skipped ] Requires debug build innodb.group_commit_binlog_pos 'xtradb' [ skipped ] Requires debug build innodb.group_commit_crash 'xtradb' [ skipped ] Requires debug build innodb.innodb-change-buffer-recovery 'xtradb' [ skipped ] Requires debug build innodb.innodb_bug14676111 'xtradb' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug41029 'xtradb' [ skipped ] Requires debug build innodb.innodb_bug53756 'xtradb' [ skipped ] Requires debug build innodb.blob-update-debug 'xtradb' [ skipped ] Requires debug build innodb.foreign-keys 'xtradb' [ skipped ] Requires debug build innodb.innodb_bug11754376 'xtradb' [ skipped ] Requires debug build innodb.innodb_bug14007649 'xtradb' [ skipped ] Requires debug build innodb.innodb_corrupt_bit 'xtradb' [ skipped ] Requires debug build main.flush_read_lock_kill 'xtradb' [ skipped ] Requires debug build main.innodb_mysql_sync 'xtradb' [ skipped ] Requires debug build main.uniques_crash-7912 'xtradb' [ skipped ] Requires debug build main.warnings_debug 'xtradb' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug36981 'xtradb' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug40992 'xtradb' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug41996 'xtradb' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug42991 'xtradb' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43249 'xtradb' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43360 'xtradb' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43448 'xtradb' [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43617 'xtradb' [ skipped ] Requires debug build sys_vars.innodb_buffer_pool_evict_basic 'xtradb' [ skipped ] Requires debug build sys_vars.innodb_change_buffering_debug_basic 'xtradb' [ skipped ] Requires debug build sys_vars.innodb_limit_optimistic_insert_debug_basic 'xtradb' [ skipped ] Requires debug build sys_vars.innodb_trx_purge_view_update_only_debug_basic 'xtradb' [ skipped ] Requires debug build sys_vars.innodb_trx_rseg_n_slots_debug_basic 'xtradb' [ skipped ] Requires debug build archive.archive_debug [ skipped ] Requires debug build maria.maria-recovery2 [ skipped ] Requires debug build maria.maria-gis-recovery [ skipped ] Requires debug build maria.maria-recovery [ skipped ] Requires debug build maria.maria-recovery3 [ skipped ] Requires debug build perfschema.tampered_perfschema_table1 [ skipped ] Requires debug build maria.maria-recovery-rtree-ft [ skipped ] Requires debug build main.myisam_crash_before_flush_keys [ skipped ] Requires debug build maria.maria-recovery-bitmap [ skipped ] Requires debug build main.error_simulation [ skipped ] Requires debug build main.cache_temporal_4265 [ skipped ] Requires debug build main.ctype_like_range [ skipped ] Requires debug build main.drop_bad_db_type [ skipped ] Requires debug build main.drop_debug [ skipped ] Requires debug build main.filesort_debug [ skipped ] Requires debug build main.log_tables_debug [ skipped ] Requires debug build main.mdev6830 [ skipped ] Requires debug build main.merge_debug [ skipped ] Requires debug build main.myisam_debug [ skipped ] Requires debug build main.processlist [ skipped ] Requires debug build main.select_debug [ skipped ] Requires debug build main.signal_code [ skipped ] Requires debug build main.sp-code [ skipped ] Requires debug build main.subselect_debug [ skipped ] Requires debug build main.union_crash-714 [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43101 [ skipped ] Requires debug build optimizer_unfixed_bugs.bug43618 [ skipped ] Requires debug build optimizer_unfixed_bugs.bug45221 [ skipped ] Requires debug build plugins.audit_null_debug [ skipped ] Requires debug build plugins.pam [ skipped ] No pam setup for mtr sys_vars.debug_basic [ skipped ] Requires debug build sys_vars.debug_binlog_fsync_sleep_basic [ skipped ] Requires debug build sys_vars.debug_crc_break_basic [ skipped ] Requires debug build sys_vars.debug_dbug_basic [ skipped ] Requires debug build sys_vars.debug_dbug_func [ skipped ] Requires debug build sys_vars.debug_dbug_func_notembedded [ skipped ] Requires debug build sys_vars.innodb_persistent_stats_root_page_basic [ skipped ] Requires debug build federated.federated_partition 'X,innodb_plugin' [ pass ] 277 federated.federated_partition 'X,xtradb' [ pass ] 129 federated.federated_transactions 'X,innodb_plugin' [ fail ] Test ended at 2017-11-01 15:44:59 CURRENT_TEST: federated.federated_transactions --- /share/HDA_DATA/mariadb/mysql-test/suite/federated/federated_transactions.result 2017-10-31 01:54:48.000000000 +0000 +++ /share/HDA_DATA/mariadb/mysql-test/suite/federated/federated_transactions.reject 2017-11-01 15:42:44.030000000 +0000 @@ -29,10 +29,10 @@ INSERT INTO federated.t1 (id, name) VALUES (6, 'fig'); SELECT * FROM federated.t1; id name -1 foo -2 fee -5 foe -6 fig +1 +2 +5 +6 DELETE FROM federated.t1; DROP TABLE IF EXISTS federated.t1; DROP DATABASE IF EXISTS federated; mysqltest: Result length mismatch - saving '/share/HDA_DATA/mariadb/mysql-test/var/log/federated.federated_transactions-X,innodb_plugin/' to '/share/HDA_DATA/mariadb/mysql-test/var/log/federated.federated_transactions-X,innodb_plugin/' Only 270 of 3240 completed. -------------------------------------------------------------------------- The servers were restarted 2 times Spent 0.406 of 46 seconds executing testcases Failure: Failed 1/3 tests, 66.67% were successful. Failing test(s): federated.federated_transactions 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 236 tests were skipped, 0 by the test itself.