mysql5.7 查询引起奔溃_MySQL5.7查询时服务挂掉-CSDN博客

本文链接：https://blog.csdn.net/weixin_39809793/article/details/113238052

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