MySQL5.7查询时服务挂掉

问题描述

问 题

SELECT
    hstmoneyvi0_.sys_id AS sys_id1_25_,
    hstmoneyvi0_.create_date AS create_d2_25_,
    hstmoneyvi0_.create_time AS create_t3_25_,
    hstmoneyvi0_.create_user AS create_u4_25_,
    hstmoneyvi0_.upd_date AS upd_date5_25_,
    hstmoneyvi0_.upd_time AS upd_time6_25_,
    hstmoneyvi0_.upd_user AS upd_user7_25_,
    hstmoneyvi0_.product_code AS product_8_25_,
    hstmoneyvi0_.buy_date_time AS buy_date9_25_,
    hstmoneyvi0_.end_date AS end_dat10_25_,
    hstmoneyvi0_.start_date AS start_d11_25_,
    hstmoneyvi0_.user_id AS user_id12_25_,
    hstmoneyvi0_.vip_bag_id AS vip_bag13_25_
FROM
    t_money_vip_bag_record hstmoneyvi0_
WHERE
    1 = 1
AND hstmoneyvi0_.user_id = 'yl001'
AND hstmoneyvi0_.product_code = 'shenlun'
ORDER BY
    hstmoneyvi0_.end_date DESC
LIMIT 1

查询语句时MySQL服务直接挂掉了。这张表包含两个索引字段，删除一个就能正常查询。保持原来两个索引字段就会引起这个问题。

14:34:04 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=65536
max_used_connections=1
max_threads=500
thread_count=1
connection_count=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 174270 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x16b75dcc0
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...
7fef58a5c01    MSVCR120.dll!pow()
13f285f5a    mysqld.exe!?get_sweep_read_cost@@YAXPEAUTABLE@@_K_NPEAVCost_estimate@@@Z()
13f83ebe7    mysqld.exe!?right@?$Priority_queue@PEAVQUICK_SELECT_I@@V?$vector@PEAVQUICK_SELECT_I@@V?$Malloc_allocator@PEAVQUICK_SELECT_I@@@@@std@@UQuick_ror_union_less@@@@CA_K_K@Z()
13f834be9    mysqld.exe!?free_tree@SEL_ARG@@QEAAXXZ()
13f840ed5    mysqld.exe!?test_quick_select@@YAHPEAVTHD@@V?$Bitmap@$0EA@@@_K2_NW4enum_order@st_order@@PEBVQEP_shared_owner@@PEAVItem@@PEAV2@PEAPEAVQUICK_SELECT_I@@@Z()
13f3f34fe    mysqld.exe!?get_op_type@Ft_hints@@QEAA?AW4ft_operation@@XZ()
13f3f1f5d    mysqld.exe!?estimate_rowcount@JOIN@@AEAA_NXZ()
13f3f4cc9    mysqld.exe!?make_join_plan@JOIN@@AEAA_NXZ()
13f3f683b    mysqld.exe!?optimize@JOIN@@QEAAHXZ()
13f43e509    mysqld.exe!?optimize@st_select_lex@@QEAA_NPEAVTHD@@@Z()
13f43c52d    mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
13f2b3cb7    mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
13f2b5be6    mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
13f2b9643    mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
13f2b26f3    mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
13f2b372a    mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
13f2806ac    mysqld.exe!handle_connection()
13fcadd42    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
13f9c133c    mysqld.exe!my_thread_once()
7fef5834f7f    MSVCR120.dll!_beginthreadex()
7fef5835126    MSVCR120.dll!_endthreadex()
770df56d    kernel32.dll!BaseThreadInitThunk()
77313281    ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (16b7c38d0): SELECT
    hstmoneyvi0_.sys_id AS sys_id1_25_,
    hstmoneyvi0_.create_date AS create_d2_25_,
    hstmoneyvi0_.create_time AS create_t3_25_,
    hstmoneyvi0_.create_user AS create_u4_25_,
    hstmoneyvi0_.upd_date AS upd_date5_25_,
    hstmoneyvi0_.upd_time AS upd_time6_25_,
    hstmoneyvi0_.upd_user AS upd_user7_25_,
    hstmoneyvi0_.product_code AS product_8_25_,
    hstmoneyvi0_.buy_date_time AS buy_date9_25_,
    hstmoneyvi0_.end_date AS end_dat10_25_,
    hstmoneyvi0_.start_date AS start_d11_25_,
    hstmoneyvi0_.user_id AS user_id12_25_,
    hstmoneyvi0_.vip_bag_id AS vip_bag13_25_
FROM
    t_money_vip_bag_record hstmoneyvi0_
WHERE
    1 = 1
AND hstmoneyvi0_.user_id = 'yl001'
AND hstmoneyvi0_.product_code = 'shenlun'
ORDER BY
    hstmoneyvi0_.end_date DESC
LIMIT 1
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.

解决方案

看情况是MySQL5.7在 windows sever 2008下的 一个bug

这篇关于MySQL5.7查询时服务挂掉的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！