个别表运行更新语句mysql服务停止怎么解决-问答-阿里云开发者社区-阿里云

开发者社区> 问答> 正文

个别表运行更新语句mysql服务停止怎么解决

蛮大人123 2016-02-06 11:28:42 3486

地数据库上运行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.

SQL 关系型数据库 MySQL 数据库
分享到
取消 提交回答
全部回答(1)
  • qilu
    2019-07-17 18:38:17

    这个问题建议升级到mysql 5.6的最新版本。 然后测试 一下。

    0 0
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

推荐文章
相似问题
推荐课程