Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
11.2.0
-
None
Description
CREATE TEMPORARY SEQUENCE seq1 ; |
--error 4086 |
ALTER TABLE `seq1` CHANGE `cache_size` cache_size int ; |
|
CREATE OR REPLACE TEMPORARY SEQUENCE seq1; |
SHOW TABLES;
|
|
|
230704 13:24:47 [ERROR] mysqld got signal 11 ;
|
|
Server version: 11.2.0-MariaDB-debug-log source revision: 7c7de020b576a42bd381a9060c3076f85da0d9d4
|
|
sigaction.c:0(__restore_rt)[0x7f954e653420]
|
sql/sql_show.cc:5315(get_all_tables(THD*, TABLE_LIST*, Item*))[0x561438970199]
|
sql/sql_show.cc:9129(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x5614389a6f4b]
|
sql/sql_select.cc:4889(JOIN::exec_inner())[0x56143885f94d]
|
sql/sql_select.cc:4710(JOIN::exec())[0x56143885d5e4]
|
sql/sql_select.cc:5239(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*))[0x561438861d35]
|
sql/sql_select.cc:627(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x5614388314a9]
|
sql/sql_parse.cc:6030(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5614387529ca]
|
sql/sql_parse.cc:3944(mysql_execute_command(THD*, bool))[0x5614387435de]
|
sql/sql_parse.cc:7769(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x56143875d80f]
|
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x561438735cef]
|
sql/sql_parse.cc:1405(do_command(THD*, bool))[0x561438732a39]
|
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x561438c0dd17]
|
sql/sql_connect.cc:1320(handle_one_connection)[0x561438c0d674]
|
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x56143988aa46]
|
nptl/pthread_create.c:478(start_thread)[0x7f954e647609]
|
|
Query (0x6290001092a8): SHOW TABLES
|
CREATE TEMPORARY SEQUENCE seq1 ; |
--error 4086 |
ALTER TABLE `seq1` CHANGE `cache_size` cache_size int ; |
|
CREATE OR REPLACE TEMPORARY SEQUENCE seq1; |
SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type='temporary'; |
|
230704 13:23:08 [ERROR] mysqld got signal 11 ;
|
|
Server version: 11.2.0-MariaDB-debug source revision: 8a0eabc65d2ae06fd66542160ae3bbc7b475371c
|
|
sql/signal_handler.cc:241(handle_fatal_signal)[0x55f0a1dbd6c6]
|
sigaction.c:0(__restore_rt)[0x7f368be58420]
|
sql/sql_show.cc:5914(process_i_s_table_temporary_tables(THD*, TABLE*, TABLE*))[0x55f0a169b5df]
|
sql/sql_show.cc:5330(get_all_tables(THD*, TABLE_LIST*, Item*))[0x55f0a1693a44]
|
sql/sql_show.cc:9129(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x55f0a16ca02b]
|
sql/sql_select.cc:4889(JOIN::exec_inner())[0x55f0a1582a2d]
|
sql/sql_select.cc:4710(JOIN::exec())[0x55f0a15806c4]
|
sql/sql_select.cc:5239(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*))[0x55f0a1584e15]
|
sql/sql_select.cc:627(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x55f0a1554589]
|
sql/sql_parse.cc:6030(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55f0a1475aaa]
|
sql/sql_parse.cc:3944(mysql_execute_command(THD*, bool))[0x55f0a14666be]
|
sql/sql_parse.cc:7769(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55f0a14808ef]
|
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55f0a1458dcf]
|
sql/sql_parse.cc:1405(do_command(THD*, bool))[0x55f0a1455b19]
|
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55f0a1930df7]
|
sql/sql_connect.cc:1320(handle_one_connection)[0x55f0a1930754]
|
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55f0a25afec4]
|
nptl/pthread_create.c:478(start_thread)[0x7f368be4c609]
|
|
Query (0x6290000e62a8): SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type='temporary'
|
Attachments
Issue Links
- is caused by
-
MDEV-12459 The information_schema tables for getting temporary tables info is missing, at least for innodb there is no INNODB_TEMP_TABLE_INFO
- Closed
- links to