[MDEV-26944] Server crash on selecting some data from information_schema - Jira

Details

Type: Bug
Status: In Review (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.6.4, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.4, 11.8
Fix Version/s: 10.5, 10.6, 10.11, 11.4, 11.8
Component/s: Prepared Statements
Labels:
- crash
Environment:
Linux Ubuntu 20.04.3 LTS, 5.4.0-88-generic
MariaDB 10.6.4

Description

I have two queries that return some data from information_schema about table structures and foreign keys (sql.txt).
But once per 5-6 executions mariadb-server crashed and goes to restart.
Same logs are appear in journalctl (log.txt).
Executing CALL `forms_data_columns`('', 'U') cause crash each even times.

Reproduce

create table t1 (i int);

prepare stmt from " SELECT x FROM

 ( SELECT i AS y, (SELECT y FROM t1 LIMIT 1 ) AS x FROM  t1 a) dt;";

execute stmt;

execute stmt;

Result

#12 0x00007ef53d039206 in __assert_fail (assertion=0x56c024ff175b "(*select_ref)->is_fixed()", file=0x56c024f1cdec "../src/sql/item.cc", line=5681, function=0x56c024f2bba2 "Item **resolve_ref_in_select_and_group(THD *, Item_ident *, SELECT_LEX *)") at ./assert/assert.c:101

#13 0x000056c0256558bc in resolve_ref_in_select_and_group (thd=0x7ef51c000d58, ref=0x7ef51c11a0d0, select=0x7ef51c1195c0) at ../src/sql/item.cc:5681

#14 0x000056c025654acd in Item_field::fix_outer_field (this=0x7ef51c11a0d0, thd=0x7ef51c000d58, from_field=0x7ef5382bbbd8, reference=0x7ef51c11a218) at ../src/sql/item.cc:5959

#15 0x000056c025655ea6 in Item_field::fix_fields (this=0x7ef51c11a0d0, thd=0x7ef51c000d58, reference=0x7ef51c11a218) at ../src/sql/item.cc:6248

#16 0x000056c02562e5c1 in Item::fix_fields_if_needed (this=0x7ef51c11a0d0, thd=0x7ef51c000d58, ref=0x7ef51c11a218) at ../src/sql/item.h:1005

#17 0x000056c025631ba9 in Item::fix_fields_if_needed_for_scalar (this=0x7ef51c11a0d0, thd=0x7ef51c000d58, ref=0x7ef51c11a218) at ../src/sql/item.h:1009

#18 0x000056c0258789fe in setup_fields (thd=0x7ef51c000d58, ref_pointer_array=..., fields=..., column_usage=MARK_COLUMNS_READ, sum_func_list=0x7ef51c014750, pre_fix=0x7ef51c119d78, allow_sum_func=true) at ../src/sql/sql_base.cc:7693

#19 0x000056c025a1f78b in JOIN::prepare (this=0x7ef51c014418, tables_init=0x7ef51c11a258, 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=0x7ef51c119bf8, unit_arg=0x7ef51c11a980) at ../src/sql/sql_select.cc:1375

#20 0x000056c02590698b in subselect_single_select_engine::prepare (this=0x7ef51c11b430, thd=0x7ef51c000d58) at ../src/sql/item_subselect.cc:3883

#21 0x000056c0258f63fd in Item_subselect::fix_fields (this=0x7ef51c11b288, thd_param=0x7ef51c000d58, ref=0x7ef51c11cda8) at ../src/sql/item_subselect.cc:293

#22 0x000056c025b2e003 in create_view_field (thd=0x7ef51c000d58, view=0x7ef51c11c478, field_ref=0x7ef51c11cda8, name=0x7ef51c11cdb0) at ../src/sql/table.cc:6937

#23 0x000056c025b2e9fd in Field_iterator_view::create_item (this=0x7ef5382bc5a0, thd=0x7ef51c000d58) at ../src/sql/table.cc:6912

#24 0x000056c02587529a in find_field_in_view (thd=0x7ef51c000d58, table_list=0x7ef51c11c478, name=0x7ef51c119468 "x", length=1, item_name=0x7ef51c119468 "x", ref=0x7ef51c1195b8, register_tree_change=true) at ../src/sql/sql_base.cc:5816

#25 0x000056c025874b01 in find_field_in_table_ref (thd=0x7ef51c000d58, table_list=0x7ef51c11c478, name=0x7ef51c119468 "x", length=1, item_name=0x7ef51c119468 "x", db_name=0x0, table_name=0x0, ref=0x7ef51c1195b8, check_privileges=true, allow_rowid=true, cached_field_index_ptr=0x7ef51c11956c, register_tree_change=true, actual_table=0x7ef5382bcbc0) at ../src/sql/sql_base.cc:6156

#26 0x000056c0258761bf in find_field_in_tables (thd=0x7ef51c000d58, item=0x7ef51c119470, first_table=0x7ef51c11c478, last_table=0x0, ref=0x7ef51c1195b8, report_error=IGNORE_EXCEPT_NON_UNIQUE, check_privileges=true, register_tree_change=true) at ../src/sql/sql_base.cc:6392

#27 0x000056c025655b40 in Item_field::fix_fields (this=0x7ef51c119470, thd=0x7ef51c000d58, reference=0x7ef51c1195b8) at ../src/sql/item.cc:6157

#28 0x000056c02562e5c1 in Item::fix_fields_if_needed (this=0x7ef51c119470, thd=0x7ef51c000d58, ref=0x7ef51c1195b8) at ../src/sql/item.h:1005

#29 0x000056c025631ba9 in Item::fix_fields_if_needed_for_scalar (this=0x7ef51c119470, thd=0x7ef51c000d58, ref=0x7ef51c1195b8) at ../src/sql/item.h:1009

#30 0x000056c0258789fe in setup_fields (thd=0x7ef51c000d58, ref_pointer_array=..., fields=..., column_usage=MARK_COLUMNS_READ, sum_func_list=0x7ef51c014038, pre_fix=0x7ef51c119118, allow_sum_func=true) at ../src/sql/sql_base.cc:7693

#31 0x000056c025a1f78b in JOIN::prepare (this=0x7ef51c013d00, tables_init=0x7ef51c11c478, 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=0x7ef51c118f98, unit_arg=0x7ef51c117350) at ../src/sql/sql_select.cc:1375

#32 0x000056c025a1b67d in mysql_select (thd=0x7ef51c000d58, tables=0x7ef51c11c478, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x7ef51c11cba8, unit=0x7ef51c117350, select_lex=0x7ef51c118f98) at ../src/sql/sql_select.cc:4897

#33 0x000056c025a1b073 in handle_select (thd=0x7ef51c000d58, lex=0x7ef51c117288, result=0x7ef51c11cba8, setup_tables_done_option=0) at ../src/sql/sql_select.cc:449

#34 0x000056c0259c2ed0 in execute_sqlcom_select (thd=0x7ef51c000d58, all_tables=0x7ef51c11c478) at ../src/sql/sql_parse.cc:6452

#35 0x000056c0259ba144 in mysql_execute_command (thd=0x7ef51c000d58) at ../src/sql/sql_parse.cc:4043

#36 0x000056c0259ff068 in Prepared_statement::execute (this=0x7ef51c1e23e8, expanded_query=0x7ef5382bf2f0, open_cursor=false) at ../src/sql/sql_prepare.cc:5138

#37 0x000056c0259fb07c in Prepared_statement::execute_loop (this=0x7ef51c1e23e8, expanded_query=0x7ef5382bf2f0, open_cursor=false, packet=0x0, packet_end=0x0) at ../src/sql/sql_prepare.cc:4560

#38 0x000056c0259fac86 in mysql_sql_stmt_execute (thd=0x7ef51c000d58) at ../src/sql/sql_prepare.cc:3607

#39 0x000056c0259ba188 in mysql_execute_command (thd=0x7ef51c000d58) at ../src/sql/sql_parse.cc:4059

#40 0x000056c0259b3e94 in mysql_parse (thd=0x7ef51c000d58, rawbuf=0x7ef51c013ae0 "execute stmt", length=12, parser_state=0x7ef5382c1438, is_com_multi=false, is_next_command=false) at ../src/sql/sql_parse.cc:8252

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

log.txt
2021-10-30 17:23
19 kB
Andrey Timofeev
sql.txt
2021-10-30 17:31
3 kB
Andrey Timofeev

Issue Links

is caused by

MDEV-14957 JOIN::prepare gets unusable "conds" as argument

Closed

is duplicated by

MDEV-31175 Server crash on 2n execution of select with view and aggregate function

Confirmed

relates to

MDEV-8789 Implement non-recursive common table expressions

Closed

MDEV-14786 Server crashes in Item_cond::transform on 2nd execution of SP querying from a view

Closed

MDEV-22713 Assertion `(*select_ref)->is_fixed()' failed in resolve_ref_in_select_and_group

Confirmed

MDEV-28917 SIGSEGV in resolve_ref_in_select_and_group and Assertion `n < m_size' failed in Bounds_checked_array on INSERT

Confirmed

(1 relates to)

Activity

Ascending order - Click to sort in descending order

Alice Sherepa added a comment - 2021-11-02 09:26 - edited

Thank you!
I repeated as described on 10.2-10.6

10.2 d0b611a76d91a5b6dbbc8
Version: '10.2.41-MariaDB-debug-log'
mysqld: /10.2/src/sql/item.cc:5006: Item** resolve_ref_in_select_and_group(THD, Item_ident, SELECT_LEX): Assertion `(select_ref)->fixed' failed.
211102 9:41:03 [ERROR] mysqld got signal 6 ;

Server version: 10.2.41-MariaDB-debug-log

sql/item.cc:5007(resolve_ref_in_select_and_group(THD, Item_ident, st_select_lex*))[0x55c812de2e07]
sql/item.cc:5286(Item_field::fix_outer_field(THD, Field, Item*))[0x55c812de372c]
sql/item.cc:5579(Item_field::fix_fields(THD, Item*))[0x55c812de4427]
sql/item_func.cc:201(Item_func::fix_fields(THD, Item*))[0x55c812e3a2d9]
sql/item_strfunc.cc:106(Item_str_func::fix_fields(THD, Item*))[0x55c812e6caf1]
sql/sql_base.cc:7276(setup_fields(THD, Bounds_checked_array<Item>, List<Item>&, enum_mark_columns, List<Item>, List<Item>, bool))[0x55c812ad1665]
sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST, unsigned int, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit))[0x55c812b7a8e5]
sql/item_subselect.cc:3781(subselect_single_select_engine::prepare(THD*))[0x55c812e940bb]
sql/item_subselect.cc:269(Item_subselect::fix_fields(THD, Item*))[0x55c812e88213]
sql/table.cc:5985(create_view_field(THD, TABLE_LIST, Item*, char const))[0x55c812c4f0fd]
sql/table.cc:5961(Field_iterator_view::create_item(THD*))[0x55c812c4efe1]
sql/sql_base.cc:5396(find_field_in_view(THD, TABLE_LIST, char const, unsigned int, char const, Item**, bool))[0x55c812accbeb]
sql/sql_base.cc:5756(find_field_in_table_ref(THD, TABLE_LIST, char const, unsigned int, char const, char const, char const, Item*, bool, bool, unsigned int, bool, TABLE_LIST**))[0x55c812acdb75]
sql/sql_base.cc:5989(find_field_in_tables(THD, Item_ident, TABLE_LIST, TABLE_LIST, Item**, find_item_error_report_type, bool, bool))[0x55c812ace437]
sql/item.cc:5488(Item_field::fix_fields(THD, Item*))[0x55c812de40d0]
sql/item_func.cc:201(Item_func::fix_fields(THD, Item*))[0x55c812e3a2d9]
sql/item_func.cc:201(Item_func::fix_fields(THD, Item*))[0x55c812e3a2d9]
sql/item_cmpfunc.cc:2453(Item_func_if::fix_fields(THD, Item*))[0x55c812e06403]
sql/item_func.cc:201(Item_func::fix_fields(THD, Item*))[0x55c812e3a2d9]
sql/item_strfunc.cc:106(Item_str_func::fix_fields(THD, Item*))[0x55c812e6caf1]
sql/item_sum.cc:3612(Item_func_group_concat::fix_fields(THD, Item*))[0x55c812ea887b]
sql/item_func.cc:201(Item_func::fix_fields(THD, Item*))[0x55c812e3a2d9]
sql/item_strfunc.cc:106(Item_str_func::fix_fields(THD, Item*))[0x55c812e6caf1]
sql/sql_base.cc:7276(setup_fields(THD, Bounds_checked_array<Item>, List<Item>&, enum_mark_columns, List<Item>, List<Item>, bool))[0x55c812ad1665]
sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST, unsigned int, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit))[0x55c812b7a8e5]
sql/sql_select.cc:3827(mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x55c812b85396]
sql/sql_select.cc:361(handle_select(THD, LEX, select_result*, unsigned long))[0x55c812b7959c]
sql/sql_parse.cc:6271(execute_sqlcom_select(THD, TABLE_LIST))[0x55c812b43bfc]
sql/sql_parse.cc:3582(mysql_execute_command(THD*))[0x55c812b3a770]
sql/sp_head.cc:3331(sp_instr_stmt::exec_core(THD, unsigned int))[0x55c812a8b700]
sql/sp_head.cc:3094(sp_lex_keeper::reset_lex_and_exec_core(THD, unsigned int, bool, sp_instr*))[0x55c812a8ad61]
sql/sp_head.cc:3247(sp_instr_stmt::execute(THD, unsigned int))[0x55c812a8b3a5]
sql/sp_head.cc:1326(sp_head::execute(THD*, bool))[0x55c812a863a7]
sql/sp_head.cc:2202(sp_head::execute_procedure(THD, List<Item>))[0x55c812a885c5]
sql/sql_parse.cc:2981(do_execute_sp(THD, sp_head))[0x55c812b38b4a]
sql/sql_parse.cc:5622(mysql_execute_command(THD*))[0x55c812b414f5]
sql/sql_parse.cc:7793(mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool))[0x55c812b479b8]
sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x55c812b35c13]
sql/sql_parse.cc:1381(do_command(THD*))[0x55c812b3470e]
sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x55c812c905a3]
sql/sql_connect.cc:1242(handle_one_connection)[0x55c812c90308]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55c8134ba348]
nptl/pthread_create.c:478(start_thread)[0x7fe381391609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fe380f6c293]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fe3280aa440): SELECT CONCAT(
'select ',
GROUP_CONCAT(CONCAT('pri.', dataName, ' as ', dataItemName, if(dataReferenceQuery IS NOT NULL, CONCAT(', ', dataReferenceQuery), '')) SEPARATOR ', '),
' FROM ', dataTable, ' as pri WHERE ', GROUP_CONCAT(concat(if(REGEXP_SUBSTR(dataActions, '.K.') != '', CONCAT('pri.', dataName), null)), ' = ?' SEPARATOR ' and ')
) AS `query` FROM (
SELECT a.TABLE_NAME AS dataTable, a.COLUMN_NAME AS dataName, a.DATA_TYPE AS dataType, a.COLUMN_COMMENT AS dataMetaInfo, REGEXP_SUBSTR(a.COLUMN_COMMENT, '(?<=\:)[A-z]*') dataItemName,
a.COLUMN_KEY AS dataKeyType, REGEXP_SUBSTR(a.COLUMN_COMMENT, '.{1,5}(?=\:)') dataActions,
nullif(REGEXP_SUBSTR(a.COLUMN_COMMENT, '(?<=R\:\")[A-z]*(?=\")'), '') dataReferenceColumn,
(
SELECT CONCAT('(select ', dataReferenceColumn, ' from ', REGEXP_SUBSTR(f.REF_NAME, '(?<=\/)[A-z]*'), ' as sec where sec.', g.REF_COL_NAME, ' = pri.', dataName, ') as ', dataItemName, '_text')
FROM information_schema.INNODB_SYS_FOREIGN f JOIN information_schema.INNODB_SYS_FOREIGN_COLS g ON f.ID = g.ID
WHERE f.N_COLS = 1 AND f.FOR_NAME = CONCAT(DATABASE(), '/', dataTable) AND g.FOR_COL_NAME = dataName LIMIT 1
) AS dataReferenceQuery
FROM information_schema.`COLUMNS` a
WHERE table_schema = DATABASE() AND TABLE_NAME = (SELECT b.table_name FROM information_schema.`TABLES` b WHERE b.TABLE_COMMENT REGEXP CONCAT('N:', NAME_CONST('_name',_latin1'' COLLATE 'latin1_swedish_ci'), '\,.*'))
AND COLUMN_COMMENT REGEXP CONCAT('^.[', NAME_CONST('_action',_latin1'U' COLLATE 'latin1_swedish_ci'), '].\:.*')) lateral
GROUP BY dataTable

CREATE PROCEDURE sp()

SELECT x

FROM

 (SELECT a.column_name AS y,

        (SELECT y FROM information_schema.innodb_sys_foreign LIMIT 1) AS x

  FROM information_schema.columns a) dt ;

CALL sp();

CALL sp();

10.2 d0b611a76d91a5b6dbbc8
Version: '10.2.41-MariaDB-debug-log'
mysqld: /10.2/src/sql/item.cc:5006: Item** resolve_ref_in_select_and_group(THD, Item_ident, SELECT_LEX): Assertion `(select_ref)->fixed' failed.
211102 10:21:52 [ERROR] mysqld got signal 6 ;

Server version: 10.2.41-MariaDB-debug-log

sql/item.cc:5007(resolve_ref_in_select_and_group(THD, Item_ident, st_select_lex*))[0x56356d870e07]
sql/item.cc:5286(Item_field::fix_outer_field(THD, Field, Item*))[0x56356d87172c]
sql/item.cc:5579(Item_field::fix_fields(THD, Item*))[0x56356d872427]
sql/sql_base.cc:7276(setup_fields(THD, Bounds_checked_array<Item>, List<Item>&, enum_mark_columns, List<Item>, List<Item>, bool))[0x56356d55f665]
sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST, unsigned int, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit))[0x56356d6088e5]
sql/item_subselect.cc:3781(subselect_single_select_engine::prepare(THD*))[0x56356d9220bb]
sql/item_subselect.cc:269(Item_subselect::fix_fields(THD, Item*))[0x56356d916213]
sql/table.cc:5985(create_view_field(THD, TABLE_LIST, Item*, char const))[0x56356d6dd0fd]
sql/table.cc:5961(Field_iterator_view::create_item(THD*))[0x56356d6dcfe1]
sql/sql_base.cc:5396(find_field_in_view(THD, TABLE_LIST, char const, unsigned int, char const, Item**, bool))[0x56356d55abeb]
sql/sql_base.cc:5756(find_field_in_table_ref(THD, TABLE_LIST, char const, unsigned int, char const, char const, char const, Item*, bool, bool, unsigned int, bool, TABLE_LIST**))[0x56356d55bb75]
sql/sql_base.cc:5989(find_field_in_tables(THD, Item_ident, TABLE_LIST, TABLE_LIST, Item**, find_item_error_report_type, bool, bool))[0x56356d55c437]
sql/item.cc:5488(Item_field::fix_fields(THD, Item*))[0x56356d8720d0]
sql/sql_base.cc:7276(setup_fields(THD, Bounds_checked_array<Item>, List<Item>&, enum_mark_columns, List<Item>, List<Item>, bool))[0x56356d55f665]
sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST, unsigned int, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit))[0x56356d6088e5]
sql/sql_select.cc:3827(mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x56356d613396]
sql/sql_select.cc:361(handle_select(THD, LEX, select_result*, unsigned long))[0x56356d60759c]
sql/sql_parse.cc:6271(execute_sqlcom_select(THD, TABLE_LIST))[0x56356d5d1bfc]
sql/sql_parse.cc:3582(mysql_execute_command(THD*))[0x56356d5c8770]
sql/sp_head.cc:3331(sp_instr_stmt::exec_core(THD, unsigned int))[0x56356d519700]
sql/sp_head.cc:3094(sp_lex_keeper::reset_lex_and_exec_core(THD, unsigned int, bool, sp_instr*))[0x56356d518d61]
sql/sp_head.cc:3247(sp_instr_stmt::execute(THD, unsigned int))[0x56356d5193a5]
sql/sp_head.cc:1326(sp_head::execute(THD*, bool))[0x56356d5143a7]
sql/sp_head.cc:2202(sp_head::execute_procedure(THD, List<Item>))[0x56356d5165c5]
sql/sql_parse.cc:2981(do_execute_sp(THD, sp_head))[0x56356d5c6b4a]
sql/sql_parse.cc:5622(mysql_execute_command(THD*))[0x56356d5cf4f5]
sql/sql_parse.cc:7793(mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool))[0x56356d5d59b8]
sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x56356d5c3c13]
sql/sql_parse.cc:1381(do_command(THD*))[0x56356d5c270e]
sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x56356d71e5a3]
sql/sql_connect.cc:1242(handle_one_connection)[0x56356d71e308]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x56356df48348]
nptl/pthread_create.c:478(start_thread)[0x7f5e3c0c7609]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f5e3bca2293]

Query (0x7f5de818f138): SELECT x
FROM
(SELECT a.column_name AS y,
(SELECT y FROM information_schema.innodb_sys_foreign LIMIT 1) AS x
FROM information_schema.columns a) dt

Also repeatable with prepared statements and without information_schema:

create table t1 (i int);

prepare stmt from " SELECT x FROM

 ( SELECT i AS y, (SELECT y FROM t1 LIMIT 1 ) AS x FROM  t1 a) dt;";

execute stmt;

execute stmt;

Version: '10.2.41-MariaDB-debug-log'

mysqld: /10.2/src/sql/item.cc:5006: Item** resolve_ref_in_select_and_group(THD*, Item_ident*, SELECT_LEX*): Assertion `(*select_ref)->fixed' failed.

211102 10:32:54 [ERROR] mysqld got signal 6 ;

Server version: 10.2.41-MariaDB-debug-log

sql/item.cc:5007(resolve_ref_in_select_and_group(THD*, Item_ident*, st_select_lex*))[0x557ac7a16e07]

sql/item.cc:5286(Item_field::fix_outer_field(THD*, Field**, Item**))[0x557ac7a1772c]

sql/item.cc:5579(Item_field::fix_fields(THD*, Item**))[0x557ac7a18427]

sql/sql_base.cc:7276(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_mark_columns, List<Item>*, List<Item>*, bool))[0x557ac7705665]

sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x557ac77ae8e5]

sql/item_subselect.cc:3781(subselect_single_select_engine::prepare(THD*))[0x557ac7ac80bb]

sql/item_subselect.cc:269(Item_subselect::fix_fields(THD*, Item**))[0x557ac7abc213]

sql/table.cc:5985(create_view_field(THD*, TABLE_LIST*, Item**, char const*))[0x557ac78830fd]

sql/table.cc:5961(Field_iterator_view::create_item(THD*))[0x557ac7882fe1]

sql/sql_base.cc:5396(find_field_in_view(THD*, TABLE_LIST*, char const*, unsigned int, char const*, Item**, bool))[0x557ac7700beb]

sql/sql_base.cc:5756(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned int, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**))[0x557ac7701b75]

sql/sql_base.cc:5989(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x557ac7702437]

sql/item.cc:5488(Item_field::fix_fields(THD*, Item**))[0x557ac7a180d0]

sql/sql_base.cc:7276(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_mark_columns, List<Item>*, List<Item>*, bool))[0x557ac7705665]

sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x557ac77ae8e5]

sql/sql_select.cc:3827(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x557ac77b9396]

sql/sql_select.cc:361(handle_select(THD*, LEX*, select_result*, unsigned long))[0x557ac77ad59c]

sql/sql_parse.cc:6271(execute_sqlcom_select(THD*, TABLE_LIST*))[0x557ac7777bfc]

sql/sql_parse.cc:3582(mysql_execute_command(THD*))[0x557ac776e770]

sql/sql_prepare.cc:5057(Prepared_statement::execute(String*, bool))[0x557ac7799f8b]

sql/sql_prepare.cc:4486(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x557ac7798494]

sql/sql_prepare.cc:3577(mysql_sql_stmt_execute(THD*))[0x557ac7796181]

sql/sql_parse.cc:3599(mysql_execute_command(THD*))[0x557ac776e7b5]

sql/sql_parse.cc:7793(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x557ac777b9b8]

sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x557ac7769c13]

sql/sql_parse.cc:1381(do_command(THD*))[0x557ac776870e]

sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x557ac78c45a3]

sql/sql_connect.cc:1242(handle_one_connection)[0x557ac78c4308]

perfschema/pfs.cc:1871(pfs_spawn_thread)[0x557ac80ee348]

nptl/pthread_create.c:478(start_thread)[0x7f75a50e8609]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f75a4cc3293]

Query (0x7f7548012798): SELECT x FROM

 ( SELECT i AS y, (SELECT y FROM t1 LIMIT 1 ) AS x FROM  t1 a) dt

Alice Sherepa added a comment - 2021-11-02 09:26 - edited Thank you! I repeated as described on 10.2-10.6 10.2 d0b611a76d91a5b6dbbc8 Version: '10.2.41-MariaDB-debug-log' mysqld: /10.2/src/sql/item.cc:5006: Item** resolve_ref_in_select_and_group(THD*, Item_ident*, SELECT_LEX*): Assertion `(*select_ref)->fixed' failed. 211102 9:41:03 [ERROR] mysqld got signal 6 ; Server version: 10.2.41-MariaDB-debug-log sql/item.cc:5007(resolve_ref_in_select_and_group(THD*, Item_ident*, st_select_lex*))[0x55c812de2e07] sql/item.cc:5286(Item_field::fix_outer_field(THD*, Field**, Item**))[0x55c812de372c] sql/item.cc:5579(Item_field::fix_fields(THD*, Item**))[0x55c812de4427] sql/item_func.cc:201(Item_func::fix_fields(THD*, Item**))[0x55c812e3a2d9] sql/item_strfunc.cc:106(Item_str_func::fix_fields(THD*, Item**))[0x55c812e6caf1] sql/sql_base.cc:7276(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_mark_columns, List<Item>*, List<Item>*, bool))[0x55c812ad1665] sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55c812b7a8e5] sql/item_subselect.cc:3781(subselect_single_select_engine::prepare(THD*))[0x55c812e940bb] sql/item_subselect.cc:269(Item_subselect::fix_fields(THD*, Item**))[0x55c812e88213] sql/table.cc:5985(create_view_field(THD*, TABLE_LIST*, Item**, char const*))[0x55c812c4f0fd] sql/table.cc:5961(Field_iterator_view::create_item(THD*))[0x55c812c4efe1] sql/sql_base.cc:5396(find_field_in_view(THD*, TABLE_LIST*, char const*, unsigned int, char const*, Item**, bool))[0x55c812accbeb] sql/sql_base.cc:5756(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned int, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**))[0x55c812acdb75] sql/sql_base.cc:5989(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x55c812ace437] sql/item.cc:5488(Item_field::fix_fields(THD*, Item**))[0x55c812de40d0] sql/item_func.cc:201(Item_func::fix_fields(THD*, Item**))[0x55c812e3a2d9] sql/item_func.cc:201(Item_func::fix_fields(THD*, Item**))[0x55c812e3a2d9] sql/item_cmpfunc.cc:2453(Item_func_if::fix_fields(THD*, Item**))[0x55c812e06403] sql/item_func.cc:201(Item_func::fix_fields(THD*, Item**))[0x55c812e3a2d9] sql/item_strfunc.cc:106(Item_str_func::fix_fields(THD*, Item**))[0x55c812e6caf1] sql/item_sum.cc:3612(Item_func_group_concat::fix_fields(THD*, Item**))[0x55c812ea887b] sql/item_func.cc:201(Item_func::fix_fields(THD*, Item**))[0x55c812e3a2d9] sql/item_strfunc.cc:106(Item_str_func::fix_fields(THD*, Item**))[0x55c812e6caf1] sql/sql_base.cc:7276(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_mark_columns, List<Item>*, List<Item>*, bool))[0x55c812ad1665] sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55c812b7a8e5] sql/sql_select.cc:3827(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55c812b85396] sql/sql_select.cc:361(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55c812b7959c] sql/sql_parse.cc:6271(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55c812b43bfc] sql/sql_parse.cc:3582(mysql_execute_command(THD*))[0x55c812b3a770] sql/sp_head.cc:3331(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55c812a8b700] sql/sp_head.cc:3094(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55c812a8ad61] sql/sp_head.cc:3247(sp_instr_stmt::execute(THD*, unsigned int*))[0x55c812a8b3a5] sql/sp_head.cc:1326(sp_head::execute(THD*, bool))[0x55c812a863a7] sql/sp_head.cc:2202(sp_head::execute_procedure(THD*, List<Item>*))[0x55c812a885c5] sql/sql_parse.cc:2981(do_execute_sp(THD*, sp_head*))[0x55c812b38b4a] sql/sql_parse.cc:5622(mysql_execute_command(THD*))[0x55c812b414f5] sql/sql_parse.cc:7793(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c812b479b8] sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c812b35c13] sql/sql_parse.cc:1381(do_command(THD*))[0x55c812b3470e] sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x55c812c905a3] sql/sql_connect.cc:1242(handle_one_connection)[0x55c812c90308] perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55c8134ba348] nptl/pthread_create.c:478(start_thread)[0x7fe381391609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fe380f6c293] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fe3280aa440): SELECT CONCAT( 'select ', GROUP_CONCAT(CONCAT('pri.', dataName, ' as ', dataItemName, if(dataReferenceQuery IS NOT NULL, CONCAT(', ', dataReferenceQuery), '')) SEPARATOR ', '), ' FROM ', dataTable, ' as pri WHERE ', GROUP_CONCAT(concat(if(REGEXP_SUBSTR(dataActions, '.*K.*') != '', CONCAT('pri.', dataName), null)), ' = ?' SEPARATOR ' and ') ) AS `query` FROM ( SELECT a.TABLE_NAME AS dataTable, a.COLUMN_NAME AS dataName, a.DATA_TYPE AS dataType, a.COLUMN_COMMENT AS dataMetaInfo, REGEXP_SUBSTR(a.COLUMN_COMMENT, '(?<=\:)[A-z]*') dataItemName, a.COLUMN_KEY AS dataKeyType, REGEXP_SUBSTR(a.COLUMN_COMMENT, '.{1,5}(?=\:)') dataActions, nullif(REGEXP_SUBSTR(a.COLUMN_COMMENT, '(?<=R\:\")[A-z]*(?=\")'), '') dataReferenceColumn, ( SELECT CONCAT('(select ', dataReferenceColumn, ' from ', REGEXP_SUBSTR(f.REF_NAME, '(?<=\/)[A-z]*'), ' as sec where sec.', g.REF_COL_NAME, ' = pri.', dataName, ') as ', dataItemName, '_text') FROM information_schema.INNODB_SYS_FOREIGN f JOIN information_schema.INNODB_SYS_FOREIGN_COLS g ON f.ID = g.ID WHERE f.N_COLS = 1 AND f.FOR_NAME = CONCAT(DATABASE(), '/', dataTable) AND g.FOR_COL_NAME = dataName LIMIT 1 ) AS dataReferenceQuery FROM information_schema.`COLUMNS` a WHERE table_schema = DATABASE() AND TABLE_NAME = (SELECT b.table_name FROM information_schema.`TABLES` b WHERE b.TABLE_COMMENT REGEXP CONCAT('N:', NAME_CONST('_name',_latin1'' COLLATE 'latin1_swedish_ci'), '\,.*')) AND COLUMN_COMMENT REGEXP CONCAT('^.*[', NAME_CONST('_action',_latin1'U' COLLATE 'latin1_swedish_ci'), '].*\:.*')) lateral GROUP BY dataTable CREATE PROCEDURE sp() SELECT x FROM ( SELECT a.column_name AS y, ( SELECT y FROM information_schema.innodb_sys_foreign LIMIT 1) AS x FROM information_schema.columns a) dt ; CALL sp(); CALL sp(); 10.2 d0b611a76d91a5b6dbbc8 Version: '10.2.41-MariaDB-debug-log' mysqld: /10.2/src/sql/item.cc:5006: Item** resolve_ref_in_select_and_group(THD*, Item_ident*, SELECT_LEX*): Assertion `(*select_ref)->fixed' failed. 211102 10:21:52 [ERROR] mysqld got signal 6 ; Server version: 10.2.41-MariaDB-debug-log sql/item.cc:5007(resolve_ref_in_select_and_group(THD*, Item_ident*, st_select_lex*))[0x56356d870e07] sql/item.cc:5286(Item_field::fix_outer_field(THD*, Field**, Item**))[0x56356d87172c] sql/item.cc:5579(Item_field::fix_fields(THD*, Item**))[0x56356d872427] sql/sql_base.cc:7276(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_mark_columns, List<Item>*, List<Item>*, bool))[0x56356d55f665] sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x56356d6088e5] sql/item_subselect.cc:3781(subselect_single_select_engine::prepare(THD*))[0x56356d9220bb] sql/item_subselect.cc:269(Item_subselect::fix_fields(THD*, Item**))[0x56356d916213] sql/table.cc:5985(create_view_field(THD*, TABLE_LIST*, Item**, char const*))[0x56356d6dd0fd] sql/table.cc:5961(Field_iterator_view::create_item(THD*))[0x56356d6dcfe1] sql/sql_base.cc:5396(find_field_in_view(THD*, TABLE_LIST*, char const*, unsigned int, char const*, Item**, bool))[0x56356d55abeb] sql/sql_base.cc:5756(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned int, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**))[0x56356d55bb75] sql/sql_base.cc:5989(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x56356d55c437] sql/item.cc:5488(Item_field::fix_fields(THD*, Item**))[0x56356d8720d0] sql/sql_base.cc:7276(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_mark_columns, List<Item>*, List<Item>*, bool))[0x56356d55f665] sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x56356d6088e5] sql/sql_select.cc:3827(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x56356d613396] sql/sql_select.cc:361(handle_select(THD*, LEX*, select_result*, unsigned long))[0x56356d60759c] sql/sql_parse.cc:6271(execute_sqlcom_select(THD*, TABLE_LIST*))[0x56356d5d1bfc] sql/sql_parse.cc:3582(mysql_execute_command(THD*))[0x56356d5c8770] sql/sp_head.cc:3331(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x56356d519700] sql/sp_head.cc:3094(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x56356d518d61] sql/sp_head.cc:3247(sp_instr_stmt::execute(THD*, unsigned int*))[0x56356d5193a5] sql/sp_head.cc:1326(sp_head::execute(THD*, bool))[0x56356d5143a7] sql/sp_head.cc:2202(sp_head::execute_procedure(THD*, List<Item>*))[0x56356d5165c5] sql/sql_parse.cc:2981(do_execute_sp(THD*, sp_head*))[0x56356d5c6b4a] sql/sql_parse.cc:5622(mysql_execute_command(THD*))[0x56356d5cf4f5] sql/sql_parse.cc:7793(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56356d5d59b8] sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56356d5c3c13] sql/sql_parse.cc:1381(do_command(THD*))[0x56356d5c270e] sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x56356d71e5a3] sql/sql_connect.cc:1242(handle_one_connection)[0x56356d71e308] perfschema/pfs.cc:1871(pfs_spawn_thread)[0x56356df48348] nptl/pthread_create.c:478(start_thread)[0x7f5e3c0c7609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f5e3bca2293] Query (0x7f5de818f138): SELECT x FROM (SELECT a.column_name AS y, (SELECT y FROM information_schema.innodb_sys_foreign LIMIT 1) AS x FROM information_schema.columns a) dt Also repeatable with prepared statements and without information_schema: create table t1 (i int ); prepare stmt from " SELECT x FROM ( SELECT i AS y, (SELECT y FROM t1 LIMIT 1 ) AS x FROM t1 a) dt;" ; execute stmt; execute stmt; Version: '10.2.41-MariaDB-debug-log' mysqld: /10.2/src/sql/item.cc:5006: Item** resolve_ref_in_select_and_group(THD*, Item_ident*, SELECT_LEX*): Assertion `(*select_ref)->fixed' failed. 211102 10:32:54 [ERROR] mysqld got signal 6 ; Server version: 10.2.41-MariaDB-debug-log sql/item.cc:5007(resolve_ref_in_select_and_group(THD*, Item_ident*, st_select_lex*))[0x557ac7a16e07] sql/item.cc:5286(Item_field::fix_outer_field(THD*, Field**, Item**))[0x557ac7a1772c] sql/item.cc:5579(Item_field::fix_fields(THD*, Item**))[0x557ac7a18427] sql/sql_base.cc:7276(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_mark_columns, List<Item>*, List<Item>*, bool))[0x557ac7705665] sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x557ac77ae8e5] sql/item_subselect.cc:3781(subselect_single_select_engine::prepare(THD*))[0x557ac7ac80bb] sql/item_subselect.cc:269(Item_subselect::fix_fields(THD*, Item**))[0x557ac7abc213] sql/table.cc:5985(create_view_field(THD*, TABLE_LIST*, Item**, char const*))[0x557ac78830fd] sql/table.cc:5961(Field_iterator_view::create_item(THD*))[0x557ac7882fe1] sql/sql_base.cc:5396(find_field_in_view(THD*, TABLE_LIST*, char const*, unsigned int, char const*, Item**, bool))[0x557ac7700beb] sql/sql_base.cc:5756(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned int, char const*, char const*, char const*, Item**, bool, bool, unsigned int*, bool, TABLE_LIST**))[0x557ac7701b75] sql/sql_base.cc:5989(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, Item**, find_item_error_report_type, bool, bool))[0x557ac7702437] sql/item.cc:5488(Item_field::fix_fields(THD*, Item**))[0x557ac7a180d0] sql/sql_base.cc:7276(setup_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, enum_mark_columns, List<Item>*, List<Item>*, bool))[0x557ac7705665] sql/sql_select.cc:807(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x557ac77ae8e5] sql/sql_select.cc:3827(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x557ac77b9396] sql/sql_select.cc:361(handle_select(THD*, LEX*, select_result*, unsigned long))[0x557ac77ad59c] sql/sql_parse.cc:6271(execute_sqlcom_select(THD*, TABLE_LIST*))[0x557ac7777bfc] sql/sql_parse.cc:3582(mysql_execute_command(THD*))[0x557ac776e770] sql/sql_prepare.cc:5057(Prepared_statement::execute(String*, bool))[0x557ac7799f8b] sql/sql_prepare.cc:4486(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x557ac7798494] sql/sql_prepare.cc:3577(mysql_sql_stmt_execute(THD*))[0x557ac7796181] sql/sql_parse.cc:3599(mysql_execute_command(THD*))[0x557ac776e7b5] sql/sql_parse.cc:7793(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x557ac777b9b8] sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x557ac7769c13] sql/sql_parse.cc:1381(do_command(THD*))[0x557ac776870e] sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x557ac78c45a3] sql/sql_connect.cc:1242(handle_one_connection)[0x557ac78c4308] perfschema/pfs.cc:1871(pfs_spawn_thread)[0x557ac80ee348] nptl/pthread_create.c:478(start_thread)[0x7f75a50e8609] /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f75a4cc3293] Query (0x7f7548012798): SELECT x FROM ( SELECT i AS y, (SELECT y FROM t1 LIMIT 1 ) AS x FROM t1 a) dt

Stephan Vos added a comment - 2023-01-06 11:30

What is the cause of this issue?
I have something similar for a procedure that does archiving of partitioned tables.
It reads from information_schema.partitions and also uses execute immediate to perform partition exchanging and dropping.

Stephan Vos added a comment - 2023-01-06 11:30 What is the cause of this issue? I have something similar for a procedure that does archiving of partitioned tables. It reads from information_schema.partitions and also uses execute immediate to perform partition exchanging and dropping.

Stephan Vos added a comment - 2023-06-06 12:07

Any movement on fixing this reproduceable issue

Stephan Vos added a comment - 2023-06-06 12:07 Any movement on fixing this reproduceable issue

Alice Sherepa added a comment - 2023-06-13 10:33

still reproducible. on non-debug:

Version: '10.9.7-MariaDB'

230613 12:31:09 [ERROR] mysqld got signal 11 ;

Server version: 10.9.7-MariaDB source revision: 33fd519ca7318cd85bee56e8f79df4608ead194e

sigaction.c:0(__restore_rt)[0x7f2605f6a420]

sql/item.cc:3512(Item_field::used_tables() const)[0x5590990a0983]

sql/item.h:5363(Used_tables_and_const_cache::used_tables_and_const_cache_join(Item const*))[0x55909909ec02]

sql/item.cc:6126(Item_field::fix_fields(THD*, Item**))[0x5590990a1a4e]

sql/item.h:1156(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x559098dcd450]

sql/sql_select.cc:1462(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x559098e8d37b]

sql/item_subselect.cc:3888(subselect_single_select_engine::prepare(THD*))[0x55909914f78d]

sql/item_subselect.cc:295(Item_subselect::fix_fields(THD*, Item**))[0x55909914ee04]

sql/table.cc:6980(create_view_field(THD*, TABLE_LIST*, Item**, st_mysql_const_lex_string*))[0x559098f0ca18]

sql/sql_base.cc:6106(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned long, char const*, char const*, char const*, List<TABLE_LIST>*, Item**, bool, bool, unsigned short*, bool, TABLE_LIST**))[0x559098dc9fff]

sql/sql_base.cc:6699(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, List<TABLE_LIST>*, Item**, find_item_error_report_type, bool, bool))[0x559098dca88d]

sql/item.cc:6034(Item_field::fix_fields(THD*, Item**))[0x5590990a17a9]

sql/item.h:1156(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x559098dcd450]

sql/sql_select.cc:1462(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x559098e8d37b]

sql/sql_select.cc:5068(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x559098ea2bd6]

sql/sql_select.cc:596(handle_select(THD*, LEX*, select_result*, unsigned long))[0x559098ea2f34]

sql/sql_parse.cc:6279(execute_sqlcom_select(THD*, TABLE_LIST*))[0x559098cbba9e]

sql/sql_parse.cc:3948(mysql_execute_command(THD*, bool))[0x559098e358db]

sql/sp_head.cc:3858(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x559098d87178]

sql/sp_head.cc:3590(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559098d901f6]

sql/sp_head.cc:3764(sp_instr_stmt::execute(THD*, unsigned int*))[0x559098d90c9f]

sql/sp_head.cc:1459(sp_head::execute(THD*, bool))[0x559098d8b164]

psi/mysql_sp.h:79(sp_head::execute_procedure(THD*, List<Item>*))[0x559098d8cbef]

sql/sql_parse.cc:3027(do_execute_sp(THD*, sp_head*))[0x559098e29d8a]

sql/sql_parse.cc:3270(Sql_cmd_call::execute(THD*))[0x559098e2c33a]

sql/sql_parse.cc:6014(mysql_execute_command(THD*, bool))[0x559098e3421b]

sql/sql_parse.cc:8044(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x559098e37c9b]

sql/sql_parse.cc:1953(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x559098e3a0d8]

sql/sql_parse.cc:1409(do_command(THD*, bool))[0x559098e3b603]

sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x559098f452c7]

sql/sql_connect.cc:1324(handle_one_connection)[0x559098f45564]

perfschema/pfs.cc:2204(pfs_spawn_thread)[0x5590992d1b0c]

nptl/pthread_create.c:478(start_thread)[0x7f2605f5e609]

addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530ea0)

/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f2605b4a133]

Query (0x7f25c0417b70): SELECT x

FROM

 (SELECT a.column_name AS y,

        (SELECT y FROM information_schema.innodb_sys_foreign LIMIT 1) AS x

  FROM information_schema.columns a) dt

Alice Sherepa added a comment - 2023-06-13 10:33 still reproducible. on non-debug: Version: '10.9.7-MariaDB' 230613 12:31:09 [ERROR] mysqld got signal 11 ; Server version: 10.9.7-MariaDB source revision: 33fd519ca7318cd85bee56e8f79df4608ead194e sigaction.c:0(__restore_rt)[0x7f2605f6a420] sql/item.cc:3512(Item_field::used_tables() const)[0x5590990a0983] sql/item.h:5363(Used_tables_and_const_cache::used_tables_and_const_cache_join(Item const*))[0x55909909ec02] sql/item.cc:6126(Item_field::fix_fields(THD*, Item**))[0x5590990a1a4e] sql/item.h:1156(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x559098dcd450] sql/sql_select.cc:1462(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x559098e8d37b] sql/item_subselect.cc:3888(subselect_single_select_engine::prepare(THD*))[0x55909914f78d] sql/item_subselect.cc:295(Item_subselect::fix_fields(THD*, Item**))[0x55909914ee04] sql/table.cc:6980(create_view_field(THD*, TABLE_LIST*, Item**, st_mysql_const_lex_string*))[0x559098f0ca18] sql/sql_base.cc:6106(find_field_in_table_ref(THD*, TABLE_LIST*, char const*, unsigned long, char const*, char const*, char const*, List<TABLE_LIST>*, Item**, bool, bool, unsigned short*, bool, TABLE_LIST**))[0x559098dc9fff] sql/sql_base.cc:6699(find_field_in_tables(THD*, Item_ident*, TABLE_LIST*, TABLE_LIST*, List<TABLE_LIST>*, Item**, find_item_error_report_type, bool, bool))[0x559098dca88d] sql/item.cc:6034(Item_field::fix_fields(THD*, Item**))[0x5590990a17a9] sql/item.h:1156(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x559098dcd450] sql/sql_select.cc:1462(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x559098e8d37b] sql/sql_select.cc:5068(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x559098ea2bd6] sql/sql_select.cc:596(handle_select(THD*, LEX*, select_result*, unsigned long))[0x559098ea2f34] sql/sql_parse.cc:6279(execute_sqlcom_select(THD*, TABLE_LIST*))[0x559098cbba9e] sql/sql_parse.cc:3948(mysql_execute_command(THD*, bool))[0x559098e358db] sql/sp_head.cc:3858(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x559098d87178] sql/sp_head.cc:3590(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x559098d901f6] sql/sp_head.cc:3764(sp_instr_stmt::execute(THD*, unsigned int*))[0x559098d90c9f] sql/sp_head.cc:1459(sp_head::execute(THD*, bool))[0x559098d8b164] psi/mysql_sp.h:79(sp_head::execute_procedure(THD*, List<Item>*))[0x559098d8cbef] sql/sql_parse.cc:3027(do_execute_sp(THD*, sp_head*))[0x559098e29d8a] sql/sql_parse.cc:3270(Sql_cmd_call::execute(THD*))[0x559098e2c33a] sql/sql_parse.cc:6014(mysql_execute_command(THD*, bool))[0x559098e3421b] sql/sql_parse.cc:8044(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x559098e37c9b] sql/sql_parse.cc:1953(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x559098e3a0d8] sql/sql_parse.cc:1409(do_command(THD*, bool))[0x559098e3b603] sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x559098f452c7] sql/sql_connect.cc:1324(handle_one_connection)[0x559098f45564] perfschema/pfs.cc:2204(pfs_spawn_thread)[0x5590992d1b0c] nptl/pthread_create.c:478(start_thread)[0x7f2605f5e609] addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530ea0) /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f2605b4a133] Query (0x7f25c0417b70): SELECT x FROM (SELECT a.column_name AS y, (SELECT y FROM information_schema.innodb_sys_foreign LIMIT 1) AS x FROM information_schema.columns a) dt

Aleksey Midenkov added a comment - 2025-04-12 10:54

Please review:

91513d2875f (HEAD -> bb-10.5-midenok2, mariadb/bb-10.5-midenok2) MDEV-26944 Server crash on selecting some data from information_schema

Aleksey Midenkov added a comment - 2025-04-12 10:54 Please review: 91513d2875f (HEAD -> bb-10.5-midenok2, mariadb/bb-10.5-midenok2) MDEV-26944 Server crash on selecting some data from information_schema

Oleksandr Byelkin added a comment - 2025-04-21 18:58

Bugs when something is not done but becouse of the other flag on the second execution we do not do it we usually fixed by adding separate flag for the action which should be done only once, so please fix it so.

Oleksandr Byelkin added a comment - 2025-04-21 18:58 Bugs when something is not done but becouse of the other flag on the second execution we do not do it we usually fixed by adding separate flag for the action which should be done only once, so please fix it so.

Aleksey Midenkov added a comment - 2025-04-23 13:24

Please review:

647995982b5 MDEV-26944 Server crash on selecting some data from information_schema

Aleksey Midenkov added a comment - 2025-04-23 13:24 Please review: 647995982b5 MDEV-26944 Server crash on selecting some data from information_schema

People

Assignee:: Oleksandr Byelkin

Reporter:: Andrey Timofeev

Votes:: 1 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2021-10-30 17:33

Updated:: 2 days ago 22:07

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Reproduce

Result

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration