地数据库上运行sql语句,有的几个表一运行更新语句就断开连接、sql服务终止,其他的表没问题,出错的表结构也没问题,把我的数据库备份到其他的电脑上也没出错,我以前试的,有个表是条件是主键就出这个错误--sql服务停止,但是where条件是其他的也没问题,关键是同一个表在别的电脑上就没事。
错误日志:
09:29:19 UTC - mysqld got exception 0xc000001d ;
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.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=6
max_threads=151
thread_count=6
connection_count=6
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68009 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x1297d7f0
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...
140aa1c11 mysqld.exe!pow()[pow.asm:1616]
13ffb3b7b mysqld.exe!get_sweep_read_cost()[handler.cc:7070]
1405815e7 mysqld.exe!ror_intersect_add()[opt_range.cc:5430]
1405776b9 mysqld.exe!get_best_ror_intersect()[opt_range.cc:5611]
140583885 mysqld.exe!test_quick_select()[opt_range.cc:3078]
14059ec25 mysqld.exe!mysql_update()[sql_update.cc:496]
1405a0ee0 mysqld.exe!Sql_cmd_update::try_single_table_update()[sql_update.cc:2883]
14059d22a mysqld.exe!Sql_cmd_update::execute()[sql_update.cc:3010]
140006545 mysqld.exe!mysql_execute_command()[sql_parse.cc:3520]
140008e2a mysqld.exe!mysql_parse()[sql_parse.cc:5524]
140001ebd mysqld.exe!dispatch_command()[sql_parse.cc:1431]
140002eca mysqld.exe!do_command()[sql_parse.cc:998]
13ffa9e14 mysqld.exe!handle_connection()[connection_handler_per_thread.cc:301]
1409e8582 mysqld.exe!pfs_spawn_thread()[pfs.cc:2195]
140705d0b mysqld.exe!win_thread_start()[my_thread.c:38]
140aa938f mysqld.exe!_callthreadstartex()[threadex.c:376]
140aa95da mysqld.exe!_threadstartex()[threadex.c:354]
773cf56d kernel32.dll!BaseThreadInitThunk()
77603281 ntdll.dll!RtlUserThreadStart()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (129ba820): update ac_aj_jbxx_sj
SET bgbh='2016021900001'
where tid = 197
Connection ID (thread ID): 3
Status: 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.
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。