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

Trying to lock uninitialized mutex in ha_myisam::info upon converting S3 table to MyISAM with binlog

    XMLWordPrintable

Details

    Description

      The test case to be put into suite/s3. I was running it with MinIO, didn't try AWS.

      --source include/have_s3.inc
      --source include/have_log_bin.inc
       
      DROP TABLE IF EXISTS t;
      CREATE TABLE t (a INT);
      ALTER TABLE t ENGINE=S3;
      ALTER TABLE t ENGINE=MyISAM;
       
      # Cleanup
      DROP TABLE t;
      

      10.5 0fca5068

      safe_mutex: Trying to lock uninitialized mutex at /data/src/10.5/storage/myisam/ha_myisam.cc, line 2110
      220708 21:42:48 [ERROR] mysqld got signal 6 ;
       
      #5  0x00007f1a86862537 in __GI_abort () at abort.c:79
              save_stage = 1
              act = {__sigaction_handler = {sa_handler = 0x55b522aa5658, sa_sigaction = 0x55b522aa5658}, sa_mask = {__val = {2110, 139751324819680, 94236447437266, 139751794242704, 576114466, 139751794242704, 94236453558425, 139751323602144, 576126001, 581649532, 139751324819680, 139751794244288, 94236466740352, 139751794242752, 139751904495040, 139751904498848}}, sa_flags = -2037704830, sa_restorer = 0x800d75a0}
              sigs = {__val = {32, 0 <repeats 15 times>}}
      #6  0x000055b52254627f in safe_mutex_lock (mp=0x7f1a64076f38, my_flags=0, file=0x55b522aa5658 "/data/src/10.5/storage/myisam/ha_myisam.cc", line=2110) at /data/src/10.5/mysys/thr_mutex.c:245
              error = 32538
              __PRETTY_FUNCTION__ = "safe_mutex_lock"
      #7  0x000055b5224a5aa7 in inline_mysql_mutex_lock (that=0x7f1a64076f38, src_file=0x55b522aa5658 "/data/src/10.5/storage/myisam/ha_myisam.cc", src_line=2110) at /data/src/10.5/include/mysql/psi/mysql_thread.h:765
              result = 21941
      #8  0x000055b5224ace68 in ha_myisam::info (this=0x7f1a64078100, flag=72) at /data/src/10.5/storage/myisam/ha_myisam.cc:2110
              share = 0x7f1a64076d88
              misam_info = {records = 11, deleted = 0, recpos = 18446744073709551615, newrecpos = 139751794243728, dupp_key_pos = 139751794243088, data_file_length = 94236439418786, max_data_file_length = 1970324836974591, index_file_length = 139751794243728, max_index_file_length = 17179868160, delete_length = 139751794243840, reclength = 5, mean_reclength = 94236439418786, auto_increment = 1, key_map = 0, data_file_name = 0x7f1a64079030 "./test/#sql-alter-2cdcb5-5.MYD", index_file_name = 0x7f1a64079010 "./test/#sql-alter-2cdcb5-5.MYI", keys = 577036198, options = 0, errkey = -2146600720, sortkey = -1, filenr = 66, create_time = 1657305768, check_time = 94236456415713, update_time = 0, reflength = 7, record_offset = 7, rec_per_key = 0x7f1a64078f38}
      #9  0x000055b5224ad2b9 in ha_myisam::update_create_info (this=0x7f1a64078100, create_info=0x7f1a800d7730) at /data/src/10.5/storage/myisam/ha_myisam.cc:2205
      No locals.
      #10 0x000055b52198c99b in add_table_options (thd=0x7f1a64000db8, table=0x7f1a64077c58, create_info_arg=0x7f1a800d9410, schema_table=false, sequence=false, packet=0x7f1a800d8b90) at /data/src/10.5/sql/sql_show.cc:1844
              sql_mode = 1411383296
              share = 0x7f1a64076d88
              hton = 0x55b523ccf678
              create_info = {<Table_scope_and_contents_source_st> = {<Table_scope_and_contents_source_pod_st> = {alter_table_convert_to_charset = 0x0, tabledef_version = {str = 0x0, length = 0}, connect_string = {str = 0x0, length = 0}, comment = {str = 0x0, length = 0}, alias = {str = 0x0, length = 0}, password = 0x0, tablespace = 0x0, data_file_name = 0x0, index_file_name = 0x0, max_rows = 0, min_rows = 0, auto_increment_value = 0, table_options = 0, avg_row_length = 0, used_fields = 0, key_block_size = 0, expression_length = 0, field_check_constraints = 0, stats_sample_pages = 0, null_bits = 0, options = 8, merge_insert_method = 0, extra_size = 0, db_type = 0x0, row_type = ROW_TYPE_DEFAULT, transactional = HA_CHOICE_UNDEF, storage_media = HA_SM_DEFAULT, page_checksum = HA_CHOICE_YES, option_list = 0x0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, varchar = false, sequence = false, check_constraint_list = 0x0, option_struct = 0x0, fields_option_struct = 0x0, indexes_option_struct = 0x0, 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 = 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}, 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 = 0x0, schema_comment = 0x0}, alter_info = 0x0}
              check_options = true
      #11 0x000055b52198ed3a in show_create_table_ex (thd=0x7f1a64000db8, table_list=0x7f1a800d84b0, force_db=0x0, force_name=0x0, packet=0x7f1a800d8b90, create_info_arg=0x7f1a800d9410, with_db_name=WITH_DB_NAME) at /data/src/10.5/sql/sql_show.cc:2429
              field_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b523216b00 <end_of_list>, last = 0x7f1a800d7a60, elements = 0}, <No data fields>}
              tmp = "int(11)\000\000\000\000\000\000\000\000\000\320\216\r\200\032\177\000\000\005hM\"\265U\000\000\230\016\253\"\265U\000\000\220\000\000\000\000\000\000\000\350\212\r\200\032\177\000\000\000\000\000\000\000\000\000\000\370\212\r\200\032\177\000\000B\000\000\000\000\000\000\000\b\213\r\200\032\177\000\000\037\000\000\000\000\000\000\000\000\213\r\200\032\177\000\000\037\000\000\000\000\000\000\000\070\211\r\200\032\177\000\000\000\000\000\000\000\000\000\000@\211\r\200\032\177\000\000\000\000\000\000\000\000\000\000R\020\000\000\002\000\000\000\060s\ad\032\177\000\000\n\000\000\000st/\000\001\000\000\000A\000\000\000\002", '\000' <repeats 15 times>, "\006\000\000\000\005\000\000\000"...
              for_str = 0x0
              def_value_buf = " \200\r\200\032\177\000\000P\200\r\200\000\000\000\000:\332\252\"\265U\000\000\000\000\000\000\000\000\000\000 ~\r\200\032\177\000\000\022\377S\"\000\000\000\000\322\016\253\"\265U\000\000\000\000\000\000\000\000\000\000@~\r\200\032\177\000\000\022\377S\"\000\000\001\000`~\r\200\032\177\000\000\361\376V\"\265U\000\000`~\r\200\032\177\000\000\340\f\000d\032\177\000\000\340\f\000d\032\177\000\000\270\f\000d\001\000\000\000\240\200\r\200\032\177\000\000c\361V\"\265U\000\000./test/#\320\200\r\200\032\177\000\000\016\000\000\000dcb5\340\f\000d\032\177\000\000\254(\301\"\265U\000\000\341E\241\206\000\000\000\000R\332\252\"\265U\000\000\000\000\000\000\000\000\000\000"...
              alias = {str = 0x7f1a64077350 "t", length = 1}
              type = {<Charset> = {m_charset = 0x55b5231ffc80 <my_charset_utf8mb3_general_ci>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x7f1a800d7ae0 "int(11)", str_length = 7}, Alloced_length = 766, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}
              def_value = {<Charset> = {m_charset = 0x55b5231ffc80 <my_charset_utf8mb3_general_ci>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x55b522674111 "NULL", str_length = 0}, Alloced_length = 0, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}
              ptr = 0x7f1a64069fd0
              field = 0x0
              primary_key = 64
              key_info = 0x0
              table = 0x7f1a64077c58
              share = 0x7f1a64076d88
              period = @0x7f1a640772c8: {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}
              sql_mode = 1411383296
              explicit_fields = false
              foreign_db_mode = false
              limited_mysql_mode = false
              show_table_options = true
              check_options = false
              hton = 0x55b523ccf678
              error = 0
              _db_stack_frame_ = {func = 0x55b52267e816 "mysql_alter_table", file = 0x55b52267c118 "/data/src/10.5/sql/sql_table.cc", level = 2147483655, line = -1, prev = 0x7f1a800d9740}
              old_map = 0x7f1a64077d88
              not_the_first_field = true
              __PRETTY_FUNCTION__ = "int show_create_table_ex(THD*, TABLE_LIST*, const char*, const char*, String*, Table_specification_st*, enum_with_db_name)"
      #12 0x000055b52198d2c5 in show_create_table (thd=0x7f1a64000db8, table_list=0x7f1a800d84b0, packet=0x7f1a800d8b90, create_info_arg=0x7f1a800d9410, with_db_name=WITH_DB_NAME) at /data/src/10.5/sql/sql_show.cc:2005
      No locals.
      #13 0x000055b52189a62b in binlog_show_create_table (thd=0x7f1a64000db8, table=0x7f1a64077c58, create_info=0x7f1a800d9410) at /data/src/10.5/sql/sql_insert.cc:4822
              __PRETTY_FUNCTION__ = "int binlog_show_create_table(THD*, TABLE*, Table_specification_st*)"
              query = {<String> = {<Charset> = {m_charset = 0x55b5231ffc80 <my_charset_utf8mb3_general_ci>}, <Binary_string> = {<Static_binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x7f1a800d8bae "CREATE OR REPLACE TABLE `t` (\n  `a` int(11) DEFAULT NULL\n)", str_length = 58}, Alloced_length = 2048, extra_alloc = 0, alloced = false, thread_specific = false}, <No data fields>}, buff = "CREATE OR REPLACE TABLE `t` (\n  `a` int(11) DEFAULT NULL\n)\000\361~!\265U\000\000\037\000\000\000\000\000\000\000\000\227\203\232\251\274\001\254\300\215\r\200\032\177\000\000\060\026\207!\265U\000\000\000\000\000\000\000\000\000@\001\000\000\000\000\000\000\000\037\000\000\000\000\000\000\000\016\216\r\200\032\177\000\000\001\214\r\200\001\000\000\000\270\r\000d\032\177\000\000p\214\r\200\032\177\000\000\000\000\000\000\000\000\000\000\026\350g\"\265U\000\000\030\301g\"\265U\000\000\a\000\000\200\n\036\000\000@\227\r\200\032\177\000\000\350\r\376\"\265U"...}
              result = -2146597568
              tmp_table_list = {next_local = 0x0, next_global = 0x0, prev_global = 0x0, db = {str = 0x0, length = 0}, table_name = {str = 0x0, length = 0}, schema_table_name = {str = 0x0, length = 0}, alias = {str = 0x0, length = 0}, option = 0x0, on_expr = 0x0, on_context = 0x0, sj_on_expr = 0x0, sj_inner_tables = 0, sj_in_exprs = 0, sj_subq_pred = 0x0, original_subq_pred_used_tables = 0, jtbm_subselect = 0x0, jtbm_table_no = 0, sj_mat_info = 0x0, prep_on_expr = 0x0, cond_equal = 0x0, natural_join = 0x0, is_natural_join = false, join_using_fields = 0x0, join_columns = 0x0, is_join_columns_complete = false, next_name_resolution_table = 0x0, index_hints = 0x0, table = 0x7f1a64077c58, table_id = 0, derived_result = 0x0, map = 0, correspondent_table = 0x0, derived = 0x0, with = 0x0, with_internal_reference_map = 0, next_with_rec_ref = 0x0, is_derived_with_recursive_reference = false, block_handle_derived = false, dt_handler = 0x0, derived_spec = {str = 0x0, length = 0}, pushdown_derived = 0x0, schema_table = 0x0, schema_select_lex = 0x0, schema_table_reformed = false, schema_table_param = 0x0, select_lex = 0x0, view = 0x0, field_translation = 0x0, field_translation_end = 0x0, field_translation_updated = false, merge_underlying_list = 0x0, view_tables = 0x0, belong_to_view = 0x0, belong_to_derived = 0x0, referencing_view = 0x0, view_used_tables = 0, map_exec = 0, tablenr_exec = 0, maybe_null_exec = 0, parent_l = 0x0, security_ctx = 0x0, view_sctx = 0x0, allowed_show = false, where = 0x0, check_option = 0x0, select_stmt = {str = 0x0, length = 0}, md5 = {str = 0x0, length = 0}, source = {str = 0x0, length = 0}, view_db = {str = 0x0, length = 0}, view_name = {str = 0x0, length = 0}, timestamp = {str = 0x0, length = 0}, definer = {<AUTHID> = {user = {str = 0x0, length = 0}, host = {str = 0x0, length = 0}}, auth = 0x0}, file_version = 0, mariadb_version = 0, updatable_view = 0, algorithm = 0, view_suid = 0, with_check = 0, effective_with_check = 0 '\000', derived_type = 0 '\000', 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}}, engine_data = 0, callback_func = 0x0, lock_type = TL_UNLOCK, mdl_type = MDL_INTENTION_EXCLUSIVE, table_options = 0, outer_join = 0, shared = 0, updatable = false, straight = false, updating = false, force_index = false, ignore_leaves = false, crashed = false, dep_tables = 0, on_expr_dep_tables = 0, nested_join = 0x0, embedding = 0x0, join_list = 0x0, lifted = false, cacheable_table = false, table_in_first_from_clause = false, open_type = OT_TEMPORARY_OR_BASE, contain_auto_increment = false, compact_view_format = false, where_processed = false, check_option_processed = false, required_type = TABLE_TYPE_UNKNOWN, db_type = 0x0, timestamp_buffer = '\000' <repeats 19 times>, prelocking_placeholder = TABLE_LIST::PRELOCK_NONE, open_strategy = TABLE_LIST::OPEN_NORMAL, is_alias = false, is_fqtn = false, fill_me = false, merged = false, merged_for_insert = false, sequence = false, used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x0, last = 0x0, elements = 0}, <No data fields>}, persistent_used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x0, last = 0x0, elements = 0}, <No data fields>}, view_creation_ctx = 0x0, view_client_cs_name = {str = 0x0, length = 0}, view_connection_cl_name = {str = 0x0, length = 0}, view_body_utf8 = {str = 0x0, length = 0}, trg_event_map = 0 '\000', slave_fk_event_map = 0 '\000', optimized_away = false, materialized = false, i_s_requested_object = 0, prohibit_cond_pushdown = false, table_open_method = 0, schema_table_state = NOT_PROCESSED, is_table_read_plan = 0x0, mdl_request = {type = MDL_INTENTION_EXCLUSIVE, duration = MDL_STATEMENT, next_in_list = 0x0, prev_in_list = 0x0, ticket = 0x0, key = {m_length = 0, m_db_name_length = 0, m_hash_value = 0, m_ptr = '\000' <repeats 386 times>}, m_src_file = 0x0, m_src_line = 0}, partition_names = 0x0, vers_conditions = {type = SYSTEM_TIME_UNSPECIFIED, orig_type = SYSTEM_TIME_UNSPECIFIED, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x0, field_end = 0x0, period = 0x0}, period_conditions = {type = SYSTEM_TIME_UNSPECIFIED, orig_type = SYSTEM_TIME_UNSPECIFIED, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x0, field_end = 0x0, period = 0x0}, for_insert_data = 0 '\000', m_table_ref_type = TABLE_REF_NULL, m_table_ref_version = 0}
      #14 0x000055b52189a98c in binlog_create_table (thd=0x7f1a64000db8, table=0x7f1a64077c58, replace=true) at /data/src/10.5/sql/sql_insert.cc:4889
              create_info = {<HA_CREATE_INFO> = {<Table_scope_and_contents_source_st> = {<Table_scope_and_contents_source_pod_st> = {alter_table_convert_to_charset = 0x7f1a800d9440, tabledef_version = {str = 0xb52256f320 <error: Cannot access memory at address 0xb52256f320>, length = 8589934597}, connect_string = {str = 0x700000001 <error: Cannot access memory at address 0x700000001>, length = 16}, comment = {str = 0x55b52253fde6 <_my_thread_var+20> "]\303UH\211\345H\203\354\020H\211}\370H\215\005ec[\001\213", length = 139749645877248}, alias = {str = 0x4 <error: Cannot access memory at address 0x4>, length = 139639654939712}, password = 0x7f1a64069fb7 "\217\377", tablespace = 0x7f1a64069fd0 "", data_file_name = 0x7f1a64069fb0 "t", index_file_name = 0x7f1a64000ce0 "kNw?\377\177", max_rows = 139751323602104, min_rows = 139751794250928, auto_increment_value = 94236453565216, table_options = 139751324033224, avg_row_length = 178864255036881, used_fields = 94236522249080, key_block_size = 94236455139768, expression_length = 18857053913097, field_check_constraints = 94236453371366, stats_sample_pages = 2148373728, null_bits = 32538, options = 0, merge_insert_method = 21941, extra_size = 2148373792, db_type = 0x55b521fba897 <PFS_buffer_scalable_container<PFS_thread, 256, 256, PFS_thread_array, PFS_thread_allocator>::sanitize(PFS_thread*)+91>, row_type = 1064823287, transactional = 32767, storage_media = (unknown: 0x64015be8), page_checksum = 32538, option_list = 0x7f1a800d9530, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, varchar = false, sequence = false, check_constraint_list = 0x0, option_struct = 0x7f1a86902b41 <__GI___clock_gettime+33>, fields_option_struct = 0x7f1a86273c40, indexes_option_struct = 0x55b521fae7d5 <copy_events_stages(PFS_events_stages*, PFS_events_stages const*)+40>, table = 0x7f1a86172fd0, pos_in_locked_tables = 0x55b523c072a8, merge_list = 0x7f1a800d9560, mdl_ticket = 0x55b521fae979 <insert_events_stages_history_long(PFS_events_stages*)+194>, table_was_deleted = 208, seq_create_info = 0x7f1a86172fd0}, vers_info = {<Table_period_info> = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x55b52264dfa6 "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 = 0x7f1a64000db8, schema_comment = 0x7f1a800d9630}, alter_info = 0xac01bca99a839700}, <DDL_options_st> = {m_options = DDL_options_st::OPT_OR_REPLACE}, <No data fields>}
              result = false
              save_option_bits = 8798240770816
      #15 0x000055b5219e98bc in mysql_alter_table (thd=0x7f1a64000db8, new_db=0x7f1a64005818, new_name=0x7f1a64005c38, create_info=0x7f1a800db370, table_list=0x7f1a64015510, alter_info=0x7f1a800db2a0, order_num=0, order=0x0, ignore=false, if_exists=false) at /data/src/10.5/sql/sql_table.cc:10928
              res = false
              org_tmp_table = NON_TRANSACTIONAL_TMP_TABLE
              engine_changed = false
              error = false
              no_ha_table = false
              table = 0x7f1a64062248
              new_table = 0x7f1a64077c58
              partition_changed = false
              fast_alter_partition = false
              key_info = 0x7f1a64016688
              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 = 0x55b523ccf678
              old_db_type = 0x55b523da0ee8
              copied = 0
              deleted = 0
              frm = {str = 0x7f1a64053878 "\376\001\n\t\022", length = 432}
              index_file = "\000\236\r\200\032\177\000\000\361\376V\"\265U\000\000\000\236\r\200\032\177\000\000\340\f\000d\032\177\000\000\340\f\000d\032\177\000\000\270\f\000d\001\000\000\000@\240\r\200\032\177\000\000c\361V\"\265U\000\000\060\236\r\200\032\177\000\000p\240\r\200\032\177\000\000\n\000\000\000\032\177\000\000\340\f\000d\032\177\000\000\000\000\000\000\000\000\000\000\346\375S\"\265U\000\000`\236\r\200\032\177\000\000\022\377S\"\000\000\000\000\220\232h\"\265U\000\000\000\000\000\000\000\000\000\000\200\236\r\200\032\177\000\000\022\377S\"\000\000\001\000\240\236\r\200\032\177\000\000\361\376V\"\265U\000\000\240\236\r\200\032\177\000\000\340\f\000d\032\177\000\000\340\f\000d\032\177\000\000"...
              data_file = "\f\000\000\200\324\000\000\000\000\227\203\232\251\274\001\254@\240\r\200\032\177\000\000#\346R\"\265U\000\000\000\000\000\000\000\000\000\000\220\240\r\200\032\177\000\000@\240\r\200\032\177\000\000\000\272\350#\265U\000\000e\232h\"\265U\000\000\270\230h\"\265U\000\000\v\000\000\200\254\001\000\000p\240\r\200\032\177\000\000\006\000\000\000\000\000\000\000\000\227\203\232\251\274\001\254\340\240\r\200\032\177\000\000h\301\241!\265U\000\000p\240\r\200\032\177\000\000\240\247\r\200\032\177\000\000\220\240\r\200", '\000' <repeats 12 times>, "\220\232h\"\265U\000\000\270\230h\"\265U\000\000\n\000\000\200\366\001\000\000\000\241\r\200\032\177", '\000' <repeats 26 times>...
              target_mdl_request = {type = MDL_NOT_INITIALIZED, duration = MDL_STATEMENT, next_in_list = 0x0, prev_in_list = 0x0, ticket = 0x0, key = {m_length = 0, m_db_name_length = 0, m_hash_value = 0, m_ptr = '\000' <repeats 88 times>, "\355\063\253\"\265U\000\000\000\000\000\000\000\000\000\000\300\234\r\200\032\177\000\000\022\377S\"\000\000\001\000\340\234\r\200\032\177\000\000\361\376V\"\265U\000\000\340\234\r\200\032\177\000\000\340\f\000d\032\177\000\000\340\f\000d\032\177\000\000\270\f\000d\001\000\000\000 \237\r\200\032\177\000\000c\361V\"\000\000\000\000\355\063\253\"\265U\000\000\000\000\000\000\000\000\000\000"...}, m_src_file = 0x7f1a800d9de0 "", m_src_line = 575930130}
              mdl_ticket = 0x7f1a641aecf0
              alter_prelocking_strategy = {<Prelocking_strategy> = {_vptr.Prelocking_strategy = 0x55b522ecffd0 <vtable for Alter_table_prelocking_strategy+16>}, <No data fields>}
              _db_stack_frame_ = {func = 0x55b5226a859d "Sql_cmd_alter_table::execute", file = 0x55b5226a8318 "/data/src/10.5/sql/sql_alter.cc", level = 2147483654, line = -1, prev = 0x7f1a800db280}
              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 = 0x7f1a64015be8 "test", length = 4}, table_name = {str = 0x7f1a640154d8 "t", length = 1}, alias = {str = 0x7f1a640154d8 "t", length = 1}, new_db = {str = 0x7f1a64015be8 "test", length = 4}, new_name = {str = 0x7f1a640154d8 "t", length = 1}, new_alias = {str = 0x7f1a640154d8 "t", length = 1}, tmp_name = {str = 0x7f1a800dab0b "#sql-alter-2cdcb5-5", 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>, "hs\004d\032\177\000\000(\207\005d\032\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\267\r\200\032\177\000\000\200\267\r\200\032\177\000\000\320s\004d\032\177\000\000\350s\004d\032\177\000\000\001", '\000' <repeats 15 times>, "\300s\004d\032\177\000\000\340s\004d\032\177", '\000' <repeats 18 times>, "e6\241\206\032\177\000\000@\026\001\367\001\000\000\000A\006q\333\001\000\000\000j\234~\005t\b\266n \252\r\200\032\177\000\000\254l\241\206\032\177\000\000\341E\241\206\032\177\000\000\000\000\000\000t\b\266n\301\311}Q\000\000\000\000\070s\241\206\032\177\000\000\320\000\000\000\000\000\000\000\v\001\000\000\000\000\000\000\323\352\246\243\000\000\000\000\000\000\000\000\000"..., new_alias_buff = '\000' <repeats 14 times>, "\210\062\241\206\032\177\000\000\000\000\000\000\000\000\000\000(7\241\206\032\177\000\000\000\000\000\000\000\000\000\000(\262\001#\265U\000\000\000\000\000\000\000\000\000@\340\253\r\200\032\177\000\000\254(\301\"\265U\000\000\341E\241\206\032\177", '\000' <repeats 18 times>, "\250w\310\"\265U\000\000\336\351\000\000\000\000\000\000\270\064\000\000\000\000\000\000`\257\r\200\032\177\000\000\000\253\r\200\032\177\000\000P~\224\206\032\177\000\000\000\300\004\000\000\000\000\000\366%\241\206\032\177\000\000\235\031C\221\231\334p\033P\253\r\200\032\177\000\000\061\000\000\000\000\000\000\000``*", tmp_name_buff = "#sql-alter-2cdcb5-5\000\000\200q*\207\032\177\000\000\241B\227\206\032\177\000\000\310\377\377\377\377\377\377\377\001", '\000' <repeats 16 times>, "A\241\206\032\177\000\000\000P\372 \265U\000\000 w*\207\032\177\000\000@P\372 \265U\000\000\f\000\241\206\032\177\000\000\061", '\000' <repeats 15 times>, "\001\000\000\000\000\000\000\000\240\325\r\200\032\177", '\000' <repeats 11 times>, "\227\203\232\251\274\001\254\000\000\000\000\000\000\000\000\260\254\r\200\032\177\000\000X\255\r\200\032\177\000\000\260\254\r\200\032\177\000\000`\257\r\200\032\177\000\000\061\236\215!", path = "./test/t\000\000\000\000\341Q\241\206\032\177\000\000\061\236\215!\265U", '\000' <repeats 18 times>, "\030\215\215!\265U\000\000<\275\313\"\265U\000\000\001\000\000\000\000\000\000\000\300\301\r\200\032\177\000\000\376{\310\"\265U\000\000\260\254\r\200\032\177\000\000<\275\313\"\265U\000\000Q\275\313\"\265U\000\000\t|\310\"\265U\000\000\240\255\r\200\032\177\000\000\310\025\241\206\032\177\000\000\000\000\000\000\000\000\000\000h\254\r\200\032\177\000\000\000\000\000\000\000\000\000\000\225I\347\"\265U\000\000\033\377\001\000\000\000\000\000\260\254\r\200\032\177\000\000P\257\r\200\032\177\000\000\177~\224\206\032\177\000\000\260\254\r\200"..., new_path = "./test/t\000\000\000c\361V\"\265U\000\000\000\000\000\000\000\000\000\000`\260\r\200\032\177\000\000\a\000\000\000\000\000\000\000\340\f\000d\000\000\000\000-\350e\"\265U\000\000\000\000\000\000\000\000\000\000\060\256\r\200\032\177\000\000\022\377S\"\000\000\001\000P\256\r\200\032\177\000\000\361\376V\"\000\000\000\000\260\224c\"\265U\000\000\000\000\000\000\000\000\000\000`\256\r\200\032\177\000\000\022\377S\"\000\000\001\000\200\256\r\200\032\177\000\000\361\376V\"\265U\000\000\200\256\r\200\032\177\000\000\340\f\000d\032\177\000\000\340\f\000d\032\177\000\000\270\f\000d\001\000\000\000\300\260\r\200\032\177\000\000c\361V\"\265U\000\000\300\256\r\200\032"..., tmp_path = "./test/#sql-alter-2cdcb5-5\000\341\271#\265U\000\000@\260\r\200\032\177\000\000\227\250\373!\265U\000\000\367\351w?\377\177\000\000@\232\017#\265U\000\000P\260\r\200\032\177\000\000\000\000\000\000\000\000\000\000\260\224c\"\265U\000\000\000\000\000\000\000\000\000\000P\260\r\200\032\177\000\000pW\000d\032\177\000\000`\260\r\200\032\177\000\000 \377\227!\265U\000\000p\260\r\200\032\177\000\000pW\000d\032\177\000\000\300\260\r\200\032\177\000\000\027\362\265!\265U\000\000\350[\001d\032\177\000\000 X\001d\032\177\000\000\300\260\r\200\032\177\000\000\252\376\201!\265U\000\000\000\000\000\000\200\377\377\377"..., tmp_table = false}
              backup_name_buff = "#sql-backup-2cdcb5-5", '\000' <repeats 20 times>, "\270\r\000d\032\177\000\000\310I\005d\032\177\000\000\310I\005d\032\177\000\000\310I\005d\032\177", '\000' <repeats 162 times>...
              backup_name = {str = 0x7f1a64015be8 "test", length = 4}
      #16 0x000055b521a90485 in Sql_cmd_alter_table::execute (this=0x7f1a64015bf8, thd=0x7f1a64000db8) at /data/src/10.5/sql/sql_alter.cc:543
              lex = 0x7f1a64004e98
              select_lex = 0x7f1a64005770
              first_table = 0x7f1a64015510
              used_engine = true
              __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 = 0x7f1a64016688 "\303\305jd\376\355\021\354\204\355\004\003", length = 16}, connect_string = {str = 0x7f1a64058db0 "", length = 0}, comment = {str = 0x7f1a640699a8 "", length = 0}, alias = {str = 0x7f1a640154d8 "t", length = 1}, password = 0x0, tablespace = 0x0, data_file_name = 0x0, index_file_name = 0x0, max_rows = 0, min_rows = 0, auto_increment_value = 1, table_options = 8, avg_row_length = 0, used_fields = 4096, 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 = 16, db_type = 0x55b523ccf678, row_type = ROW_TYPE_DEFAULT, transactional = HA_CHOICE_UNDEF, storage_media = HA_SM_DEFAULT, page_checksum = HA_CHOICE_YES, option_list = 0x0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, varchar = false, sequence = false, check_constraint_list = 0x7f1a800db318, option_struct = 0x0, fields_option_struct = 0x7f1a64015dd0, indexes_option_struct = 0x7f1a64015dd8, 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 = 0x55b52264dfa6 "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 = 0x55b5230f9a40 <my_charset_latin1>, schema_comment = 0x0}, alter_info = 0x7f1a800db2a0}
              alter_info = {drop_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b523216b00 <end_of_list>, last = 0x7f1a800db2a0, elements = 0}, <No data fields>}, alter_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b523216b00 <end_of_list>, last = 0x7f1a800db2b8, elements = 0}, <No data fields>}, key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b523216b00 <end_of_list>, last = 0x7f1a800db2d0, elements = 0}, <No data fields>}, alter_rename_key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b523216b00 <end_of_list>, last = 0x7f1a800db2e8, elements = 0}, <No data fields>}, create_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7f1a64015ed0, last = 0x7f1a64015ed0, elements = 1}, <No data fields>}, check_constraint_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b523216b00 <end_of_list>, last = 0x7f1a800db318, elements = 0}, <No data fields>}, flags = 128, partition_flags = 0, keys_onoff = Alter_info::LEAVE_AS_IS, partition_names = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55b523216b00 <end_of_list>, last = 0x7f1a800db348, elements = 0}, <No data fields>}, num_parts = 0, requested_algorithm = Alter_info::ALTER_TABLE_ALGORITHM_COPY, 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 = 0x55b52265b998 "mysql_execute_command", file = 0x55b52265ad20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f1a800dbe00}
      #17 0x000055b5218e7c00 in mysql_execute_command (thd=0x7f1a64000db8) at /data/src/10.5/sql/sql_parse.cc:6056
              res = 0
              up_result = 0
              lex = 0x7f1a64004e98
              select_lex = 0x7f1a64005770
              first_table = 0x7f1a64015510
              all_tables = 0x7f1a64015510
              unit = 0x7f1a64004f60
              have_table_map_for_update = false
              rpl_filter = 0x0
              _db_stack_frame_ = {func = 0x55b52265ccef "mysql_parse", file = 0x55b52265ad20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f1a800dc210}
              __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)"
              ots = {ctx = 0x7f1a64004b60, traceable = false}
              trace_command = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x55b522ecdd28 <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 = 0x55b522ecdd08 <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
      #18 0x000055b5218edcf9 in mysql_parse (thd=0x7f1a64000db8, rawbuf=0x7f1a64015430 "ALTER TABLE t ENGINE=MyISAM", length=27, parser_state=0x7f1a800dc3d0, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8100
              found_semicolon = 0x0
              error = 32538
              lex = 0x7f1a64004e98
              err = false
              _db_stack_frame_ = {func = 0x55b52265b1b2 "dispatch_command", file = 0x55b52265ad20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f1a800dc3b0}
              __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)"
      #19 0x000055b5218d9e32 in dispatch_command (command=COM_QUERY, thd=0x7f1a64000db8, packet=0x7f1a6400b6e9 "ALTER TABLE t ENGINE=MyISAM", packet_length=27, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1891
              packet_end = 0x7f1a6401544b ""
              parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f1a64000db8, m_ptr = 0x7f1a6401544c "\004", m_tok_start = 0x7f1a6401544c "\004", m_tok_end = 0x7f1a6401544c "\004", m_end_of_query = 0x7f1a6401544b "", m_tok_start_prev = 0x7f1a6401544b "", m_buf = 0x7f1a64015430 "ALTER TABLE t ENGINE=MyISAM", m_buf_length = 27, m_echo = true, m_echo_saved = 188, m_cpp_buf = 0x7f1a640154a8 "ALTER TABLE t ENGINE=MyISAM", m_cpp_ptr = 0x7f1a640154c3 "", m_cpp_tok_start = 0x7f1a640154c3 "", m_cpp_tok_start_prev = 0x7f1a640154c3 "", m_cpp_tok_end = 0x7f1a640154c3 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x7f1a64000ce0 "kNw?\377\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: 0x7f18), m_cpp_text_start = 0x7f1a640154bd "MyISAM", m_cpp_text_end = 0x7f1a640154c3 "", 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 = 0x7f1a640048f0}
              net = 0x7f1a640010e0
              error = false
              do_end_of_statement = true
              _db_stack_frame_ = {func = 0x55b52265af1d "do_command", file = 0x55b52265ad20 "/data/src/10.5/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f1a800dcc80}
              drop_more_results = false
              __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)"
              __FUNCTION__ = "dispatch_command"
              res = <optimized out>
      #20 0x000055b5218d868c in do_command (thd=0x7f1a64000db8) at /data/src/10.5/sql/sql_parse.cc:1375
              return_value = false
              packet = 0x7f1a6400b6e8 "\003ALTER TABLE t ENGINE=MyISAM"
              packet_length = 28
              net = 0x7f1a640010e0
              command = COM_QUERY
              _db_stack_frame_ = {func = 0x55b522ab97e0 "?func", file = 0x55b522ab97e6 "?file", level = 2147483649, line = -1, prev = 0x0}
              __PRETTY_FUNCTION__ = "bool do_command(THD*)"
              __FUNCTION__ = "do_command"
      #21 0x000055b521a85a97 in do_handle_one_connection (connect=0x55b524205398, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1418
              create_user = true
              thr_create_utime = 3727880539813
              thd = 0x7f1a64000db8
              __PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*, bool)"
      #22 0x000055b521a85759 in handle_one_connection (arg=0x55b5241f28d8) at /data/src/10.5/sql/sql_connect.cc:1312
              connect = 0x55b5241f28d8
      #23 0x000055b521f965cc in pfs_spawn_thread (arg=0x55b524204fa8) at /data/src/10.5/storage/perfschema/pfs.cc:2201
              typed_arg = 0x55b524204fa8
              user_arg = 0x55b5241f28d8
              user_start_routine = 0x55b521a856fe <handle_one_connection(void*)>
              pfs = 0x7f1a861706c0
              klass = 0x55b523bb7900
      #24 0x00007f1a86d3dea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
              ret = <optimized out>
              pd = <optimized out>
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {139751794267904, 7252748028837884070, 140734258166158, 140734258166159, 139751794265664, 311296, -7308233903418117978, -7308249003960700762}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
              not_first_call = 0
      #25 0x00007f1a8693adef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Activity

          People

            monty Michael Widenius
            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.