|
Here is how MySQL 5.5 (affected) crashes:
|
MSQL 5.5.62 (Debug)
|
mysqld: /test/5.5_dbg/sql/sql_select.cc:9479: void restore_prev_nj_state(JOIN_TAB*): Assertion `nest->counter > 0' failed.
|
|
MSQL 5.5.62 (Debug)
|
Core was generated by `/test/MS121121-mysql-5.5.62-linux-x86_64-dbg/bin/mysqld --no-defaults --core --'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
[Current thread is 1 (Thread 0x152c0cc1f700 (LWP 808806))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x000055e4dd3cb1f1 in my_write_core (sig=sig@entry=6) at /test/5.5_dbg/mysys/stacktrace.c:433
|
#2 0x000055e4dd288e1e in handle_fatal_signal (sig=6) at /test/5.5_dbg/sql/signal_handler.cc:247
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x0000152c1d492859 in __GI_abort () at abort.c:79
|
#6 0x0000152c1d492729 in __assert_fail_base (fmt=0x152c1d628588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55e4dd688960 "nest->counter > 0", file=0x55e4dd6878a8 "/test/5.5_dbg/sql/sql_select.cc", line=9479, function=<optimized out>) at assert.c:92
|
#7 0x0000152c1d4a3f36 in __GI___assert_fail (assertion=assertion@entry=0x55e4dd688960 "nest->counter > 0", file=file@entry=0x55e4dd6878a8 "/test/5.5_dbg/sql/sql_select.cc", line=line@entry=9479, function=function@entry=0x55e4dd6879c0 "void restore_prev_nj_state(JOIN_TAB*)") at assert.c:101
|
#8 0x000055e4dd18b0b4 in restore_prev_nj_state (last=last@entry=0x152c0001d8a8) at /test/5.5_dbg/sql/sql_select.cc:9476
|
#9 0x000055e4dd18e5b7 in best_extension_by_limited_search (join=join@entry=0x152c0001c130, remaining_tables=remaining_tables@entry=1, idx=idx@entry=0, record_count=record_count@entry=1, read_time=read_time@entry=0, search_depth=search_depth@entry=62, prune_level=prune_level@entry=1) at /test/5.5_dbg/sql/sql_select.cc:5634
|
#10 0x000055e4dd1a322c in greedy_search (prune_level=1, search_depth=62, remaining_tables=1, join=0x152c0001c130) at /test/5.5_dbg/sql/sql_select.cc:5321
|
#11 choose_plan (join_tables=<optimized out>, join=0x152c0001c130) at /test/5.5_dbg/sql/sql_select.cc:5035
|
#12 make_join_statistics (join=join@entry=0x152c0001c130, tables_arg=0x152c0002ce10, conds=0x0, keyuse_array=keyuse_array@entry=0x152c0001d6e8) at /test/5.5_dbg/sql/sql_select.cc:3143
|
#13 0x000055e4dd1a5f93 in JOIN::optimize (this=this@entry=0x152c0001c130) at /test/5.5_dbg/sql/sql_select.cc:1072
|
#14 0x000055e4dd1aae4f in mysql_select (thd=thd@entry=0x55e4df497ba0, rref_pointer_array=rref_pointer_array@entry=0x152c00023f40, tables=0x152c00014610, wild_num=0, fields=@0x152c00023e68: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x152c000249e0, last = 0x152c000249e0, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147749632, result=0x152c00024a08, unit=0x152c00023738, select_lex=0x152c00023d58) at /test/5.5_dbg/sql/sql_select.cc:2605
|
#15 0x000055e4dd1ab0df in handle_select (thd=thd@entry=0x55e4df497ba0, lex=lex@entry=0x152c00023688, result=result@entry=0x152c00024a08, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/5.5_dbg/sql/sql_select.cc:285
|
#16 0x000055e4dd15e26c in execute_sqlcom_select (thd=thd@entry=0x55e4df497ba0, all_tables=0x152c00014610) at /test/5.5_dbg/sql/sql_parse.cc:4676
|
#17 0x000055e4dd16535a in mysql_execute_command (thd=0x55e4df497ba0) at /test/5.5_dbg/sql/sql_parse.cc:2213
|
#18 0x000055e4dd366b6d in sp_instr_stmt::exec_core (this=0x152c00024ac0, thd=<optimized out>, nextp=0x152c0cc1d3b4) at /test/5.5_dbg/sql/sp_head.cc:3209
|
#19 0x000055e4dd36d8cd in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x152c00024b00, thd=thd@entry=0x55e4df497ba0, nextp=nextp@entry=0x152c0cc1d3b4, open_tables=open_tables@entry=false, instr=instr@entry=0x152c00024ac0) at /test/5.5_dbg/sql/sp_head.cc:2998
|
#20 0x000055e4dd36dd61 in sp_instr_stmt::execute (this=0x152c00024ac0, thd=0x55e4df497ba0, nextp=0x152c0cc1d3b4) at /test/5.5_dbg/sql/sp_head.cc:3141
|
#21 0x000055e4dd36960d in sp_head::execute (this=this@entry=0x152c00022eb0, thd=thd@entry=0x55e4df497ba0, merge_da_on_success=merge_da_on_success@entry=true) at /test/5.5_dbg/sql/sp_head.cc:1435
|
#22 0x000055e4dd36ad2c in sp_head::execute_procedure (this=this@entry=0x152c00022eb0, thd=thd@entry=0x55e4df497ba0, args=args@entry=0x55e4df49a130) at /test/5.5_dbg/sql/sp_head.cc:2199
|
#23 0x000055e4dd16ab38 in mysql_execute_command (thd=thd@entry=0x55e4df497ba0) at /test/5.5_dbg/sql/sql_parse.cc:4120
|
#24 0x000055e4dd16cc47 in mysql_parse (thd=thd@entry=0x55e4df497ba0, rawbuf=<optimized out>, length=10, parser_state=parser_state@entry=0x152c0cc1e610) at /test/5.5_dbg/sql/sql_parse.cc:5831
|
#25 0x000055e4dd16e4bd in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x55e4df497ba0, packet=packet@entry=0x55e4df51efb1 "CALL p (1)", packet_length=packet_length@entry=10) at /test/5.5_dbg/sql/sql_class.h:758
|
#26 0x000055e4dd16fd83 in do_command (thd=0x55e4df497ba0) at /test/5.5_dbg/sql/sql_parse.cc:776
|
#27 0x000055e4dd2203f2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x55e4df497ba0) at /test/5.5_dbg/sql/sql_connect.cc:870
|
#28 0x000055e4dd2204c4 in handle_one_connection (arg=0x55e4df497ba0) at /test/5.5_dbg/sql/sql_connect.cc:789
|
#29 0x0000152c1d99b609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#30 0x0000152c1d58f293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
|
MSQL 5.5.62 (Optimized)
|
Core was generated by `/test/MS121121-mysql-5.5.62-linux-x86_64-opt/bin/mysqld --no-defaults --core --'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
[Current thread is 1 (Thread 0x14c5e40c0700 (LWP 808808))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x0000555682b00fcf in my_write_core (sig=sig@entry=11) at /test/5.5_opt/mysys/stacktrace.c:433
|
#2 0x00005556829d915e in handle_fatal_signal (sig=11) at /test/5.5_opt/sql/signal_handler.cc:247
|
#3 <signal handler called>
|
#4 0x000055568290ef0a in make_cond_for_table (cond=cond@entry=0x0, tables=tables@entry=13835058055282163713, used_table=1) at /test/5.5_opt/sql/sql_select.cc:13340
|
#5 0x000055568291029f in make_join_select (join=join@entry=0x14c5d801c6e0, select=0x14c5d8037570, cond=0x0) at /test/5.5_opt/sql/sql_select.cc:6807
|
#6 0x0000555682920f00 in JOIN::optimize (this=0x14c5d801c6e0) at /test/5.5_opt/sql/sql_select.cc:1203
|
#7 JOIN::optimize (this=0x14c5d801c6e0) at /test/5.5_opt/sql/sql_select.cc:856
|
#8 0x0000555682923d7a in mysql_select (thd=thd@entry=0x5556853822c0, rref_pointer_array=rref_pointer_array@entry=0x14c5d80246f0, tables=0x14c5d8029680, wild_num=0, fields=@0x14c5d8024618: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14c5d8025190, last = 0x14c5d8025190, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147749632, result=0x14c5d80251b8, unit=0x14c5d8023ee8, select_lex=0x14c5d8024508) at /test/5.5_opt/sql/sql_select.cc:2605
|
#9 0x0000555682923f22 in handle_select (thd=thd@entry=0x5556853822c0, lex=lex@entry=0x14c5d8023e38, result=result@entry=0x14c5d80251b8, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/5.5_opt/sql/sql_select.cc:285
|
#10 0x00005556828dfd92 in execute_sqlcom_select (thd=thd@entry=0x5556853822c0, all_tables=0x14c5d8029680) at /test/5.5_opt/sql/sql_parse.cc:4676
|
#11 0x00005556828e9e2a in mysql_execute_command (thd=0x5556853822c0) at /test/5.5_opt/sql/sql_parse.cc:2213
|
#12 0x0000555682aa49d9 in sp_instr_stmt::exec_core (this=0x14c5d8025268, thd=<optimized out>, nextp=0x14c5e40be4c4) at /test/5.5_opt/sql/sp_head.cc:3209
|
#13 0x0000555682aab0bb in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x14c5d80252a8, thd=thd@entry=0x5556853822c0, nextp=nextp@entry=0x14c5e40be4c4, open_tables=open_tables@entry=false, instr=instr@entry=0x14c5d8025268) at /test/5.5_opt/sql/sp_head.cc:2998
|
#14 0x0000555682aab445 in sp_instr_stmt::execute (this=0x14c5d8025268, thd=0x5556853822c0, nextp=0x14c5e40be4c4) at /test/5.5_opt/sql/sp_head.cc:3141
|
#15 0x0000555682aa7a9b in sp_head::execute (this=this@entry=0x14c5d8023660, thd=thd@entry=0x5556853822c0, merge_da_on_success=merge_da_on_success@entry=true) at /test/5.5_opt/sql/sp_head.cc:1435
|
#16 0x0000555682aa9291 in sp_head::execute_procedure (this=this@entry=0x14c5d8023660, thd=thd@entry=0x5556853822c0, args=args@entry=0x555685384840) at /test/5.5_opt/sql/sp_head.cc:2199
|
#17 0x00005556828e931c in mysql_execute_command (thd=thd@entry=0x5556853822c0) at /test/5.5_opt/sql/sql_parse.cc:4120
|
#18 0x00005556828ebe4f in mysql_parse (rawbuf=<optimized out>, length=10, parser_state=0x14c5e40bf6a0, thd=0x5556853822c0) at /test/5.5_opt/sql/sql_parse.cc:5831
|
#19 mysql_parse (thd=0x5556853822c0, rawbuf=<optimized out>, length=10, parser_state=0x14c5e40bf6a0) at /test/5.5_opt/sql/sql_parse.cc:5755
|
#20 0x00005556828ee14f in dispatch_command (command=<optimized out>, thd=0x5556853822c0, packet=<optimized out>, packet_length=<optimized out>) at /test/5.5_opt/sql/sql_class.h:758
|
#21 0x00005556828eec1f in do_command (thd=<optimized out>) at /test/5.5_opt/sql/sql_parse.cc:776
|
#22 0x0000555682988ec2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x5556853822c0) at /test/5.5_opt/sql/sql_connect.cc:870
|
#23 0x0000555682988f8c in handle_one_connection (arg=0x5556853822c0) at /test/5.5_opt/sql/sql_connect.cc:789
|
#24 0x000014c5f4f0d609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#25 0x000014c5f4b01293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
|