Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.37, 10.6.11
Description
Attached tablespace files (copied from MySQL-8.0.31 after flush tables t1 for export).
MariaDB [test]> create table t1 (i int not null primary key);
|
Query OK, 0 rows affected (0.001 sec)
|
|
MariaDB [test]> alter table t1 discard tablespace;
|
Query OK, 0 rows affected (0.001 sec)
|
|
# copy files into test
|
|
MariaDB [test]> alter table t1 import tablespace;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
(gdb) bt full
|
#0 0x00007ff890f6f8e4 in __strnlen_evex () from /lib64/libc.so.6
|
No symbol table info available.
|
#1 0x0000000000f234ad in process_str_arg (cs=cs@entry=0x1768680 <my_charset_latin1>, to=0x7ff8910686bc "", end=end@entry=0x7ff89106889f "", length_arg=0, width=65535, width@entry=140705561741471, par=0x75 <error: Cannot access memory at address 0x75>, print_type=0, nice_cut=0 '\000') at /home/dan/repos/mariadb-server-10.6/strings/my_vsnprintf.c:277
|
dots = 0
|
left_len = 484
|
slen = 0
|
left_fill = <optimized out>
|
length = 0
|
plen = <optimized out>
|
well_formed_error = <optimized out>
|
#2 0x0000000000f22724 in my_vsnprintf_ex (cs=0x75, to=0x7ff8910686bc "", to@entry=0x7ff8910686a0 "IO Read error: (60038816, ) ", n=n@entry=512, fmt=0x11107ca "s", ap=0x7ff891068980) at /home/dan/repos/mariadb-server-10.6/strings/my_vsnprintf.c:729
|
par = 0x75 <error: Cannot access memory at address 0x75>
|
start = 0x7ff8910686a0 "IO Read error: (60038816, ) "
|
end = 0x7ff89106889f ""
|
print_type = 0
|
length = 117
|
width = 65535
|
have_longlong = <optimized out>
|
#3 0x0000000000f23a3d in my_vsnprintf (to=0xffff <error: Cannot access memory at address 0xffff>, to@entry=0x7ff8910686a0 "IO Read error: (60038816, ) ", n=140705561741471, n@entry=512, fmt=0x0, ap=0xffff) at /home/dan/repos/mariadb-server-10.6/strings/my_vsnprintf.c:816
|
No locals.
|
#4 0x0000000000ebe449 in my_printv_error (error=1810, format=0x7ff89106889f "", MyFlags=0, ap=0x0) at /home/dan/repos/mariadb-server-10.6/mysys/my_error.c:176
|
ebuff = "IO Read error: (60038816, ) ", '\000' <repeats 12 times>, "\243\f", '\000' <repeats 119 times>, "\270\220\361^\026\206\271Ї\006\221\370\177\000\000\377\377\377\377\000\000\000\000\200\234\006\221\370\177\000\000\000\000\000\000\000\000\000\000\b"...
|
#5 0x0000000000ca7c55 in ib_senderrf (thd=thd@entry=0x7ff764000c68, level=level@entry=IB_LOG_LEVEL_ERROR, code=code@entry=1810) at /home/dan/repos/mariadb-server-10.6/storage/innobase/handler/ha_innodb.cc:20710
|
args = {{gp_offset = 48, fp_offset = 48, overflow_arg_area = 0x7ff8910689c0, reg_save_area = 0x7ff8910688d0}}
|
format = 0x75 <error: Cannot access memory at address 0x75>
|
l = 140705561741471
|
#6 0x0000000000cbc2a1 in ib_errf (thd=thd@entry=0x7ff764000c68, level=level@entry=IB_LOG_LEVEL_ERROR, code=code@entry=1810, format=0x127c2d7 "Unsupported meta-data version number (%zu), file ignored") at /home/dan/repos/mariadb-server-10.6/storage/innobase/handler/ha_innodb.cc:20777
|
args = {{gp_offset = 40, fp_offset = 48, overflow_arg_area = 0x7ff891068ac0, reg_save_area = 0x7ff8910689c0}}
|
str = 0x0
|
#7 0x0000000000d42844 in row_import_read_meta_data (file=0x7ff764010a10, thd=0x75, cfg=@0x7ff891068b48: {m_table = 0x7ff764023a90, m_version = 7, m_hostname = 0x0, m_table_name = 0x0, m_autoinc = 0, m_zip_size = 0, m_flags = 0, m_n_cols = 0, m_cols = 0x0, m_col_names = 0x0, m_n_indexes = 0, m_indexes = 0x0, m_missing = false}) at /home/dan/repos/mariadb-server-10.6/storage/innobase/row/row0import.cc:3000
|
row = "\000\000\000\a"
|
#8 row_import_read_cfg (table=0x7ff764023a90, thd=0x75, cfg=@0x7ff891068b48: {m_table = 0x7ff764023a90, m_version = 7, m_hostname = 0x0, m_table_name = 0x0, m_autoinc = 0, m_zip_size = 0, m_flags = 0, m_n_cols = 0, m_cols = 0x0, m_col_names = 0x0, m_n_indexes = 0, m_indexes = 0x0, m_missing = false}) at /home/dan/repos/mariadb-server-10.6/storage/innobase/row/row0import.cc:3415
|
name = "./test/t1.cfg", '\000' <repeats 103 times>, "\001", '\000' <repeats 99 times>...
|
file = 0x7ff764010a10
|
err = <optimized out>
|
msg = <optimized out>
|
#9 row_import_for_mysql (table=0x7ff764023a90, prebuilt=0x7ff764025710) at /home/dan/repos/mariadb-server-10.6/storage/innobase/row/row0import.cc:4302
|
cfg = {m_table = 0x7ff764023a90, m_version = 7, m_hostname = 0x0, m_table_name = 0x0, m_autoinc = 0, m_zip_size = 0, m_flags = 0, m_n_cols = 0, m_cols = 0x0, m_col_names = 0x0, m_n_indexes = 0, m_indexes = 0x0, m_missing = false}
|
converter = {<AbstractCallback> = {_vptr$AbstractCallback = 0x7ff86be00dc0, m_zip_size = 34372585529, m_file = {m_file = 0, m_psi = 0x7ff891069d18}, m_filepath = 0x7ff891069d18 "\370\234\006\221\370\177", m_trx = 0x1, m_space = 0, m_size = 140705561746680, m_xdes = 0x7ff891069cf8 "\030\235\006\221\370\177", m_xdes_page_no = 0, m_space_flags = 140703128616978}, m_cfg = 0x7ff891069d60, m_index = 0x7ff89106a1a0, m_rec_iter = {m_cur = {index = 0xeb4b34 <normalize_dirname+196>, rec = 0x101006000000001 <error: Cannot access memory at address 0x101006000000001>, offsets = 0x9, block = 0x747365742f2e2f2e}, m_mtr = {m_last = 0x2f, m_last_offset = 40336, m_log_mode = 2, m_modifications = 1, m_made_dirty = 0, m_inside_ibuf = 0, m_trim_pages = 0, m_memo = {m_heap = 0x7ff891069d90, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x1, prev = 0x0}}, size_ = 140705561746800}, m_size = 140705561746800, m_first_block = {<ilist_node<void>> = {next = 0x0, prev = 0x20}, m_data = "\000\000\000\000\000\000\000\000\001\000\000\000\370\177\000\000\001", '\000' <repeats 15 times>, "\260\235\006\221\370\177\000\000\260\235\006\221\370\177\000\000\357\003\000\000\000\000\000\000\031\000\000\000\000\000\000\000\060\000\000d\367\177\000\000\310\376\377\377\377\377\377\377\031\000\000\000\000\000\000\000\250[\002d\367\177", '\000' <repeats 26 times>, "h\313\351\220\370\177\000\000\001\000\000\000\000\000\000\000\060\240\006\221\370\177\000\000\060\240\006\221\370\177\000\000\033\025\314\000\000\000\000\000@\240\006\221\370\177\000\000\031", '\000' <repeats 15 times>, ";F\323\000\000\000\000\000\006\000\000\000\000\000\000\000\000"..., m_used = 32760}}, m_log = {m_heap = 0x7ff89106a5a0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x1, prev = 0x0}}, size_ = 140705561747360}, m_size = 140705561747360, m_first_block = {<ilist_node<void>> = {next = 0x0, prev = 0x0}, m_data = "\000\240\006\221\370\177\000\000\000\240\006\221\370\177\000\000\001", '\000' <repeats 15 times>, "\340\237\006\221\370\177\000\000\340\237\006\221\370\177\000\000\000\021\002d\367\177\000\000\200\026 \220\370\177\000\000\250[\002d\367\177\000\000\360a\002d\367\177\000\000\360\241\006\221\370\177\000\000\000\270\220\361^\026\206\271\020\242\006\221\370\177\000\000\000\270\220\361^\026\206\271\362\033\367\000\000\000\000\000\340\246\006\221\370\177\000\000\000\000\000\000\000\000\000\000\360\245\006\221\370\177\000\000\003\000\000\000\000\000\000\000Z\251\345\220\370\177\000\000\060\000\000\000\060\000\000\000\240\241\006\221\370\177\000\000\240\240\006\221\370\177\000\000\000\270\220\361^\026\206\271h\002", '\000' <repeats 14 times>..., m_used = 0}}, m_user_space = 0x0, m_commit_lsn = 0, m_freed_space = 0x1700000000000000, m_freed_pages = 0x203a42446f6e6e49}}, m_offsets_ = {24916, 27746, 29541, 24944, 25955, 26144, 29295, 29728, 25185, 25964, 24608, 25972, 29811, 11872, 29792, 24625, 26912, 8307, 25971, 8308, 29537, 25632, 29545, 24931, 25714, 25701, 46, 0, 7, 0, 0, 0, 0, 0, 0, 0, 29180, 25602, 32759, 0, 576, 0, 0, 0, 29792, 24625, 24576, 0, 5696, 36896, 32760, 0, 4160, 5120, 32760, 0, 3176, 25600, 32759, 0, 42112, 37126, 32760, 0, 64167, 224, 0, 0, 35, 0, 0, 0, 4352, 25602, 32759, 0, 1, 0, 0, 0, 5760, 36896, 32760, 0, 1424, 25601, 32759, 0, 2192, 25601, 32759, 0, 24944, 29810, 115, 0 <repeats 13 times>, 1120, 27616, 32760, 0, 49213, 37097, 32760, 0, 0, 0, 0, 0, 9904, 0, 0, 0, 96, 0, 0, 0, 72, 0, 32760, 0, 0, 0, 0, 0, 1552, 0, 0, 0, 48, 25600, 32759, 0, 65224, 65535, 65535, 65535, 1552, 0, 0, 0, 0, 0, 0, 0, 58360, 25601, 32759, 0, 52072, 37097, 32760, 0, 232, 0, 0, 0, 0, 0, 0, 0, 1528, 0, 0, 0, 42320, 37126, 32760, 0, 42320, 37126, 32760, 0, 0, 0, 0, 6912, 0 <repeats 12 times>, 41896, 37126, 32760, 0, 41896...}, m_offsets = 0x0, m_heap = 0x0, m_cluster_index = 0x0}
|
name = {data_ = 0x0, size_ = 8589934595}
|
autoinc = 0
|
filepath = 0x0
|
trx = 0x7ff890200b80
|
err = <optimized out>
|
thd = 0x75
|
data_dir_path = <optimized out>
|
fsp_flags = <optimized out>
|
index = <optimized out>
|
#10 0x0000000000cb2df5 in ha_innobase::discard_or_import_tablespace (this=0x7ff764023250, discard=0 '\000') at /home/dan/repos/mariadb-server-10.6/storage/innobase/handler/ha_innodb.cc:13398
|
err = DB_SUCCESS
|
#11 0x00000000007b8c3a in mysql_discard_or_import_tablespace (thd=thd@entry=0x7ff764000c68, table_list=table_list@entry=0x7ff764013118, discard=false) at /home/dan/repos/mariadb-server-10.6/sql/sql_table.cc:5504
|
alter_prelocking_strategy = {<Prelocking_strategy> = {_vptr$Prelocking_strategy = 0xf6ec60 <vtable for Alter_table_prelocking_strategy+16>}, <No data fields>}
|
error = <optimized out>
|
#12 0x00000000008250c1 in Sql_cmd_discard_import_tablespace::execute (this=0x7ff764013828, thd=0x7ff764000c68) at /home/dan/repos/mariadb-server-10.6/sql/sql_alter.cc:589
|
select_lex = <optimized out>
|
table_list = 0x7ff764013118
|
#13 0x000000000071e889 in mysql_execute_command (thd=thd@entry=0x7ff764000c68, is_called_from_prepared_stmt=false) at /home/dan/repos/mariadb-server-10.6/sql/sql_parse.cc:5997
|
ots = {ctx = 0x7ff764004a20, traceable = false}
|
res = 0
|
up_result = 0
|
lex = 0x7ff764004d50
|
select_lex = 0x7ff764005638
|
first_table = 0x7ff764013118
|
unit = 0x7ff764004e18
|
have_table_map_for_update = <optimized out>
|
all_tables = <optimized out>
|
rpl_filter = <optimized out>
|
orig_binlog_format = <optimized out>
|
orig_current_stmt_binlog_format = <optimized out>
|
error = <optimized out>
|
wsrep_error_label = <optimized out>
|
#14 0x000000000071a56c in mysql_parse (thd=thd@entry=0x7ff764000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7ff89106c520) at /home/dan/repos/mariadb-server-10.6/sql/sql_parse.cc:8016
|
found_semicolon = <optimized out>
|
error = <optimized out>
|
lex = 0x7ff764004d50
|
err = false
|
#15 0x0000000000718c71 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7ff764000c68, packet=packet@entry=0x7ff7640084f9 "alter table t1 import tablespace", packet_length=packet_length@entry=32, blocking=false) at /home/dan/repos/mariadb-server-10.6/sql/sql_parse.cc:1896
|
parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7ff764000c68, m_ptr = 0x7ff764013051 "\004", m_tok_start = 0x7ff764013051 "\004", m_tok_end = 0x7ff764013051 "\004", m_end_of_query = 0x7ff764013050 "", m_tok_start_prev = 0x7ff764013050 "", m_buf = 0x7ff764013030 "alter table t1 import tablespace", m_buf_length = 32, m_echo = true, m_echo_saved = true, m_cpp_buf = 0x7ff7640130a8 "alter table t1 import tablespace", m_cpp_ptr = 0x7ff7640130c8 "", m_cpp_tok_start = 0x7ff7640130c8 "", m_cpp_tok_start_prev = 0x7ff7640130c8 "", m_cpp_tok_end = 0x7ff7640130c8 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x0, 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 = NO_COMMENT, m_cpp_text_start = 0x7ff7640130b4 "t1 import tablespace", m_cpp_text_end = 0x7ff7640130b6 " import tablespace", 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 = 0x0}
|
packet_end = <optimized out>
|
net = <optimized out>
|
error = false
|
do_end_of_statement = true
|
drop_more_results = false
|
#16 0x000000000071a960 in do_command (thd=0x7ff764000c68, blocking=true) at /home/dan/repos/mariadb-server-10.6/sql/sql_parse.cc:1409
|
packet = 0x7ff7640084f8 "\003alter table t1 import tablespace"
|
net = <optimized out>
|
command = COM_QUERY
|
packet_length = 33
|
return_value = <optimized out>
|
#17 0x000000000081f6ae in do_handle_one_connection (connect=<optimized out>, connect@entry=0x3941eb8, put_in_cache=true) at /home/dan/repos/mariadb-server-10.6/sql/sql_connect.cc:1416
|
create_user = true
|
thr_create_utime = 194216341094
|
thd = 0x75
|
#18 0x000000000081f427 in handle_one_connection (arg=arg@entry=0x3941eb8) at /home/dan/repos/mariadb-server-10.6/sql/sql_connect.cc:1318
|
connect = 0x3941eb8
|
#19 0x0000000000b4df27 in pfs_spawn_thread (arg=0x38f75f8) at /home/dan/repos/mariadb-server-10.6/storage/perfschema/pfs.cc:2201
|
typed_arg = 0x38f75f8
|
klass = <optimized out>
|
pfs = <optimized out>
|
user_start_routine = 0x81f3d0 <handle_one_connection(void*)>
|
user_arg = 0x3941eb8
|
#20 0x00007ff890e8cded in start_thread () from /lib64/libc.so.6
|
No symbol table info available.
|
#21 0x00007ff890f12370 in clone3 () from /lib64/libc.so.6
|
No symbol table info available.
|