MySQL Bugs: #79787: Losing connection to server after specyfic querry

Bug #79787	Losing connection to server after specyfic querry
Submitted:	28 Dec 2015 16:22	Modified:	28 Dec 2015 18:13
Reporter:	Kornel Stępnik	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.7	OS:	Windows (64bit)
Assigned to:		CPU Architecture:	Any
Tags:	Connection, database, error, exception, Querry

Description:
After running the script I'am providing, the MySQL server is losing connection. The query that makes that is SELECT * from fulltable.

LOG
Version: '5.7.9-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2015-12-28T13:36:30.290159Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6527956ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2015-12-28T15:29:23.693883Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 450239ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
16:19:11 UTC - mysqld got exception 0xc0000005 ;
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=4
max_threads=151
thread_count=3
connection_count=3
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 58341 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x1d2134e4fe0
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...
7ff605e3d542    mysqld.exe!?exec@Item_subselect@@UEAA_NXZ()
7ff605e432ab    mysqld.exe!?val_int@Item_singlerow_subselect@@UEAA_JXZ()
7ff605d053dc    mysqld.exe!?val_int@Item_direct_ref@@UEAA_JXZ()
7ff605caf62c    mysqld.exe!?compare_int_signed@Arg_comparator@@QEAAHXZ()
7ff605cbd4b1    mysqld.exe!?val_int@Item_func_gt@@UEAA_JXZ()
7ff605d03a41    mysqld.exe!?val_bool@Item@@UEAA_NXZ()
7ff605cb1ce6    mysqld.exe!?find_item@Item_func_case@@QEAAPEAVItem@@PEAVString@@@Z()
7ff605cbd3f6    mysqld.exe!?val_int@Item_func_case@@UEAA_JXZ()
7ff605d053dc    mysqld.exe!?val_int@Item_direct_ref@@UEAA_JXZ()
7ff605caf62c    mysqld.exe!?compare_int_signed@Arg_comparator@@QEAAHXZ()
7ff605cbd451    mysqld.exe!?val_int@Item_func_eq@@UEAA_JXZ()
7ff605d03a41    mysqld.exe!?val_bool@Item@@UEAA_NXZ()
7ff605cbcb9c    mysqld.exe!?val_int@Item_cond_and@@UEAA_JXZ()
7ff60625682e    mysqld.exe!?end_write_group@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff60625a437    mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff6062556c1    mysqld.exe!?create_intermediate_table@JOIN@@AEAA_NPEAVQEP_TAB@@PEAV?$List@VItem@@@@AEAVORDER_with_src@1@_N@Z()
7ff60625703b    mysqld.exe!?exec@JOIN@@QEAAXXZ()
7ff605e3dd7d    mysqld.exe!?exec@subselect_single_select_engine@@UEAA_NXZ()
7ff605e3d5ee    mysqld.exe!?exec@Item_subselect@@UEAA_NXZ()
7ff605e432ab    mysqld.exe!?val_int@Item_singlerow_subselect@@UEAA_JXZ()
7ff605d372e0    mysqld.exe!?int_op@Item_func_plus@@UEAA_JXZ()
7ff605d3e2c3    mysqld.exe!?val_int@Item_func_numhybrid@@UEAA_JXZ()
7ff605cffb0a    mysqld.exe!?save_in_field_inner@Item@@MEAA?AW4type_conversion_status@@PEAVField@@_N@Z()
7ff605cff8ef    mysqld.exe!?save_in_field@Item@@QEAA?AW4type_conversion_status@@PEAVField@@_N@Z()
7ff606254de3    mysqld.exe!?copy_funcs@@YA_NPEAV?$Mem_root_array@PEAVItem@@$00@@PEBVTHD@@@Z()
7ff606256485    mysqld.exe!?end_send_group@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff60625a540    mysqld.exe!?sub_select_op@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff6062569b5    mysqld.exe!?end_write_group@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff60625a437    mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff6062569b5    mysqld.exe!?end_write_group@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff60625a437    mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff6062556c1    mysqld.exe!?create_intermediate_table@JOIN@@AEAA_NPEAVQEP_TAB@@PEAV?$List@VItem@@@@AEAVORDER_with_src@1@_N@Z()
7ff60625703b    mysqld.exe!?exec@JOIN@@QEAAXXZ()
7ff605efceba    mysqld.exe!?materialize_derived@TABLE_LIST@@QEAA_NPEAVTHD@@@Z()
7ff60625780d    mysqld.exe!?join_materialize_derived@@YAHPEAVQEP_TAB@@@Z()
7ff60625882a    mysqld.exe!?prepare_scan@QEP_TAB@@QEAA_NXZ()
7ff60625a2e7    mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAVQEP_TAB@@_N@Z()
7ff6062556c1    mysqld.exe!?create_intermediate_table@JOIN@@AEAA_NPEAVQEP_TAB@@PEAV?$List@VItem@@@@AEAVORDER_with_src@1@_N@Z()
7ff60625703b    mysqld.exe!?exec@JOIN@@QEAAXXZ()
7ff605e28571    mysqld.exe!?handle_query@@YA_NPEAVTHD@@PEAULEX@@PEAVQuery_result@@_K3@Z()
7ff605ce27f6    mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
7ff605ce46de    mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@_N@Z()
7ff605ce7faa    mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEAVParser_state@@@Z()
7ff605ce12c9    mysqld.exe!?dispatch_command@@YA_NPEAVTHD@@PEBTCOM_DATA@@W4enum_server_command@@@Z()
7ff605ce226a    mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
7ff605c89634    mysqld.exe!handle_connection()
7ff60669ad82    mysqld.exe!?reserve@?$vector@EV?$allocator@E@std@@@std@@QEAAX_K@Z()
7ff6063c46fb    mysqld.exe!my_thread_once()
7ff60675b39f    mysqld.exe!my_wildcmp_mb()
7ff60675b5ea    mysqld.exe!my_wildcmp_mb()
7ff8441a8102    KERNEL32.DLL!BaseThreadInitThunk()
7ff846b4c2e4    ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (1d2134c7bf0): select * from fulltable
LIMIT 0, 400
Connection ID (thread ID): 9
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.

How to repeat:
Run all the querries from the script. NOTE: the tables must be populated.

File to reproduce error

Attachment: testCase.sql (application/octet-stream, text), 151.04 KiB.

Hi,   please upgrade to 5.7.10 as the crash is not repeatable there.
On 5.7.9,  the stack trace is:

mysqld-debug.exe!Item_subselect::exec()[item_subselect.cc:575]
mysqld-debug.exe!Item_singlerow_subselect::val_int()[item_subselect.cc:1230]
mysqld-debug.exe!Item_direct_ref::val_int()[item.cc:8563]
mysqld-debug.exe!Item_direct_view_ref::val_int()[item.cc:8757]
mysqld-debug.exe!Arg_comparator::compare_int_signed()[item_cmpfunc.cc:1840]
mysqld-debug.exe!Item_func_gt::val_int()[item_cmpfunc.cc:2607]
mysqld-debug.exe!Item::val_bool()[item.cc:211]
mysqld-debug.exe!Item_func_case::find_item()[item_cmpfunc.cc:3790]
mysqld-debug.exe!Item_func_case::val_int()[item_cmpfunc.cc:3857]
mysqld-debug.exe!Item_direct_ref::val_int()[item.cc:8563]
mysqld-debug.exe!Item_direct_view_ref::val_int()[item.cc:8757]
mysqld-debug.exe!Arg_comparator::compare_int_signed()[item_cmpfunc.cc:1840]
mysqld-debug.exe!Item_func_eq::val_int()[item_cmpfunc.cc:2487]
mysqld-debug.exe!Item::val_bool()[item.cc:211]
mysqld-debug.exe!Item_cond_and::val_int()[item_cmpfunc.cc:6102]
mysqld-debug.exe!evaluate_join_record()[sql_executor.cc:1483]
mysqld-debug.exe!sub_select()[sql_executor.cc:1288]
mysqld-debug.exe!do_select()[sql_executor.cc:941]
mysqld-debug.exe!JOIN::exec()[sql_executor.cc:199]
mysqld-debug.exe!subselect_single_select_engine::exec()[item_subselect.cc:3072]
mysqld-debug.exe!Item_subselect::exec()[item_subselect.cc:581]
mysqld-debug.exe!Item_singlerow_subselect::val_int()[item_subselect.cc:1230]
mysqld-debug.exe!Item_func_plus::int_op()[item_func.cc:1754]
mysqld-debug.exe!Item_func_numhybrid::val_int()[item_func.cc:1414]
mysqld-debug.exe!Item::save_in_field_inner()[item.cc:6832]
mysqld-debug.exe!Item::save_in_field()[item.cc:6702]
mysqld-debug.exe!Item_result_field::save_in_result_field()[item.h:3917]
mysqld-debug.exe!copy_funcs()[sql_executor.cc:566]
mysqld-debug.exe!end_write()[sql_executor.cc:3337]
mysqld-debug.exe!QEP_tmp_table::put_record()[sql_executor.cc:4617]
mysqld-debug.exe!QEP_tmp_table::put_record()[sql_executor.h:248]
mysqld-debug.exe!sub_select_op()[sql_executor.cc:1074]
mysqld-debug.exe!evaluate_join_record()[sql_executor.cc:1633]
mysqld-debug.exe!sub_select()[sql_executor.cc:1288]
mysqld-debug.exe!evaluate_join_record()[sql_executor.cc:1633]
mysqld-debug.exe!sub_select()[sql_executor.cc:1288]
mysqld-debug.exe!do_select()[sql_executor.cc:941]
mysqld-debug.exe!JOIN::exec()[sql_executor.cc:199]
mysqld-debug.exe!TABLE_LIST::materialize_derived()[sql_derived.cc:325]
mysqld-debug.exe!join_materialize_derived()[sql_executor.cc:2479]
mysqld-debug.exe!QEP_TAB::prepare_scan()[sql_executor.cc:1322]
mysqld-debug.exe!sub_select()[sql_executor.cc:1222]
mysqld-debug.exe!do_select()[sql_executor.cc:941]
mysqld-debug.exe!JOIN::exec()[sql_executor.cc:199]
mysqld-debug.exe!handle_query()[sql_select.cc:185]
mysqld-debug.exe!execute_sqlcom_select()[sql_parse.cc:4947]
mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:2597]
mysqld-debug.exe!mysql_parse()[sql_parse.cc:5357]
mysqld-debug.exe!dispatch_command()[sql_parse.cc:1287]
mysqld-debug.exe!do_command()[sql_parse.cc:852]
mysqld-debug.exe!handle_connection()[connection_handler_per_thread.cc:295]
mysqld-debug.exe!pfs_spawn_thread()[pfs.cc:2194]
mysqld-debug.exe!win_thread_start()[my_thread.c:37]
mysqld-debug.exe!_callthreadstartex()[threadex.c:376]
mysqld-debug.exe!_threadstartex()[threadex.c:359]

I run mysql_upgrade, but I'm getting 'This installation of MySQL is already upgraded to 5.7.9' message.

OK, I have just upgraded to version 5.7.10 and everything is working now.