Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.0.33, 10.1.29, 10.2.10, 10.3.3
-
10.2.14
Description
Statements like ALTER TABLE t. MODIFY COLUMN c DECIMAL(10,2) for the InnoDB table may hand at dropping of temporary table stage when the table has FULLTEXT index(es) defined.
Full backtrace of relevant threads may look as follows:
Thread 28 (Thread 0x7f5436be3700 (LWP 19822)):
|
#0 ib_vector_last (table=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/include/ut0vec.ic:206
|
No locals.
|
#1 fts_sync_index_check (table=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0fts.cc:4049
|
word = 0x7f5313f36c10
|
rbt_node = 0x7f5313f36bf0
|
#2 fts_sync (table=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0fts.cc:4292
|
index_cache = 0x7f5313f98788
|
i = <value optimized out>
|
error = <value optimized out>
|
cache = 0x7f53135ae2f0
|
#3 fts_sync_table (table=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0fts.cc:4356
|
err = DB_SUCCESS
|
#4 0x00007f588972de62 in fts_optimize_sync_table (table_id=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0opt.cc:2960
|
table = 0x7f531359e6d0
|
#5 0x00007f588972e26b in fts_optimize_thread (arg=0x7f58a47957d0) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/fts/fts0opt.cc:3088
|
msg = 0x7f5313fb28c0
|
heap_alloc = 0x7f542c0016e0
|
current = <value optimized out>
|
done = <value optimized out>
|
n_tables = <value optimized out>
|
n_optimize = <value optimized out>
|
wq = 0x7f58a47957d0
|
tables = 0x7f542c000a30
|
#6 0x00007f5888851aa1 in start_thread () from /lib64/libpthread.so.0
|
No symbol table info available.
|
#7 0x00007f5886f69bcd in clone () from /lib64/libc.so.6
|
No symbol table info available.
|
|
...
|
|
Thread 6 (Thread 0x7f586c243700 (LWP 29207)):
|
#0 0x00007f588885900d in nanosleep () from /lib64/libpthread.so.0
|
No symbol table info available.
|
#1 0x00007f58895505d0 in os_thread_sleep (tm=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/os/os0thread.cc:230
|
t = {tv_sec = 0, tv_nsec = 250000000}
|
#2 0x00007f58895a6409 in row_drop_table_for_mysql (name=0x7f586c23e1e0 "edoc_devel_oh/#sql-4914_19d3d", trx=0x7f586d8a5318, drop_db=false, create_failed=0, nonatomic=true) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/row/row0mysql.cc:3639
|
err = <value optimized out>
|
table = 0x7f531359e6d0
|
page_nos = 0x5a3d0a08
|
filepath = 0x0
|
tablename = 0x0
|
locked_dictionary = true
|
info = 0x0
|
page_no = <value optimized out>
|
foreign = <value optimized out>
|
heap = 0x0
|
#3 0x00007f58894ebec5 in ha_innobase::delete_table (this=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/storage/innobase/handler/ha_innodb.cc:13671
|
err = <value optimized out>
|
trx_in_innodb = {m_trx = 0x7f586d8a5698}
|
iter =
|
thd = 0x7f534c0009a8
|
norm_name = "edoc_devel_oh/#sql-4914_19d3d", '\000' <repeats 19 times>, "\001;\204\211X\177\000\000\200\067\204\211X\177\000\000\000\001\204\211X\177", '\000' <repeats 18 times>"\377, \377\377\377\377\377\377\377", '\000' <repeats 16 times>, "\020\000\000\000\b\000\000\000\000\001\000\000\000\000\000\000\003\000\000\000\000\000\000\000 \000\000LS\177\000\000\220\v\000\000\000\000\000\000\020\020\001\000\000\000\000\000\340\342#lX\177\000\000\t\263\357\206X\177\000\000\360\342#lX\177\000\000\001\326\061\211X\177\000\000]\255\\\023S\177\000\000\002\000\000\000\000\000\000\000\340\342#l^\000\000\000.\000\000\000\000\000\000\000\005", '\000' <repeats 35 times>, "S\177\000\000\000\000\000\000\000\000\000\000\021\004", '\000' <repeats 14 times>...
|
parent_trx = 0x7f586d8a5698
|
trx = 0x7f586d8a5318
|
name_len = <value optimized out>
|
#4 0x00007f58892e2b50 in THD::rm_temporary_table (this=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/temporary_tables.cc:676
|
error = false
|
file = 0x7f5313591e60
|
frm_path = "./edoc_devel_oh/#sql-4914_19d3d.frm\000X\177\000\000\260\346#lX\177", '\000' <repeats 18 times>"\210, \r\000\000\000\000\000\000\020\020\000\000\000\000\000\000\200\r\000\000\000\000\000\000V|iT_\374\026\207X\205Y\023\036\000\000\000\000\000\000\000\036\000\000\000\006\000\000\000\000\000\000\000=\353L\211\362\001\000\000\030\257\234\211X\177\000\000\360\220Y\023S\177\000\000@\347#lX\177\000\000\260\246L\211X\177\000\000\000\000\000\000\000\000\000\000\360\220Y\023S\177\000\000\200\347#lX\177\000\000\000\000\000\000\000\000\000\000\362\001\000\000\000\000\000\000\001", '\000' <repeats 15 times>, "\036\000\000\000\000\000\000\000\360\347#lX\177\000\000r k\211X\177\000\000"...
|
#5 0x00007f58892e2fa1 in THD::free_tmp_table_share (this=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/temporary_tables.cc:1445
|
No locals.
|
#6 0x00007f58892e48a3 in THD::drop_temporary_table (this=0x7f534c0009a8, table=0x7f5313598558, is_trans=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/temporary_tables.cc:639
|
share = 0x7f53135b2a98
|
tab = <value optimized out>
|
locked = false
|
result = false
|
it = {list = <value optimized out>, current = 0x0}
|
#7 0x00007f5889238c0f in mysql_alter_table (thd=0x7f534c0009a8, new_db=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_table.cc:9653
|
|
...
|
|
#10 0x00007f58891b9d2a in mysql_parse (thd=0x7f534c0009a8, rawbuf=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:7887
|
found_semicolon = <value optimized out>
|
lex = 0x7f534c0042c0
|
err = <value optimized out>
|
__FUNCTION__ = "mysql_parse"
|
#11 0x00007f58891bc09e in dispatch_command (command=COM_QUERY, thd=0x7f534c0009a8, packet=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:1805
|
packet_end = 0x7f534c00f0b1 ""
|
parser_state = {m_input = {m_compute_digest = false}, m_lip = {m_thd = 0x7f534c0009a8, yylineno = 1, yylval = 0x7f586c2412a0, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f534c00f0b2 "\r", m_tok_start = 0x7f534c00f0b2 "\r", m_tok_end = 0x7f534c00f0b2 "\r", m_end_of_query = 0x7f534c00f0b1 "", m_tok_start_prev = 0x7f534c00f0b1 "", m_buf = 0x7f534c00f080 "ALTER TABLE unit MODIFY COLUMN ceu DECIMAL (10,2)", m_buf_length = 49, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f534c00f120 "ALTER TABLE unit MODIFY COLUMN ceu DECIMAL (10,2)", m_cpp_ptr = 0x7f534c00f151 "", m_cpp_tok_start = 0x7f534c00f151 "", m_cpp_tok_start_prev = 0x7f534c00f151 "", m_cpp_tok_end = 0x7f534c00f151 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x20 <Address 0x20 out of bounds>, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 28, m_cpp_text_start = 0x7f534c00f14f "2)", m_cpp_text_end = 0x7f534c00f150 ")", m_underscore_cs = 0x0, m_digest = 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}
|
net = 0x7f586c242150
|
do_end_of_statement = true
|
__FUNCTION__ = "dispatch_command"
|
error = false
|
drop_more_results = false
|
#12 0x00007f58891bc65e in do_command (thd=0x7f534c0009a8) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_parse.cc:1360
|
return_value = <value optimized out>
|
packet = <value optimized out>
|
packet_length = 50
|
net = 0x7f534c000be8
|
command = COM_QUERY
|
#13 0x00007f5889279faf in do_handle_one_connection (connect=) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_connect.cc:1354
|
create_user = true
|
thr_create_utime = <value optimized out>
|
thd = 0x7f534c0009a8
|
#14 0x00007f588927a0d4 in handle_one_connection (arg=0x7f58b8f07c28) at /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.2.11/sql/sql_connect.cc:1260
|
connect = 0x7f58b8f07c28
|
#15 0x00007f5888851aa1 in start_thread () from /lib64/libpthread.so.0
|
No symbol table info available.
|
#16 0x00007f5886f69bcd in clone () from /lib64/libc.so.6
|
No symbol table info available.
|
Attachments
Issue Links
- is caused by
-
MDEV-13483 10.0.33 merge
- Closed