Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL)
-
None
Description
Reproducible on 10.4, with MyIsam/Innodb
CREATE TABLE t1 (i1 int, i2 int); |
CREATE TABLE t2 (i1 int, i2 int); |
CREATE TABLE t3 (i1 int, i2 int); |
CREATE TABLE t4 (i1 int, i2 int); |
CREATE TABLE t5 (i1 int, i2 int); |
|
|
SELECT 1 FROM ((SELECT DISTINCT t2.* |
FROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3) |
WHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5); |
Thread 1 (Thread 0x7f38ce4fb700 (LWP 31353)):
|
#0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
|
#1 0x00005598c89c2761 in my_write_core (sig=11) at /home/alice/git/10.4/mysys/stacktrace.c:481
|
#2 0x00005598c82050d1 in handle_fatal_signal (sig=11) at /home/alice/git/10.4/sql/signal_handler.cc:305
|
#3 <signal handler called>
|
#4 0x00005598c7f9fb48 in Bitmap<64u>::merge (this=0x1b0, map2=...) at /home/alice/git/10.4/sql/sql_bitmap.h:196
|
#5 0x00005598c7f66c05 in add_key_field (join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0, cond=0x7f38bc05f118, field=0x7f38bc0620f8, eq_func=true, value=0x7f38bc05f1a8, num_values=1, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5391
|
#6 0x00005598c7f6704f in add_key_equal_fields (join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0, cond=0x7f38bc05f118, field_item=0x7f38bc05f398, eq_func=true, val=0x7f38bc05f1a8, num_values=1, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5512
|
#7 0x00005598c7f67e43 in Item_bool_func2::add_key_fields_optimize_op (this=0x7f38bc05f118, join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0x7f38ce4f9068, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, equal_func=true) at /home/alice/git/10.4/sql/sql_select.cc:5795
|
#8 0x00005598c825dc7e in Item_func_eq::add_key_fields (this=0x7f38bc05f118, join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0x7f38ce4f9068, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8) at /home/alice/git/10.4/sql/item_cmpfunc.h:715
|
#9 0x00005598c7f694a2 in update_ref_and_keys (thd=0x7f38bc000b00, keyuse=0x7f38bc14fc10, join_tab=0x7f38bc063778, tables=3, cond=0x7f38bc05f118, normal_tables=18446744073709551609, select_lex=0x7f38bc015520, sargables=0x7f38ce4f91f8) at /home/alice/git/10.4/sql/sql_select.cc:6266
|
#10 0x00005598c7f63e9c in make_join_statistics (join=0x7f38bc14f920, tables_list=..., keyuse_array=0x7f38bc14fc10) at /home/alice/git/10.4/sql/sql_select.cc:4568
|
#11 0x00005598c7f5aad3 in JOIN::optimize_inner (this=0x7f38bc14f920) at /home/alice/git/10.4/sql/sql_select.cc:1926
|
#12 0x00005598c7f58f33 in JOIN::optimize (this=0x7f38bc14f920) at /home/alice/git/10.4/sql/sql_select.cc:1448
|
#13 0x00005598c7ec8257 in mysql_derived_optimize (thd=0x7f38bc000b00, lex=0x7f38bc0048e0, derived=0x7f38bc018c08) at /home/alice/git/10.4/sql/sql_derived.cc:936
|
#14 0x00005598c7ec681f in mysql_handle_single_derived (lex=0x7f38bc0048e0, derived=0x7f38bc018c08, phases=4) at /home/alice/git/10.4/sql/sql_derived.cc:198
|
#15 0x00005598c7f5a026 in JOIN::optimize_inner (this=0x7f38bc14f2c8) at /home/alice/git/10.4/sql/sql_select.cc:1743
|
#16 0x00005598c7f58f33 in JOIN::optimize (this=0x7f38bc14f2c8) at /home/alice/git/10.4/sql/sql_select.cc:1448
|
#17 0x00005598c7f62e43 in mysql_select (thd=0x7f38bc000b00, tables=0x7f38bc018c08, wild_num=0, fields=..., conds=0x7f38bc14e748, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f38bc14f2a8, unit=0x7f38bc0049a8, select_lex=0x7f38bc015048) at /home/alice/git/10.4/sql/sql_select.cc:4261
|
#18 0x00005598c7f549d6 in handle_select (thd=0x7f38bc000b00, lex=0x7f38bc0048e0, result=0x7f38bc14f2a8, setup_tables_done_option=0) at /home/alice/git/10.4/sql/sql_select.cc:382
|
#19 0x00005598c7f1f315 in execute_sqlcom_select (thd=0x7f38bc000b00, all_tables=0x7f38bc018c08) at /home/alice/git/10.4/sql/sql_parse.cc:6545
|
#20 0x00005598c7f1576e in mysql_execute_command (thd=0x7f38bc000b00) at /home/alice/git/10.4/sql/sql_parse.cc:3768
|
#21 0x00005598c7f2304d in mysql_parse (thd=0x7f38bc000b00, rawbuf=0x7f38bc014e88 "SELECT 1 FROM ((SELECT DISTINCT t2.*\nFROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3)\nWHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5)", length=174, parser_state=0x7f38ce4fa5f0, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:8063
|
#22 0x00005598c7f101d0 in dispatch_command (command=COM_QUERY, thd=0x7f38bc000b00, packet=0x7f38bc00b441 "SELECT 1 FROM ((SELECT DISTINCT t2.*\nFROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3)\nWHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5)", packet_length=174, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:1847
|
#23 0x00005598c7f0ebed in do_command (thd=0x7f38bc000b00) at /home/alice/git/10.4/sql/sql_parse.cc:1392
|
#24 0x00005598c8075613 in do_handle_one_connection (connect=0x5598ca88ab20) at /home/alice/git/10.4/sql/sql_connect.cc:1402
|
#25 0x00005598c8075364 in handle_one_connection (arg=0x5598ca88ab20) at /home/alice/git/10.4/sql/sql_connect.cc:1308
|
#26 0x00005598c8952baa in pfs_spawn_thread (arg=0x5598ca892c10) at /home/alice/git/10.4/storage/perfschema/pfs.cc:1862
|
#27 0x00007f38d4f9a6ba in start_thread (arg=0x7f38ce4fb700) at pthread_create.c:333
|
#28 0x00007f38d442f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.4 [ 22408 ] |
| Description |
{noformat} Thread 1 (Thread 0x7f542a55a700 (LWP 24594)): #0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x00005584ed401761 in my_write_core (sig=11) at /home/alice/git/10.4/mysys/stacktrace.c:481 #2 0x00005584ecc440d1 in handle_fatal_signal (sig=11) at /home/alice/git/10.4/sql/signal_handler.cc:305 #3 <signal handler called> #4 0x00005584ec9deb48 in Bitmap<64u>::merge (this=0x1b0, map2=...) at /home/alice/git/10.4/sql/sql_bitmap.h:196 #5 0x00005584ec9a5c05 in add_key_field (join=0x7f54180946d8, key_fields=0x7f542a558078, and_level=0, cond=0x7f54180c9b50, field=0x7f54180c8318, eq_func=true, value=0x7f54180c9be0, num_values=1, usable_tables=18446744073709551609, sargables=0x7f542a5581f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5391 #6 0x00005584ec9a604f in add_key_equal_fields (join=0x7f54180946d8, key_fields=0x7f542a558078, and_level=0, cond=0x7f54180c9b50, field_item=0x7f54180c9dd0, eq_func=true, val=0x7f54180c9be0, num_values=1, usable_tables=18446744073709551609, sargables=0x7f542a5581f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5512 #7 0x00005584ec9a6e43 in Item_bool_func2::add_key_fields_optimize_op (this=0x7f54180c9b50, join=0x7f54180946d8, key_fields=0x7f542a558078, and_level=0x7f542a558068, usable_tables=18446744073709551609, sargables=0x7f542a5581f8, equal_func=true) at /home/alice/git/10.4/sql/sql_select.cc:5795 #8 0x00005584ecc9cc7e in Item_func_eq::add_key_fields (this=0x7f54180c9b50, join=0x7f54180946d8, key_fields=0x7f542a558078, and_level=0x7f542a558068, usable_tables=18446744073709551609, sargables=0x7f542a5581f8) at /home/alice/git/10.4/sql/item_cmpfunc.h:715 #9 0x00005584ec9a84a2 in update_ref_and_keys (thd=0x7f5418000b00, keyuse=0x7f54180949c8, join_tab=0x7f54180ca430, tables=3, cond=0x7f54180c9b50, normal_tables=18446744073709551609, select_lex=0x7f5418015550, sargables=0x7f542a5581f8) at /home/alice/git/10.4/sql/sql_select.cc:6266 #10 0x00005584ec9a2e9c in make_join_statistics (join=0x7f54180946d8, tables_list=..., keyuse_array=0x7f54180949c8) at /home/alice/git/10.4/sql/sql_select.cc:4568 #11 0x00005584ec999ad3 in JOIN::optimize_inner (this=0x7f54180946d8) at /home/alice/git/10.4/sql/sql_select.cc:1926 #12 0x00005584ec997f33 in JOIN::optimize (this=0x7f54180946d8) at /home/alice/git/10.4/sql/sql_select.cc:1448 #13 0x00005584ec907257 in mysql_derived_optimize (thd=0x7f5418000b00, lex=0x7f54180048e0, derived=0x7f5418018c40) at /home/alice/git/10.4/sql/sql_derived.cc:936 #14 0x00005584ec90581f in mysql_handle_single_derived (lex=0x7f54180048e0, derived=0x7f5418018c40, phases=4) at /home/alice/git/10.4/sql/sql_derived.cc:198 #15 0x00005584ec999026 in JOIN::optimize_inner (this=0x7f5418094080) at /home/alice/git/10.4/sql/sql_select.cc:1743 #16 0x00005584ec997f33 in JOIN::optimize (this=0x7f5418094080) at /home/alice/git/10.4/sql/sql_select.cc:1448 #17 0x00005584ec9a1e43 in mysql_select (thd=0x7f5418000b00, tables=0x7f5418018c40, wild_num=0, fields=..., conds=0x7f5418093500, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5418094060, unit=0x7f54180049a8, select_lex=0x7f5418015078) at /home/alice/git/10.4/sql/sql_select.cc:4261 #18 0x00005584ec9939d6 in handle_select (thd=0x7f5418000b00, lex=0x7f54180048e0, result=0x7f5418094060, setup_tables_done_option=0) at /home/alice/git/10.4/sql/sql_select.cc:382 #19 0x00005584ec95e315 in execute_sqlcom_select (thd=0x7f5418000b00, all_tables=0x7f5418018c40) at /home/alice/git/10.4/sql/sql_parse.cc:6545 #20 0x00005584ec95476e in mysql_execute_command (thd=0x7f5418000b00) at /home/alice/git/10.4/sql/sql_parse.cc:3768 #21 0x00005584ec96204d in mysql_parse (thd=0x7f5418000b00, rawbuf=0x7f5418014e88 "SELECT 1\nFROM ((SELECT DISTINCT AA.*\nFROM (AA LEFT JOIN (A RIGHT JOIN D ON (D.pk = A.pk)) ON (D.pk = A.col_int_nokey))) AS alias1,C,D)\nWHERE alias1.pk IN (SELECT COUNT(DD.col_int_nokey) FROM DD)", length=194, parser_state=0x7f542a5595f0, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:8063 #22 0x00005584ec94f1d0 in dispatch_command (command=COM_QUERY, thd=0x7f5418000b00, packet=0x7f541800b441 "SELECT 1\nFROM ((SELECT DISTINCT AA.*\nFROM (AA LEFT JOIN (A RIGHT JOIN D ON (D.pk = A.pk)) ON (D.pk = A.col_int_nokey))) AS alias1,C,D)\nWHERE alias1.pk IN (SELECT COUNT(DD.col_int_nokey) FROM DD)", packet_length=194, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:1847 #23 0x00005584ec94dbed in do_command (thd=0x7f5418000b00) at /home/alice/git/10.4/sql/sql_parse.cc:1392 #24 0x00005584ecab4613 in do_handle_one_connection (connect=0x5584ef49cb20) at /home/alice/git/10.4/sql/sql_connect.cc:1402 #25 0x00005584ecab4364 in handle_one_connection (arg=0x5584ef49cb20) at /home/alice/git/10.4/sql/sql_connect.cc:1308 #26 0x00005584ed391baa in pfs_spawn_thread (arg=0x5584ef4a4c10) at /home/alice/git/10.4/storage/perfschema/pfs.cc:1862 #27 0x00007f5430ff96ba in start_thread (arg=0x7f542a55a700) at pthread_create.c:333 #28 0x00007f543048e41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 {noformat} |
Reproducible on 0.4, with MyIsam/Innodb
{code:sql} CREATE TABLE t1 (i1 int, i2 int); CREATE TABLE t2 (i1 int, i2 int); CREATE TABLE t3 (i1 int, i2 int); CREATE TABLE t4 (i1 int, i2 int); CREATE TABLE t5 (i1 int, i2 int); SELECT 1 FROM ((SELECT DISTINCT t2.* FROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3) WHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5); {code} {noformat} Thread 1 (Thread 0x7f38ce4fb700 (LWP 31353)): #0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x00005598c89c2761 in my_write_core (sig=11) at /home/alice/git/10.4/mysys/stacktrace.c:481 #2 0x00005598c82050d1 in handle_fatal_signal (sig=11) at /home/alice/git/10.4/sql/signal_handler.cc:305 #3 <signal handler called> #4 0x00005598c7f9fb48 in Bitmap<64u>::merge (this=0x1b0, map2=...) at /home/alice/git/10.4/sql/sql_bitmap.h:196 #5 0x00005598c7f66c05 in add_key_field (join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0, cond=0x7f38bc05f118, field=0x7f38bc0620f8, eq_func=true, value=0x7f38bc05f1a8, num_values=1, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5391 #6 0x00005598c7f6704f in add_key_equal_fields (join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0, cond=0x7f38bc05f118, field_item=0x7f38bc05f398, eq_func=true, val=0x7f38bc05f1a8, num_values=1, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5512 #7 0x00005598c7f67e43 in Item_bool_func2::add_key_fields_optimize_op (this=0x7f38bc05f118, join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0x7f38ce4f9068, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, equal_func=true) at /home/alice/git/10.4/sql/sql_select.cc:5795 #8 0x00005598c825dc7e in Item_func_eq::add_key_fields (this=0x7f38bc05f118, join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0x7f38ce4f9068, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8) at /home/alice/git/10.4/sql/item_cmpfunc.h:715 #9 0x00005598c7f694a2 in update_ref_and_keys (thd=0x7f38bc000b00, keyuse=0x7f38bc14fc10, join_tab=0x7f38bc063778, tables=3, cond=0x7f38bc05f118, normal_tables=18446744073709551609, select_lex=0x7f38bc015520, sargables=0x7f38ce4f91f8) at /home/alice/git/10.4/sql/sql_select.cc:6266 #10 0x00005598c7f63e9c in make_join_statistics (join=0x7f38bc14f920, tables_list=..., keyuse_array=0x7f38bc14fc10) at /home/alice/git/10.4/sql/sql_select.cc:4568 #11 0x00005598c7f5aad3 in JOIN::optimize_inner (this=0x7f38bc14f920) at /home/alice/git/10.4/sql/sql_select.cc:1926 #12 0x00005598c7f58f33 in JOIN::optimize (this=0x7f38bc14f920) at /home/alice/git/10.4/sql/sql_select.cc:1448 #13 0x00005598c7ec8257 in mysql_derived_optimize (thd=0x7f38bc000b00, lex=0x7f38bc0048e0, derived=0x7f38bc018c08) at /home/alice/git/10.4/sql/sql_derived.cc:936 #14 0x00005598c7ec681f in mysql_handle_single_derived (lex=0x7f38bc0048e0, derived=0x7f38bc018c08, phases=4) at /home/alice/git/10.4/sql/sql_derived.cc:198 #15 0x00005598c7f5a026 in JOIN::optimize_inner (this=0x7f38bc14f2c8) at /home/alice/git/10.4/sql/sql_select.cc:1743 #16 0x00005598c7f58f33 in JOIN::optimize (this=0x7f38bc14f2c8) at /home/alice/git/10.4/sql/sql_select.cc:1448 #17 0x00005598c7f62e43 in mysql_select (thd=0x7f38bc000b00, tables=0x7f38bc018c08, wild_num=0, fields=..., conds=0x7f38bc14e748, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f38bc14f2a8, unit=0x7f38bc0049a8, select_lex=0x7f38bc015048) at /home/alice/git/10.4/sql/sql_select.cc:4261 #18 0x00005598c7f549d6 in handle_select (thd=0x7f38bc000b00, lex=0x7f38bc0048e0, result=0x7f38bc14f2a8, setup_tables_done_option=0) at /home/alice/git/10.4/sql/sql_select.cc:382 #19 0x00005598c7f1f315 in execute_sqlcom_select (thd=0x7f38bc000b00, all_tables=0x7f38bc018c08) at /home/alice/git/10.4/sql/sql_parse.cc:6545 #20 0x00005598c7f1576e in mysql_execute_command (thd=0x7f38bc000b00) at /home/alice/git/10.4/sql/sql_parse.cc:3768 #21 0x00005598c7f2304d in mysql_parse (thd=0x7f38bc000b00, rawbuf=0x7f38bc014e88 "SELECT 1 FROM ((SELECT DISTINCT t2.*\nFROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3)\nWHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5)", length=174, parser_state=0x7f38ce4fa5f0, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:8063 #22 0x00005598c7f101d0 in dispatch_command (command=COM_QUERY, thd=0x7f38bc000b00, packet=0x7f38bc00b441 "SELECT 1 FROM ((SELECT DISTINCT t2.*\nFROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3)\nWHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5)", packet_length=174, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:1847 #23 0x00005598c7f0ebed in do_command (thd=0x7f38bc000b00) at /home/alice/git/10.4/sql/sql_parse.cc:1392 #24 0x00005598c8075613 in do_handle_one_connection (connect=0x5598ca88ab20) at /home/alice/git/10.4/sql/sql_connect.cc:1402 #25 0x00005598c8075364 in handle_one_connection (arg=0x5598ca88ab20) at /home/alice/git/10.4/sql/sql_connect.cc:1308 #26 0x00005598c8952baa in pfs_spawn_thread (arg=0x5598ca892c10) at /home/alice/git/10.4/storage/perfschema/pfs.cc:1862 #27 0x00007f38d4f9a6ba in start_thread (arg=0x7f38ce4fb700) at pthread_create.c:333 #28 0x00007f38d442f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 {noformat} |
| Summary | [draft] server crashes in Bitmap<64u>::merge | server crashes in Bitmap<64u>::merge |
| Assignee | Alice Sherepa [ alice ] | Igor Babaev [ igor ] |
| Description |
Reproducible on 0.4, with MyIsam/Innodb
{code:sql} CREATE TABLE t1 (i1 int, i2 int); CREATE TABLE t2 (i1 int, i2 int); CREATE TABLE t3 (i1 int, i2 int); CREATE TABLE t4 (i1 int, i2 int); CREATE TABLE t5 (i1 int, i2 int); SELECT 1 FROM ((SELECT DISTINCT t2.* FROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3) WHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5); {code} {noformat} Thread 1 (Thread 0x7f38ce4fb700 (LWP 31353)): #0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x00005598c89c2761 in my_write_core (sig=11) at /home/alice/git/10.4/mysys/stacktrace.c:481 #2 0x00005598c82050d1 in handle_fatal_signal (sig=11) at /home/alice/git/10.4/sql/signal_handler.cc:305 #3 <signal handler called> #4 0x00005598c7f9fb48 in Bitmap<64u>::merge (this=0x1b0, map2=...) at /home/alice/git/10.4/sql/sql_bitmap.h:196 #5 0x00005598c7f66c05 in add_key_field (join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0, cond=0x7f38bc05f118, field=0x7f38bc0620f8, eq_func=true, value=0x7f38bc05f1a8, num_values=1, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5391 #6 0x00005598c7f6704f in add_key_equal_fields (join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0, cond=0x7f38bc05f118, field_item=0x7f38bc05f398, eq_func=true, val=0x7f38bc05f1a8, num_values=1, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5512 #7 0x00005598c7f67e43 in Item_bool_func2::add_key_fields_optimize_op (this=0x7f38bc05f118, join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0x7f38ce4f9068, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, equal_func=true) at /home/alice/git/10.4/sql/sql_select.cc:5795 #8 0x00005598c825dc7e in Item_func_eq::add_key_fields (this=0x7f38bc05f118, join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0x7f38ce4f9068, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8) at /home/alice/git/10.4/sql/item_cmpfunc.h:715 #9 0x00005598c7f694a2 in update_ref_and_keys (thd=0x7f38bc000b00, keyuse=0x7f38bc14fc10, join_tab=0x7f38bc063778, tables=3, cond=0x7f38bc05f118, normal_tables=18446744073709551609, select_lex=0x7f38bc015520, sargables=0x7f38ce4f91f8) at /home/alice/git/10.4/sql/sql_select.cc:6266 #10 0x00005598c7f63e9c in make_join_statistics (join=0x7f38bc14f920, tables_list=..., keyuse_array=0x7f38bc14fc10) at /home/alice/git/10.4/sql/sql_select.cc:4568 #11 0x00005598c7f5aad3 in JOIN::optimize_inner (this=0x7f38bc14f920) at /home/alice/git/10.4/sql/sql_select.cc:1926 #12 0x00005598c7f58f33 in JOIN::optimize (this=0x7f38bc14f920) at /home/alice/git/10.4/sql/sql_select.cc:1448 #13 0x00005598c7ec8257 in mysql_derived_optimize (thd=0x7f38bc000b00, lex=0x7f38bc0048e0, derived=0x7f38bc018c08) at /home/alice/git/10.4/sql/sql_derived.cc:936 #14 0x00005598c7ec681f in mysql_handle_single_derived (lex=0x7f38bc0048e0, derived=0x7f38bc018c08, phases=4) at /home/alice/git/10.4/sql/sql_derived.cc:198 #15 0x00005598c7f5a026 in JOIN::optimize_inner (this=0x7f38bc14f2c8) at /home/alice/git/10.4/sql/sql_select.cc:1743 #16 0x00005598c7f58f33 in JOIN::optimize (this=0x7f38bc14f2c8) at /home/alice/git/10.4/sql/sql_select.cc:1448 #17 0x00005598c7f62e43 in mysql_select (thd=0x7f38bc000b00, tables=0x7f38bc018c08, wild_num=0, fields=..., conds=0x7f38bc14e748, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f38bc14f2a8, unit=0x7f38bc0049a8, select_lex=0x7f38bc015048) at /home/alice/git/10.4/sql/sql_select.cc:4261 #18 0x00005598c7f549d6 in handle_select (thd=0x7f38bc000b00, lex=0x7f38bc0048e0, result=0x7f38bc14f2a8, setup_tables_done_option=0) at /home/alice/git/10.4/sql/sql_select.cc:382 #19 0x00005598c7f1f315 in execute_sqlcom_select (thd=0x7f38bc000b00, all_tables=0x7f38bc018c08) at /home/alice/git/10.4/sql/sql_parse.cc:6545 #20 0x00005598c7f1576e in mysql_execute_command (thd=0x7f38bc000b00) at /home/alice/git/10.4/sql/sql_parse.cc:3768 #21 0x00005598c7f2304d in mysql_parse (thd=0x7f38bc000b00, rawbuf=0x7f38bc014e88 "SELECT 1 FROM ((SELECT DISTINCT t2.*\nFROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3)\nWHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5)", length=174, parser_state=0x7f38ce4fa5f0, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:8063 #22 0x00005598c7f101d0 in dispatch_command (command=COM_QUERY, thd=0x7f38bc000b00, packet=0x7f38bc00b441 "SELECT 1 FROM ((SELECT DISTINCT t2.*\nFROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3)\nWHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5)", packet_length=174, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:1847 #23 0x00005598c7f0ebed in do_command (thd=0x7f38bc000b00) at /home/alice/git/10.4/sql/sql_parse.cc:1392 #24 0x00005598c8075613 in do_handle_one_connection (connect=0x5598ca88ab20) at /home/alice/git/10.4/sql/sql_connect.cc:1402 #25 0x00005598c8075364 in handle_one_connection (arg=0x5598ca88ab20) at /home/alice/git/10.4/sql/sql_connect.cc:1308 #26 0x00005598c8952baa in pfs_spawn_thread (arg=0x5598ca892c10) at /home/alice/git/10.4/storage/perfschema/pfs.cc:1862 #27 0x00007f38d4f9a6ba in start_thread (arg=0x7f38ce4fb700) at pthread_create.c:333 #28 0x00007f38d442f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 {noformat} |
Reproducible on 10.4, with MyIsam/Innodb
{code:sql} CREATE TABLE t1 (i1 int, i2 int); CREATE TABLE t2 (i1 int, i2 int); CREATE TABLE t3 (i1 int, i2 int); CREATE TABLE t4 (i1 int, i2 int); CREATE TABLE t5 (i1 int, i2 int); SELECT 1 FROM ((SELECT DISTINCT t2.* FROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3) WHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5); {code} {noformat} Thread 1 (Thread 0x7f38ce4fb700 (LWP 31353)): #0 __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x00005598c89c2761 in my_write_core (sig=11) at /home/alice/git/10.4/mysys/stacktrace.c:481 #2 0x00005598c82050d1 in handle_fatal_signal (sig=11) at /home/alice/git/10.4/sql/signal_handler.cc:305 #3 <signal handler called> #4 0x00005598c7f9fb48 in Bitmap<64u>::merge (this=0x1b0, map2=...) at /home/alice/git/10.4/sql/sql_bitmap.h:196 #5 0x00005598c7f66c05 in add_key_field (join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0, cond=0x7f38bc05f118, field=0x7f38bc0620f8, eq_func=true, value=0x7f38bc05f1a8, num_values=1, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5391 #6 0x00005598c7f6704f in add_key_equal_fields (join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0, cond=0x7f38bc05f118, field_item=0x7f38bc05f398, eq_func=true, val=0x7f38bc05f1a8, num_values=1, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, row_col_no=0) at /home/alice/git/10.4/sql/sql_select.cc:5512 #7 0x00005598c7f67e43 in Item_bool_func2::add_key_fields_optimize_op (this=0x7f38bc05f118, join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0x7f38ce4f9068, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8, equal_func=true) at /home/alice/git/10.4/sql/sql_select.cc:5795 #8 0x00005598c825dc7e in Item_func_eq::add_key_fields (this=0x7f38bc05f118, join=0x7f38bc14f920, key_fields=0x7f38ce4f9078, and_level=0x7f38ce4f9068, usable_tables=18446744073709551609, sargables=0x7f38ce4f91f8) at /home/alice/git/10.4/sql/item_cmpfunc.h:715 #9 0x00005598c7f694a2 in update_ref_and_keys (thd=0x7f38bc000b00, keyuse=0x7f38bc14fc10, join_tab=0x7f38bc063778, tables=3, cond=0x7f38bc05f118, normal_tables=18446744073709551609, select_lex=0x7f38bc015520, sargables=0x7f38ce4f91f8) at /home/alice/git/10.4/sql/sql_select.cc:6266 #10 0x00005598c7f63e9c in make_join_statistics (join=0x7f38bc14f920, tables_list=..., keyuse_array=0x7f38bc14fc10) at /home/alice/git/10.4/sql/sql_select.cc:4568 #11 0x00005598c7f5aad3 in JOIN::optimize_inner (this=0x7f38bc14f920) at /home/alice/git/10.4/sql/sql_select.cc:1926 #12 0x00005598c7f58f33 in JOIN::optimize (this=0x7f38bc14f920) at /home/alice/git/10.4/sql/sql_select.cc:1448 #13 0x00005598c7ec8257 in mysql_derived_optimize (thd=0x7f38bc000b00, lex=0x7f38bc0048e0, derived=0x7f38bc018c08) at /home/alice/git/10.4/sql/sql_derived.cc:936 #14 0x00005598c7ec681f in mysql_handle_single_derived (lex=0x7f38bc0048e0, derived=0x7f38bc018c08, phases=4) at /home/alice/git/10.4/sql/sql_derived.cc:198 #15 0x00005598c7f5a026 in JOIN::optimize_inner (this=0x7f38bc14f2c8) at /home/alice/git/10.4/sql/sql_select.cc:1743 #16 0x00005598c7f58f33 in JOIN::optimize (this=0x7f38bc14f2c8) at /home/alice/git/10.4/sql/sql_select.cc:1448 #17 0x00005598c7f62e43 in mysql_select (thd=0x7f38bc000b00, tables=0x7f38bc018c08, wild_num=0, fields=..., conds=0x7f38bc14e748, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f38bc14f2a8, unit=0x7f38bc0049a8, select_lex=0x7f38bc015048) at /home/alice/git/10.4/sql/sql_select.cc:4261 #18 0x00005598c7f549d6 in handle_select (thd=0x7f38bc000b00, lex=0x7f38bc0048e0, result=0x7f38bc14f2a8, setup_tables_done_option=0) at /home/alice/git/10.4/sql/sql_select.cc:382 #19 0x00005598c7f1f315 in execute_sqlcom_select (thd=0x7f38bc000b00, all_tables=0x7f38bc018c08) at /home/alice/git/10.4/sql/sql_parse.cc:6545 #20 0x00005598c7f1576e in mysql_execute_command (thd=0x7f38bc000b00) at /home/alice/git/10.4/sql/sql_parse.cc:3768 #21 0x00005598c7f2304d in mysql_parse (thd=0x7f38bc000b00, rawbuf=0x7f38bc014e88 "SELECT 1 FROM ((SELECT DISTINCT t2.*\nFROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3)\nWHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5)", length=174, parser_state=0x7f38ce4fa5f0, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:8063 #22 0x00005598c7f101d0 in dispatch_command (command=COM_QUERY, thd=0x7f38bc000b00, packet=0x7f38bc00b441 "SELECT 1 FROM ((SELECT DISTINCT t2.*\nFROM (t2 LEFT JOIN (t1 RIGHT JOIN t3 ON (t3.i1 = t1.i1)) ON (t3.i1 = t1.i2))) AS tbl,t4,t3)\nWHERE tbl.i1 IN (SELECT COUNT(t5.i2) FROM t5)", packet_length=174, is_com_multi=false, is_next_command=false) at /home/alice/git/10.4/sql/sql_parse.cc:1847 #23 0x00005598c7f0ebed in do_command (thd=0x7f38bc000b00) at /home/alice/git/10.4/sql/sql_parse.cc:1392 #24 0x00005598c8075613 in do_handle_one_connection (connect=0x5598ca88ab20) at /home/alice/git/10.4/sql/sql_connect.cc:1402 #25 0x00005598c8075364 in handle_one_connection (arg=0x5598ca88ab20) at /home/alice/git/10.4/sql/sql_connect.cc:1308 #26 0x00005598c8952baa in pfs_spawn_thread (arg=0x5598ca892c10) at /home/alice/git/10.4/storage/perfschema/pfs.cc:1862 #27 0x00007f38d4f9a6ba in start_thread (arg=0x7f38ce4fb700) at pthread_create.c:333 #28 0x00007f38d442f41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109 {noformat} |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Assignee | Igor Babaev [ igor ] | Galina Shalygina [ shagalla ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Assignee | Galina Shalygina [ shagalla ] | Igor Babaev [ igor ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Igor Babaev [ igor ] | Galina Shalygina [ shagalla ] |
| Assignee | Galina Shalygina [ shagalla ] | Igor Babaev [ igor ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Igor Babaev [ igor ] | Galina Shalygina [ shagalla ] |
| Component/s | Optimizer [ 10200 ] | |
| Fix Version/s | 10.4.0 [ 23115 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Link |
This issue relates to |
| Workflow | MariaDB v3 [ 88357 ] | MariaDB v4 [ 154647 ] |