博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
drop table big_table 调试
阅读量:7210 次
发布时间:2019-06-29

本文共 10556 字,大约阅读时间需要 35 分钟。

(gdb) thread apply all btThread 9 (Thread 0x7f5430627940 (LWP 5126)):#0  0x00007f5497db1019 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0#1  0x0000000000baaa63 in os_cond_wait (cond=0x42b5d40, fast_mutex=0x42b5d00) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:214#2  0x0000000000baaadf in os_event_wait_low (event=0x42b5d00, reset_sig_count=1) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:592#3  0x0000000000c6ff5d in sync_array_wait_event (arr=0x1943d60, index=0) at /usr/src/mysql-5.6.28/storage/innobase/sync/sync0arr.cc:424#4  0x0000000000c71bbe in rw_lock_s_lock_spin (lock=0x7f543a683530, pass=2, file_name=0x1071be0 "/usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc", line=1062) at /usr/src/mysql-5.6.28/storage/innobase/sync/sync0rw.cc:429#5  0x0000000000cf9c64 in rw_lock_s_lock_func (lock=0x7f543a683530, pass=2, file_name=0x1071be0 "/usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc", line=1062) at /usr/src/mysql-5.6.28/storage/innobase/include/sync0rw.ic:369#6  0x0000000000cf9d10 in pfs_rw_lock_s_lock_func (lock=0x7f543a683530, pass=2, file_name=0x1071be0 "/usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc", line=1062) at /usr/src/mysql-5.6.28/storage/innobase/include/sync0rw.ic:697#7  0x0000000000cfb7a4 in buf_flush_page (buf_pool=0x19a61a8, bpage=0x7f543a683400, flush_type=BUF_FLUSH_LIST, sync=false) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:1062#8  0x0000000000cfbb7c in buf_flush_try_neighbors (space=191, offset=11800, flush_type=BUF_FLUSH_LIST, n_flushed=15, n_to_flush=25) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:1273#9  0x0000000000cfbe60 in buf_flush_page_and_try_neighbors (bpage=0x7f543a683400, flush_type=BUF_FLUSH_LIST, n_to_flush=25, count=0x7f5430626f70) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:1350#10 0x0000000000cfc453 in buf_do_flush_list_batch (buf_pool=0x19a61a8, min_n=25, lsn_limit=18446744073709551615) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:1625#11 0x0000000000cfc833 in buf_flush_batch (buf_pool=0x19a61a8, flush_type=BUF_FLUSH_LIST, min_n=25, lsn_limit=18446744073709551615) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:1700#12 0x0000000000cfcc88 in buf_flush_list (min_n=25, lsn_limit=18446744073709551615, n_processed=0x7f5430627068) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:1937#13 0x0000000000cfcdf5 in page_cleaner_do_flush_batch (n_to_flush=200, lsn_limit=18446744073709551615) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:2166#14 0x0000000000cfd85f in buf_flush_page_cleaner_thread (arg=0x0) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:2432#15 0x00007f5497dac83d in start_thread () from /lib64/libpthread.so.0#16 0x00007f5497259fdd in clone () from /lib64/libc.so.6#17 0x0000000000000000 in ?? ()Thread 4 (Thread 0x7f542e5e1940 (LWP 5160)):#0  0x0000000000c73635 in sync_thread_levels_g (arr=0x4ab7330, limit=146, warn=0) at /usr/src/mysql-5.6.28/storage/innobase/sync/sync0sync.cc:845#1  0x0000000000c7456d in sync_thread_add_level (latch=0x7f5442ed5cb0, level=146, relock=0) at /usr/src/mysql-5.6.28/storage/innobase/sync/sync0sync.cc:1206#2  0x0000000000c74f2c in mutex_set_debug_info (mutex=0x7f5442ed5cb0, file_name=0x106d580 "/usr/src/mysql-5.6.28/storage/innobase/buf/buf0buf.cc", line=4536) at /usr/src/mysql-5.6.28/storage/innobase/sync/sync0sync.cc:615#3  0x0000000000ce43c5 in mutex_enter_func (mutex=0x7f5442ed5cb0, file_name=0x106d580 "/usr/src/mysql-5.6.28/storage/innobase/buf/buf0buf.cc", line=4536) at /usr/src/mysql-5.6.28/storage/innobase/include/sync0sync.ic:213#4  0x0000000000ce4478 in pfs_mutex_enter_func (mutex=0x7f5442ed5cb0, file_name=0x106d580 "/usr/src/mysql-5.6.28/storage/innobase/buf/buf0buf.cc", line=4536) at /usr/src/mysql-5.6.28/storage/innobase/include/sync0sync.ic:250#5  0x0000000000ce6f0f in buf_pool_validate_instance (buf_pool=0x19a5d38) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0buf.cc:4536#6  0x0000000000ce7d58 in buf_validate () at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0buf.cc:4754#7  0x0000000000ceedc0 in buf_page_get_gen (space=191, zip_size=0, offset=0, rw_latch=2, guess=0x0, mode=10, file=0x10862e0 "/usr/src/mysql-5.6.28/storage/innobase/fsp/fsp0fsp.cc", line=200, mtr=0x7f542e5dd6a0) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0buf.cc:3087#8  0x0000000000d5a2dd in fsp_get_space_header (id=191, zip_size=0, mtr=0x7f542e5dd6a0) at /usr/src/mysql-5.6.28/storage/innobase/fsp/fsp0fsp.cc:200#9  0x0000000000d60d37 in fsp_reserve_free_extents (n_reserved=0x7f542e5dd5f0, space=191, n_ext=1, alloc_type=3000000, mtr=0x7f542e5dd6a0) at /usr/src/mysql-5.6.28/storage/innobase/fsp/fsp0fsp.cc:2745#10 0x0000000000ccb028 in btr_cur_pessimistic_delete (err=0x7f542e5ddb84, has_reserved_extents=0, cursor=0x4943f78, flags=0, rb_ctx=RB_NORMAL, mtr=0x7f542e5dd6a0) at /usr/src/mysql-5.6.28/storage/innobase/btr/btr0cur.cc:3357#11 0x0000000000d94dcc in row_undo_ins_remove_clust_rec (node=0x4943f08) at /usr/src/mysql-5.6.28/storage/innobase/row/row0uins.cc:151#12 0x0000000000d950c8 in row_undo_ins (node=0x4943f08) at /usr/src/mysql-5.6.28/storage/innobase/row/row0uins.cc:461#13 0x0000000000c4c9d1 in row_undo (node=0x4943f08, thr=0x486e500) at /usr/src/mysql-5.6.28/storage/innobase/row/row0undo.cc:303#14 0x0000000000c4cb06 in row_undo_step (thr=0x486e500) at /usr/src/mysql-5.6.28/storage/innobase/row/row0undo.cc:350#15 0x0000000000bd8a99 in que_thr_step (thr=0x486e500) at /usr/src/mysql-5.6.28/storage/innobase/que/que0que.cc:1077#16 0x0000000000bd8cb4 in que_run_threads_low (thr=0x486e500) at /usr/src/mysql-5.6.28/storage/innobase/que/que0que.cc:1141#17 0x0000000000bd8e5c in que_run_threads (thr=0x486e500) at /usr/src/mysql-5.6.28/storage/innobase/que/que0que.cc:1182#18 0x0000000000c8c5e4 in trx_rollback_to_savepoint_low (trx=0x495b098, savept=0x495b410) at /usr/src/mysql-5.6.28/storage/innobase/trx/trx0roll.cc:112#19 0x0000000000c8cdea in trx_rollback_to_savepoint (trx=0x495b098, savept=0x495b410) at /usr/src/mysql-5.6.28/storage/innobase/trx/trx0roll.cc:154#20 0x0000000000c8d33d in trx_rollback_last_sql_stat_for_mysql (trx=0x495b098) at /usr/src/mysql-5.6.28/storage/innobase/trx/trx0roll.cc:247#21 0x0000000000b329de in innobase_rollback (hton=0x194f7c0, thd=0x1934550, rollback_trx=false) at /usr/src/mysql-5.6.28/storage/innobase/handler/ha_innodb.cc:3637#22 0x0000000000625cd2 in ha_rollback_low (thd=0x1934550, all=false) at /usr/src/mysql-5.6.28/sql/handler.cc:1555#23 0x0000000000a4bd26 in MYSQL_BIN_LOG::rollback (this=0x180f380 
, thd=0x1934550, all=false) at /usr/src/mysql-5.6.28/sql/binlog.cc:1561#24 0x0000000000625b51 in ha_rollback_trans (thd=0x1934550, all=false) at /usr/src/mysql-5.6.28/sql/handler.cc:1626#25 0x000000000089eb79 in trans_rollback_stmt (thd=0x1934550) at /usr/src/mysql-5.6.28/sql/transaction.cc:484#26 0x00000000007d6090 in mysql_execute_command (thd=0x1934550) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:5032#27 0x00000000007d67c4 in mysql_parse (thd=0x1934550, rawbuf=0x49b8380 "insert into big_table select * from big_table", length=45, parser_state=0x7f542e5e0910) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:6386#28 0x00000000007d83f4 in dispatch_command (command=COM_QUERY, thd=0x1934550, packet=0x48e8fb1 "insert into big_table select * from big_table", packet_length=45) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:1340#29 0x00000000007d9c80 in do_command (thd=0x1934550) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:1037#30 0x000000000078e3fb in do_handle_one_connection (thd_arg=0x1934550) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:982#31 0x000000000078e4c1 in handle_one_connection (arg=0x1934550) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:898#32 0x0000000000b11172 in pfs_spawn_thread (arg=0x47889a0) at /usr/src/mysql-5.6.28/storage/perfschema/pfs.cc:1860#33 0x00007f5497dac83d in start_thread () from /lib64/libpthread.so.0#34 0x00007f5497259fdd in clone () from /lib64/libc.so.6#35 0x0000000000000000 in ?? ()
Thread 3 (Thread 0x7f542e5a0940 (LWP 6005)):#0  0x00007f5497db1280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0#1  0x0000000000abe163 in safe_cond_timedwait (cond=0x49523e8, mp=0x4952378, abstime=0x7f542e59dba0, file=0xf07240 "/usr/src/mysql-5.6.28/include/mysql/psi/mysql_thread.h", line=1199) at /usr/src/mysql-5.6.28/mysys/thr_mutex.c:278#2  0x000000000070497e in inline_mysql_cond_timedwait (that=0x49523e8, mutex=0x4952378, abstime=0x7f542e59dba0, src_file=0xf070a8 "/usr/src/mysql-5.6.28/sql/mdl.cc", src_line=1327) at /usr/src/mysql-5.6.28/include/mysql/psi/mysql_thread.h:1199#3  0x0000000000704a42 in MDL_wait::timed_wait (this=0x4952378, owner=0x4952290, abs_timeout=0x7f542e59dba0, set_status_on_timeout=false, wait_state_name=0x14f4b30 
) at /usr/src/mysql-5.6.28/sql/mdl.cc:1326#4 0x0000000000706a0d in MDL_context::acquire_lock (this=0x4952378, mdl_request=0x4891f90, lock_wait_timeout=31536000) at /usr/src/mysql-5.6.28/sql/mdl.cc:2246#5 0x00000000007070d4 in MDL_context::acquire_locks (this=0x4952378, mdl_requests=0x7f542e59df20, lock_wait_timeout=31536000) at /usr/src/mysql-5.6.28/sql/mdl.cc:2357#6 0x000000000075fd46 in lock_table_names (thd=0x4952290, tables_start=0x4891bf0, tables_end=0x0, lock_wait_timeout=31536000, flags=0) at /usr/src/mysql-5.6.28/sql/sql_base.cc:4956#7 0x0000000000843260 in mysql_rm_table (thd=0x4952290, tables=0x4891bf0, if_exists=0 '\000', drop_temporary=0 '\000') at /usr/src/mysql-5.6.28/sql/sql_table.cc:2131#8 0x00000000007d1e63 in mysql_execute_command (thd=0x4952290) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:3648#9 0x00000000007d67c4 in mysql_parse (thd=0x4952290, rawbuf=0x4891b00 "drop table big_table", length=20, parser_state=0x7f542e59f910) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:6386#10 0x00000000007d83f4 in dispatch_command (command=COM_QUERY, thd=0x4952290, packet=0x49bc971 "drop table big_table", packet_length=20) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:1340#11 0x00000000007d9c80 in do_command (thd=0x4952290) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:1037#12 0x000000000078e3fb in do_handle_one_connection (thd_arg=0x496bfa0) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:982#13 0x000000000078e4c1 in handle_one_connection (arg=0x496bfa0) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:898#14 0x0000000000b11172 in pfs_spawn_thread (arg=0x49200f0) at /usr/src/mysql-5.6.28/storage/perfschema/pfs.cc:1860#15 0x00007f5497dac83d in start_thread () from /lib64/libpthread.so.0#16 0x00007f5497259fdd in clone () from /lib64/libc.so.6#17 0x0000000000000000 in ?? ()

 

转载地址:http://mqrum.baihongyu.com/

你可能感兴趣的文章
UE4的AI学习(1)——基本概念
查看>>
自动开机 双网卡网络唤醒
查看>>
Unity中的特殊文件夹
查看>>
Windows下安装Hadoop
查看>>
ganglia 一站式部署
查看>>
svn 的使用
查看>>
react-router-dom
查看>>
nohup后台执行
查看>>
转贴:Cache 总结
查看>>
自学或者复习的话,runnoob这个网站不错~~
查看>>
快速用梯度下降法实现一个Logistic Regression 分类器
查看>>
python基础学习2
查看>>
[Tyvj 1728]普通平衡树
查看>>
css3
查看>>
table 中,如何使得单元格的内容不换行,单元格不被撑开
查看>>
Hibernate中session.get()和session.load()的区别
查看>>
泊松分布(Poisson distribution)的简单认识
查看>>
Android之使用传感器获取相应数据
查看>>
Jquery中html()方法 and "click"绑定后代元素
查看>>
HashMap和Hashtable的详细区别
查看>>