极客观点
项目管理
HarmonyOS
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.
mysql
看情况是MySQL5.7在 windows sever 2008下的 一个bug