jokin132 2016-03-26 03:12 采纳率: 0%
浏览 1436

mysql执行update临时表时崩溃

直接上日志:
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.goodsid

set 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...在我的文件系统中根本不存在这个文件

  • 写回答

1条回答

  • CSDN-Ada助手 CSDN-AI 官方账号 2022-12-13 17:53
    关注
    不知道你这个问题是否已经解决, 如果还没有解决的话:

    如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 写成博客, 将相关链接放在评论区, 以帮助更多的人 ^-^
    评论

报告相同问题?

悬赏问题

  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!
  • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像,如何解决?
  • ¥15 求daily translation(DT)偏差订正方法的代码
  • ¥15 js调用html页面需要隐藏某个按钮