互联网服务MySQLMySQL版本升级

今天将MySQL版本升级到5.7.19 执行查询,mysql服务直接挂了?

04:09:13 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=297795584
read_buffer_size=2097152
max_used_connections=53
max_threads=1000
thread_count=50
connection_count=49
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 204668 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x696565f0
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...
7fef9f65c01 MSVCR120.dll!pow()
13fcc5f7a mysqld.exe!get_sweep_read_cost()[handler.cc:7199]
140287b37 mysqld.exe!ror_intersect_add()[opt_range.cc:5461]
14027da89 mysqld.exe!get_best_ror_intersect()[opt_range.cc:5642]
140289e25 mysqld.exe!test_quick_select()[opt_range.cc:3108]
13fe36a3e mysqld.exe!get_quick_record_count()[sql_optimizer.cc:5948]
13fe3549d mysqld.exe!JOIN::estimate_rowcount()[sql_optimizer.cc:5694]
13fe38209 mysqld.exe!JOIN::make_join_plan()[sql_optimizer.cc:5051]
13fe39d7b mysqld.exe!JOIN::optimize()[sql_optimizer.cc:368]
13fe82149 mysqld.exe!st_select_lex::optimize()[sql_select.cc:1009]
13fe8016d mysqld.exe!handle_query()[sql_select.cc:164]
13fcf3f17 mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5158]
13fcf5e46 mysqld.exe!mysql_execute_command()[sql_parse.cc:2795]
13fcf98a3 mysqld.exe!mysql_parse()[sql_parse.cc:5580]
13fcf2953 mysqld.exe!dispatch_command()[sql_parse.cc:1464]
13fcf398a mysqld.exe!do_command()[sql_parse.cc:1001]
13fc9a4dc mysqld.exe!handle_connection()[connection_handler_per_thread.cc:300]
1406f43a2 mysqld.exe!pfs_spawn_thread()[pfs.cc:2191]
14040743c mysqld.exe!win_thread_start()[my_thread.c:38]
7fef9ef4f7f MSVCR120.dll!_beginthreadex()
7fef9ef5126 MSVCR120.dll!_endthreadex()
76aff56d kernel32.dll!BaseThreadInitThunk()
76d33281 ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (6c6dd060): SELECT ins.C_DESC AS C_DESC,

   
      
      
  
 
  
 ins.C_DOMAIN_ID AS C_DOMAIN_ID,ins.C_ID AS C_ID,ins.C_PRIMARY_IP AS C_PRIMARY_IP,ins.C_MODEL_ID AS C_MODEL_ID,ins.C_IS_CMDB AS C_IS_CMDB,p.c_in_use AS C_IS_MANAGED,ins.C_MAC AS C_MAC,ins.C_NAME AS C_NAME,ins.C_NAME_DISPLAY AS C_NAME_DISPLAY,
       ins.C_CONTACT AS C_CONTACT,rel.C_POLICY_ID AS C_POLICY_ID,p.c_name C_POLICY_NAME,ins.C_MODEL_NUMBER AS C_MODEL_NUMBER,ins.C_SERIES AS C_SERIES,ins.C_SERVER_ID AS C_SERVER_ID,ins.C_SOURCE AS C_SOURCE,ins.C_SYSOID AS C_SYSOID,ins.C_RES_TYPE_ID AS C_RES_TYPE_ID,
         ins.C_RES_TYPE_NAME AS C_RES_TYPE_NAME,ins.C_SERVER_NAME AS C_SERVER_NAME,ins.C_VENDOR_NAME AS C_VENDOR_NAME,ins.C_LOCATION AS C_LOCATION,ins.C_TAG1 AS C_TAG1,ins.C_TAG2 AS C_TAG2,ins.C_TAG3 AS C_TAG3,ins.C_TAG4 AS C_TAG4,ins.C_TREE_NODE_ID AS C_TREE_NODE_ID,ins.C_VENDOR_ID AS C_VENDOR_ID,
       ins.C_DEV_TYPE AS C_DEV_TYPE,ins.C_RES_CATALOG AS C_RES_CATALOG FROM
 
        
     t_moni_policy_info p 
       IN

Connection ID (thread ID): 65
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.

我换了一台机器,就没事,但是在这台机器上一执行就复现

参与15

3同行回答

liucj2004liucj2004其它undefined
这条日志之上有什么其他的warning或者error信息吗?其他查询会不会复现这个问题,升级后有没有upgrade过显示全部

这条日志之上有什么其他的warning或者error信息吗?其他查询会不会复现这个问题,升级后有没有upgrade过

收起
农业其它 · 2017-10-13
浏览4760
yuansuiyun 邀答
sunqiang1024sunqiang1024测试工程师星网锐捷
在mysql 官网看到mysqld got exception 0xc000001dThis error message occurs because you are also using a CPU that does not support the VPSRLQ instruction and indicates that the CPU instruction that was attempted is not supported.To fix this error, you m...显示全部

在mysql 官网看到mysqld got exception 0xc000001d
This error message occurs because you are also using a CPU that does not support the VPSRLQ instruction and indicates that the CPU instruction that was attempted is not supported.

To fix this error, you must install SP1. This adds the required operating system support for the CPU capability detection and disables that support when the CPU does not have the required instructions.

Alternatively, install an older version of MySQL, such as 5.6.

正在更新sp1中,但是不知道VPSRLQ instruction这个指令是什么东西,google也没搜到

问题解决了,就是打了2008 sp1的补丁就可以了,微软官方下载:windows6.1-KB976932-X64.exe

收起
互联网服务 · 2017-10-13
浏览4260
冯帅冯帅数据库管理员贝壳金服
如果是另一台机器同样的版本,执行正常,可以先看下操作系统的日志,有可能是资源不足,操作系统Kill 了mysql进程显示全部

如果是另一台机器同样的版本,执行正常,可以先看下操作系统的日志,有可能是资源不足,操作系统Kill 了mysql进程

收起
融资租赁 · 2017-10-13
浏览4234
yuansuiyun 邀答

提问者

sunqiang1024
测试工程师星网锐捷
擅长领域: 服务器应用服务器WAS

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2017-10-13
  • 关注会员:3 人
  • 问题浏览:5849
  • 最近回答:2017-10-13
  • X社区推广