互联网服务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

提问者

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

相关问题

相关资料

相关文章

问题状态

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