小编给大家分享一下MySQL中mysqldump导出数据异常重启及drop栈帧的示例分析，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！

在进行mysqldump的时候只要访问到库中一个表，只要一访问就抛错重启如下：

stack_bottom=7f656f792e28thread_stack0x30000/dbdata/mysql5600/bin/mysqld(my_print_stacktrace+0x35)[0x905a25]/dbdata/mysql5600/bin/mysqld(handle_fatal_signal+0x43b)[0x65c50b]/dbdata/mysql5600/bin/mysqld(_Z29page_find_rec_max_not_deletedPKh+0xa0)[0x9b5570]/dbdata/mysql5600/bin/mysqld[0x9fdca0]/dbdata/mysql5600/bin/mysqld[0x967202]/dbdata/mysql5600/bin/mysqld[0x9682f9]/dbdata/mysql5600/bin/mysqld(_ZN7handler7ha_openEP5TABLEPKcii+0x3e)[0x599f3e]/dbdata/mysql5600/bin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPKcjjjP5TABLEb+0x68c)[0x77dedc]/dbdata/mysql5600/bin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xcaf)[0x699fff]/dbdata/mysql5600/bin/mysqld(_Z11open_tablesP3THDPP10TABLE_LISTPjjP19Prelocking_strategy+0xf50)[0x69bbf0]/dbdata/mysql5600/bin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTj+0x48)[0x69bd48]/dbdata/mysql5600/bin/mysqld[0x71dc3f]/dbdata/mysql5600/bin/mysqld(_Z14get_all_tablesP3THDP10TABLE_LISTP4Item+0x738)[0x72d388]/dbdata/mysql5600/bin/mysqld(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x2e1)[0x718c71]/dbdata/mysql5600/bin/mysqld(_ZN4JOIN14prepare_resultEPP4ListI4ItemE+0x9d)[0x70c94d]/dbdata/mysql5600/bin/mysqld(_ZN4JOIN4execEv+0xdc)[0x6c5abc]/dbdata/mysql5600/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x218)[0x70e3c8]/dbdata/mysql5600/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x17f)[0x70ecbf]/dbdata/mysql5600/bin/mysqld[0x6e6b05]/dbdata/mysql5600/bin/mysqld(_Z21mysql_execute_commandP3THD+0x26ce)[0x6eb6ce]/dbdata/mysql5600/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x598)[0x6ee818]/dbdata/mysql5600/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1766)[0x6f0026]/dbdata/mysql5600/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x115)[0x6b6e95]/dbdata/mysql5600/bin/mysqld(handle_one_connection+0x42)[0x6b7012]/dbdata/mysql5600/bin/mysqld(pfs_spawn_thread+0x127)[0x941627]libc.so.6(clone+0x6d)[0x34582e8b5d]二、分析

稍做分析发现出错的函数是page_find_rec_max_not_deleted，并且出现在打开表的时候，打开表为什么要去访问实际的数据块呢？我在debug环境做了一个断点在page_find_rec_max_not_deleted上栈帧如下：

#0page_find_rec_max_not_deleted(page=0x7fffb055c000"\213\032\063",<incompletesequence\316>)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/page/page0page.cc:2762#10x0000000001b505beinrow_search_get_max_rec(index=0x7fff249e8cf0,mtr=0x7ffff02d77b0)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/row/row0sel.cc:6335#20x0000000001b506f5inrow_search_max_autoinc(index=0x7fff249e8cf0,col_name=0x7fff249e2551"id",value=0x7ffff02d7d10)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/row/row0sel.cc:6373#30x00000000019ac668inha_innobase::innobase_initialize_autoinc(this=0x7fff249e28a0)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/handler/ha_innodb.cc:6118#40x00000000019ad722inha_innobase::open(this=0x7fff249e28a0,name=0x7fff249eac00"./test/mch_pay_rate",mode=2,test_if_locked=2)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/handler/ha_innodb.cc:6533#50x0000000000f664beinhandler::ha_open(this=0x7fff249e28a0,table_arg=0x7fff249e43a0,name=0x7fff249eac00"./test/mch_pay_rate",mode=2,test_if_locked=2)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/handler.cc:2904#60x00000000016a1542inopen_table_from_share(thd=0x7fff24000b70,share=0x7fff249ea820,alias=0x7fff24005a38"mch_pay_rate",db_stat=39,prgflag=8,ha_open_flags=0,outparam=0x7fff249e43a0,is_create_table=false)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/table.cc:3335#70x00000000015186ccinopen_table(thd=0x7fff24000b70,table_list=0x7ffff02d9600,ot_ctx=0x7ffff02d8d40)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:3560#80x000000000151b24finopen_and_process_table(thd=0x7fff24000b70,lex=0x7fff24003150,tables=0x7ffff02d9600,counter=0x7fff24003210,flags=1024,prelocking_strategy=0x7ffff02d8e70,has_prelocking_list=false,ot_ctx=0x7ffff02d8d40)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:5171#90x000000000151c3abinopen_tables(thd=0x7fff24000b70,start=0x7ffff02d8e30,counter=0x7fff24003210,flags=1024,prelocking_strategy=0x7ffff02d8e70)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:5789#100x000000000151d7e5inopen_tables_for_query(thd=0x7fff24000b70,tables=0x7ffff02d9600,flags=1024)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:6564#110x000000000160cda1inmysqld_list_fields(thd=0x7fff24000b70,table_list=0x7ffff02d9600,wild=0x7fff24006388"")at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_show.cc:1092#120x00000000015a248findispatch_command(thd=0x7fff24000b70,com_data=0x7ffff02d9d70,command=COM_FIELD_LIST)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1622#130x00000000015a09c6indo_command(thd=0x7fff24000b70)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1010#140x00000000016e29d0inhandle_connection(arg=0x387b9e0)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/conn_handler/connection_handler_per_thread.cc:312#150x0000000001d7b4b0inpfs_spawn_thread(arg=0x380b6e0)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/perfschema/pfs.cc:2188#160x0000003f74807aa1instart_thread()from/lib64/libpthread.so.0#170x0000003f740e8bcdinclone()from/lib64/libc.so.6

其实原因可以一目了然，原来打开表的时候如果有自增字段需要访问索引的最后一个块，而数据文件已经损坏了只要打开表就会重启。

还好这个表是不需要的，只是简单drop 就行了。再次进行mysqldump正常了。8.0听说对于初始化自增值做了加强，不需要访问数据文件了而是做了持久化，也许8.0就不会有这种问题了。

有的时候即便我们idb文件不存在drop table是可以进行的下面是两个栈帧。

dropdb#0open_table(thd=0x7fff20000b70,table_list=0x7ffff02d5ec0,ot_ctx=0x7ffff02d5da0)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:3612#10x000000000151d21cinopen_ltable(thd=0x7fff20000b70,table_list=0x7ffff02d5ec0,lock_type=TL_WRITE,lock_flags=2048)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:6400#20x000000000152692finopen_system_table_for_update(thd=0x7fff20000b70,one_table=0x7ffff02d5ec0)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:10710#30x00000000014d90e9inopen_proc_table_for_update(thd=0x7fff20000b70)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sp.cc:485#40x00000000014dc840insp_drop_db_routines(thd=0x7fff20000b70,db=0x7fff20006388"employees")at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sp.cc:1634#50x0000000001551203inmysql_rm_db(thd=0x7fff20000b70,db=...,if_exists=false,silent=false)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_db.cc:891#60x00000000015a86e0inmysql_execute_command(thd=0x7fff20000b70,first_level=true)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:4007#70x00000000015adcd6inmysql_parse(thd=0x7fff20000b70,parser_state=0x7ffff02d9600)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5836#80x00000000015a1b95indispatch_command(thd=0x7fff20000b70,com_data=0x7ffff02d9d70,command=COM_QUERY)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1447#90x00000000015a09c6indo_command(thd=0x7fff20000b70)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1010#100x00000000016e29d0inhandle_connection(arg=0x387d890)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/conn_handler/connection_handler_per_thread.cc:312#110x0000000001d7b4b0inpfs_spawn_thread(arg=0x3866c20)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/perfschema/pfs.cc:2188#120x0000003f74807aa1instart_thread()from/lib64/libpthread.so.0#130x0000003f740e8bcdinclone()from/lib64/libc.so.6droptable(gdb)bt#0os_file_handle_error_no_exit(name=0x7fff24028dd8"./test/t1.ibd",operation=0x22e1538"delete",on_error_silent=false)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/os/os0file.cc:5946#10x0000000001a7b154inos_file_delete_func(name=0x7fff24028dd8"./test/t1.ibd")at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/os/os0file.cc:3849#20x0000000001cd6d8dinpfs_os_file_delete_func(key=46,name=0x7fff24028dd8"./test/t1.ibd",src_file=0x2364a38"/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/fil/fil0fil.cc",src_line=2896)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/include/os0file.ic:470#30x0000000001cdf3aeinfil_delete_tablespace(id=617,buf_remove=BUF_REMOVE_FLUSH_NO_WRITE)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/fil/fil0fil.cc:2896#40x0000000001b1686ainrow_drop_single_table_tablespace(space_id=617,tablename=0x7fff24010e00"test/t1",filepath=0x7fff2403b258"./test/t1.ibd",is_temp=false,is_encrypted=false,trx=0x7ffff2f2e5d0)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/row/row0mysql.cc:4217#50x0000000001b17be2inrow_drop_table_for_mysql(name=0x7ffff02d63d0"test/t1",trx=0x7ffff2f2e5d0,drop_db=false,nonatomic=true,handler=0x0)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/row/row0mysql.cc:4751#60x00000000019b9e1ainha_innobase::delete_table(this=0x7fff24006b30,name=0x7ffff02d7840"./test/t1")at/root/mysql5.7.14/percona-server-5.7.14-7/storage/innobase/handler/ha_innodb.cc:12955#70x0000000000f6c2dainhandler::ha_delete_table(this=0x7fff24006b30,name=0x7ffff02d7840"./test/t1")at/root/mysql5.7.14/percona-server-5.7.14-7/sql/handler.cc:5071#80x0000000000f65ba5inha_delete_table(thd=0x7fff24000b70,table_type=0x2e9edd0,path=0x7ffff02d7840"./test/t1",db=0x7fff24006938"test",alias=0x7fff24006378"t1",generate_warning=true)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/handler.cc:2722#90x00000000016347d9inmysql_rm_table_no_locks(thd=0x7fff24000b70,tables=0x7fff240063b0,if_exists=false,drop_temporary=false,drop_view=false,dont_log_query=false)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_table.cc:2644#100x0000000001633572inmysql_rm_table(thd=0x7fff24000b70,tables=0x7fff240063b0,if_exists=0'\000',drop_temporary=0'\000')at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_table.cc:2207#110x00000000015a78dfinmysql_execute_command(thd=0x7fff24000b70,first_level=true)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:3742#120x00000000015adcd6inmysql_parse(thd=0x7fff24000b70,parser_state=0x7ffff02d9600)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5836#130x00000000015a1b95indispatch_command(thd=0x7fff24000b70,com_data=0x7ffff02d9d70,command=COM_QUERY)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1447#140x00000000015a09c6indo_command(thd=0x7fff24000b70)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1010#150x00000000016e29d0inhandle_connection(arg=0x3855a50)at/root/mysql5.7.14/percona-server-5.7.14-7/sql/conn_handler/connection_handler_per_thread.cc:312#160x0000000001d7b4b0inpfs_spawn_thread(arg=0x37ef3b0)at/root/mysql5.7.14/percona-server-5.7.14-7/storage/perfschema/pfs.cc:2188#170x0000003f74807aa1instart_thread()from/lib64/libpthread.so.0#180x0000003f740e8bcdinclone()from/lib64/libc.so.6

row_drop_single_table_tablespace 函数INNODB删除物理文件如果文件不存在row_drop_single_table_tablespace -> fil_delete_tablespace 中有如下代码

if(!os_file_delete(innodb_data_file_key,path)&&!os_file_delete_if_exists(innodb_data_file_key,path,NULL)){/*Note:Thisisbecausewehaveremovedthetablespaceinstancefromthecache.*/err=DB_IO_ERROR;}

第一个条件os_file_delete函数会返回flase他会调用如下：

os_file_handle_error_no_exit->os_file_handle_error_cond_exit中会直接返回falseos_file_handle_error_cond_exit的err值为：(gdb)perr$24=71

并且报错

第二个条件os_file_delete_if_exists

会返回

(gdb)presult$26=true

也就是 函数os_file_delete_if_exists_func返回了true，即便文件不存也是true。
因此本条件不会触发报错，则drop table即便idb文件不存在也会继续。

以上是“MySQL中mysqldump导出数据异常重启及drop栈帧的示例分析”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注亿速云行业资讯频道！