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 = 1AND hstmoneyvi0_.user_id = 'yl001'AND hstmoneyvi0_.product_code = 'shenlun'ORDER BY    hstmoneyvi0_.end_date DESCLIMIT 1

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

14:34:04 UTC - mysqld got exception 0xc000001d ;This could be because you hit a bug. It is also possible that this binaryor 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 informationcollection process might fail.key_buffer_size=8388608read_buffer_size=65536max_used_connections=1max_threads=500thread_count=1connection_count=1It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 174270 K  bytes of memoryHope that's ok; if not, decrease some variables in the equation.Thread pointer: 0x16b75dcc0Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly 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 = 1AND hstmoneyvi0_.user_id = 'yl001'AND hstmoneyvi0_.product_code = 'shenlun'ORDER BY    hstmoneyvi0_.end_date DESCLIMIT 1Connection ID (thread ID): 3Status: NOT_KILLEDThe manual page at http://dev.mysql.com/doc/mysql/en/crashing.html containsinformation that should help you find out what is causing the crash.