Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.28, 10.1.31
-
None
Description
Can't reliably reproduce this yet, but a query of the form
SELECT count(*) FROM t1 WHERE col1 in (SELECT col2 FROM t2 INNER JOIN t3 USING(col3) WHERE col4 = 123 );
|
may sometimes crash with the following backtrace when setting
optimizer_search_depth=63
|
The backtrace is as follows:
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
|
#1 0x0000561993f4c50a in my_write_core (sig=sig@entry=11)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/mysys/stacktrace.c:477
|
#2 0x0000561993b311d8 in handle_fatal_signal (sig=11)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/signal_handler.cc:296
|
#3 <signal handler called>
|
#4 0x0000561993ab7303 in optimize_semijoin_nests (join=join@entry=0x7f9a19023618,
|
all_table_map=all_table_map@entry=7)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/opt_subselect.cc:2359
|
#5 0x0000561993a0758f in make_join_statistics (join=join@entry=0x7f9a19023618, tables_list=...,
|
keyuse_array=keyuse_array@entry=0x7f9a19023958)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_select.cc:4187
|
#6 0x0000561993a0e607 in JOIN::optimize_inner (this=0x7f9a19023618)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_select.cc:1367
|
#7 0x0000561993a11908 in JOIN::optimize (this=0x7f9a19023618)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_select.cc:1045
|
#8 0x0000561993a12305 in mysql_select (thd=thd@entry=0x7f9a8139c008,
|
rref_pointer_array=rref_pointer_array@entry=0x7f9a813a02d8, tables=0x7f9a19020428,
|
wild_num=<optimized out>, fields=..., conds=0x7f9a19022d40, og_num=0, order=0x0, group=0x0, having=0x0,
|
proc_param=0x0, select_options=2147748612, result=0x7f9a19023038, unit=0x7f9a8139f948,
|
select_lex=0x7f9a813a0048)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_select.cc:3435
|
#9 0x0000561993a126f8 in mysql_explain_union (thd=thd@entry=0x7f9a8139c008,
|
unit=unit@entry=0x7f9a8139f948, result=result@entry=0x7f9a19023038)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_select.cc:24843
|
#10 0x0000561993919d5e in execute_sqlcom_select (thd=thd@entry=0x7f9a8139c008, all_tables=<optimized out>)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_parse.cc:5851
|
#11 0x00005619939c578f in mysql_execute_command (thd=thd@entry=0x7f9a8139c008)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_parse.cc:2982
|
#12 0x00005619939c791a in mysql_parse (thd=0x7f9a8139c008, rawbuf=<optimized out>, length=<optimized out>,
|
parser_state=<optimized out>)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_parse.cc:7333
|
#13 0x00005619939cad6e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f9a8139c008,
|
packet=packet@entry=0x7f9a6f3c0009 "", packet_length=packet_length@entry=191)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_parse.cc:1484
|
#14 0x00005619939cb53a in do_command (thd=0x7f9a8139c008)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_parse.cc:1106
|
#15 0x0000561993a873dc in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f9a8139c008)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_connect.cc:1349
|
#16 0x0000561993a87587 in handle_one_connection (arg=0x7f9a8139c008)
|
at /home/hartmut/projects/mariadb/releases/mariadb-10.1.28/sql/sql_connect.cc:1261
|
#17 0x00007f9a831006ba in start_thread (arg=0x7f9a84b70b00) at pthread_create.c:333
|
#18 0x00007f9a827ab41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|