[MDEV-26944] Server crash on selecting some data from information_schema Created: 2021-10-30  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: Information Schema, Stored routines
Affects Version/s: 10.6.4, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

Type: Bug Priority: Critical
Reporter: Andrey Timofeev Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 1
Labels: crash
Environment:

Linux Ubuntu 20.04.3 LTS, 5.4.0-88-generic
MariaDB 10.6.4

Attachments: Text File log.txt     Text File sql.txt    
Issue Links:
Duplicate
is duplicated by MDEV-31175 Server crash on 2n execution of selec... Open
Relates
relates to MDEV-22713 Assertion `(*select_ref)->is_fixed()'... Confirmed
relates to MDEV-28917 SIGSEGV in resolve_ref_in_select_and_... Confirmed

 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.

 Comments   
Comment by Alice Sherepa [ 2021-11-02 ]

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

Comment by Stephan Vos [ 2023-01-06 ]

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.

Comment by Stephan Vos [ 2023-06-06 ]

Any movement on fixing this reproduceable issue

Comment by Alice Sherepa [ 2023-06-13 ]

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

Generated at Thu Feb 08 09:49:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.