Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3
-
None
-
None
-
None
Description
10.3 afc56a509cc7d |
#3 <signal handler called>
|
#4 0x0000562b35730f64 in Item_ident::get_depended_from (this=0x7f77742b4190) at /data/src/10.3/sql/item.cc:10540
|
#5 0x0000562b3571c2c5 in Item_field::used_tables (this=0x7f77742b4190) at /data/src/10.3/sql/item.cc:3536
|
#6 0x0000562b35398e53 in setup_fields (thd=0x7f7774000b00, ref_pointer_array=..., fields=..., column_usage=MARK_COLUMNS_READ, sum_func_list=0x7f77742d0740, pre_fix=0x7f77742b28f0, allow_sum_func=true) at /data/src/10.3/sql/sql_base.cc:7308
|
#7 0x0000562b354545b6 in JOIN::prepare (this=0x7f77742d0420, tables_init=0x7f77742b4cb8, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f77742b27b0, unit_arg=0x7f77742b2048) at /data/src/10.3/sql/sql_select.cc:1214
|
#8 0x0000562b35502c6d in st_select_lex_unit::prepare_join (this=0x7f77742b2048, thd_arg=0x7f7774000b00, sl=0x7f77742b27b0, tmp_result=0x7f77742b92f8, additional_options=0, is_union_select=false) at /data/src/10.3/sql/sql_union.cc:675
|
#9 0x0000562b35504024 in st_select_lex_unit::prepare (this=0x7f77742b2048, thd_arg=0x7f7774000b00, sel_result=0x7f77742b92f8, additional_options=0) at /data/src/10.3/sql/sql_union.cc:947
|
#10 0x0000562b353d365e in mysql_derived_prepare (thd=0x7f7774000b00, lex=0x7f77e88bba80, derived=0x7f77742b1468) at /data/src/10.3/sql/sql_derived.cc:769
|
#11 0x0000562b353d216d in mysql_handle_derived (lex=0x7f77e88bba80, phases=35) at /data/src/10.3/sql/sql_derived.cc:121
|
#12 0x0000562b353931c8 in open_normal_and_derived_tables (thd=0x7f7774000b00, tables=0x7f77742b1468, flags=1090, dt_phases=35) at /data/src/10.3/sql/sql_base.cc:4943
|
#13 0x0000562b35393388 in open_tables_only_view_structure (thd=0x7f7774000b00, table_list=0x7f77742b1468, can_deadlock=false) at /data/src/10.3/sql/sql_base.cc:4999
|
#14 0x0000562b354b2c3f in fill_schema_table_by_open (thd=0x7f7774000b00, mem_root=0x7f77e88bd330, is_show_fields_or_keys=false, table=0x7f77742040d8, schema_table=0x562b36984d00 <schema_tables+2432>, orig_db_name=0x7f77742aeea0, orig_table_name=0x7f77742aef80, open_tables_state_backup=0x7f77e88bd380, can_deadlock=false) at /data/src/10.3/sql/sql_show.cc:4568
|
#15 0x0000562b354b493e in get_all_tables (thd=0x7f7774000b00, tables=0x7f7774017450, cond=0x7f7774018ef0) at /data/src/10.3/sql/sql_show.cc:5268
|
#16 0x0000562b354c489a in get_schema_tables_result (join=0x7f777411d408, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.3/sql/sql_show.cc:8664
|
#17 0x0000562b3545eb72 in JOIN::exec_inner (this=0x7f777411d408) at /data/src/10.3/sql/sql_select.cc:4036
|
#18 0x0000562b3545e216 in JOIN::exec (this=0x7f777411d408) at /data/src/10.3/sql/sql_select.cc:3867
|
#19 0x0000562b35505d94 in st_select_lex_unit::exec (this=0x7f7774004898) at /data/src/10.3/sql/sql_union.cc:1427
|
#20 0x0000562b35500ffa in mysql_union (thd=0x7f7774000b00, lex=0x7f77740047d0, result=0x7f77741b9cd8, unit=0x7f7774004898, setup_tables_done_option=0) at /data/src/10.3/sql/sql_union.cc:41
|
#21 0x0000562b354510d1 in handle_select (thd=0x7f7774000b00, lex=0x7f77740047d0, result=0x7f77741b9cd8, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:360
|
#22 0x0000562b3541be0b in execute_sqlcom_select (thd=0x7f7774000b00, all_tables=0x7f7774014710) at /data/src/10.3/sql/sql_parse.cc:6523
|
#23 0x0000562b3541250f in mysql_execute_command (thd=0x7f7774000b00) at /data/src/10.3/sql/sql_parse.cc:3748
|
#24 0x0000562b3541f804 in mysql_parse (thd=0x7f7774000b00, rawbuf=0x7f7774013958 "( SELECT * FROM (INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`CHARACTER_MAXIMUM_LENGTH` = table1.`F_GEOMETRY_COLUMN` ) ) WHERE table1.`F_TABLE_CATALOG` >= 'tb' LIMIT 3 /* QNO 1227 CON_ID 17 */ ) UNION DISTINCT ( SELECT * FROM (INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`CHARACTER_MAXIMUM_LENGTH` = table1.`F_GEOMETRY_COLUMN` ) ) WHERE table1.`F_TABLE_CATALOG` >= 'tb' LIMIT 3 /* QNO 1227 CON_ID 17 */ ) /* TRANSFORM_OUTCOME_DISTINCT */ /* QNO 1257 CON_ID 17 */", length=614, parser_state=0x7f77e88bf630, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7980
|
#25 0x0000562b3540cfb7 in dispatch_command (command=COM_QUERY, thd=0x7f7774000b00, packet=0x7f777400b191 "( SELECT * FROM (INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`CHARACTER_MAXIMUM_LENGTH` = table1.`F_GEOMETRY_COLUMN` ) ) WHERE table1.`F_TABLE_CATALOG` >= 'tb' LIMIT 3 /* QNO 1227 CON_ID 17 */ ) UNION DISTINCT ( SELECT * FROM (INFORMATION_SCHEMA.`GEOMETRY_COLUMNS` AS table1 LEFT OUTER JOIN INFORMATION_SCHEMA.`PARAMETERS` AS table2 ON ( table2.`CHARACTER_MAXIMUM_LENGTH` = table1.`F_GEOMETRY_COLUMN` ) ) WHERE table1.`F_TABLE_CATALOG` >= 'tb' LIMIT 3 /* QNO 1227 CON_ID 17 */ ) /* TRANSFORM_OUTCOME_DISTINCT */ /* QNO 1257 CON_ID 17 */ ", packet_length=615, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1825
|
#26 0x0000562b3540b9f6 in do_command (thd=0x7f7774000b00) at /data/src/10.3/sql/sql_parse.cc:1370
|
#27 0x0000562b355745d7 in do_handle_one_connection (connect=0x562b38483630) at /data/src/10.3/sql/sql_connect.cc:1402
|
#28 0x0000562b35574364 in handle_one_connection (arg=0x562b38483630) at /data/src/10.3/sql/sql_connect.cc:1308
|
#29 0x00007f77edafb494 in start_thread (arg=0x7f77e88c0700) at pthread_create.c:333
|
#30 0x00007f77ebee193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
experimental 6b97ede2ef98c |
perl ./runall-new.pl --duration=350 --threads=2 --seed=1518986252 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/data/bld/10.3 --grammar=conf/runtime/information_schema.yy --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/dev/shm/vardir2
|
Reproducible reasonably well with RQG, but not with MTR so far.