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
    关注
    不知道你这个问题是否已经解决, 如果还没有解决的话:

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

报告相同问题?

悬赏问题

  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥50 汇编语言除法溢出问题
  • ¥65 C++实现删除N个数据列表共有的元素
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波