我通过调用存储过程来实现一个查询表获取数据的业务流程，结果一查询MYSQL就自动停止，而且不是一定出来，10有4次可以正常，6次不正常，兄弟们帮忙下，错误信息文件内容如下（一次从启动服务，到异常停止的过程，调用存储过程马上就挂掉），我用的是mysql5.45版本：
101015 10:33:16 [Note] Plugin 'FEDERATED' is disabled.
101015 10:33:16 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
101015 10:33:16 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
101015 10:33:16 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
101015 10:33:16 InnoDB: Started; log sequence number 0 4224509452
101015 10:33:16 [Note] Event Scheduler: Loaded 0 events
101015 10:33:16 [Note] Event Scheduler: scheduler thread started with id 1
101015 10:33:16 [Note] mysqld-debug: ready for connections.
Version: '5.1.50-community-debug' socket: '' port: 3990 MySQL Community Server - Debug (GPL)
101015 10:33:59 - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.key_buffer_size=268435456
read_buffer_size=1048576
max_used_connections=3
max_threads=151
threads_connected=4
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3432393 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.thd: 0x231aa4b8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
0041D7BF mysqld-debug.exe!_output_l()[output.c:1648]
008C7766 mysqld-debug.exe!vfprintf_helper()[vfprintf.c:69]
008C785B mysqld-debug.exe!vfprintf()[vfprintf.c:117]
0091DB6F mysqld-debug.exe!_db_doprnt_()[dbug.c:1168]
00532378 mysqld-debug.exe!open_tables()[sql_base.cc:4559]
00533880 mysqld-debug.exe!open_and_lock_tables_derived()[sql_base.cc:5039]
005616F2 mysqld-debug.exe!open_and_lock_tables()[mysql_priv.h:1522]
005B953B mysqld-debug.exe!execute_sqlcom_select()[sql_parse.cc:5073]
005B1BB1 mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:2292]
00707424 mysqld-debug.exe!Prepared_statement::execute()[sql_prepare.cc:3622]
007067DC mysqld-debug.exe!Prepared_statement::execute_loop()[sql_prepare.cc:3297]
007003D3 mysqld-debug.exe!mysql_sql_stmt_execute()[sql_prepare.cc:2562]
005B1BD9 mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:2301]
006C6CC0 mysqld-debug.exe!sp_instr_stmt::exec_core()[sp_head.cc:2952]
006C5E32 mysqld-debug.exe!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:2773]
006C62EF mysqld-debug.exe!sp_instr_stmt::execute()[sp_head.cc:2895]
006C13C3 mysqld-debug.exe!sp_head::execute()[sp_head.cc:1280]
006C33A7 mysqld-debug.exe!sp_head::execute_procedure()[sp_head.cc:2011]
005B6C2B mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:4438]
005BBB2F mysqld-debug.exe!mysql_parse()[sql_parse.cc:6032]
005AF7E5 mysqld-debug.exe!dispatch_command()[sql_parse.cc:1260]
005AED92 mysqld-debug.exe!do_command()[sql_parse.cc:888]
004A8738 mysqld-debug.exe!handle_one_connection()[sql_connect.cc:1136]
008E67E6 mysqld-debug.exe!pthread_start()[my_winthread.c:85]
008C25E1 mysqld-debug.exe!_callthreadstart()[thread.c:293]
008C2587 mysqld-debug.exe!_threadstart()[thread.c:277]
7C824829 kernel32.dll!GetModuleHandleA()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 231F8098=select * from (select b.dt,a.srcip,a.srcport,a.srcmac,a.destip,a.destport,a.destmac,a.ctype,a.appname,a.clientname,a.dbname,a.username,a.sysuser,'fd0005864b8e3214' as agentid,b.operate,b.operateobject,b.detail,b.rulename,b.lever,b.pro from dbaudit_fd0005864b8e3214_20101014_s a,( select a.sessionkey,a.dt,a.operate,a.operateobject,a.detail,'' as rulename,0 as lever,0 as pro from dbaudit_fd0005864b8e3214_20101014 a where a.dt>=1287002040 and a.dt<=1287002220 order by a.id desc limit 100)b where a.sessionkey=b.sessionkey)a union select * from (select b.dt,a.srcip,a.srcport,a.srcmac,a.destip,a.destport,a.destmac,a.ctype,a.appname,a.clientname,a.dbname,a.username,a.sysuser,'fd66fbbe23576d32' as agentid,b.operate,b.operateobject,b.detail,b.rulename,b.lever,b.pro from dbaudit_fd66fbbe23576d32_20101014_s a,( select a.sessionkey,a.dt,a.operate,a.operateobject,a.detail,'' as rulename,0 as lever,0 as pro from dbaudit_fd66fbbe23576d32_20101014 a where a.dt>=-180 and a.dt<=0 order by a.id desc limit 100)b where a.sessionke
thd->thread_id=4
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
101015 10:33:16 [Note] Plugin 'FEDERATED' is disabled.
101015 10:33:16 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
101015 10:33:16 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
101015 10:33:16 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
101015 10:33:16 InnoDB: Started; log sequence number 0 4224509452
101015 10:33:16 [Note] Event Scheduler: Loaded 0 events
101015 10:33:16 [Note] Event Scheduler: scheduler thread started with id 1
101015 10:33:16 [Note] mysqld-debug: ready for connections.
Version: '5.1.50-community-debug' socket: '' port: 3990 MySQL Community Server - Debug (GPL)
101015 10:33:59 - mysqld got exception 0xc0000005 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.key_buffer_size=268435456
read_buffer_size=1048576
max_used_connections=3
max_threads=151
threads_connected=4
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3432393 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.thd: 0x231aa4b8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
0041D7BF mysqld-debug.exe!_output_l()[output.c:1648]
008C7766 mysqld-debug.exe!vfprintf_helper()[vfprintf.c:69]
008C785B mysqld-debug.exe!vfprintf()[vfprintf.c:117]
0091DB6F mysqld-debug.exe!_db_doprnt_()[dbug.c:1168]
00532378 mysqld-debug.exe!open_tables()[sql_base.cc:4559]
00533880 mysqld-debug.exe!open_and_lock_tables_derived()[sql_base.cc:5039]
005616F2 mysqld-debug.exe!open_and_lock_tables()[mysql_priv.h:1522]
005B953B mysqld-debug.exe!execute_sqlcom_select()[sql_parse.cc:5073]
005B1BB1 mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:2292]
00707424 mysqld-debug.exe!Prepared_statement::execute()[sql_prepare.cc:3622]
007067DC mysqld-debug.exe!Prepared_statement::execute_loop()[sql_prepare.cc:3297]
007003D3 mysqld-debug.exe!mysql_sql_stmt_execute()[sql_prepare.cc:2562]
005B1BD9 mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:2301]
006C6CC0 mysqld-debug.exe!sp_instr_stmt::exec_core()[sp_head.cc:2952]
006C5E32 mysqld-debug.exe!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:2773]
006C62EF mysqld-debug.exe!sp_instr_stmt::execute()[sp_head.cc:2895]
006C13C3 mysqld-debug.exe!sp_head::execute()[sp_head.cc:1280]
006C33A7 mysqld-debug.exe!sp_head::execute_procedure()[sp_head.cc:2011]
005B6C2B mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:4438]
005BBB2F mysqld-debug.exe!mysql_parse()[sql_parse.cc:6032]
005AF7E5 mysqld-debug.exe!dispatch_command()[sql_parse.cc:1260]
005AED92 mysqld-debug.exe!do_command()[sql_parse.cc:888]
004A8738 mysqld-debug.exe!handle_one_connection()[sql_connect.cc:1136]
008E67E6 mysqld-debug.exe!pthread_start()[my_winthread.c:85]
008C25E1 mysqld-debug.exe!_callthreadstart()[thread.c:293]
008C2587 mysqld-debug.exe!_threadstart()[thread.c:277]
7C824829 kernel32.dll!GetModuleHandleA()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 231F8098=select * from (select b.dt,a.srcip,a.srcport,a.srcmac,a.destip,a.destport,a.destmac,a.ctype,a.appname,a.clientname,a.dbname,a.username,a.sysuser,'fd0005864b8e3214' as agentid,b.operate,b.operateobject,b.detail,b.rulename,b.lever,b.pro from dbaudit_fd0005864b8e3214_20101014_s a,( select a.sessionkey,a.dt,a.operate,a.operateobject,a.detail,'' as rulename,0 as lever,0 as pro from dbaudit_fd0005864b8e3214_20101014 a where a.dt>=1287002040 and a.dt<=1287002220 order by a.id desc limit 100)b where a.sessionkey=b.sessionkey)a union select * from (select b.dt,a.srcip,a.srcport,a.srcmac,a.destip,a.destport,a.destmac,a.ctype,a.appname,a.clientname,a.dbname,a.username,a.sysuser,'fd66fbbe23576d32' as agentid,b.operate,b.operateobject,b.detail,b.rulename,b.lever,b.pro from dbaudit_fd66fbbe23576d32_20101014_s a,( select a.sessionkey,a.dt,a.operate,a.operateobject,a.detail,'' as rulename,0 as lever,0 as pro from dbaudit_fd66fbbe23576d32_20101014 a where a.dt>=-180 and a.dt<=0 order by a.id desc limit 100)b where a.sessionke
thd->thread_id=4
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
你说的问题应该和这个一样。
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 24DDC0B0=SELECT sp_urldecode(EXTRACTVALUE( NAME_CONST('xmlstr',_latin1'<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<xml>\n <logsvrlist>\n <logsvr name=\"4E544C6F67537672\" memo=\"C8D5D6BEC9F3BCC6B7FECEF1\" appname=\"4C6F675376722E657865\" enable很奇怪，以前从来没有出现过