Skip to content

Instantly share code, notes, and snippets.

@yoku0825

yoku0825/gist:70bf826917ed45b602fe35b09db552ef

Last active July 10, 2024 08:34
Show Gist options
  • Save yoku0825/70bf826917ed45b602fe35b09db552ef to your computer and use it in GitHub Desktop.
Save yoku0825/70bf826917ed45b602fe35b09db552ef to your computer and use it in GitHub Desktop.
Download ZIP
ALTER TABLE .. ADD FULLTEXT KEY .. WITH PARSER ngram の時の create_temp_file
Raw
gistfile1.txt
(gdb) b create_temp_file
+b create_temp_file
Breakpoint 1 at 0x206c8da: file /home/yoku0825/mysql-8.0.38/mysys/mf_tempfile.cc, line 277.
(gdb) c
+c
Continuing.
[Switching to Thread 0x7f2da46f6700 (LWP 2201)]
Breakpoint 1, create_temp_file (to=to@entry=0x7f2da46efa30 "\240\372n\244-\177", dir=dir@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib", mode=mode@entry=194,
unlink_or_keep=unlink_or_keep@entry=UNLINK_FILE, MyFlags=MyFlags@entry=16) at /home/yoku0825/mysql-8.0.38/mysys/mf_tempfile.cc:277
277 if (unlink_or_keep == UNLINK_FILE) {
(gdb) bt
+bt
#0 create_temp_file (to=to@entry=0x7f2da46efa30 "\240\372n\244-\177", dir=dir@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib", mode=mode@entry=194,
unlink_or_keep=unlink_or_keep@entry=UNLINK_FILE, MyFlags=MyFlags@entry=16) at /home/yoku0825/mysql-8.0.38/mysys/mf_tempfile.cc:277
#1 0x0000000000e8b2e0 in inline_mysql_file_create_temp (key=0, src_file=0x2fe1020 "/home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc", src_line=350, mode=194, unlink_or_keep=UNLINK_FILE,
myFlags=16, pfx=0x315be9f "ib", dir=0x50262f0 "/tmp", to=0x7f2da46efa30 "\240\372n\244-\177") at /home/yoku0825/mysql-8.0.38/include/mysql/psi/mysql_file.h:978
#2 mysql_tmpfile_path (path=path@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib") at /home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc:350
#3 0x00000000020abff0 in innobase_mysql_tmpfile (path=path@entry=0x50262f0 "/tmp") at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/ha_innodb.cc:2484
#4 0x00000000023b246e in ddl::file_create_low(char const*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:153
#5 0x00000000023b275c in ddl::file_create (file=0x7f2d58a6b358, path=path@entry=0x0) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:172
#6 0x00000000023b64c9 in ddl::FTS::Parser::init(unsigned long) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:387
#7 0x00000000023b666f in ddl::FTS::create(unsigned long) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:1497
#8 0x00000000023aff31 in ddl::Context::setup_fts_build (this=0x7f2da46f0440) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ctx.cc:451
#9 0x00000000023b9faa in ddl::Loader::prepare() () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:374
#10 0x00000000023bbb25 in ddl::Loader::build_all (this=this@entry=0x7f2da46f0340) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:478
#11 0x00000000023b06a5 in ddl::Context::build (this=this@entry=0x7f2da46f0440) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ctx.cc:514
#12 0x00000000021005c6 in ha_innobase::inplace_alter_table_impl<dd::Table> (this=this@entry=0x7f2d580cae90, altered_table=<optimized out>, altered_table@entry=0x7f2d589e8fa0,
ha_alter_info=<optimized out>, ha_alter_info@entry=0x7f2da46f1170) at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:6304
#13 0x00000000021008de in ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*, dd::Table const*, dd::Table*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:1558
#14 0x0000000000e69d82 in ha_inplace_alter_table (new_table_def=0x7f2d589e63b0, old_table_def=0x7f2d5808f290, ha_alter_info=0x7f2da46f1170, altered_table=0x7f2d589e8fa0, this=<optimized out>)
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13473
#15 mysql_inplace_alter_table(THD*, dd::Schema const&, dd::Schema const&, dd::Table const*, dd::Table*, Table_ref*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, Alter_table_ctx*, std::set<std::string, std::less<std::string>, Stateless_allocator<std::string, histograms::Histogram_psi_key_alloc, My_free_functor> >&, FOREIGN_KEY*, unsigned int, Foreign_key_parents_invalidator*) ()
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13534
#16 0x0000000000e7e7e6 in mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, Table_ref*, Alter_info*) () at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:17502
#17 0x00000000012a4129 in Sql_cmd_alter_table::execute(THD*) () at /home/yoku0825/mysql-8.0.38/sql/sql_alter.cc:350
#18 0x0000000000dc83ff in mysql_execute_command(THD*, bool) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:4722
#19 0x0000000000dcc090 in dispatch_sql_command(THD*, Parser_state*) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:5371
#20 0x0000000000dcd42e in dispatch_command(THD*, COM_DATA const*, enum_server_command) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:2055
#21 0x0000000000dcf80e in do_command (thd=thd@entry=0x7f2d58000d20) at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:1440
#22 0x0000000000f263f0 in handle_connection (arg=arg@entry=0x71e4da0) at /home/yoku0825/mysql-8.0.38/sql/conn_handler/connection_handler_per_thread.cc:303
#23 0x00000000024fe095 in pfs_spawn_thread (arg=0x71811a0) at /home/yoku0825/mysql-8.0.38/storage/perfschema/pfs.cc:3050
#24 0x00007f2dba426ea5 in start_thread (arg=0x7f2da46f6700) at pthread_create.c:307
#25 0x00007f2db8a40b0d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
(gdb) bt
+bt
#0 create_temp_file (to=to@entry=0x7f2da46efa30 "\200\372n\244-\177", dir=dir@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib", mode=mode@entry=194,
unlink_or_keep=unlink_or_keep@entry=UNLINK_FILE, MyFlags=MyFlags@entry=16) at /home/yoku0825/mysql-8.0.38/mysys/mf_tempfile.cc:277
#1 0x0000000000e8b2e0 in inline_mysql_file_create_temp (key=0, src_file=0x2fe1020 "/home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc", src_line=350, mode=194, unlink_or_keep=UNLINK_FILE,
myFlags=16, pfx=0x315be9f "ib", dir=0x50262f0 "/tmp", to=0x7f2da46efa30 "\200\372n\244-\177") at /home/yoku0825/mysql-8.0.38/include/mysql/psi/mysql_file.h:978
#2 mysql_tmpfile_path (path=path@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib") at /home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc:350
#3 0x00000000020abff0 in innobase_mysql_tmpfile (path=path@entry=0x50262f0 "/tmp") at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/ha_innodb.cc:2484
#4 0x00000000023b246e in ddl::file_create_low(char const*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:153
#5 0x00000000023b275c in ddl::file_create (file=0x7f2d58a6af38, path=path@entry=0x0) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:172
#6 0x00000000023b64c9 in ddl::FTS::Parser::init(unsigned long) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:387
#7 0x00000000023b666f in ddl::FTS::create(unsigned long) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:1497
#8 0x00000000023aff31 in ddl::Context::setup_fts_build (this=0x7f2da46f0440) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ctx.cc:451
#9 0x00000000023b9faa in ddl::Loader::prepare() () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:374
#10 0x00000000023bbb25 in ddl::Loader::build_all (this=this@entry=0x7f2da46f0340) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:478
#11 0x00000000023b06a5 in ddl::Context::build (this=this@entry=0x7f2da46f0440) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ctx.cc:514
#12 0x00000000021005c6 in ha_innobase::inplace_alter_table_impl<dd::Table> (this=this@entry=0x7f2d580cae90, altered_table=<optimized out>, altered_table@entry=0x7f2d589e8fa0,
ha_alter_info=<optimized out>, ha_alter_info@entry=0x7f2da46f1170) at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:6304
#13 0x00000000021008de in ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*, dd::Table const*, dd::Table*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:1558
#14 0x0000000000e69d82 in ha_inplace_alter_table (new_table_def=0x7f2d589e63b0, old_table_def=0x7f2d5808f290, ha_alter_info=0x7f2da46f1170, altered_table=0x7f2d589e8fa0, this=<optimized out>)
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13473
#15 mysql_inplace_alter_table(THD*, dd::Schema const&, dd::Schema const&, dd::Table const*, dd::Table*, Table_ref*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, Alter_table_ctx*, std::set<std::string, std::less<std::string>, Stateless_allocator<std::string, histograms::Histogram_psi_key_alloc, My_free_functor> >&, FOREIGN_KEY*, unsigned int, Foreign_key_parents_invalidator*) ()
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13534
#16 0x0000000000e7e7e6 in mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, Table_ref*, Alter_info*) () at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:17502
#17 0x00000000012a4129 in Sql_cmd_alter_table::execute(THD*) () at /home/yoku0825/mysql-8.0.38/sql/sql_alter.cc:350
#18 0x0000000000dc83ff in mysql_execute_command(THD*, bool) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:4722
#19 0x0000000000dcc090 in dispatch_sql_command(THD*, Parser_state*) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:5371
#20 0x0000000000dcd42e in dispatch_command(THD*, COM_DATA const*, enum_server_command) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:2055
#21 0x0000000000dcf80e in do_command (thd=thd@entry=0x7f2d58000d20) at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:1440
#22 0x0000000000f263f0 in handle_connection (arg=arg@entry=0x71e4da0) at /home/yoku0825/mysql-8.0.38/sql/conn_handler/connection_handler_per_thread.cc:303
#23 0x00000000024fe095 in pfs_spawn_thread (arg=0x71811a0) at /home/yoku0825/mysql-8.0.38/storage/perfschema/pfs.cc:3050
#24 0x00007f2dba426ea5 in start_thread (arg=0x7f2da46f6700) at pthread_create.c:307
#25 0x00007f2db8a40b0d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
..
(gdb) c
+c
Continuing.
[New Thread 0x7f2d7effd700 (LWP 2753)]
[New Thread 0x7f2d7e7fc700 (LWP 2754)]
Breakpoint 1, create_temp_file (to=to@entry=0x7f2da46ecb80 "\001", dir=dir@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib", mode=mode@entry=194, unlink_or_keep=unlink_or_keep@entry=UNLINK_FILE,
MyFlags=MyFlags@entry=16) at /home/yoku0825/mysql-8.0.38/mysys/mf_tempfile.cc:277
277 if (unlink_or_keep == UNLINK_FILE) {
(gdb) bt
+bt
#0 create_temp_file (to=to@entry=0x7f2da46ecb80 "\001", dir=dir@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib", mode=mode@entry=194, unlink_or_keep=unlink_or_keep@entry=UNLINK_FILE,
MyFlags=MyFlags@entry=16) at /home/yoku0825/mysql-8.0.38/mysys/mf_tempfile.cc:277
#1 0x0000000000e8b2e0 in inline_mysql_file_create_temp (key=0, src_file=0x2fe1020 "/home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc", src_line=350, mode=194, unlink_or_keep=UNLINK_FILE,
myFlags=16, pfx=0x315be9f "ib", dir=0x50262f0 "/tmp", to=0x7f2da46ecb80 "\001") at /home/yoku0825/mysql-8.0.38/include/mysql/psi/mysql_file.h:978
#2 mysql_tmpfile_path (path=path@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib") at /home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc:350
#3 0x00000000020abff0 in innobase_mysql_tmpfile (path=path@entry=0x50262f0 "/tmp") at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/ha_innodb.cc:2484
#4 0x00000000023b246e in ddl::file_create_low(char const*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:153
#5 0x00000000023b275c in ddl::file_create (file=file@entry=0x7f2d58bfd268, path=<optimized out>) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:172
#6 0x00000000024535e1 in ddl::Builder::create_file (this=<optimized out>, file=@0x7f2d58bfd268: {m_file = {<ut::Non_copyable> = {<No data fields>}, m_fd = -1}, m_size = 0, m_n_recs = 0})
at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0builder.cc:1163
#7 0x000000000245a5ac in ddl::Builder::bulk_add_row(ddl::Cursor&, ddl::Row&, unsigned long, std::function<dberr_t ()>&&) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0builder.cc:1522
#8 0x000000000245a935 in ddl::Builder::add_row(ddl::Cursor&, ddl::Row&, unsigned long, std::function<dberr_t ()>&&) (this=0x7f2d58a91df0, cursor=
Python Exception <class 'gdb.error'> There is no member or method named _M_head_impl.:
Python Exception <class 'gdb.error'> There is no member or method named _M_head_impl.:
@0x7f2d58a91ec0: {_vptr.Cursor = 0x3a66418 <vtable for ddl::Parallel_cursor+16>, m_ctx = @0x7f2da46f0440, m_row_heap = {m_ptr = }, m_tuple_heap = {m_ptr = }, m_prev_fields = 0x7f2d58a44d10}, row=
@0x7f2d58a467e0: {m_ext = 0x0, m_offsets = 0x7f2d58caa568, m_rec = 0x7f2d9d1fd213 "", m_ptr = 0x7f2d58caa5a0, m_add_cols = 0x0}, thread_id=0,
latch_release=<unknown type in /usr/mysql/8.0.38/bin/mysqld, CU 0x1a5ed014, DIE 0x1a68b78d>) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0builder.cc:1590
#9 0x00000000023bd72d in operator() (__closure=0x7f2da46edf00, thread_ctx=<optimized out>, row=
@0x7f2d58a467e0: {m_ext = 0x0, m_offsets = 0x7f2d58caa568, m_rec = 0x7f2d9d1fd213 "", m_ptr = 0x7f2d58caa5a0, m_add_cols = 0x0})
at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/std_function.h:211
#10 0x00000000023bda19 in operator() (read_ctx=0x7f2d58c22110, __closure=0x7f2d58a3bab0) at /home/yoku0825/mysql-8.0.38/storage/innobase/include/row0pread.h:711
#11 __invoke_impl<dberr_t, ddl::Parallel_cursor::scan(ddl::Builders&)::<lambda(const Parallel_reader::Ctx*)>&, const Parallel_reader::Ctx*> (__f=
@0x7f2d58a3bab0: {__rows = std::vector of length 1, capacity 1 = {
[0] = {m_ext = 0x0, m_offsets = 0x7f2d58caa568, m_rec = 0x7f2d9d1fd213 "", m_ptr = 0x7f2d58caa5a0, m_add_cols = 0x0}
}, __this = 0x7f2d58a91ec0, __bulk_inserter = @0x7f2da46edf00, __n_rows = std::vector of length 1, capacity 1 = {
[0] = 75
}}) at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/invoke.h:61
#12 __invoke_r<dberr_t, ddl::Parallel_cursor::scan(ddl::Builders&)::<lambda(const Parallel_reader::Ctx*)>&, const Parallel_reader::Ctx*> (__fn=
@0x7f2d58a3bab0: {__rows = std::vector of length 1, capacity 1 = {
[0] = {m_ext = 0x0, m_offsets = 0x7f2d58caa568, m_rec = 0x7f2d9d1fd213 "", m_ptr = 0x7f2d58caa5a0, m_add_cols = 0x0}
}, __this = 0x7f2d58a91ec0, __bulk_inserter = @0x7f2da46edf00, __n_rows = std::vector of length 1, capacity 1 = {
[0] = 75
}}) at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/invoke.h:114
#13 std::_Function_handler<dberr_t(const Parallel_reader::Ctx*), ddl::Parallel_cursor::scan(ddl::Builders&)::<lambda(const Parallel_reader::Ctx*)> >::_M_invoke(const std::_Any_data &, <unknown type in /usr/mysql/8.0.38/bin/mysqld, CU 0x196fbdb3, DIE 0x19789a01>) (__functor=<optimized out>, __args#0=<optimized out>) at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/std_function.h:290
#14 0x0000000002202f52 in operator() (__args#0=0x7f2d58c22110, this=<optimized out>) at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/std_function.h:586
#15 Parallel_reader::Ctx::traverse_recs (this=this@entry=0x7f2d58c22110, pcursor=pcursor@entry=0x7f2da46ed8c0, mtr=mtr@entry=0x7f2da46ed8e0)
at /home/yoku0825/mysql-8.0.38/storage/innobase/row/row0pread.cc:753
#16 0x00000000022032f9 in Parallel_reader::Ctx::traverse() () at /home/yoku0825/mysql-8.0.38/storage/innobase/row/row0pread.cc:634
#17 0x00000000022088f0 in Parallel_reader::worker(Parallel_reader::Thread_ctx*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/row/row0pread.cc:869
#18 0x0000000002209031 in Parallel_reader::parallel_read() () at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/stl_vector.h:1043
#19 0x00000000022090f0 in Parallel_reader::spawn (this=this@entry=0x7f2da46edff0, n_threads=<optimized out>) at /home/yoku0825/mysql-8.0.38/storage/innobase/row/row0pread.cc:1348
#20 0x0000000002209182 in Parallel_reader::run (this=this@entry=0x7f2da46edff0, n_threads=n_threads@entry=0) at /home/yoku0825/mysql-8.0.38/storage/innobase/row/row0pread.cc:1363
#21 0x00000000023bf0b4 in ddl::Parallel_cursor::scan(std::vector<ddl::Builder*, ut::allocator<ddl::Builder*, ut::detail::allocator_base_pfs<ddl::Builder*> > >&) ()
at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0par-scan.cc:373
#22 0x00000000023bbac2 in ddl::Loader::scan_and_build_indexes (this=this@entry=0x7f2da46f0340) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:449
#23 0x00000000023bbbf8 in ddl::Loader::build_all (this=this@entry=0x7f2da46f0340) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:481
#24 0x00000000023b06a5 in ddl::Context::build (this=this@entry=0x7f2da46f0440) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ctx.cc:514
#25 0x00000000021005c6 in ha_innobase::inplace_alter_table_impl<dd::Table> (this=this@entry=0x7f2d580cae90, altered_table=<optimized out>, altered_table@entry=0x7f2d589e8fa0,
ha_alter_info=<optimized out>, ha_alter_info@entry=0x7f2da46f1170) at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:6304
#26 0x00000000021008de in ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*, dd::Table const*, dd::Table*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:1558
#27 0x0000000000e69d82 in ha_inplace_alter_table (new_table_def=0x7f2d589e63b0, old_table_def=0x7f2d5808f290, ha_alter_info=0x7f2da46f1170, altered_table=0x7f2d589e8fa0, this=<optimized out>)
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13473
#28 mysql_inplace_alter_table(THD*, dd::Schema const&, dd::Schema const&, dd::Table const*, dd::Table*, Table_ref*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, Alter_table_ctx*, std::set<std::string, std::less<std::string>, Stateless_allocator<std::string, histograms::Histogram_psi_key_alloc, My_free_functor> >&, FOREIGN_KEY*, unsigned int, Foreign_key_parents_invalidator*) ()
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13534
#29 0x0000000000e7e7e6 in mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, Table_ref*, Alter_info*) () at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:17502
#30 0x00000000012a4129 in Sql_cmd_alter_table::execute(THD*) () at /home/yoku0825/mysql-8.0.38/sql/sql_alter.cc:350
#31 0x0000000000dc83ff in mysql_execute_command(THD*, bool) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:4722
#32 0x0000000000dcc090 in dispatch_sql_command(THD*, Parser_state*) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:5371
#33 0x0000000000dcd42e in dispatch_command(THD*, COM_DATA const*, enum_server_command) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:2055
#34 0x0000000000dcf80e in do_command (thd=thd@entry=0x7f2d58000d20) at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:1440
#35 0x0000000000f263f0 in handle_connection (arg=arg@entry=0x71e4da0) at /home/yoku0825/mysql-8.0.38/sql/conn_handler/connection_handler_per_thread.cc:303
#36 0x00000000024fe095 in pfs_spawn_thread (arg=0x71811a0) at /home/yoku0825/mysql-8.0.38/storage/perfschema/pfs.cc:3050
#37 0x00007f2dba426ea5 in start_thread (arg=0x7f2da46f6700) at pthread_create.c:307
#38 0x00007f2db8a40b0d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
[yoku0825@yoku0825-conoha ~]$ lsof -p $(pidof mysqld) | grep deleted
mysqld 2130 yoku0825 5u REG 253,2 0 919571 /tmp/#919571 (deleted)
mysqld 2130 yoku0825 6u REG 253,2 0 920360 /tmp/#920360 (deleted)
mysqld 2130 yoku0825 7u REG 253,2 0 920367 /tmp/#920367 (deleted)
mysqld 2130 yoku0825 12u REG 253,2 0 920371 /tmp/#920371 (deleted)
mysqld 2130 yoku0825 38u REG 253,2 152535040 920383 /tmp/#920383 (deleted)
mysqld 2130 yoku0825 39u REG 253,2 0 920391 /tmp/#920391 (deleted)
mysqld 2130 yoku0825 40u REG 253,2 0 920397 /tmp/#920397 (deleted)
mysqld 2130 yoku0825 41u REG 253,2 0 920398 /tmp/#920398 (deleted)
mysqld 2130 yoku0825 42u REG 253,2 0 920423 /tmp/#920423 (deleted)
mysqld 2130 yoku0825 43u REG 253,2 0 921955 /tmp/#921955 (deleted)
mysqld 2130 yoku0825 44u REG 253,2 152764416 923519 /tmp/#923519 (deleted)
mysqld 2130 yoku0825 45u REG 253,2 0 923528 /tmp/#923528 (deleted)
mysqld 2130 yoku0825 46u REG 253,2 0 923529 /tmp/#923529 (deleted)
mysqld 2130 yoku0825 47u REG 253,2 0 923530 /tmp/#923530 (deleted)
mysqld 2130 yoku0825 48u REG 253,2 0 923532 /tmp/#923532 (deleted)
mysqld 2130 yoku0825 49u REG 253,2 0 923533 /tmp/#923533 (deleted)
mysqld 2130 yoku0825 51uW REG 253,2 114688 1706029 /usr/mysql/8.0.38/data/d1/fts_0000000000000473_being_deleted.ibd
mysqld 2130 yoku0825 52uW REG 253,2 114688 1706030 /usr/mysql/8.0.38/data/d1/fts_0000000000000473_being_deleted_cache.ibd
mysqld 2130 yoku0825 55uW REG 253,2 114688 1706032 /usr/mysql/8.0.38/data/d1/fts_0000000000000473_deleted.ibd
mysqld 2130 yoku0825 56uW REG 253,2 114688 1706033 /usr/mysql/8.0.38/data/d1/fts_0000000000000473_deleted_cache.ibd
mysqld 2130 yoku0825 58u REG 253,2 11919360 923635 /tmp/#923635 (deleted)
(gdb) bt
+bt
#0 create_temp_file (to=to@entry=0x7f2d7effbee0 "", dir=dir@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib", mode=mode@entry=194, unlink_or_keep=unlink_or_keep@entry=UNLINK_FILE,
MyFlags=MyFlags@entry=16) at /home/yoku0825/mysql-8.0.38/mysys/mf_tempfile.cc:277
#1 0x0000000000e8b2e0 in inline_mysql_file_create_temp (key=0, src_file=0x2fe1020 "/home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc", src_line=350, mode=194, unlink_or_keep=UNLINK_FILE,
myFlags=16, pfx=0x315be9f "ib", dir=0x50262f0 "/tmp", to=0x7f2d7effbee0 "") at /home/yoku0825/mysql-8.0.38/include/mysql/psi/mysql_file.h:978
#2 mysql_tmpfile_path (path=path@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib") at /home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc:350
#3 0x00000000020abff0 in innobase_mysql_tmpfile (path=path@entry=0x50262f0 "/tmp") at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/ha_innodb.cc:2484
#4 0x00000000023b246e in ddl::file_create_low(char const*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:153
#5 0x00000000023bcc3f in ddl::Merge_file_sort::sort(ddl::Builder*, std::deque<unsigned long, ut::allocator<unsigned long, ut::detail::allocator_base_pfs<unsigned long> > >&) ()
at /home/yoku0825/mysql-8.0.38/storage/innobase/include/ddl0impl-builder.h:202
#6 0x00000000023b7925 in ddl::FTS::Parser::parse(ddl::Builder*)::{lambda()#2}::operator()() const () at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/unique_ptr.h:421
#7 0x00000000023b8454 in ddl::FTS::Parser::parse (this=this@entry=0x7f2d58a3eb20, builder=<optimized out>, builder@entry=0x7f2d58a91d20) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:1068
#8 0x00000000023b8521 in operator() (__closure=<optimized out>) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:1552
#9 __invoke_impl<dberr_t, ddl::FTS::start_parse_threads(ddl::Builder*)::<lambda(PSI_thread_seqnum, ddl::FTS::Parser*, ddl::Builder*)>::<lambda()> > (__f=<optimized out>)
at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/invoke.h:61
#10 __invoke<ddl::FTS::start_parse_threads(ddl::Builder*)::<lambda(PSI_thread_seqnum, ddl::FTS::Parser*, ddl::Builder*)>::<lambda()> > (__fn=<optimized out>)
at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/invoke.h:96
#11 invoke<ddl::FTS::start_parse_threads(ddl::Builder*)::<lambda(PSI_thread_seqnum, ddl::FTS::Parser*, ddl::Builder*)>::<lambda()> > (__fn=<optimized out>)
at /opt/rh/devtoolset-11/root/usr/include/c++/11/functional:97
#12 operator()<ddl::FTS::start_parse_threads(ddl::Builder*)::<lambda(PSI_thread_seqnum, ddl::FTS::Parser*, ddl::Builder*)>::<lambda()> > (f=<optimized out>, this=0x7f2d7effcb30)
at /home/yoku0825/mysql-8.0.38/storage/innobase/include/os0thread-create.h:154
#13 operator() (__closure=<optimized out>, builder=0x7f2d58a91d20, parser=0x7f2d58a3eb20, seqnum=<optimized out>) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:1547
#14 __invoke_impl<void, ddl::FTS::start_parse_threads(ddl::Builder*)::<lambda(PSI_thread_seqnum, ddl::FTS::Parser*, ddl::Builder*)>, long unsigned int, ddl::FTS::Parser*, ddl::Builder*> (
__f=<optimized out>) at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/invoke.h:61
#15 __invoke<ddl::FTS::start_parse_threads(ddl::Builder*)::<lambda(PSI_thread_seqnum, ddl::FTS::Parser*, ddl::Builder*)>, long unsigned int, ddl::FTS::Parser*, ddl::Builder*> (__fn=<optimized out>)
at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/invoke.h:96
#16 _M_invoke<0, 1, 2, 3> (this=<optimized out>) at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/std_thread.h:253
#17 operator() (this=<optimized out>) at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/std_thread.h:260
#18 std::thread::_State_impl<std::thread::_Invoker<std::tuple<ddl::FTS::start_parse_threads(ddl::Builder*)::<lambda(PSI_thread_seqnum, ddl::FTS::Parser*, ddl::Builder*)>, long unsigned int, ddl::FTS::Parser*, ddl::Builder*> > >::_M_run(void) (this=<optimized out>) at /opt/rh/devtoolset-11/root/usr/include/c++/11/bits/std_thread.h:211
#19 0x0000000002868f54 in execute_native_thread_routine ()
#20 0x00007f2dba426ea5 in start_thread (arg=0x7f2d7effd700) at pthread_create.c:307
#21 0x00007f2db8a40b0d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Raw
gistfile2.txt
(gdb)
+bt
#0 open64 () at ../sysdeps/unix/syscall-template.S:81
#1 0x000000000206c9ae in open (__oflag=4784130, __path=0x7f2da46ef780 "/tmp/") at /usr/include/bits/fcntl2.h:53
#2 operator() (__closure=<optimized out>) at /home/yoku0825/mysql-8.0.38/mysys/mf_tempfile.cc:297
#3 RetryOnEintr<create_temp_file(char*, char const*, char const*, int, UnlinkOrKeepFile, myf)::<lambda()>, int> (err=<optimized out>, sysc=<optimized out>)
at /home/yoku0825/mysql-8.0.38/mysys/mysys_priv.h:112
#4 create_temp_file (to=to@entry=0x7f2da46efa30 "/tmp/ibfd=4194304", dir=<optimized out>, dir@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib", mode=mode@entry=194,
unlink_or_keep=unlink_or_keep@entry=UNLINK_FILE, MyFlags=MyFlags@entry=16) at /home/yoku0825/mysql-8.0.38/mysys/mf_tempfile.cc:295
#5 0x0000000000e8b2e0 in inline_mysql_file_create_temp (key=0, src_file=0x2fe1020 "/home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc", src_line=350, mode=194, unlink_or_keep=UNLINK_FILE,
myFlags=16, pfx=0x315be9f "ib", dir=0x50262f0 "/tmp", to=0x7f2da46efa30 "/tmp/ibfd=4194304") at /home/yoku0825/mysql-8.0.38/include/mysql/psi/mysql_file.h:978
#6 mysql_tmpfile_path (path=path@entry=0x50262f0 "/tmp", prefix=prefix@entry=0x315be9f "ib") at /home/yoku0825/mysql-8.0.38/sql/sql_thd_internal_api.cc:350
#7 0x00000000020abff0 in innobase_mysql_tmpfile (path=path@entry=0x50262f0 "/tmp") at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/ha_innodb.cc:2484
#8 0x00000000023b246e in ddl::file_create_low(char const*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:153
#9 0x00000000023b275c in ddl::file_create (file=0x7f2d58a08f88, path=path@entry=0x0) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:172
#10 0x00000000023b64c9 in ddl::FTS::Parser::init(unsigned long) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:387
#11 0x00000000023b666f in ddl::FTS::create(unsigned long) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:1497
#12 0x00000000023aff31 in ddl::Context::setup_fts_build (this=0x7f2da46f0440) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ctx.cc:451
#13 0x00000000023b9faa in ddl::Loader::prepare() () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:374
#14 0x00000000023bbb25 in ddl::Loader::build_all (this=this@entry=0x7f2da46f0340) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:478
#15 0x00000000023b06a5 in ddl::Context::build (this=this@entry=0x7f2da46f0440) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ctx.cc:514
#16 0x00000000021005c6 in ha_innobase::inplace_alter_table_impl<dd::Table> (this=this@entry=0x7f2d589e1500, altered_table=<optimized out>, altered_table@entry=0x7f2d58a0a3f0,
ha_alter_info=<optimized out>, ha_alter_info@entry=0x7f2da46f1170) at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:6304
#17 0x00000000021008de in ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*, dd::Table const*, dd::Table*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:1558
#18 0x0000000000e69d82 in ha_inplace_alter_table (new_table_def=0x7f2d589f6840, old_table_def=0x7f2d58a6e8c0, ha_alter_info=0x7f2da46f1170, altered_table=0x7f2d58a0a3f0, this=<optimized out>)
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13473
#19 mysql_inplace_alter_table(THD*, dd::Schema const&, dd::Schema const&, dd::Table const*, dd::Table*, Table_ref*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, Alter_table_ctx*, std::set<std::string, std::less<std::string>, Stateless_allocator<std::string, histograms::Histogram_psi_key_alloc, My_free_functor> >&, FOREIGN_KEY*, unsigned int, Foreign_key_parents_invalidator*) ()
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13534
#20 0x0000000000e7e7e6 in mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, Table_ref*, Alter_info*) () at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:17502
#21 0x00000000012a4129 in Sql_cmd_alter_table::execute(THD*) () at /home/yoku0825/mysql-8.0.38/sql/sql_alter.cc:350
#22 0x0000000000dc83ff in mysql_execute_command(THD*, bool) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:4722
#23 0x0000000000dcc090 in dispatch_sql_command(THD*, Parser_state*) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:5371
#24 0x0000000000dcd42e in dispatch_command(THD*, COM_DATA const*, enum_server_command) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:2055
#25 0x0000000000dcf80e in do_command (thd=thd@entry=0x7f2d58000d20) at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:1440
#26 0x0000000000f263f0 in handle_connection (arg=arg@entry=0x71e4da0) at /home/yoku0825/mysql-8.0.38/sql/conn_handler/connection_handler_per_thread.cc:303
#27 0x00000000024fe095 in pfs_spawn_thread (arg=0x71811a0) at /home/yoku0825/mysql-8.0.38/storage/perfschema/pfs.cc:3050
#28 0x00007f2dba426ea5 in start_thread (arg=0x7f2da46f6700) at pthread_create.c:307
#29 0x00007f2db8a40b0d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
(gdb) up
+up
#1 0x000000000206c9ae in open (__oflag=4784130, __path=0x7f2da46ef780 "/tmp/") at /usr/include/bits/fcntl2.h:53
53 return __open_alias (__path, __oflag, __va_arg_pack ());
(gdb) xxd __path 100
+xxd __path 100
++dump binary memory dump.bin __path __path+100
++shell xxd dump.bin
0000000: 2f74 6d70 2f00 0000 7304 0000 0000 0000 /tmp/...s.......
0000010: 0000 0000 2d7f 0000 4919 1703 0000 0000 ....-...I.......
0000020: c0fd 6ea4 2d7f 0000 002e af8d 8e38 3495 ..n.-........84.
0000030: 08ff 6ea4 2d7f 0000 0884 a458 2d7f 0000 ..n.-......X-...
0000040: e0f9 6ea4 2d7f 0000 0884 a458 2d7f 0000 ..n.-......X-...
0000050: 94df cc9c 2d7f 0000 0500 0000 0000 0000 ....-...........
0000060: 40f8 6ea4 @.n.
Breakpoint 1, close () at ../sysdeps/unix/syscall-template.S:81
81 T_PSEUDO (SYSCALL_SYMBOL, SYSCALL_NAME, SYSCALL_NARGS)
(gdb) bt
+bt
#0 close () at ../sysdeps/unix/syscall-template.S:81
#1 0x00000000020722b3 in operator() (__closure=<optimized out>) at /home/yoku0825/mysql-8.0.38/mysys/my_open.cc:112
#2 RetryOnEintr<my_close(File, myf)::<lambda()>, int> (err=<optimized out>, sysc=<optimized out>) at /home/yoku0825/mysql-8.0.38/mysys/mysys_priv.h:112
#3 my_close(int, int) () at /home/yoku0825/mysql-8.0.38/mysys/my_open.cc:112
#4 0x00000000020ac018 in innobase_mysql_tmpfile (path=path@entry=0x50262f0 "/tmp") at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/ha_innodb.cc:2534
#5 0x00000000023b246e in ddl::file_create_low(char const*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:153
#6 0x00000000023b275c in ddl::file_create (file=0x7f2d58be9ca8, path=path@entry=0x0) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ddl.cc:172
#7 0x00000000023b64c9 in ddl::FTS::Parser::init(unsigned long) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:387
#8 0x00000000023b666f in ddl::FTS::create(unsigned long) () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0fts.cc:1497
#9 0x00000000023aff31 in ddl::Context::setup_fts_build (this=0x7f2da46f0440) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ctx.cc:451
#10 0x00000000023b9faa in ddl::Loader::prepare() () at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:374
#11 0x00000000023bbb25 in ddl::Loader::build_all (this=this@entry=0x7f2da46f0340) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0loader.cc:478
#12 0x00000000023b06a5 in ddl::Context::build (this=this@entry=0x7f2da46f0440) at /home/yoku0825/mysql-8.0.38/storage/innobase/ddl/ddl0ctx.cc:514
#13 0x00000000021005c6 in ha_innobase::inplace_alter_table_impl<dd::Table> (this=this@entry=0x7f2d58a620e0, altered_table=<optimized out>, altered_table@entry=0x7f2d58be64b0,
ha_alter_info=<optimized out>, ha_alter_info@entry=0x7f2da46f1170) at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:6304
#14 0x00000000021008de in ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*, dd::Table const*, dd::Table*) () at /home/yoku0825/mysql-8.0.38/storage/innobase/handler/handler0alter.cc:1558
#15 0x0000000000e69d82 in ha_inplace_alter_table (new_table_def=0x7f2d58a81b60, old_table_def=0x7f2d58a6e8c0, ha_alter_info=0x7f2da46f1170, altered_table=0x7f2d58be64b0, this=<optimized out>)
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13473
#16 mysql_inplace_alter_table(THD*, dd::Schema const&, dd::Schema const&, dd::Table const*, dd::Table*, Table_ref*, TABLE*, TABLE*, Alter_inplace_info*, enum_alter_inplace_result, Alter_table_ctx*, std::set<std::string, std::less<std::string>, Stateless_allocator<std::string, histograms::Histogram_psi_key_alloc, My_free_functor> >&, FOREIGN_KEY*, unsigned int, Foreign_key_parents_invalidator*) ()
at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:13534
#17 0x0000000000e7e7e6 in mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, Table_ref*, Alter_info*) () at /home/yoku0825/mysql-8.0.38/sql/sql_table.cc:17502
#18 0x00000000012a4129 in Sql_cmd_alter_table::execute(THD*) () at /home/yoku0825/mysql-8.0.38/sql/sql_alter.cc:350
#19 0x0000000000dc83ff in mysql_execute_command(THD*, bool) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:4722
#20 0x0000000000dcc090 in dispatch_sql_command(THD*, Parser_state*) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:5371
#21 0x0000000000dcd42e in dispatch_command(THD*, COM_DATA const*, enum_server_command) () at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:2055
#22 0x0000000000dcf80e in do_command (thd=thd@entry=0x7f2d58000d20) at /home/yoku0825/mysql-8.0.38/sql/sql_parse.cc:1440
#23 0x0000000000f263f0 in handle_connection (arg=arg@entry=0x71e4da0) at /home/yoku0825/mysql-8.0.38/sql/conn_handler/connection_handler_per_thread.cc:303
#24 0x00000000024fe095 in pfs_spawn_thread (arg=0x71811a0) at /home/yoku0825/mysql-8.0.38/storage/perfschema/pfs.cc:3050
#25 0x00007f2dba426ea5 in start_thread (arg=0x7f2da46f6700) at pthread_create.c:307
#26 0x00007f2db8a40b0d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment