Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29112

Server crashes in dirname_length upon altering partitioned S3 table using NOCOPY algorithm

    XMLWordPrintable

    Details

      Description

      --source include/have_partition.inc
      --source include/have_s3.inc
       
      DROP TABLE IF EXISTS t;
      CREATE TABLE t (a INT) ENGINE=Aria PARTITION BY HASH (a);
      ALTER TABLE t ENGINE=S3;
      ALTER TABLE t FORCE, ALGORITHM=NOCOPY;
       
      # Cleanup
      DROP TABLE t;
      

      10.5 8494758e

      #3  <signal handler called>
      No locals.
      #4  0x0000559ae907c20c in dirname_length (name=0x0) at /data/src/10.5/mysys/mf_dirname.c:34
              pos = 0x0
              gpos = 0xffffffffffffffff <error: Cannot access memory at address 0xffffffffffffffff>
      #5  0x00007faa851c0e58 in s3_create_partitioning_metadata (path=0x7faa84370fce "./test/#sql-alter-3981e3-4", old_path=0x0, action_flag=CHF_DELETE_FLAG) at /data/src/10.5/storage/maria/ha_s3.cc:971
              s3_client = 0x7faa6807f1c8
              s3_info = {access_key = {str = 0x559aead0d028 "minio", length = 5}, secret_key = {str = 0x559aeace8548 "minioadmin", length = 10}, region = {str = 0x559aeab8fba4 "", length = 0}, bucket = {str = 0x559aeab8fb4c "storage-engine", length = 14}, host_name = {str = 0x559aeab8fb0f "127.0.0.1", length = 9}, port = 9000, use_http = 1 '\001', database = {str = 0x7faa8436efb0 "test", length = 4}, table = {str = 0x7faa84370fd5 "#sql-alter-3981e3-4", length = 19}, base_table = {str = 0x7faa84370fd5 "#sql-alter-3981e3-4", length = 19}, tabledef_version = {str = 0x559ae90d9011 <my_strnncoll_binary+74> "\211E\364\203}\364", length = 139640194920240}, protocol_version = 0 '\000'}
              error = 0
              database = "test\000\177\000\000O8\v\351\232U\000\000\020\360\066\204\252\177\000\000X>\312\352\232U\000\000\230\374>\205\252\177\000\000A\000\000\000\377\345\233\270 \323\273\351\232U\000\000\200\374>\205\252\177\000\000P\n\310\352\004\000\000\000\200\374>\205\252\177\000\000\060\360\066\204\252\177\000\000g\333\260\350\232U\000\000x\247\320\352\232U\000\000\200\374>\205\252\177\000\000`\360\066\204\252\177\000\000\006\000\000\000\004\000\000\000`\360\066\204\252\177\000\000\200\017\262\350\232U\000\000\200\374>\205\252\177\000\000\000\237[\352\232U\000\000 \023\310\352\232U\000\000 \023\310\352\232U\000\000\220\360\066\204\252\177\000\000\306\257\261\350\232U\000\000\200"
              tmp_path = 0x7faa84370fce "./test/#sql-alter-3981e3-4"
              _db_stack_frame_ = {func = 0x559ae9422228 "ha_partition::create_partitioning_metadata", file = 0x559ae9421f78 "/data/src/10.5/sql/ha_partition.cc", level = 2147483656, line = -1, prev = 0x7faa8436f1a0}
      #6  0x0000559ae8ad76cc in ha_partition::create_partitioning_metadata (this=0x7faa68077890, path=0x7faa84370fce "./test/#sql-alter-3981e3-4", old_path=0x0, action_flag=CHF_DELETE_FLAG) at /data/src/10.5/sql/ha_partition.cc:730
              part = 0x7faa680792e8
              _db_stack_frame_ = {func = 0x559ae91e4816 "mysql_alter_table", file = 0x559ae91e2118 "/data/src/10.5/sql/sql_table.cc", level = 2147483655, line = -1, prev = 0x7faa8436f740}
      #7  0x0000559ae87bca55 in handler::ha_create_partitioning_metadata (this=0x7faa68077890, name=0x7faa84370fce "./test/#sql-alter-3981e3-4", old_name=0x0, action_flag=CHF_DELETE_FLAG) at /data/src/10.5/sql/handler.cc:5159
              __PRETTY_FUNCTION__ = "int handler::ha_create_partitioning_metadata(const char*, const char*, chf_create_flags)"
      #8  0x0000559ae854c95f in cleanup_table_after_inplace_alter (table=0x7faa8436f820) at /data/src/10.5/sql/sql_table.cc:9869
      No locals.
      #9  0x0000559ae854f153 in mysql_alter_table (thd=0x7faa68000db8, new_db=0x7faa68005818, new_name=0x7faa68005c38, create_info=0x7faa84371370, table_list=0x7faa68015400, alter_info=0x7faa843712a0, order_num=0, order=0x0, ignore=false, if_exists=false) at /data/src/10.5/sql/sql_table.cc:10774
              ha_alter_info = {create_info = 0x7faa84371370, alter_info = 0x7faa843712a0, key_info_buffer = 0x7faa68017950, key_count = 0, index_drop_count = 0, index_drop_buffer = 0x7faa68017a48, index_add_count = 0, index_add_buffer = 0x7faa68017a48, rename_keys = {m_root = 0x7faa68006a38, m_array = 0x0, m_size = 0, m_capacity = 0}, handler_ctx = 0x7faa68017a48, group_commit_ctx = 0x7faa68017a60, handler_flags = 576460752303424512, partition_flags = 140369866001848, modified_part_info = 0x7faa68015cc0, ignore = false, online = false, inplace_supported = HA_ALTER_INPLACE_NOT_SUPPORTED, unsupported_reason = 0x0, error_if_not_empty = false, mdl_exclusive_after_prepare = false}
              altered_share = {table_category = TABLE_CATEGORY_TEMPORARY, name_hash = {key_offset = 0, key_length = 0, blength = 0, records = 0, flags = 0, array = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0, m_psi_key = 0, malloc_flags = 0}, get_key = 0x0, hash_function = 0x0, free = 0x0, charset = 0x0}, mem_root = {free = 0x7faa68083a78, used = 0x7faa68077008, pre_alloc = 0x0, min_malloc = 32, block_size = 985, block_num = 7, first_block_usage = 0, error_handler = 0x559ae85a2cf3 <sql_alloc_error_handler()>, m_psi_key = 8}, keynames = {count = 0, name = 0x0, type_names = 0x7faa68083b00, type_lengths = 0x7faa68083b18}, fieldnames = {count = 1, name = 0x0, type_names = 0x7faa68083af0, type_lengths = 0x7faa68083b10}, intervals = 0x0, LOCK_ha_data = {m_mutex = {global = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, file = 0x0, name = 0x0, line = 0, count = 0, create_flags = 0, active_flags = 0, id = 0, thread = 0, locked_mutex = 0x0, used_mutex = 0x0, prev = 0x0, next = 0x0}, m_psi = 0x0}, LOCK_share = {m_mutex = {global = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, mutex = {__data = {__lock = 0, __count = 0, __owner = 0, __nusers = 0, __kind = 0, __spins = 0, __elision = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = '\000' <repeats 39 times>, __align = 0}, file = 0x0, name = 0x0, line = 0, count = 0, create_flags = 0, active_flags = 0, id = 0, thread = 0, locked_mutex = 0x0, used_mutex = 0x0, prev = 0x0, next = 0x0}, m_psi = 0x0}, tdc = 0x0, tabledef_version = {str = 0x7faa68083a90 "R\372\333X\005\002\021\355\272\034\004\003", length = 16}, option_list = 0x0, option_struct = 0x7faa68083c18, field = 0x7faa68083ae0, found_next_number_field = 0x0, key_info = 0x0, check_constraints = 0x7faa68083af0, blob_field = 0x0, vcol_defs = {str = 0x7faa68083b30 " p\ah\252\177", length = 0}, stats_cb = {stats_state = {state = 0}, hist_state = {state = 0}, mem_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 0, block_size = 0, block_num = 0, first_block_usage = 0, error_handler = 0x0, m_psi_key = 0}, table_stats = 0x0, total_hist_size = 0}, default_values = 0x7faa68083ad0 "\377", comment = {str = 0x7faa68083ad8 "", length = 0}, table_charset = 0x559ae9c5fa40 <my_charset_latin1>, check_set = 0x0, all_set = {bitmap = 0x7faa68083c28, last_word_ptr = 0x7faa68083c28, mutex = 0x0, last_word_mask = 4294967294, n_bits = 1}, table_cache_key = {str = 0x7faa68015ad8 "test", length = 0}, db = {str = 0x7faa68015ad8 "test", length = 4}, table_name = {str = 0x7faa680153c8 "t", length = 1}, path = {str = 0x7faa84370fce "./test/#sql-alter-3981e3-4", length = 26}, normalized_path = {str = 0x7faa84370fce "./test/#sql-alter-3981e3-4", length = 26}, connect_string = {str = 0x7faa68083aa0 "", length = 0}, keys_in_use = {buffer = {0}}, keys_for_keyread = {buffer = {0}}, min_rows = 0, max_rows = 0, avg_row_length = 0, mysql_version = 100517, reclength = 5, stored_rec_length = 5, db_plugin = 0x7faa68162808, row_type = ROW_TYPE_DEFAULT, table_type = TABLE_TYPE_NORMAL, tmp_table = INTERNAL_TMP_TABLE, transactional = HA_CHOICE_UNDEF, page_checksum = HA_CHOICE_UNDEF, key_block_size = 0, stats_sample_pages = 0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, null_bytes = 1, last_null_bit_pos = 2, null_bytes_for_compare = 1, fields = 1, stored_fields = 1, virtual_fields = 0, virtual_not_stored_blob_fields = 0, null_fields = 1, blob_fields = 0, varchar_fields = 0, default_fields = 0, visible_fields = 1, default_expressions = 0, table_check_constraints = 0, field_check_constraints = 0, rec_buff_length = 8, keys = 0, key_parts = 0, ext_key_parts = 0, max_key_length = 0, max_unique_length = 0, uniques = 0, db_create_options = 8, db_options_in_use = 8, db_record_offset = 1, rowid_field_offset = 0, primary_key = 64, next_number_index = 0, next_number_key_offset = 0, next_number_keypart = 0, error = OPEN_FRM_OK, open_errno = 0, column_bitmap_size = 4, frm_version = 10 '\n', check_set_initialized = TABLE_SHARE::NO_V_KEYS, use_ext_keys = false, null_field_first = true, system = false, not_usable_by_query_cache = true, online_backup = false, no_replicate = false, crashed = false, is_view = false, can_cmp_whole_record = true, table_creation_was_logged = false, non_determinstic_insert = false, has_update_default_function = false, can_do_row_logging = false, long_unique_table = false, table_map_id = 28, incompatible_version = 0, view_def = 0x0, sequence = 0x0, auto_partitioned = false, partition_info_str = 0x7faa68083ab0 " PARTITION BY HASH (`a`)", partition_info_str_len = 24, partition_info_buffer_size = 24, default_part_plugin = 0x7faa68182fb8, versioned = VERS_UNDEFINED, vers = {start_fieldno = 0, end_fieldno = 0, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x559ae91f01fa "SYSTEM_TIME", length = 11}, <No data fields>}, <No data fields>}, constr_name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, unique_keys = 0}, period = {start_fieldno = 0, end_fieldno = 0, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, constr_name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, unique_keys = 0}, table_field_def_cache = 0x0, ha_share = 0x7faa6807ef20, m_psi = 0x0, frm_image = 0x0}
              altered_table = {s = 0x7faa843701d0, file = 0x7faa68077890, next = 0x0, prev = 0x0, share_all_next = 0x0, share_all_prev = 0x0, global_free_next = 0x0, global_free_prev = 0x0, instance = 0, in_use = 0x7faa68000db8, record = {0x7faa68087e88 "\377", 0x7faa68087e88 "\377", 0x7faa68087e88 "\377"}, write_row_record = 0x0, insert_values = 0x0, covering_keys = {buffer = {0}}, intersect_keys = {buffer = {0}}, keys_in_use_for_query = {buffer = {0}}, keys_in_use_for_group_by = {buffer = {0}}, keys_in_use_for_order_by = {buffer = {0}}, constraint_dependent_keys = {buffer = {0}}, key_info = 0x0, field = 0x7faa68087e90, vfield = 0x0, default_field = 0x0, next_number_field = 0x0, found_next_number_field = 0x0, check_constraints = 0x0, triggers = 0x0, pos_in_table_list = 0x0, pos_in_locked_tables = 0x0, internal_tables = 0x0, group = 0x0, alias = {<Charset> = {m_charset = 0x559ae9bbd320 <my_charset_bin>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x7faa68087e70 "t", str_length = 1}, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}, null_flags = 0x7faa68087e88 "\377", def_read_set = {bitmap = 0x7faa680793f8, last_word_ptr = 0x7faa680793f8, mutex = 0x0, last_word_mask = 4294967294, n_bits = 1}, def_write_set = {bitmap = 0x7faa680793fc, last_word_ptr = 0x7faa680793fc, mutex = 0x0, last_word_mask = 4294967294, n_bits = 1}, tmp_set = {bitmap = 0x7faa68079404, last_word_ptr = 0x7faa68079404, mutex = 0x0, last_word_mask = 4294967294, n_bits = 1}, def_rpl_write_set = {bitmap = 0x7faa68079410, last_word_ptr = 0x7faa68079410, mutex = 0x0, last_word_mask = 4294967294, n_bits = 1}, eq_join_set = {bitmap = 0x7faa68079408, last_word_ptr = 0x7faa68079408, mutex = 0x0, last_word_mask = 4294967294, n_bits = 1}, cond_set = {bitmap = 0x7faa6807940c, last_word_ptr = 0x7faa6807940c, mutex = 0x0, last_word_mask = 4294967294, n_bits = 1}, read_set = 0x7faa84370510, write_set = 0x7faa84370510, rpl_write_set = 0x0, has_value_set = {bitmap = 0x7faa68079400, last_word_ptr = 0x7faa68079400, mutex = 0x0, last_word_mask = 4294967294, n_bits = 1}, query_id = 0, collected_stats = 0x0, used_stat_records = 0, opt_range_keys = {buffer = {0}}, opt_range = 0x7faa68087ea0, const_key_parts = 0x7faa68087ea0, opt_range_condition_rows = 0, cond_selectivity = 1, cond_selectivity_sampling_explain = 0x0, map = 0, lock_position = 0, lock_data_start = 0, lock_count = 0, tablenr = 0, used_fields = 0, temp_pool_slot = 0, status = 3, db_stat = 0, derived_select_number = 0, maybe_null = 0, current_lock = 2, copy_blobs = false, next_number_field_updated = false, null_row = false, no_rows_with_nulls = false, null_catch_flags = 0 '\000', force_index = false, force_index_order = false, force_index_group = false, distinct = false, const_table = false, no_rows = false, used_for_duplicate_elimination = false, keep_row_order = false, no_keyread = false, locked_by_logger = false, locked_by_name = false, fulltext_searched = false, no_cache = false, open_by_handler = false, auto_increment_field_not_null = false, insert_or_update = false, alias_name_used = false, get_fields_in_item_tree = false, vcol_refix_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x559ae9d7cb00 <end_of_list>, last = 0x7faa8436fae0, elements = 0}, <No data fields>}, m_needs_reopen = false, created = false, master_had_triggers = false, reginfo = {join_tab = 0x0, lock_type = TL_UNLOCK, not_exists_optimize = false, impossible_range = false}, mem_root = {free = 0x7faa68079178, used = 0x7faa68087e58, pre_alloc = 0x0, min_malloc = 32, block_size = 984, block_num = 10, first_block_usage = 1, error_handler = 0x559ae85a2cf3 <sql_alloc_error_handler()>, m_psi_key = 62}, blob_storage = 0x0, grant = {grant_table_user = 0x0, grant_table_role = 0x0, version = 0, privilege = NO_ACL, want_privilege = NO_ACL, orig_want_privilege = NO_ACL, m_internal = {m_schema_lookup_done = false, m_schema_access = 0x0, m_table_lookup_done = false, m_table_access = 0x0}}, expr_arena = 0x0, part_info = 0x7faa68087fc8, all_partitions_pruned_away = false, max_keys = 0, stats_is_read = false, histograms_are_read = false, mdl_ticket = 0x0, spl_opt_info = 0x0, keys_usable_for_splitting = {buffer = {0}}, notnull_cond = 0x0, with_impossible_ranges = {buffer = {0}}, range_rowid_filter_cost_info_elems = 0, range_rowid_filter_cost_info = 0x0, range_rowid_filter_cost_info_ptr = 0x0, vers_write = false}
              use_inplace = true
              engine_changed = false
              error = false
              no_ha_table = true
              table = 0x7faa68080688
              new_table = 0x0
              partition_changed = false
              fast_alter_partition = false
              key_info = 0x7faa68017950
              key_count = 0
              varchar = false
              table_creation_was_logged = true
              binlog_as_create_select = false
              log_if_exists = true
              tables_opened = 1
              new_db_type = 0x559aeadaa098
              old_db_type = 0x559aeadaa098
              copied = 0
              deleted = 0
              frm = {str = 0x7faa6810ab98 "\376\001\n\024\026", length = 463}
              index_file = "\000\376\066\204\252\177\000\000\375`\r\351\232U\000\000\000\376\066\204\252\177\000\000\340\f\000h\252\177\000\000\340\f\000h\252\177\000\000\270\f\000h\001\000\000\000@\000\067\204\252\177\000\000oS\r\351\232U\000\000\060\376\066\204\252\177\000\000p\000\067\204\252\177\000\000\n\000\000\000\252\177\000\000\340\f\000h\252\177\000\000\000\000\000\000\000\000\000\000\362_\n\351\232U\000\000`\376\066\204\252\177\000\000\036a\n\351\000\000\000\000\220\372\036\351\232U\000\000\000\000\000\000\000\000\000\000\200\376\066\204\252\177\000\000\036a\n\351\000\000\001\000\240\376\066\204\252\177\000\000\375`\r\351\232U\000\000\240\376\066\204\252\177\000\000\340\f\000h\252\177\000\000\340\f\000h\252\177\000\000"...
              data_file = "\f\000\000\200\324\000\000\000\000\202\060H\363<\"\226@\000\067\204\252\177\000\000/H\t\351\232U\000\000\000\000\000\000\000\000\000\000\220\000\067\204\252\177\000\000@\000\067\204\252\177\000\000\000\266\347\352\232U\000\000e\372\036\351\232U\000\000\270\370\036\351\232U\000\000\v\000\000\200\254\001\000\000p\000\067\204\252\177\000\000\a\000\000\000\000\000\000\000\000\202\060H\363<\"\226\340\000\067\204\252\177\000\000h!X\350\232U\000\000p\000\067\204\252\177\000\000\240\a7\204\252\177\000\000\220\000\067\204", '\000' <repeats 12 times>, "\220\372\036\351\232U\000\000\270\370\036\351\232U\000\000\n\000\000\200\366\001\000\000\000\001\067\204\252\177", '\000' <repeats 26 times>...
              target_mdl_request = {type = MDL_NOT_INITIALIZED, duration = 32682, next_in_list = 0x7faa843701b0, prev_in_list = 0x7faa843715e0, ticket = 0x0, key = {m_length = 64608, m_db_name_length = 33846, m_hash_value = 0, m_ptr = "\001\000\000\000\000\000\000\000\327\303\005h\252\177\000\000\300\254\005h\252\177\000\000\270\r\000h\252\177\000\000\340\025\067\204\252\177\000\000\250l\001h\252\177\000\000\375`\r\351\232U\000\000\320`\001h\252\177\000\000Xm\001h\000\000\000\000-\224a\351\232U\000\000\000\000\000\000\000\000\000\000-\224a\351\232U\000\000\000\000\000\000\000\000\000\000\300\374\066\204\252\177\000\000\036a\n\351\000\000\001\000\340\374\066\204\252\177\000\000\375`\r\351\232U\000\000\340\374\066\204\252\177\000\000\340\f\000h\252\177\000\000\340\f\000h\252\177\000\000\270\f\000h\001\000\000\000 \377\066\204\252\177\000\000oS\r\351\000\000\000\000-\224a\351\232U\000\000\000\000\000\000\000\000\000\000"...}, m_src_file = 0x7faa8436fde0 "", m_src_line = 3909771550}
              mdl_ticket = 0x7faa681bf290
              alter_prelocking_strategy = {<Prelocking_strategy> = {_vptr.Prelocking_strategy = 0x559ae9a35fd0 <vtable for Alter_table_prelocking_strategy+16>}, <No data fields>}
              _db_stack_frame_ = {func = 0x559ae920e59d "Sql_cmd_alter_table::execute", file = 0x559ae920e318 "/data/src/10.5/sql/sql_alter.cc", level = 2147483654, line = -1, prev = 0x7faa84371280}
              table_kind = 0
              __PRETTY_FUNCTION__ = "bool mysql_alter_table(THD*, const LEX_CSTRING*, const LEX_CSTRING*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, uint, ORDER*, bool, bool)"
              alter_ctx = {implicit_default_value_error_field = 0x0, error_if_not_empty = false, tables_opened = 1, db = {str = 0x7faa68015ad8 "test", length = 4}, table_name = {str = 0x7faa680153c8 "t", length = 1}, alias = {str = 0x7faa680153c8 "t", length = 1}, new_db = {str = 0x7faa68015ad8 "test", length = 4}, new_name = {str = 0x7faa680153c8 "t", length = 1}, new_alias = {str = 0x7faa680153c8 "t", length = 1}, tmp_name = {str = 0x7faa84370b0b "#sql-alter-3981e3-4", length = 19}, tmp_buff = "Reco\376\377\377\377\000\000\000\000\340\002\000\000\000\000\000\000\340\002", '\000' <repeats 14 times>, " 0", '\000' <repeats 18 times>, "Xv\004h\252\177\000\000\070\244\005h\252\177\000\000\000\000\000\000\000\000\000", fk_error_if_delete_row = false, fk_error_id = 0x0, fk_error_table = 0x0, modified_primary_key = false, new_filename = "./test/t.frm\000\000\000\200\027\067\204\252\177\000\000\200\027\067\204\252\177\000\000\340v\004h\252\177\000\000\370v\004h\252\177\000\000\001", '\000' <repeats 15 times>, "\320v\004h\252\177\000\000\360v\004h\252\177", '\000' <repeats 18 times>, "eFl\211\252\177", '\000' <repeats 26 times>, " \n7\204\252\177\000\000\254|l\211\252\177\000\000\341Ul\211\252\177", '\000' <repeats 18 times>, "\070\203l\211\252\177\000\000\320\000\000\000\000\000\000\000\v\001", '\000' <repeats 54 times>..., new_alias_buff = '\000' <repeats 14 times>, "\210Bl\211\252\177\000\000\000\000\000\000\000\000\000\000(Gl\211\252\177\000\000\000\000\000\000\000\000\000\000(\022\270\351\232U\000\000\000\000\000\000\000\000\000@\340\v7\204\252\177\000\000\354\210w\351\232U\000\000\341Ul\211\252\177", '\000' <repeats 18 times>, "\350\327~\351\232U\000\000\336\351\000\000\000\000\000\000\270\064\000\000\000\000\000\000`\017\067\204\252\177\000\000\000\v7\204\252\177\000\000P\216_\211\252\177\000\000\000\300\004\000\000\000\000\000\366\065l\211\252\177\000\000\020\v7\204\252\177\000\000P\v7\204\252\177\000\000\061\000\000\000\000\000\000\000`p\365", tmp_name_buff = "#sql-alter-3981e3-4\000\000\200\201\365\211\252\177\000\000\241Rb\211\252\177\000\000\310\377\377\377\377\377\377\377\001", '\000' <repeats 16 times>, "Ql\211\252\177\000\000\000\260\260\347\232U\000\000 \207\365\211\252\177\000\000@\260\260\347\232U\000\000\f\000l\211\252\177\000\000\061", '\000' <repeats 15 times>, "\001\000\000\000\000\000\000\000\240\065\067\204\252\177", '\000' <repeats 11 times>, "\202\060H\363<\"\226\000\000\000\000\000\000\000\000\260\f7\204\252\177\000\000X\r7\204\252\177\000\000\260\f7\204\252\177\000\000`\017\067\204\252\177\000\000\061\376C\350", path = "./test/t\000\000\000\000\341al\211\252\177\000\000\061\376C\350\232U", '\000' <repeats 18 times>, "\030\355C\350\232U\000\000|\035\202\351\232U\000\000\001\000\000\000\000\000\000\000\300!7\204\252\177\000\000>\334~\351\232U\000\000\260\f7\204\252\177\000\000|\035\202\351\232U\000\000\221\035\202\351\232U\000\000I\334~\351\232U\000\000\240\r7\204\252\177\000\000\310%l\211\252\177\000\000\000\000\000\000\000\000\000\000h\f7\204\252\177\000\000\000\000\000\000\000\000\000\000\335\251\235\351\232U\000\000\033\377\001\000\000\000\000\000\260\f7\204\252\177\000\000P\017\067\204\252\177\000\000\177\216_\211\252\177\000\000\260\f7\204"..., new_path = "./test/t\000\000\000oS\r\351\232U\000\000\000\000\000\000\000\000\000\000`\020\067\204\252\177\000\000\a\000\000\000\000\000\000\000\340\f\000h\000\000\000\000-H\034\351\232U\000\000\000\000\000\000\000\000\000\000\060\016\067\204\252\177\000\000\036a\n\351\000\000\001\000P\016\067\204\252\177\000\000\375`\r\351\000\000\000\000\260\364\031\351\232U\000\000\000\000\000\000\000\000\000\000`\016\067\204\252\177\000\000\036a\n\351\000\000\001\000\200\016\067\204\252\177\000\000\375`\r\351\232U\000\000\200\016\067\204\252\177\000\000\340\f\000h\252\177\000\000\340\f\000h\252\177\000\000\270\f\000h\001\000\000\000\300\020\067\204\252\177\000\000oS\r\351\232U\000\000\300\016\067\204\252"..., tmp_path = "./test/#sql-alter-3981e3-4\000\001\271\352\232U\000\000@\020\067\204\252\177\000\000\267\b\262\350\232U\000\000\367)\225y\375\177\000\000@\372\305\351\232U\000\000P\020\067\204\252\177\000\000\000\000\000\000\000\000\000\000\260\364\031\351\232U\000\000\000\000\000\000\000\000\000\000P\020\067\204\252\177\000\000pW\000h\252\177\000\000`\020\067\204\252\177\000\000 _N\350\232U\000\000p\020\067\204\252\177\000\000pW\000h\252\177\000\000\300\020\067\204\252\177\000\000\027Rl\350\232U\000\000\330Z\001h\252\177\000\000\020W\001h\252\177\000\000\300\020\067\204\252\177\000\000\252^8\350\232U\000\000\000\000\000\000\200\377\377\377"..., tmp_table = false}
              backup_name_buff = "\001", '\000' <repeats 119 times>, "x:\bh\252\177\000\000\bp\ah\252\177\000\000\000\000\000\000\000\000\000\000 \000\000\000\000\000\000\000\331\003\000\000\000\000\000\000\a\000\000\000\000\000\000\000\363,Z\350\232U\000\000\b", '\000' <repeats 24 times>...
              backup_name = {str = 0x7faa843701d0 "\001", length = 140369866487952}
      #10 0x0000559ae85f6485 in Sql_cmd_alter_table::execute (this=0x7faa68015ae8, thd=0x7faa68000db8) at /data/src/10.5/sql/sql_alter.cc:543
              lex = 0x7faa68004e98
              select_lex = 0x7faa68005770
              first_table = 0x7faa68015400
              used_engine = false
              __PRETTY_FUNCTION__ = "virtual bool Sql_cmd_alter_table::execute(THD*)"
              create_info = {<Table_scope_and_contents_source_st> = {<Table_scope_and_contents_source_pod_st> = {alter_table_convert_to_charset = 0x0, tabledef_version = {str = 0x7faa68017960 "R\372\333X\005\002\021\355\272\034\004\003", length = 16}, connect_string = {str = 0x0, length = 0}, comment = {str = 0x7faa68080278 "", length = 0}, alias = {str = 0x7faa680153c8 "t", length = 1}, password = 0x0, tablespace = 0x0, data_file_name = 0x0, index_file_name = 0x0, max_rows = 0, min_rows = 0, auto_increment_value = 0, table_options = 8, avg_row_length = 0, used_fields = 0, key_block_size = 0, expression_length = 0, field_check_constraints = 0, stats_sample_pages = 0, null_bits = 2, options = 72, merge_insert_method = 0, extra_size = 43, db_type = 0x559aeadaa098, row_type = ROW_TYPE_DEFAULT, transactional = HA_CHOICE_UNDEF, storage_media = HA_SM_DEFAULT, page_checksum = HA_CHOICE_UNDEF, option_list = 0x0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, varchar = false, sequence = false, check_constraint_list = 0x7faa84371318, option_struct = 0x7faa68017950, fields_option_struct = 0x7faa68015fc0, indexes_option_struct = 0x7faa68015fc8, table = 0x0, pos_in_locked_tables = 0x0, merge_list = 0x0, mdl_ticket = 0x0, table_was_deleted = false, seq_create_info = 0x0}, vers_info = {<Table_period_info> = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x559ae91b3fa6 "SYSTEM_TIME", length = 11}, <No data fields>}, <No data fields>}, period = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, create_if_not_exists = false, constr = 0x0, unique_keys = 0}, as_row = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, versioned_fields = false, unversioned_fields = false}, period_info = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, period = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, create_if_not_exists = false, constr = 0x0, unique_keys = 0}}, <Schema_specification_st> = {default_table_charset = 0x559ae9c5fa40 <my_charset_latin1>, schema_comment = 0x0}, alter_info = 0x7faa843712a0}
              alter_info = {drop_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x559ae9d7cb00 <end_of_list>, last = 0x7faa843712a0, elements = 0}, <No data fields>}, alter_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x559ae9d7cb00 <end_of_list>, last = 0x7faa843712b8, elements = 0}, <No data fields>}, key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x559ae9d7cb00 <end_of_list>, last = 0x7faa843712d0, elements = 0}, <No data fields>}, alter_rename_key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x559ae9d7cb00 <end_of_list>, last = 0x7faa843712e8, elements = 0}, <No data fields>}, create_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7faa680160c0, last = 0x7faa680160c0, elements = 1}, <No data fields>}, check_constraint_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x559ae9d7cb00 <end_of_list>, last = 0x7faa84371318, elements = 0}, <No data fields>}, flags = 1024, partition_flags = 0, keys_onoff = Alter_info::LEAVE_AS_IS, partition_names = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x559ae9d7cb00 <end_of_list>, last = 0x7faa84371348, elements = 0}, <No data fields>}, num_parts = 0, requested_algorithm = Alter_info::ALTER_TABLE_ALGORITHM_NOCOPY, requested_lock = Alter_info::ALTER_TABLE_LOCK_DEFAULT}
              priv = (SELECT_ACL | INSERT_ACL | UPDATE_ACL | DELETE_ACL | CREATE_ACL | DROP_ACL | RELOAD_ACL | SHUTDOWN_ACL | PROCESS_ACL | FILE_ACL | GRANT_ACL | REFERENCES_ACL | INDEX_ACL | ALTER_ACL | SHOW_DB_ACL | SUPER_ACL | CREATE_TMP_ACL | LOCK_TABLES_ACL | EXECUTE_ACL | REPL_SLAVE_ACL | BINLOG_MONITOR_ACL | CREATE_VIEW_ACL | SHOW_VIEW_ACL | CREATE_PROC_ACL | ALTER_PROC_ACL | CREATE_USER_ACL | EVENT_ACL | TRIGGER_ACL | CREATE_TABLESPACE_ACL | DELETE_HISTORY_ACL | SET_USER_ACL | FEDERATED_ADMIN_ACL | CONNECTION_ADMIN_ACL | READ_ONLY_ADMIN_ACL | REPL_SLAVE_ADMIN_ACL | REPL_MASTER_ADMIN_ACL | BINLOG_ADMIN_ACL | BINLOG_REPLAY_ACL | SLAVE_MONITOR_ACL)
              priv_needed = ALTER_ACL
              result = false
              _db_stack_frame_ = {func = 0x559ae91c1998 "mysql_execute_command", file = 0x559ae91c0d20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7faa84371e00}
      #11 0x0000559ae844dc00 in mysql_execute_command (thd=0x7faa68000db8) at /data/src/10.5/sql/sql_parse.cc:6056
              res = 0
              up_result = 0
              lex = 0x7faa68004e98
              select_lex = 0x7faa68005770
              first_table = 0x7faa68015400
              all_tables = 0x7faa68015400
              unit = 0x7faa68004f60
              have_table_map_for_update = false
              rpl_filter = 0x0
              _db_stack_frame_ = {func = 0x559ae91c2cef "mysql_parse", file = 0x559ae91c0d20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7faa84372210}
              __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)"
              ots = {ctx = 0x7faa68004b60, traceable = false}
              trace_command = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x559ae9a33d28 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
              trace_command_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x559ae9a33d08 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
              orig_binlog_format = BINLOG_FORMAT_MIXED
              orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
      #12 0x0000559ae8453cf9 in mysql_parse (thd=0x7faa68000db8, rawbuf=0x7faa68015310 "ALTER TABLE t FORCE, ALGORITHM=NOCOPY", length=37, parser_state=0x7faa843723d0, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8100
              found_semicolon = 0x0
              error = 32682
              lex = 0x7faa68004e98
              err = false
              _db_stack_frame_ = {func = 0x559ae91c11b2 "dispatch_command", file = 0x559ae91c0d20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7faa843723b0}
              __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)"
      #13 0x0000559ae843fe32 in dispatch_command (command=COM_QUERY, thd=0x7faa68000db8, packet=0x7faa6800b5c9 "ALTER TABLE t FORCE, ALGORITHM=NOCOPY", packet_length=37, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1891
              packet_end = 0x7faa68015335 ""
              parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7faa68000db8, m_ptr = 0x7faa68015336 "\004", m_tok_start = 0x7faa68015336 "\004", m_tok_end = 0x7faa68015336 "\004", m_end_of_query = 0x7faa68015335 "", m_tok_start_prev = 0x7faa68015335 "", m_buf = 0x7faa68015310 "ALTER TABLE t FORCE, ALGORITHM=NOCOPY", m_buf_length = 37, m_echo = true, m_echo_saved = 28, m_cpp_buf = 0x7faa68015390 "ALTER TABLE t FORCE, ALGORITHM=NOCOPY", m_cpp_ptr = 0x7faa680153b5 "", m_cpp_tok_start = 0x7faa680153b5 "", m_cpp_tok_start_prev = 0x7faa680153b5 "", m_cpp_tok_end = 0x7faa680153b5 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7faa68000ce0 "r\276\221y\375\177", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (DISCARD_COMMENT | unknown: 0x7fa8), m_cpp_text_start = 0x7faa680153af "NOCOPY", m_cpp_text_end = 0x7faa680153b5 "", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7faa680048f0}
              net = 0x7faa680010e0
              error = false
              do_end_of_statement = true
              _db_stack_frame_ = {func = 0x559ae91c0f1d "do_command", file = 0x559ae91c0d20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7faa84372c80}
              drop_more_results = false
              __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)"
              __FUNCTION__ = "dispatch_command"
              res = <optimized out>
      #14 0x0000559ae843e68c in do_command (thd=0x7faa68000db8) at /data/src/10.5/sql/sql_parse.cc:1375
              return_value = false
              packet = 0x7faa6800b5c8 "\003ALTER TABLE t FORCE, ALGORITHM=NOCOPY"
              packet_length = 38
              net = 0x7faa680010e0
              command = COM_QUERY
              _db_stack_frame_ = {func = 0x559ae961f820 "?func", file = 0x559ae961f826 "?file", level = 2147483649, line = -1, prev = 0x0}
              __PRETTY_FUNCTION__ = "bool do_command(THD*)"
              __FUNCTION__ = "do_command"
      #15 0x0000559ae85eba97 in do_handle_one_connection (connect=0x559aeb1dca08, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1418
              create_user = true
              thr_create_utime = 4396417663620
              thd = 0x7faa68000db8
              __PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"
      #16 0x0000559ae85eb759 in handle_one_connection (arg=0x559aeb188e18) at /data/src/10.5/sql/sql_connect.cc:1312
              connect = 0x559aeb188e18
      #17 0x0000559ae8afc5ec in pfs_spawn_thread (arg=0x559aeb1dc788) at /data/src/10.5/storage/perfschema/pfs.cc:2201
              typed_arg = 0x559aeb1dc788
              user_arg = 0x559aeb188e18
              user_start_routine = 0x559ae85eb6fe <handle_one_connection(void*)>
              pfs = 0x7faa88e20140
              klass = 0x559aeaba9900
      #18 0x00007faa899eeea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
              ret = <optimized out>
              pd = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140370339378944, -3333100953515457663, 140726643039006, 140726643039007, 140370339376704, 311296, 3380930334700995457, 3380903055274279809}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = 0
      #19 0x00007faa895ebdef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Reproducible on 10.5-10.10, debug and non-debug alike.

        Attachments

          Activity

            People

            Assignee:
            monty Michael Widenius
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.