mysql执行update临时表时崩溃
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql执行update临时表时崩溃，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3689字，纯文字阅读大概需要6分钟。
内容图文
mysql 直接上日志：
thd: 0x1c1a50f0
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...
InnoDB: Thread 9912 stopped in file G:\mysql-6.0.11-alpha-winbuild\mysql-community-nt-6.0.11-alpha-build\storage\innobase\include\sync0sync.ic line 115
InnoDB: Thread 4064 stopped in file G:\mysql-6.0.11-alpha-winbuild\mysql-community-nt-6.0.11-alpha-build\storage\innobase\include\sync0sync.ic line 115
0000000140364105 mysqld.exe!btr_pcur_restore_position()[btr0pcur.c:217]
0000000140305687 mysqld.exe!row_unlock_for_mysql()[row0mysql.c:1546]
00000001402F73C5 mysqld.exe!ha_innobase::unlock_row()[ha_innodb.cc:4243]
000000014015A800 mysqld.exe!evaluate_join_record()[sql_select.cc:16569]
000000014015CBBE mysqld.exe!sub_select()[sql_select.cc:16303]
000000014015DBFC mysqld.exe!do_select()[sql_select.cc:15833]
InnoDB: Thread 3948 stopped in file .\handler\ha_innodb.cc line 2277
0000000140162275 mysqld.exe!JOIN::exec()[sql_select.cc:2468]
00000001401658D1 mysqld.exe!mysql_select()[sql_select.cc:3069]
00000001401D795B mysqld.exe!mysql_derived_filling()[sql_derived.cc:294]
00000001401D77D0 mysqld.exe!mysql_handle_derived()[sql_derived.cc:56]
00000001401D0539 mysqld.exe!mysql_multi_update_prepare()[sql_update.cc:1194]
000000014008CDFC mysqld.exe!mysql_execute_command()[sql_parse.cc:3138]
000000014017D358 mysqld.exe!sp_instr_stmt::exec_core()[sp_head.cc:2929]
000000014017FBD5 mysqld.exe!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:2751]
0000000140181159 mysqld.exe!sp_instr_stmt::execute()[sp_head.cc:2864]
0000000140181816 mysqld.exe!sp_head::execute()[sp_head.cc:1250]
0000000140182884 mysqld.exe!sp_head::execute_procedure()[sp_head.cc:1989]
000000014008ED50 mysqld.exe!mysql_execute_command()[sql_parse.cc:4384]
000000014008FA7A mysqld.exe!mysql_parse()[sql_parse.cc:5942]
0000000140090547 mysqld.exe!dispatch_command()[sql_parse.cc:1051]
000000014009130C mysqld.exe!do_command()[sql_parse.cc:731]
00000001400AF135 mysqld.exe!handle_one_connection()[sql_connect.cc:1146]
000000014047011E mysqld.exe!pthread_start()[my_winthread.c:63]
0000000140500737 mysqld.exe!_callthreadstartex()[threadex.c:348]
000000014050080F mysqld.exe!_threadstartex()[threadex.c:326]
00007FFBCE738102 KERNEL32.DLL!BaseThreadInitThunk()
00007FFBCF12C5B4 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 000000001C1C0190=update results a left join (
select b.goodsid,sum(b.qty) as qty,sum(b.money) as money from erp_stockin_main a,erp_stockin_detail b where a.compid = NAME_CONST('in_compId',1) and a.dt between NAME_CONST('v_firstDay',_binary'2016-03-01' COLLATE 'binary') and NAME_CONST('in_dt',_binary'2016-03-26' COLLATE 'binary') and ( NAME_CONST('in_whouse',_utf8'' COLLATE 'utf8_general_ci') != '' or a.billtype != 'MOVE' ) -- 查全部仓库时去掉移库 and ( NAME_CONST('in_whouse',_utf8'' COLLATE 'utf8_general_ci') = '' or a.whouse = NAME_CONST('in_whouse',_utf8'' COLLATE 'utf8_general_ci')) and a.state = '1' -- 已提交 and a.billid = b.billid group by b.goodsid) b on a.goodsid = b.goodsidset a.inqty = nullif(b.qty,0), a.inmoney = nullif(b.money,0)thd->thread_id=18
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.
补充：日志中InnoDB: Thread 9912 stopped in file G:\mysql-6.0.11-alpha-winbu...在我的文件系统中根本不存在这个文件
内容总结
以上是互联网集市为您收集整理的mysql执行update临时表时崩溃全部内容，希望文章能够帮你解决mysql执行update临时表时崩溃所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。