Am 19.03.2017 um 13:13 schrieb Reindl Harald:
Am 19.03.2017 um 12:24 schrieb Sergei Golubchik:
On Mar 16, Reindl Harald wrote:
https://github.com/mariadb/server/commit/2c2bd8c1556b081fccd0fc3e010dc3ea2c3...
+ /usr/bin/patch --no-backup-if-mismatch -p1 --fuzz=0 patching file include/my_sys.h Hunk #1 succeeded at 646 (offset 49 lines). patching file include/mysql/psi/mysql_file.h patching file mysys/my_symlink2.c patching file sql/handler.cc Hunk #1 succeeded at 3840 (offset -10 lines). patching file sql/sql_db.cc Hunk #1 succeeded at 846 (offset 31 lines). Hunk #2 succeeded at 1152 (offset 33 lines). Hunk #3 succeeded at 1268 (offset 33 lines). patching file sql/table.cc Hunk #1 succeeded at 571 (offset 2 lines). patching file storage/maria/ma_delete_table.c Hunk #1 FAILED at 86. 1 out of 1 hunk FAILED -- saving rejects to file storage/maria/ma_delete_table.c.rej patching file storage/myisam/mi_delete_table.c error: Bad exit status from /var/tmp/rpm-tmp.oVCNOI (%prep)
Right, sorry. It's a 10.0 patch, it needs some fixing 10.1. Normally we just merge 10.0 into 10.1, but it'll be difficult to extract this patch from the big merge commit. So, here I've created a 10.1 patch for you, see it attached
thank you!
the patch you attached works (built on Fedora 24 and 25) tests are currently running....
Mar 19 13:06:52 Updated: 5:mariadb-libs-10.1.22-2.fc25.20170319.rh.x86_64 Mar 19 13:06:53 Updated: 5:mariadb-10.1.22-2.fc25.20170319.rh.x86_64 Mar 19 13:06:54 Updated: 5:mariadb-server-10.1.22-2.fc25.20170319.rh.x86_64 Mar 19 13:07:02 Updated: 5:mariadb-test-10.1.22-2.fc25.20170319.rh.x86_64 Mar 19 13:07:02 Updated: 5:mariadb-devel-10.1.22-2.fc25.20170319.rh.x86_64 Mar 19 13:07:02 Updated: 5:mariadb-manpages-10.1.22-2.fc25.20170319.rh.x86_64
that one at bottom is failing while i already disabled or even deleted most of irrelevant for our environment with the goal to face only new failures (it would be cool if tests for unbuilt features would not be created by make install at all) _______________________________________________________ [root@testserver:~]$ cat /usr/local/bin/mysql-test.sh #!/usr/bin/dash /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --parallel=4 --max-test-fail=0 --mysqld=--binlog-format=row --force --suites="main-,binlog-,csv-,funcs_1-,funcs_2-,handler-,heap-,maria-,optimizer_unfixed_bugs-,parts-,percona-,roles-,rpl-,sys_vars-,unit-,vcol-" --skip-test-list=/var/lib/mysql/skip-tests.txt' mysql rm -rf /usr/share/mysql-test/var/* _______________________________________________________ mariadb.spec rm -rf \ %{buildroot}/usr/share/mysql-test/plugin/connect \ %{buildroot}/usr/share/mysql-test/plugin/mroonga \ %{buildroot}/usr/share/mysql-test/plugin/sphinx \ %{buildroot}/usr/share/mysql-test/plugin/spider \ %{buildroot}/usr/share/mysql-test/plugin/tokudb \ %{buildroot}/usr/share/mysql-test/suite/archive \ %{buildroot}/usr/share/mysql-test/suite/binlog_encryption \ %{buildroot}/usr/share/mysql-test/suite/encryption \ %{buildroot}/usr/share/mysql-test/suite/federated \ %{buildroot}/usr/share/mysql-test/suite/galera \ %{buildroot}/usr/share/mysql-test/suite/perfschema \ %{buildroot}/usr/share/mysql-test/suite/wsrep _______________________________________________________ [root@testserver:~]$ cat /var/lib/mysql/skip-tests.txt main.mysql_upgrade_view : 2017-01-28 main.subselect : 2017-01-28 binlog.binlog_bug36391 : 2017-01-28 binlog.binlog_checkpoint : 2017-01-27 binlog.binlog_database : 2017-01-28 binlog.binlog_format_switch_in_tmp_table : 2017-01-28 binlog.binlog_incident : 2017-01-27 binlog.binlog_index : 2017-01-27 binlog.binlog_ioerr : 2017-01-27 binlog.binlog_killed : 2017-01-28 binlog.binlog_killed_simulate : 2017-01-27 binlog.binlog_mdev342 : 2017-01-27 binlog.binlog_mdev717 : 2017-01-27 binlog.binlog_mixed_cache_stat : 2017-01-28 binlog.binlog_mixed_load_data : 2017-01-28 binlog.binlog_mysqlbinlog2 : 2017-01-28 binlog.binlog_mysqlbinlog-cp932 : 2017-01-28 binlog.binlog_reset_master : 2017-01-27 binlog.binlog_row_binlog : 2017-01-27 binlog.binlog_sf : 2017-01-28 binlog.binlog_statement_insert_delayed : 2017-01-28 binlog.binlog_stm_binlog : 2017-01-27 binlog.binlog_stm_blackhole : 2017-01-28 binlog.binlog_stm_cache_stat : 2017-01-28 binlog.binlog_stm_ctype_cp932 : 2017-01-28 binlog.binlog_stm_ctype_ucs : 2017-01-28 binlog.binlog_stm_do_db : 2017-01-28 binlog.binlog_stm_drop_tbl : 2017-01-28 binlog.binlog_stm_drop_tmp_tbl : 2017-01-28 binlog.binlog_stm_insert_select : 2017-01-28 binlog.binlog_stm_mix_innodb_myisam : 2017-01-28 binlog.binlog_stm_ps : 2017-01-28 binlog.binlog_stm_unsafe_warning : 2017-01-28 binlog.binlog_stm_user_variables : 2017-01-28 binlog.binlog_tmp_table : 2017-01-28 binlog.binlog_truncate_kill : 2017-01-27 binlog.binlog_unsafe : 2017-01-27 binlog.binlog_write_error : 2017-01-27 binlog.binlog_xa_recover : 2017-01-27 binlog.load_data_stm_view : 2017-01-28 binlog.temptable_uservar_disconnect-7938 : 2017-01-28 funcs_1.is_columns_is_embedded : 2017-01-27 funcs_1.is_columns_myisam_embedded : 2017-01-27 funcs_1.is_columns_mysql_embedded : 2017-01-27 funcs_1.is_engines_archive : 2017-01-27 funcs_1.is_engines_blackhole : 2017-01-27 funcs_1.is_engines_federated : 2017-01-27 funcs_1.is_key_column_usage_embedded : 2017-01-27 funcs_1.is_routines_embedded : 2017-01-27 funcs_1.is_schemata_embedded : 2017-01-27 funcs_1.is_statistics_mysql_embedded : 2017-01-27 funcs_1.is_table_constraints_mysql_embedded : 2017-01-27 funcs_1.is_tables_embedded : 2017-01-27 funcs_1.is_tables_is_embedded : 2017-01-27 funcs_1.is_tables_myisam_embedded : 2017-01-27 funcs_1.is_tables_mysql_embedded : 2017-01-27 funcs_1.is_triggers_embedded : 2017-01-27 funcs_1.is_views_embedded : 2017-01-27 funcs_1.myisam_views-big : 2017-01-27 funcs_1.processlist_priv_ps : 2017-01-28 funcs_1.processlist_val_ps : 2017-01-28 main.alter_table-big : 2017-01-27 main.alter_table_online : 2017-01-27 main.analyze_stmt_orderby : 2017-01-28 main.assign_key_cache-5405 : 2017-01-27 main.auth_named_pipe : 2017-01-27 main.auth_rpl : 2017-01-27 main.blackhole : 2017-01-27 main.blackhole_plugin : 2017-01-27 main.bootstrap : 2017-01-27 main.bug12427262 : 2017-01-27 main.bug39022 : 2017-01-28 main.cache_temporal_4265 : 2017-01-27 main.commit_1innodb : 2017-01-28 main.compound : 2017-01-28 main.count_distinct3 : 2017-01-27 main.crash_commit_before : 2017-01-27 main.create-big : 2017-01-27 main.create_delayed : 2017-01-27 main.create_drop_binlog : 2017-01-27 main.create_drop_udf : 2017-01-27 main.create_or_replace : 2017-01-27 main.create_or_replace2 : 2017-01-27 main.create_or_replace_permission : 2017-01-27 main.create_select_tmp : 2017-01-28 main.create_w_max_indexes_128 : 2017-01-28 main.ctype_cp932_binlog_stm : 2017-01-28 main.ctype_gbk_binlog : 2017-01-28 main.ctype_like_range : 2017-01-27 main.ctype_partitions : 2017-01-27 main.ctype_uca_partitions : 2017-01-27 main.debug_sync : 2017-01-27 main.delayed : 2017-01-27 main.drop_bad_db_type : 2017-01-27 main.drop_debug : 2017-01-27 main.engine_error_in_alter-8453 : 2017-01-27 main.error_simulation : 2017-01-27 main.events_embedded : 2017-01-27 main.events_stress : 2017-01-27 main.explain_json_format_partitions : 2017-01-27 main.explain_non_select : 2017-01-27 main.failed_auth_unixsocket : 2017-01-28 main.filesort_debug : 2017-01-27 main.fix_priv_tables : 2017-01-28 main.flush_read_lock : 2017-01-27 main.flush_read_lock_kill : 2017-01-27 main.func_encrypt_nossl : 2017-01-28 main.func_regexp_pcre_debug : 2017-01-27 main.function_defaults_notembedded : 2017-01-27 main.gis-debug : 2017-01-27 main.grant_cache_ps_prot : 2017-01-28 main.grant_lowercase_fs : 2017-01-28 main.handlersocket : 2017-01-28 main.huge_frm-6224 : 2017-01-27 main.implicit_commit : 2017-01-27 main.information_schema_all_engines : 2017-01-27 main.information_schema-big : 2017-01-27 main.information_schema_part : 2017-01-27 main.innodb_load_xa : 2017-01-27 main.innodb_mysql_lock2 : 2017-01-28 main.innodb_mysql_sync : 2017-01-27 main.ipv4_and_ipv6 : 2017-01-21 main.ipv6 : 2017-01-21 main.kill : 2017-01-27 main.kill_processlist-6619 : 2017-01-27 main.lock : 2017-01-27 main.lock_sync : 2017-01-27 main.log_tables_debug : 2017-01-27 main.lowercase_fs_on : 2017-01-28 main.lowercase_mixed_tmpdir_innodb : 2017-01-28 main.lowercase_table2 : 2017-01-28 main.lowercase_table4 : 2017-01-28 main.mdev6830 : 2017-01-27 main.mdl_sync : 2017-01-27 main.merge-big : 2017-01-27 main.merge_debug : 2017-01-27 main.multi_update : 2017-01-28 main.myisam-big : 2017-01-27 main.myisam_crash_before_flush_keys : 2017-01-27 main.myisam_debug : 2017-01-27 main.myisam_optimize : 2017-01-27 main.mysql_binary_mode : 2017-01-28 main.mysqlbinlog : 2017-01-28 main.mysqlbinlog-innodb : 2017-01-28 main.mysqlbinlog_row_big : 2017-01-27 main.mysql_client_test : 2017-01-27 main.mysql_client_test_comp : 2017-01-27 main.mysql_client_test_nonblock : 2017-01-21 main.mysqld--help : 2017-01-28 main.mysqldump-max : 2017-01-27 main.mysql_locale_posix : 2017-01-28 main.mysql_plugin : 2017-01-28 main.mysqltest_ps : 2017-01-28 main.named_pipe : 2017-01-27 main.no-threads : 2017-01-28 main.partition : 2017-01-27 main.partition_alter : 2017-01-27 main.partition_binlog : 2017-01-27 main.partition_binlog_stmt : 2017-01-27 main.partition_blackhole : 2017-01-27 main.partition_bug18198 : 2017-01-27 main.partition_cache : 2017-01-27 main.partition_cache_innodb : 2017-01-27 main.partition_cache_myisam : 2017-01-27 main.partition_charset : 2017-01-27 main.partition_column : 2017-01-27 main.partition_column_prune : 2017-01-27 main.partition_csv : 2017-01-27 main.partition_datatype : 2017-01-27 main.partition_debug_sync : 2017-01-27 main.partition_disabled : 2017-01-28 main.partition_error : 2017-01-27 main.partition_example : 2017-01-27 main.partition_exchange : 2017-01-27 main.partition_explicit_prune : 2017-01-27 main.partition_grant : 2017-01-27 main.partition_hash : 2017-01-27 main.partition_innodb : 2017-01-27 main.partition_innodb_plugin : 2017-01-27 main.partition_innodb_semi_consistent : 2017-01-27 main.partition_innodb_stmt : 2017-01-27 main.partition_key_cache : 2017-01-27 main.partition_list : 2017-01-27 main.partition_mgm : 2017-01-27 main.partition_mgm_err : 2017-01-27 main.partition_mgm_err2 : 2017-01-27 main.partition_myisam : 2017-01-27 main.partition_not_blackhole : 2017-01-27 main.partition_not_windows : 2017-01-27 main.partition_open_files_limit : 2017-01-27 main.partition_order : 2017-01-27 main.partition_pruning : 2017-01-27 main.partition_range : 2017-01-27 main.partition_rename_longfilename : 2017-01-27 main.partition_symlink : 2017-01-27 main.partition_sync : 2017-01-27 main.partition_truncate : 2017-01-27 main.partition_utf8 : 2017-01-27 main.partition_windows : 2017-01-27 main.perror-win : 2017-01-27 main.plugin : 2017-01-27 main.plugin_auth : 2017-01-27 main.plugin_auth_qa_1 : 2017-01-27 main.plugin_auth_qa : 2017-01-27 main.plugin_auth_qa_2 : 2017-01-27 main.plugin_auth_qa_3 : 2017-01-27 main.plugin_innodb : 2017-01-27 main.plugin_load : 2017-01-27 main.plugin_load_option : 2017-01-27 main.plugin_maturity : 2017-01-27 main.plugin_not_embedded : 2017-01-27 main.processlist : 2017-01-27 main.profiling : 2017-01-27 main.query_cache_debug : 2017-01-27 main.query_cache_ps_ps_prot : 2017-01-28 main.quick_select_4161 : 2017-01-27 main.secure_file_priv_win : 2017-01-27 main.select_debug : 2017-01-27 main.set_statement_debug : 2017-01-27 main.set_statement_notembedded_binlog : 2017-01-27 main.set_statement_profiling : 2017-01-27 main.shm : 2017-01-27 main.show_explain : 2017-01-27 main.show_explain_non_select : 2017-01-27 main.show_explain_ps : 2017-01-27 main.show_profile : 2017-01-27 main.signal_code : 2017-01-27 main.slowlog_enospace-10508 : 2017-01-27 main.sp-code : 2017-01-27 main.sp_sync : 2017-01-27 main.sp_trans_log : 2017-01-28 main.ssl-big : 2017-01-27 main.stat_tables-enospc : 2017-01-27 main.stat_tables_par : 2017-01-27 main.stat_tables_par_innodb : 2017-01-27 main.stat_tables_partition : 2017-01-27 main.stat_tables_rbr : 2017-01-27 main.subselect_debug : 2017-01-27 main.sum_distinct-big : 2017-01-27 main.system_mysql_db_fix40123 : 2017-01-28 main.system_mysql_db_fix50030 : 2017-01-28 main.system_mysql_db_fix50117 : 2017-01-28 main.table_options-5867 : 2017-01-27 main-test_sql_discovery.create : 2017-01-27 main-test_sql_discovery.drop : 2017-01-27 main-test_sql_discovery.mdl_sync : 2017-01-27 main-test_sql_discovery.partition_disabled : 2017-01-27 main-test_sql_discovery.plugin : 2017-01-27 main-test_sql_discovery.rename : 2017-01-27 main.tmp_table_count-7586 : 2017-01-27 main.truncate_badse : 2017-01-27 main.truncate_coverage : 2017-01-27 main.truncate-stale-6500 : 2017-01-27 main.type_datetime_hires : 2017-01-27 main.type_newdecimal-big : 2017-01-27 main.udf : 2017-01-27 main.udf_debug_sync : 2017-01-27 main.udf_notembedded : 2017-01-27 main.udf_query_cache : 2017-01-27 main.udf_skip_grants : 2017-01-27 main.union_crash-714 : 2017-01-27 main.uniques_crash-7912 : 2017-01-27 main.user_var-binlog : 2017-01-28 main.variables_community : 2017-01-27 main.view : 2017-01-27 main.view_debug : 2017-01-27 main.warnings_debug : 2017-01-27 main.windows : 2017-01-28 main.xa_sync : 2017-01-28 maria.encrypt-wrong-key : 2017-01-21 maria.insert_select : 2017-01-28 maria.insert_select-7314 : 2017-01-28 maria.maria : 2017-01-27 maria.maria-big : 2017-01-27 maria.maria-big2 : 2017-01-27 maria.maria-gis-recovery : 2017-01-27 maria.maria_partition : 2017-01-27 maria.maria-partitioning : 2017-01-27 maria.maria-purge : 2017-01-27 maria.maria-recovery : 2017-01-27 maria.maria-recovery2 : 2017-01-27 maria.maria-recovery3 : 2017-01-27 maria.maria-recovery-big : 2017-01-27 maria.maria-recovery-bitmap : 2017-01-27 maria.maria-recovery-rtree-ft : 2017-01-27 maria.max_length : 2017-01-27 maria.truncate : 2017-01-27 optimizer_unfixed_bugs.bug36981 : 2017-01-27 optimizer_unfixed_bugs.bug40992 : 2017-01-27 optimizer_unfixed_bugs.bug41029 : 2017-01-27 optimizer_unfixed_bugs.bug41996 : 2017-01-27 optimizer_unfixed_bugs.bug42991 : 2017-01-27 optimizer_unfixed_bugs.bug43101 : 2017-01-27 optimizer_unfixed_bugs.bug43249 : 2017-01-27 optimizer_unfixed_bugs.bug43360 : 2017-01-27 optimizer_unfixed_bugs.bug43448 : 2017-01-27 optimizer_unfixed_bugs.bug43617 : 2017-01-27 optimizer_unfixed_bugs.bug43618 : 2017-01-27 optimizer_unfixed_bugs.bug45221 : 2017-01-27 parts.insert_ignore-5421 : 2017-01-27 parts.optimizer : 2017-01-27 parts.part_blocked_sql_func_innodb : 2017-01-27 parts.part_blocked_sql_func_myisam : 2017-01-27 parts.part_ctype_utf32 : 2017-01-27 parts.partition_alter1_1_2_innodb : 2017-01-27 parts.partition_alter1_1_2_myisam : 2017-01-27 parts.partition_alter1_1_innodb : 2017-01-27 parts.partition_alter1_1_myisam : 2017-01-27 parts.partition_alter1_2_innodb : 2017-01-27 parts.partition_alter1_2_myisam : 2017-01-27 parts.partition_alter2_1_1_innodb : 2017-01-27 parts.partition_alter2_1_2_innodb : 2017-01-27 parts.partition_alter2_1_maria : 2017-01-27 parts.partition_alter2_1_myisam : 2017-01-27 parts.partition_alter2_2_1_innodb : 2017-01-27 parts.partition_alter2_2_2_innodb : 2017-01-27 parts.partition_alter2_2_maria : 2017-01-27 parts.partition_alter2_2_myisam : 2017-01-27 parts.partition_alter3_innodb : 2017-01-27 parts.partition_alter3_myisam : 2017-01-27 parts.partition_alter4_innodb : 2017-01-27 parts.partition_alter4_myisam : 2017-01-27 parts.partition_auto_increment_archive : 2017-01-27 parts.partition_auto_increment_blackhole : 2017-01-27 parts.partition_auto_increment_innodb : 2017-01-27 parts.partition_auto_increment_maria : 2017-01-27 parts.partition_auto_increment_memory : 2017-01-27 parts.partition_auto_increment_myisam : 2017-01-27 parts.partition_basic_innodb : 2017-01-27 parts.partition_basic_myisam : 2017-01-27 parts.partition_basic_symlink_innodb : 2017-01-27 parts.partition_basic_symlink_myisam : 2017-01-27 parts.partition_bit_innodb : 2017-01-27 parts.partition_bit_myisam : 2017-01-27 parts.partition_char_innodb : 2017-01-27 parts.partition_char_myisam : 2017-01-27 parts.partition_datetime_innodb : 2017-01-27 parts.partition_datetime_myisam : 2017-01-27 parts.partition_debug : 2017-01-27 parts.partition_debug_innodb : 2017-01-27 parts.partition_debug_myisam : 2017-01-27 parts.partition_debug_sync_innodb : 2017-01-27 parts.partition_decimal_innodb : 2017-01-27 parts.partition_decimal_myisam : 2017-01-27 parts.partition_engine_innodb : 2017-01-27 parts.partition_engine_myisam : 2017-01-27 parts.partition_exchange_blackhole : 2017-01-27 parts.partition_exchange_innodb : 2017-01-27 parts.partition_exchange_memory : 2017-01-27 parts.partition_exchange_myisam : 2017-01-27 parts.partition_exch_innodb : 2017-01-27 parts.partition_exch_myisam : 2017-01-27 parts.partition_exch_myisam_innodb : 2017-01-27 parts.partition_exch_qa_10 : 2017-01-27 parts.partition_exch_qa_11 : 2017-01-27 parts.partition_exch_qa_12 : 2017-01-27 parts.partition_exch_qa_13 : 2017-01-27 parts.partition_exch_qa_14 : 2017-01-27 parts.partition_exch_qa_15 : 2017-01-27 parts.partition_exch_qa_1_innodb : 2017-01-27 parts.partition_exch_qa_1_myisam : 2017-01-27 parts.partition_exch_qa : 2017-01-27 parts.partition_exch_qa_2 : 2017-01-27 parts.partition_exch_qa_3 : 2017-01-27 parts.partition_exch_qa_4_innodb : 2017-01-27 parts.partition_exch_qa_4_myisam : 2017-01-27 parts.partition_exch_qa_5_innodb : 2017-01-27 parts.partition_exch_qa_5_myisam : 2017-01-27 parts.partition_exch_qa_6 : 2017-01-27 parts.partition_exch_qa_7_innodb : 2017-01-27 parts.partition_exch_qa_7_myisam : 2017-01-27 parts.partition_exch_qa_8_innodb : 2017-01-27 parts.partition_exch_qa_8_myisam : 2017-01-27 parts.partition_float_innodb : 2017-01-27 parts.partition_float_myisam : 2017-01-27 parts.partition_innodb_status_file : 2017-01-27 parts.partition_int_innodb : 2017-01-27 parts.partition_int_myisam : 2017-01-27 parts.partition_mdev6067 : 2017-01-27 parts.partition_mgm_lc0_innodb : 2017-01-27 parts.partition_mgm_lc0_memory : 2017-01-27 parts.partition_mgm_lc0_myisam : 2017-01-27 parts.partition_mgm_lc1_innodb : 2017-01-27 parts.partition_mgm_lc1_memory : 2017-01-27 parts.partition_mgm_lc1_myisam : 2017-01-27 parts.partition_mgm_lc2_innodb : 2017-01-27 parts.partition_mgm_lc2_memory : 2017-01-27 parts.partition_mgm_lc2_myisam : 2017-01-27 parts.partition_recover_myisam : 2017-01-27 parts.partition_repair_myisam : 2017-01-27 parts.partition_special_innodb : 2017-01-27 parts.partition_special_myisam : 2017-01-27 parts.partition_syntax_innodb : 2017-01-27 parts.partition_syntax_myisam : 2017-01-27 parts.part_supported_sql_func_innodb : 2017-01-27 parts.part_supported_sql_func_myisam : 2017-01-27 parts.rpl_partition : 2017-01-27 percona.innodb_sys_index : 2017-01-27 percona.percona_flush_contiguous_neighbors : 2017-01-27 roles.recursive_dbug : 2017-01-27 roles.rpl_grant_revoke_current_role-8638 : 2017-01-28 rpl.create_or_replace2 : 2017-01-27 rpl.create_or_replace_mix : 2017-01-28 rpl.create_or_replace_statement : 2017-01-28 rpl.kill_hard-6290 : 2017-01-28 rpl.last_insert_id : 2017-01-28 rpl.rpl_000013 : 2017-01-28 rpl.rpl_auto_increment_bug45679 : 2017-01-28 rpl.rpl_auto_increment_update_failure : 2017-01-28 rpl.rpl_begin_commit_rollback : 2017-01-28 rpl.rpl_binlog_corruption : 2017-01-27 rpl.rpl_binlog_errors : 2017-01-27 rpl.rpl_binlog_grant : 2017-01-28 rpl.rpl_blackhole : 2017-01-27 rpl.rpl_bug26395 : 2017-01-27 rpl.rpl_bug33931 : 2017-01-27 rpl.rpl_bug41902 : 2017-01-27 rpl.rpl_cant_read_event_incident : 2017-01-28 rpl.rpl_checksum : 2017-01-27 rpl.rpl_concurrency_error : 2017-01-28 rpl.rpl_conditional_comments : 2017-01-28 rpl.rpl_connection : 2017-01-28 rpl.rpl_corruption : 2017-01-27 rpl.rpl_create_drop_udf : 2017-01-27 rpl.rpl_create_tmp_table_if_not_exists : 2017-01-28 rpl.rpl_current_user : 2017-01-28 rpl.rpl_domain_id_filter_io_crash : 2017-01-27 rpl.rpl_domain_id_filter_master_crash : 2017-01-27 rpl.rpl_domain_id_filter_parallel : 2017-01-27 rpl.rpl_drop_temp : 2017-01-28 rpl.rpl_empty_master_host : 2017-01-28 rpl.rpl_extra_col_slave_innodb : 2017-01-27 rpl.rpl_extra_col_slave_myisam : 2017-01-27 rpl.rpl_filter_dbs_dynamic : 2017-01-28 rpl.rpl_filter_tables_dynamic : 2017-01-28 rpl.rpl_filter_tables_not_exist : 2017-01-28 rpl.rpl_filter_wild_tables_dynamic : 2017-01-28 rpl.rpl_flush_logs : 2017-01-28 rpl.rpl_gtid_crash : 2017-01-27 rpl.rpl_gtid_crash_myisam : 2017-01-27 rpl.rpl_gtid_errorhandling : 2017-01-27 rpl.rpl_gtid_errorlog : 2017-01-27 rpl.rpl_gtid_ignored : 2017-01-27 rpl.rpl_gtid_mdev4473 : 2017-01-28 rpl.rpl_gtid_mdev4474 : 2017-01-28 rpl.rpl_gtid_mdev4484 : 2017-01-27 rpl.rpl_gtid_nobinlog : 2017-01-28 rpl.rpl_gtid_reconnect : 2017-01-27 rpl.rpl_gtid_strict : 2017-01-27 rpl.rpl_heartbeat_basic : 2017-01-28 rpl.rpl_heartbeat_debug : 2017-01-27 rpl.rpl_hrtime : 2017-01-28 rpl.rpl_incident : 2017-01-27 rpl.rpl_init_slave_errors : 2017-01-27 rpl.rpl_innodb_bug28430 : 2017-01-27 rpl.rpl_innodb_mixed_ddl : 2017-01-28 rpl.rpl_innodb_mixed_dml : 2017-01-28 rpl.rpl_ip_mix : 2017-01-21 rpl.rpl_ip_mix2 : 2017-01-21 rpl.rpl_ipv6 : 2017-01-21 rpl.rpl_killed_ddl : 2017-01-27 rpl.rpl_known_bugs_detection : 2017-01-27 rpl.rpl_loaddata : 2017-01-28 rpl.rpl_loaddata_fatal : 2017-01-27 rpl.rpl_loaddata_map : 2017-01-28 rpl.rpl_loaddata_s : 2017-01-28 rpl.rpl_loaddata_symlink : 2017-01-28 rpl.rpl_lost_events_on_rotate : 2017-01-27 rpl.rpl_mariadb_slave_capability : 2017-01-27 rpl.rpl_mdev359 : 2017-01-27 rpl.rpl_mdev382 : 2017-01-28 rpl.rpl_mdev6020 : 2017-01-27 rpl.rpl_mdev8193 : 2017-01-28 rpl.rpl_mixed_binlog_max_cache_size : 2017-01-28 rpl.rpl_mixed_ddl_dml : 2017-01-28 rpl.rpl_mixed_drop_create_temp_table : 2017-01-27 rpl.rpl_mixed_implicit_commit_binlog : 2017-01-27 rpl.rpl_mixed_mixing_engines : 2017-01-27 rpl.rpl_mix_found_rows : 2017-01-28 rpl.rpl_non_direct_mixed_mixing_engines : 2017-01-27 rpl.rpl_non_direct_row_mixing_engines : 2017-01-27 rpl.rpl_non_direct_stm_mixing_engines : 2017-01-27 rpl.rpl_parallel : 2017-01-27 rpl.rpl_parallel2 : 2017-01-27 rpl.rpl_parallel_charset : 2017-01-28 rpl.rpl_parallel_mdev6589 : 2017-01-27 rpl.rpl_parallel_multilevel : 2017-01-27 rpl.rpl_parallel_no_log_slave_updates : 2017-01-27 rpl.rpl_parallel_optimistic : 2017-01-27 rpl.rpl_parallel_optimistic_nobinlog : 2017-01-28 rpl.rpl_parallel_partition : 2017-01-27 rpl.rpl_parallel_retry : 2017-01-27 rpl.rpl_parallel_show_binlog_events_purge_logs : 2017-01-27 rpl.rpl_parallel_temptable : 2017-01-27 rpl.rpl_partition_innodb : 2017-01-27 rpl.rpl_partition_memory : 2017-01-27 rpl.rpl_partition_myisam : 2017-01-27 rpl.rpl_performance_schema : 2017-01-27 rpl.rpl_plugin_load : 2017-01-27 rpl.rpl_rbr_to_sbr : 2017-01-28 rpl.rpl_report_port : 2017-01-28 rpl.rpl_rewrt_db : 2017-01-28 rpl.rpl_rotate_logs : 2017-01-28 rpl.rpl_rotate_purge_deadlock : 2017-01-27 rpl.rpl_row_4_bytes : 2017-01-27 rpl.rpl_row_basic_8partition : 2017-01-27 rpl.rpl_row_corruption : 2017-01-27 rpl.rpl_row_find_row_debug : 2017-01-27 rpl.rpl_row_implicit_commit_binlog : 2017-01-27 rpl.rpl_row_index_choice : 2017-01-27 rpl.rpl_row_mixing_engines : 2017-01-27 rpl.rpl_row_unsafe_funcs : 2017-01-28 rpl.rpl_semi_sync : 2017-01-27 rpl.rpl_semi_sync_after_sync : 2017-01-28 rpl.rpl_semi_sync_after_sync_row : 2017-01-21 rpl.rpl_semi_sync_event : 2017-01-27 rpl.rpl_semi_sync_event_after_sync : 2017-01-21 rpl.rpl_semi_sync_uninstall_plugin : 2017-01-28 rpl.rpl_semi_sync_wait_point : 2017-01-27 rpl.rpl_server_id_ignore : 2017-01-28 rpl.rpl_set_statement : 2017-01-28 rpl.rpl_show_slave_running : 2017-01-27 rpl.rpl_skip_incident : 2017-01-27 rpl.rpl_slave_load_remove_tmpfile : 2017-01-27 rpl.rpl_slave_skip : 2017-01-28 rpl.rpl_slow_query_log : 2017-01-28 rpl.rpl_sp : 2017-01-28 rpl.rpl_stm_000001 : 2017-01-28 rpl.rpl_stm_auto_increment_bug33029 : 2017-01-28 rpl.rpl_stm_binlog_max_cache_size : 2017-01-28 rpl.rpl_stm_conflicts : 2017-01-28 rpl.rpl_stm_drop_create_temp_table : 2017-01-27 rpl.rpl_stm_EE_err2 : 2017-01-28 rpl.rpl_stm_flsh_tbls : 2017-01-28 rpl.rpl_stm_found_rows : 2017-01-28 rpl.rpl_stm_implicit_commit_binlog : 2017-01-27 rpl.rpl_stm_innodb : 2017-01-28 rpl.rpl_stm_loaddata_concurrent : 2017-01-28 rpl.rpl_stm_loadfile : 2017-01-28 rpl.rpl_stm_log : 2017-01-28 rpl.rpl_stm_maria : 2017-01-28 rpl.rpl_stm_max_relay_size : 2017-01-28 rpl.rpl_stm_mixing_engines : 2017-01-27 rpl.rpl_stm_mix_show_relaylog_events : 2017-01-28 rpl.rpl_stm_multi_query : 2017-01-28 rpl.rpl_stm_no_op : 2017-01-28 rpl.rpl_stm_relay_ign_space : 2017-01-28 rpl.rpl_stm_reset_slave : 2017-01-28 rpl.rpl_stm_sql_mode : 2017-01-28 rpl.rpl_stm_start_stop_slave : 2017-01-28 rpl.rpl_stm_stop_middle_group : 2017-01-27 rpl.rpl_stm_until : 2017-01-28 rpl.rpl_stm_user_variables : 2017-01-28 rpl.rpl_stop_slave : 2017-01-27 rpl.rpl_stop_slave_error : 2017-01-28 rpl.rpl_strict_password_validation : 2017-01-28 rpl.rpl_sync : 2017-01-27 rpl.rpl_table_options : 2017-01-27 rpl.rpl_temporal_format_mariadb53_to_mysql56 : 2017-01-28 rpl.rpl_temp_table : 2017-01-28 rpl.rpl_temp_table_mix_row : 2017-01-28 rpl.rpl_test_framework : 2017-01-28 rpl.rpl_trigger : 2017-01-28 rpl.rpl_trunc_temp : 2017-01-28 rpl.rpl_udf : 2017-01-27 rpl.rpl_unsafe_statements : 2017-01-28 rpl.rpl_variables_stm : 2017-01-28 rpl.rpl_view_debug : 2017-01-27 rpl.sec_behind_master-5114 : 2017-01-21 rpl.semisync_future-7591 : 2017-01-27 rpl_semi_sync_master_wait_point : 2017-01-21 rpl.semisync_memleak_4066 : 2017-01-27 sys_vars.debug_basic : 2017-01-27 sys_vars.debug_binlog_fsync_sleep_basic : 2017-01-27 sys_vars.debug_dbug_basic : 2017-01-27 sys_vars.debug_dbug_func : 2017-01-27 sys_vars.debug_dbug_func_notembedded : 2017-01-27 sys_vars.debug_mutex_deadlock_detector_basic : 2017-01-28 sys_vars.debug_sync_basic : 2017-01-27 sys_vars.innodb_buffer_pool_evict_basic : 2017-01-27 sys_vars.innodb_buf_flush_list_now_basic : 2017-01-27 sys_vars.innodb_change_buffering_debug_basic : 2017-01-27 sys_vars.innodb_cleaner_eviction_factor_basic : 2017-01-27 sys_vars.innodb_cleaner_flush_chunk_size_basic : 2017-01-27 sys_vars.innodb_cleaner_free_list_lwm_basic : 2017-01-27 sys_vars.innodb_cleaner_lru_chunk_size_basic : 2017-01-27 sys_vars.innodb_cleaner_max_flush_time_basic : 2017-01-27 sys_vars.innodb_cleaner_max_lru_time_basic : 2017-01-27 sys_vars.innodb_debug_force_scrubbing_basic : 2017-01-27 sys_vars.innodb_disable_background_merge_basic : 2017-01-27 sys_vars.innodb_disallow_writes_basic : 2017-01-27 sys_vars.innodb_doublewrite_batch_size_basic : 2017-01-27 sys_vars.innodb_fatal_semaphore_wait_threshold : 2017-01-27 sys_vars.innodb_fil_make_page_dirty_debug_basic : 2017-01-27 sys_vars.innodb_force_recovery_crash_basic : 2017-01-27 sys_vars.innodb_limit_optimistic_insert_debug_basic : 2017-01-27 sys_vars.innodb_page_hash_locks_basic : 2017-01-27 sys_vars.innodb_priority_cleaner_basic : 2017-01-27 sys_vars.innodb_priority_io_basic : 2017-01-27 sys_vars.innodb_priority_master_basic : 2017-01-27 sys_vars.innodb_priority_purge_basic : 2017-01-27 sys_vars.innodb_purge_run_now_basic : 2017-01-27 sys_vars.innodb_purge_stop_now_basic : 2017-01-27 sys_vars.innodb_saved_page_number_debug_basic : 2017-01-27 sys_vars.innodb_sched_priority_io_basic : 2017-01-27 sys_vars.innodb_sched_priority_master_basic : 2017-01-27 sys_vars.innodb_sched_priority_purge_basic : 2017-01-27 sys_vars.innodb_trx_purge_view_update_only_debug_basic : 2017-01-27 sys_vars.innodb_trx_rseg_n_slots_debug_basic : 2017-01-27 sys_vars.named_pipe_basic : 2017-01-27 sys_vars.performance_schema_basic : 2017-01-27 sys_vars.pfs_accounts_size_basic : 2017-01-27 sys_vars.pfs_digests_size_basic : 2017-01-27 sys_vars.pfs_events_stages_history_long_size_basic : 2017-01-27 sys_vars.pfs_events_stages_history_size_basic : 2017-01-27 sys_vars.pfs_events_statements_history_long_size_basic : 2017-01-27 sys_vars.pfs_events_statements_history_size_basic : 2017-01-27 sys_vars.pfs_events_waits_history_long_size_basic : 2017-01-27 sys_vars.pfs_events_waits_history_size_basic : 2017-01-27 sys_vars.pfs_hosts_size_basic : 2017-01-27 sys_vars.pfs_max_cond_classes_basic : 2017-01-27 sys_vars.pfs_max_cond_instances_basic : 2017-01-27 sys_vars.pfs_max_digest_length_basic : 2017-01-27 sys_vars.pfs_max_file_classes_basic : 2017-01-27 sys_vars.pfs_max_file_handles_basic : 2017-01-27 sys_vars.pfs_max_file_instances_basic : 2017-01-27 sys_vars.pfs_max_mutex_classes_basic : 2017-01-27 sys_vars.pfs_max_mutex_instances_basic : 2017-01-27 sys_vars.pfs_max_rwlock_classes_basic : 2017-01-27 sys_vars.pfs_max_rwlock_instances_basic : 2017-01-27 sys_vars.pfs_max_socket_classes_basic : 2017-01-27 sys_vars.pfs_max_socket_instances_basic : 2017-01-27 sys_vars.pfs_max_stage_classes_basic : 2017-01-27 sys_vars.pfs_max_statement_classes_basic : 2017-01-27 sys_vars.pfs_max_table_handles_basic : 2017-01-27 sys_vars.pfs_max_table_instances_basic : 2017-01-27 sys_vars.pfs_max_thread_classes_basic : 2017-01-27 sys_vars.pfs_max_thread_instances_basic : 2017-01-27 sys_vars.pfs_session_connect_attrs_size_basic : 2017-01-27 sys_vars.pfs_setup_actors_size_basic : 2017-01-27 sys_vars.pfs_setup_objects_size_basic : 2017-01-27 sys_vars.pfs_users_size_basic : 2017-01-27 sys_vars.profiling_basic : 2017-01-27 sys_vars.profiling_history_size_basic : 2017-01-27 sys_vars.rpl_semi_sync_master_enabled_basic : 2017-01-27 sys_vars.rpl_semi_sync_master_timeout_basic : 2017-01-27 sys_vars.rpl_semi_sync_master_trace_level_basic : 2017-01-27 sys_vars.rpl_semi_sync_master_wait_no_slave_basic : 2017-01-27 sys_vars.rpl_semi_sync_master_wait_point_basic : 2017-01-27 sys_vars.rpl_semi_sync_slave_enabled_basic : 2017-01-27 sys_vars.rpl_semi_sync_slave_trace_level_basic : 2017-01-27 sys_vars.shared_memory_base_name_basic : 2017-01-27 sys_vars.shared_memory_basic : 2017-01-27 sys_vars.sysvars_debug : 2017-01-27 sys_vars.sysvars_innodb : 2017-01-27 sys_vars.sysvars_server_embedded : 2017-01-27 sys_vars.sysvars_server_notembedded : 2017-01-21 sys_vars.sysvars_wsrep : 2017-01-27 sys_vars.thread_pool_min_threads_basic : 2017-01-27 sys_vars.transaction_prealloc_size_bug27322 : 2017-01-27 sys_vars.wsrep_auto_increment_control_basic : 2017-01-27 sys_vars.wsrep_causal_reads_basic : 2017-01-27 sys_vars.wsrep_certify_nonpk_basic : 2017-01-27 sys_vars.wsrep_cluster_address_basic : 2017-01-27 sys_vars.wsrep_cluster_name_basic : 2017-01-27 sys_vars.wsrep_convert_lock_to_trx_basic : 2017-01-27 sys_vars.wsrep_data_home_dir_basic : 2017-01-27 sys_vars.wsrep_dbug_option_basic : 2017-01-27 sys_vars.wsrep_debug_basic : 2017-01-27 sys_vars.wsrep_desync_basic : 2017-01-27 sys_vars.wsrep_dirty_reads_basic : 2017-01-27 sys_vars.wsrep_drupal_282555_workaround_basic : 2017-01-27 sys_vars.wsrep_forced_binlog_format_basic : 2017-01-27 sys_vars.wsrep_gtid_domain_id_basic : 2017-01-27 sys_vars.wsrep_gtid_mode_basic : 2017-01-27 sys_vars.wsrep_load_data_splitting_basic : 2017-01-27 sys_vars.wsrep_log_conflicts_basic : 2017-01-27 sys_vars.wsrep_max_ws_rows_basic : 2017-01-27 sys_vars.wsrep_max_ws_size_basic : 2017-01-27 sys_vars.wsrep_mysql_replication_bundle_basic : 2017-01-27 sys_vars.wsrep_node_address_basic : 2017-01-27 sys_vars.wsrep_node_incoming_address_basic : 2017-01-27 sys_vars.wsrep_node_name_basic : 2017-01-27 sys_vars.wsrep_notify_cmd_basic : 2017-01-27 sys_vars.wsrep_on_basic : 2017-01-27 sys_vars.wsrep_osu_method_basic : 2017-01-27 sys_vars.wsrep_provider_basic : 2017-01-27 sys_vars.wsrep_provider_options_basic : 2017-01-27 sys_vars.wsrep_recover_basic : 2017-01-27 sys_vars.wsrep_replicate_myisam_basic : 2017-01-27 sys_vars.wsrep_restart_slave_basic : 2017-01-27 sys_vars.wsrep_retry_autocommit_basic : 2017-01-27 sys_vars.wsrep_slave_fk_checks_basic : 2017-01-27 sys_vars.wsrep_slave_threads_basic : 2017-01-27 sys_vars.wsrep_slave_uk_checks_basic : 2017-01-27 sys_vars.wsrep_sst_auth_basic : 2017-01-27 sys_vars.wsrep_sst_donor_basic : 2017-01-27 sys_vars.wsrep_sst_donor_rejects_queries_basic : 2017-01-27 sys_vars.wsrep_sst_method_basic : 2017-01-27 sys_vars.wsrep_sst_receive_address_basic : 2017-01-27 sys_vars.wsrep_start_position_basic : 2017-01-27 sys_vars.wsrep_sync_wait_basic : 2017-01-27 vcol.vcol_archive : 2017-01-27 vcol.vcol_blackhole : 2017-01-27 vcol.vcol_partition_innodb : 2017-01-27 vcol.vcol_partition_myisam : 2017-01-27 _______________________________________________________ main.subselect_no_mat w4 [ fail ] Test ended at 2017-03-19 13:15:03 CURRENT_TEST: main.subselect_no_mat /usr/bin/mysqltest: Error on delete of '/usr/share/mysql-test/var/4/tmp/subselect.out.file.1' (Errcode: 2 "No such file or directory") mysqltest: In included file "/usr/share/mysql-test/t/subselect.test": included from /usr/share/mysql-test/t/subselect_no_mat.test at line 12: At line 5899: query 'Select (Select Sum(`TestCase`.Revenue) From mysql.slow_log E Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2) ) As `ControlRev` From (Select 3 as Revenue, 4 as TemplateID) As `TestCase` Group By TestCase.Revenue, TestCase.TemplateID' failed: 1242: Subquery returns more than 1 row The result from queries just before the failure was: < snip > 2 SUBQUERY t2 ref b b 5 test.t1.a 2 Using index DROP TABLE t1,t2; # # MDEV-5991: crash in Item_field::used_tables # create table t1 (c int); select exists(select 1 from t1 group by `c` in (select `c` from t1)); exists(select 1 from t1 group by `c` in (select `c` from t1)) 0 drop table t1; # # MDEV-7565: Server crash with Signal 6 (part 2) # Select (Select Sum(`TestCase`.Revenue) From mysql.slow_log E Where TestCase.TemplateID not in (Select 1 from mysql.slow_log where 2=2) ) As `ControlRev` From (Select 3 as Revenue, 4 as TemplateID) As `TestCase` Group By TestCase.Revenue, TestCase.TemplateID; More results from queries before failure can be found in /usr/share/mysql-test/var/4/log/subselect_no_mat.log - saving '/usr/share/mysql-test/var/4/log/main.subselect_no_mat/' to '/usr/share/mysql-test/var/log/main.subselect_no_mat/'