commit 37a316c01d778a62a056d5d20110ef18bb55975e

Author: Dmitry Shulga

Date:   Fri Dec 9 21:10:25 2022 +0700

    MDEV-29988: Major performance regression with 10.6.11

SIGSEGV|Item::fix_fields_if_needed_for_scalar|fix_fields_for_tvc|table_value_constr::prepare|st_select_lex_unit::prepare

SIGSEGV|Item::fix_fields_if_needed|Item::fix_fields_if_needed_for_scalar|fix_fields_for_tvc|table_value_constr::prepare

SIGSEGV|Item::fix_fields_if_needed|Item::fix_fields_if_needed|Item::fix_fields_if_needed_for_scalar|fix_fields_for_tvc

DROP DATABASE test;

CREATE DATABASE test;

USE test;

SET @@max_statement_time=0.00001;

ALTER TABLE ti ENGINE=InnoDB;

SET in_predicate_conversion_threshold=2;

SHOW TABLES;

CREATE TABLE t1 (c1 MEDIUMINT UNSIGNED AUTO_INCREMENT UNIQUE KEY);

SELECT HEX('b') FROM t1 LIMIT 1;

PREPARE p FROM "SELECT object_type,object_schema,object_name,count_star,count_read,count_write,count_read_normal,count_read_with_shared_locks,count_read_high_priority,count_read_no_insert,count_read_external,count_write_LOW_PRIORITY,count_write_external FROM performance_schema.table_lock_waits_summary_by_table WHERE object_type='TABLE' AND object_schema='test' AND object_name IN ('t1','t2','t3') ORDER BY object_type,object_schema,object_name";

SELECT found_rows();

EXECUTE p;

EXECUTE p;

mariadbd: /test/11.2_dbg/sql/sql_tvc.cc:274: bool table_value_constr::prepare(THD*, SELECT_LEX*, select_result*, st_select_lex_unit*): Assertion `thd->stmt_arena->is_stmt_prepare_or_first_stmt_execute() || thd->stmt_arena->is_conventional()' failed.

Core was generated by `/test/MD141024-mariadb-11.2.6-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.

Program terminated with signal SIGABRT, Aborted.

Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 254354)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x000014e49324526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x000014e4932288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x000014e49322881b in __assert_fail_base (fmt=0x14e4933d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x564f88028948 "thd->stmt_arena->is_stmt_prepare_or_first_stmt_execute() || thd->stmt_arena->is_conventional()", file=file@entry=0x564f881a9454 "/test/11.2_dbg/sql/sql_tvc.cc", line=line@entry=274, function=function@entry=0x564f880289a8 "bool table_value_constr::prepare(THD*, SELECT_LEX*, select_result*, st_select_lex_unit*)") at ./assert/assert.c:94

#6  0x000014e49323b507 in __assert_fail (assertion=0x564f88028948 "thd->stmt_arena->is_stmt_prepare_or_first_stmt_execute() || thd->stmt_arena->is_conventional()", file=0x564f881a9454 "/test/11.2_dbg/sql/sql_tvc.cc", line=274, function=0x564f880289a8 "bool table_value_constr::prepare(THD*, SELECT_LEX*, select_result*, st_select_lex_unit*)") at ./assert/assert.c:103

#7  0x0000564f8753646e in table_value_constr::prepare (this=0x14e4340e42c0, thd=<optimized out>, sl=sl@entry=0x14e4340c3d50, tmp_result=tmp_result@entry=0x14e4340148b8, unit_arg=unit_arg@entry=0x14e4340c4208)at /test/11.2_dbg/sql/sql_tvc.cc:274

#8  0x0000564f873dc77d in st_select_lex_unit::prepare (this=this@entry=0x14e4340c4208, derived_arg=derived_arg@entry=0x14e4340e4318, sel_result=0x14e4340147c8, additional_options=additional_options@entry=0)at /test/11.2_dbg/sql/sql_union.cc:1651

#9  0x0000564f8727f91d in mysql_derived_prepare (thd=0x14e434000d58, lex=<optimized out>, derived=0x14e4340e4318)at /test/11.2_dbg/sql/sql_derived.cc:840

#10 0x0000564f8727dd09 in mysql_handle_single_derived (lex=lex@entry=0x14e4340bcb58, derived=derived@entry=0x14e4340e4318, phases=phases@entry=2) at /test/11.2_dbg/sql/sql_derived.cc:200

#11 0x0000564f874084b5 in TABLE_LIST::handle_derived (this=this@entry=0x14e4340e4318, lex=lex@entry=0x14e4340bcb58, phases=phases@entry=2) at /test/11.2_dbg/sql/table.cc:9867

#12 0x0000564f8729e287 in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x14e4340bcb58)at /test/11.2_dbg/sql/sql_lex.h:4649

#13 st_select_lex::handle_derived (this=<optimized out>, lex=0x14e4340bcb58, phases=phases@entry=2) at /test/11.2_dbg/sql/sql_lex.cc:5078

#14 0x0000564f8734a3f1 in JOIN::prepare (this=0x14e4340141c8, tables_init=<optimized out>, conds_init=<optimized out>, og_num=0, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14e4340c2f30, unit_arg=0x14e4340c33e8)at /test/11.2_dbg/sql/sql_select.cc:1465

#15 0x0000564f876ec2e7 in subselect_single_select_engine::prepare (this=0x14e4340e4c70, thd=0x14e434000d58)at /test/11.2_dbg/sql/sql_lex.h:1405

#16 0x0000564f876eb7a1 in Item_subselect::fix_fields (this=this@entry=0x14e4340e4a38, thd_param=thd_param@entry=0x14e434000d58, ref=ref@entry=0x14e490b66c18) at /test/11.2_dbg/sql/item_subselect.cc:298

#17 0x0000564f876ebe18 in Item_in_subselect::fix_fields (this=0x14e4340e4a38, thd_arg=0x14e434000d58, ref=0x14e490b66c18)at /test/11.2_dbg/sql/item_subselect.cc:3624

#18 0x0000564f87537fdd in Item_func_in::in_predicate_to_in_subs_transformer (this=0x14e4340c1588, thd=0x14e434000d58, arg=<optimized out>)at /test/11.2_dbg/sql/sql_tvc.cc:1084

#19 0x0000564f8766f9cb in Item_func::transform (this=0x14e4340c1588, thd=0x14e434000d58, transformer=&virtual table offset 1400, argument=0x0)at /test/11.2_dbg/sql/item_func.cc:533

#20 0x0000564f871a725d in Item::top_level_transform (this=<optimized out>, thd=<optimized out>, transformer=<optimized out>, arg=<optimized out>)at /test/11.2_dbg/sql/item.h:2203

#21 0x0000564f87636df9 in Item_cond::do_transform (this=0x14e4340136c8, thd=0x14e434000d58, transformer=<optimized out>, arg=0x0, toplevel=toplevel@entry=true) at /test/11.2_dbg/sql/item_cmpfunc.cc:5353

#22 0x0000564f8764887d in Item_cond::top_level_transform (this=<optimized out>, thd=<optimized out>, transformer=<optimized out>, arg=<optimized out>) at /test/11.2_dbg/sql/item_cmpfunc.h:3250

#23 0x0000564f87538469 in JOIN::transform_in_predicates_into_in_subq (this=this@entry=0x14e4340138e0, thd=0x14e434000d58)at /test/11.2_dbg/sql/sql_tvc.cc:1193

#24 0x0000564f87361494 in JOIN::optimize_inner (this=this@entry=0x14e4340138e0)at /test/11.2_dbg/sql/sql_select.cc:2220

#25 0x0000564f87362eae in JOIN::optimize (this=this@entry=0x14e4340138e0)at /test/11.2_dbg/sql/sql_select.cc:2003

#26 0x0000564f87362fce in mysql_select (thd=thd@entry=0x14e434000d58, tables=0x14e4340c0248, fields=@0x14e4340bef18: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14e4340bf258, last = 0x14e4340c01a8, elements = 13}, <No data fields>}, conds=0x14e4340136c8, og_num=3, order=0x14e4340c20b8, group=0x0, having=0x0, proc_param=0x0, select_options=2201187781376, result=0x14e4340c2460, unit=0x14e4340bcc38, select_lex=0x14e4340bec60)at /test/11.2_dbg/sql/sql_select.cc:5344

#27 0x0000564f87363858 in handle_select (thd=thd@entry=0x14e434000d58, lex=lex@entry=0x14e4340bcb58, result=result@entry=0x14e4340c2460, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/11.2_dbg/sql/sql_select.cc:642

#28 0x0000564f872c1751 in execute_sqlcom_select (thd=thd@entry=0x14e434000d58, all_tables=0x14e4340c0248) at /test/11.2_dbg/sql/sql_parse.cc:6177

#29 0x0000564f872cd5bc in mysql_execute_command (thd=0x14e434000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=true)at /test/11.2_dbg/sql/sql_parse.cc:3984

#30 0x0000564f872fc3cd in Prepared_statement::execute (this=this@entry=0x14e434047418, expanded_query=expanded_query@entry=0x14e490b67c70, open_cursor=open_cursor@entry=false)at /test/11.2_dbg/sql/sql_prepare.cc:5077

#31 0x0000564f872fc783 in Prepared_statement::execute_loop (this=this@entry=0x14e434047418, expanded_query=expanded_query@entry=0x14e490b67c70, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/11.2_dbg/sql/sql_prepare.cc:4461

#32 0x0000564f872fcc44 in mysql_sql_stmt_execute (thd=thd@entry=0x14e434000d58)at /test/11.2_dbg/sql/sql_prepare.cc:3480

#33 0x0000564f872cd623 in mysql_execute_command (thd=thd@entry=0x14e434000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false)at /test/11.2_dbg/sql/sql_parse.cc:4000

#34 0x0000564f872d42ce in mysql_parse (thd=thd@entry=0x14e434000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14e490b682a0)at /test/11.2_dbg/sql/sql_parse.cc:7938

#35 0x0000564f872d6786 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14e434000d58, packet=packet@entry=0x14e43400b319 "EXECUTE p", packet_length=packet_length@entry=9, blocking=blocking@entry=true)at /test/11.2_dbg/sql/sql_class.h:248

#36 0x0000564f872d89c2 in do_command (thd=0x14e434000d58, blocking=blocking@entry=true) at /test/11.2_dbg/sql/sql_parse.cc:1407

#37 0x0000564f87445fe7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x564f89bf4148, put_in_cache=put_in_cache@entry=true)at /test/11.2_dbg/sql/sql_connect.cc:1439

#38 0x0000564f874462ef in handle_one_connection (arg=arg@entry=0x564f89bf4148)at /test/11.2_dbg/sql/sql_connect.cc:1341

#39 0x0000564f8788df14 in pfs_spawn_thread (arg=0x564f89bc3298)at /test/11.2_dbg/storage/perfschema/pfs.cc:2201

#40 0x000014e49329ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#41 0x000014e493329c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

DROP DATABASE test;

CREATE DATABASE test;

USE test;

CREATE TABLE t2 (b CHAR(1));

CREATE TABLE t (a INT);

CREATE TABLE ti LIKE t;

SET lc_time_names='en_us';

PREPARE stmt FROM 'SELECT * FROM t WHERE EXISTS (SELECT 1 FROM t2 WHERE t2.b=t.a)';

CREATE TABLE t4 (c INT);

INSERT INTO foo VALUES (1);

SET @@max_statement_time=0.00001;

EXECUTE stmt;

EXECUTE stmt;

mariadbd: /test/11.2_dbg/sql/item_subselect.cc:3338: virtual bool Item_exists_subselect::exists2in_processor(void*): Assertion `thd->stmt_arena->is_stmt_prepare_or_first_stmt_execute() || thd->stmt_arena->is_conventional()' failed.

Core was generated by `/test/MD141024-mariadb-11.2.6-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.

Program terminated with signal SIGABRT, Aborted.

Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 2927420)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x000014697c44526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x000014697c4288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x000014697c42881b in __assert_fail_base (fmt=0x14697c5d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x559b0b37f948 "thd->stmt_arena->is_stmt_prepare_or_first_stmt_execute() || thd->stmt_arena->is_conventional()", file=file@entry=0x559b0b3afc38 "/test/11.2_dbg/sql/item_subselect.cc", line=line@entry=3338, function=function@entry=0x559b0b3b0c78 "virtual bool Item_exists_subselect::exists2in_processor(void*)") at ./assert/assert.c:94

#6  0x000014697c43b507 in __assert_fail (assertion=0x559b0b37f948 "thd->stmt_arena->is_stmt_prepare_or_first_stmt_execute() || thd->stmt_arena->is_conventional()", file=0x559b0b3afc38 "/test/11.2_dbg/sql/item_subselect.cc", line=3338, function=0x559b0b3b0c78 "virtual bool Item_exists_subselect::exists2in_processor(void*)") at ./assert/assert.c:103

#7  0x0000559b0aa457e6 in Item_exists_subselect::exists2in_processor (this=0x14691c0c4de0, opt_arg=0x14691c000d58)at /test/11.2_dbg/sql/item_subselect.cc:3338

#8  0x0000559b0aa3cf28 in Item_subselect::walk (this=0x14691c0c4de0, processor=<optimized out>, walk_subquery=false, argument=0x14691c000d58)at /test/11.2_dbg/sql/item_subselect.cc:782

#9  0x0000559b0a979224 in Item_in_optimizer::walk (this=0x14691c0c5ba8, processor=&virtual table offset 1048, walk_subquery=false, arg=0x14691c000d58) at /test/11.2_dbg/sql/item_cmpfunc.cc:1503

#10 0x0000559b0a6b84e6 in JOIN::optimize_inner (this=this@entry=0x14691c0137e0)at /test/11.2_dbg/sql/sql_select.cc:2237

#11 0x0000559b0a6b9eae in JOIN::optimize (this=this@entry=0x14691c0137e0)at /test/11.2_dbg/sql/sql_select.cc:2003

#12 0x0000559b0a6b9fce in mysql_select (thd=thd@entry=0x14691c000d58, tables=0x14691c0c2d28, fields=@0x14691c0c29a8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14691c0c2cd8, last = 0x14691c0c2cd8, elements = 1}, <No data fields>}, conds=0x14691c0c5ba8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201187781376, result=0x14691c0c5820, unit=0x14691c0c09a8, select_lex=0x14691c0c26f0)at /test/11.2_dbg/sql/sql_select.cc:5344

#13 0x0000559b0a6ba858 in handle_select (thd=thd@entry=0x14691c000d58, lex=lex@entry=0x14691c0c08c8, result=result@entry=0x14691c0c5820, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/11.2_dbg/sql/sql_select.cc:642

#14 0x0000559b0a618751 in execute_sqlcom_select (thd=thd@entry=0x14691c000d58, all_tables=0x14691c0c2d28) at /test/11.2_dbg/sql/sql_parse.cc:6177

#15 0x0000559b0a6245bc in mysql_execute_command (thd=0x14691c000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=true)at /test/11.2_dbg/sql/sql_parse.cc:3984

#16 0x0000559b0a6533cd in Prepared_statement::execute (this=this@entry=0x14691c02b798, expanded_query=expanded_query@entry=0x146979db2c70, open_cursor=open_cursor@entry=false)at /test/11.2_dbg/sql/sql_prepare.cc:5077

#17 0x0000559b0a653783 in Prepared_statement::execute_loop (this=this@entry=0x14691c02b798, expanded_query=expanded_query@entry=0x146979db2c70, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/11.2_dbg/sql/sql_prepare.cc:4461

#18 0x0000559b0a653c44 in mysql_sql_stmt_execute (thd=thd@entry=0x14691c000d58)at /test/11.2_dbg/sql/sql_prepare.cc:3480

#19 0x0000559b0a624623 in mysql_execute_command (thd=thd@entry=0x14691c000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false)at /test/11.2_dbg/sql/sql_parse.cc:4000

#20 0x0000559b0a62b2ce in mysql_parse (thd=thd@entry=0x14691c000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x146979db32a0)at /test/11.2_dbg/sql/sql_parse.cc:7938

#21 0x0000559b0a62d786 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14691c000d58, packet=packet@entry=0x14691c00b319 "EXECUTE stmt", packet_length=packet_length@entry=12, blocking=blocking@entry=true)at /test/11.2_dbg/sql/sql_class.h:248

#22 0x0000559b0a62f9c2 in do_command (thd=0x14691c000d58, blocking=blocking@entry=true) at /test/11.2_dbg/sql/sql_parse.cc:1407

#23 0x0000559b0a79cfe7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x559b0e2b82d8, put_in_cache=put_in_cache@entry=true)at /test/11.2_dbg/sql/sql_connect.cc:1439

#24 0x0000559b0a79d2ef in handle_one_connection (arg=arg@entry=0x559b0e2b82d8)at /test/11.2_dbg/sql/sql_connect.cc:1341

#25 0x0000559b0abe4f14 in pfs_spawn_thread (arg=0x559b0e287428)at /test/11.2_dbg/storage/perfschema/pfs.cc:2201

#26 0x000014697c49ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#27 0x000014697c529c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78