[MDEV-29112] Server crashes in dirname_length upon altering partitioned S3 table using NOCOPY algorithm - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.5, 10.6
Component/s: Data Definition - Alter Table, Partitioning, Storage Engine - S3
Labels:
None

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:: Michael Widenius

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2022-07-16 12:29

Updated:: 2023-11-28 10:39

Git Integration

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