Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
11.2.0
-
None
Description
CREATE TABLE t (a INT) ENGINE=MyISAM; |
CREATE TEMPORARY TABLE tmp (a INT) ENGINE=MERGE UNION=(t); |
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test'; |
|
# Cleanup
|
DROP TABLE t; |
preview-10.9-MDEV-20119-misc e62a2a0615 |
mariadbd: /data/src/preview-10.9-misc-ubsan/storage/myisammrg/ha_myisammrg.cc:1249: virtual int ha_myisammrg::info(uint): Assertion `this->file->children_attached' failed.
|
220419 22:32:10 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f1c14a66662 in __GI___assert_fail (assertion=assertion@entry=0x5632fc7f744f "this->file->children_attached", file=file@entry=0x5632fc7f76a8 "/data/src/preview-10.9-misc-ubsan/storage/myisammrg/ha_myisammrg.cc", line=line@entry=1249, function=function@entry=0x5632fc7f7d78 "virtual int ha_myisammrg::info(uint)") at assert.c:101
|
#8 0x00005632fc06157f in ha_myisammrg::info (this=0x7f1bf403e4a0, flag=212) at /data/src/preview-10.9-misc-ubsan/storage/myisammrg/ha_myisammrg.cc:1249
|
#9 0x00005632f9498541 in get_schema_tables_record (thd=thd@entry=0x7f1bf4000d48, tables=tables@entry=0x7f1c10259530, table=table@entry=0x7f1bf41e8d60, res=res@entry=false, db_name=db_name@entry=0x7f1bf421e340, table_name=table_name@entry=0x7f1bf421e350) at /data/src/preview-10.9-misc-ubsan/sql/sql_show.cc:5681
|
#10 0x00005632f94be504 in process_i_s_table_temporary_tables (thd=thd@entry=0x7f1bf4000d48, table=table@entry=0x7f1bf41e8d60, tmp_tbl=tmp_tbl@entry=0x7f1bf41ec208) at /data/src/preview-10.9-misc-ubsan/sql/sql_show.cc:5819
|
#11 0x00005632f94ca7c9 in get_all_tables (thd=0x7f1bf4000d48, tables=0x7f1bf4014c48, cond=<optimized out>) at /data/src/preview-10.9-misc-ubsan/sql/sql_show.cc:5249
|
#12 0x00005632f94d0c42 in get_schema_tables_result (join=join@entry=0x7f1bf4016b60, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /data/src/preview-10.9-misc-ubsan/sql/sql_show.cc:8880
|
#13 0x00005632f93f6558 in JOIN::exec_inner (this=this@entry=0x7f1bf4016b60) at /data/src/preview-10.9-misc-ubsan/sql/sql_select.cc:4706
|
#14 0x00005632f93f78b6 in JOIN::exec (this=this@entry=0x7f1bf4016b60) at /data/src/preview-10.9-misc-ubsan/sql/sql_select.cc:4527
|
#15 0x00005632f93ee85a in mysql_select (thd=thd@entry=0x7f1bf4000d48, tables=<optimized out>, fields=..., conds=conds@entry=0x7f1bf40154e8, og_num=og_num@entry=0, order=order@entry=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x7f1bf4016b38, unit=0x7f1bf4005158, select_lex=0x7f1bf4014658) at /data/src/preview-10.9-misc-ubsan/sql/sql_select.cc:5007
|
#16 0x00005632f93ef904 in handle_select (thd=thd@entry=0x7f1bf4000d48, lex=lex@entry=0x7f1bf4005080, result=result@entry=0x7f1bf4016b38, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/preview-10.9-misc-ubsan/sql/sql_select.cc:543
|
#17 0x00005632f90de877 in execute_sqlcom_select (thd=thd@entry=0x7f1bf4000d48, all_tables=0x7f1bf4014c48) at /data/src/preview-10.9-misc-ubsan/sql/sql_parse.cc:6252
|
#18 0x00005632f9126b0b in mysql_execute_command (thd=thd@entry=0x7f1bf4000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/src/preview-10.9-misc-ubsan/sql/sql_parse.cc:3943
|
#19 0x00005632f9146d55 in mysql_parse (thd=thd@entry=0x7f1bf4000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f1c1025b5e0) at /data/src/preview-10.9-misc-ubsan/sql/sql_parse.cc:8027
|
#20 0x00005632f91520f7 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f1bf4000d48, packet=packet@entry=0x7f1bf410de99 "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test'", packet_length=packet_length@entry=67, blocking=blocking@entry=true) at /data/src/preview-10.9-misc-ubsan/sql/sql_parse.cc:1894
|
#21 0x00005632f915ea76 in do_command (thd=0x7f1bf4000d48, blocking=blocking@entry=true) at /data/src/preview-10.9-misc-ubsan/sql/sql_parse.cc:1402
|
#22 0x00005632f97d506b in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5633010ea638, put_in_cache=put_in_cache@entry=true) at /data/src/preview-10.9-misc-ubsan/sql/sql_connect.cc:1418
|
#23 0x00005632f97d62f2 in handle_one_connection (arg=0x5633010ea638) at /data/src/preview-10.9-misc-ubsan/sql/sql_connect.cc:1312
|
#24 0x00005632fb1e60bb in pfs_spawn_thread (arg=0x56330104a398) at /data/src/preview-10.9-misc-ubsan/storage/perfschema/pfs.cc:2201
|
#25 0x00007f1c1589cea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#26 0x00007f1c14b2fdef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
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