Bug #11223 Cybozu's mysqld has been crashed at special query

• Submitted: 10 Jun 2005 2:08
• Modified: 10 Jun 2005 12:21
• Reporter: Miguel Solorzano
• Status: Duplicate
• Category: MySQL Server: Optimizer
• Severity: S1 (Critical)
• Version: 4.1.12/4.1.13 BK
• OS: Windows (Windows)
• CPU Architecture: Any

[10 Jun 2005 2:08] Miguel Solorzano

Description:
The mysqld crashes issuing special query it which is provided in
the issue script. Below call stack:

>	mysqld-debug.exe!memcpy(unsigned char * dst=0x02fd2529, unsigned char * src=0xe680e014, unsigned long count=4)  Line 216	Asm
 	mysqld-debug.exe!read_cached_record(st_join_table * tab=0x02fe2068)  Line 8164 + 0x16	C++
 	mysqld-debug.exe!flush_cached_records(JOIN * join=0x02fe0578, st_join_table * join_tab=0x02fe2068, int skip_last=0)  Line 6046 + 0x9	C++
 	mysqld-debug.exe!sub_select_cache(JOIN * join=0x02fe0578, st_join_table * join_tab=0x02fe2068, int end_of_records=1)  Line 5900 + 0xf	C++
 	mysqld-debug.exe!sub_select(JOIN * join=0x02fe0578, st_join_table * join_tab=0x02fe1f08, int end_of_records=1)  Line 5927 + 0x17	C++
 	mysqld-debug.exe!sub_select(JOIN * join=0x02fe0578, st_join_table * join_tab=0x02fe1da8, int end_of_records=1)  Line 5927 + 0x17	C++
 	mysqld-debug.exe!do_select(JOIN * join=0x02fe0578, List<Item> * fields=0x00000000, st_table * table=0x03005e28, Procedure * procedure=0x00000000)  Line 5845 + 0xf	C++
 	mysqld-debug.exe!JOIN::exec()  Line 1151 + 0x11	C++
 	mysqld-debug.exe!mysql_select(THD * thd=0x02fc0490, Item * * * rref_pointer_array=0x02fc06c8, st_table_list * tables=0x02fcd2b0, unsigned int wild_num=0, List<Item> & fields={...}, Item * conds=0x02fc3e10, unsigned int og_num=3, st_order * order=0x02fc3f18, st_order * group=0x00000000, Item * having=0x00000000, st_order * proc_param=0x00000000, unsigned long select_options=2156153344, select_result * result=0x02fc40b0, st_select_lex_unit * unit=0x02fc04dc, st_select_lex * select_lex=0x02fc05dc)  Line 1607	C++
 	mysqld-debug.exe!handle_select(THD * thd=0x02fc0490, st_lex * lex=0x02fc04d0, select_result * result=0x02fc40b0)  Line 195 + 0x87	C++
 	mysqld-debug.exe!mysql_execute_command(THD * thd=0x02fc0490)  Line 2087 + 0x11	C++
 	mysqld-debug.exe!mysql_parse(THD * thd=0x02fc0490, char * inBuf=0x02fcc030, unsigned int length=1129)  Line 4222 + 0x9	C++
 	mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x02fc0490, char * packet=0x00f10371, unsigned int packet_length=1130)  Line 1503 + 0x1d	C++
 	mysqld-debug.exe!do_command(THD * thd=0x02fc0490)  Line 1316 + 0x31	C++
 	mysqld-debug.exe!handle_one_connection(void * arg=0x02fc0490)  Line 1048 + 0x9	C++
 	mysqld-debug.exe!pthread_start(void * param=0x02fc5738)  Line 63 + 0x7	C
 	mysqld-debug.exe!_threadstart(void * ptd=0x00f0fa58)  Line 173 + 0xd	C
 	kernel32.dll!7c80b50b() 	
 	kernel32.dll!7c8399f3() 	

How to repeat:
mysql> create database cb_cbgrn;
mysql> use cb_cbgrn;
mysql> source C:\dump.txt
mysql> source C:\sql.txt
mysqld has been crashed.

Suggested fix:
-

[10 Jun 2005 12:21] Vadim Tkachenko

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

dublicate 11167