MySQL Bugs: #81255: Assertion THD::Attachable_trx::~Attachable

Bug #81255	Assertion THD::Attachable_trx::~Attachable_trx in Information schema query
Submitted:	1 May 2016 9:58	Modified:	12 Jul 2016 7:38
Reporter:	Shipra Jain	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S3 (Non-critical)
Version:	8.0.0(mysql-trunk-wl6599-7167 - Debug)	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Assertion THD::Attachable_trx::~Attachable_trx in Information schema query

SELECT * FROM (INFORMATION_SCHEMA . `tables_dynamic` AS table1 INNER JOIN test . `view_D` AS table2 ON ( table2 . `col_time_nokey` = table1 . `INDEX_LENGTH` ) ) WHERE `pk` BETWEEN 7 AND 7 + 1   LIMIT 7

#4  0x00007f8519b288a5 in raise () from /lib64/libc.so.6
#5  0x00007f8519b2a085 in abort () from /lib64/libc.so.6
#6  0x00007f8519b21a1e in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f8519b21ae0 in __assert_fail () from /lib64/libc.so.6
#8  0x00000000012647d4 in THD::Attachable_trx::~Attachable_trx (this=0x7f8454108a80, __in_chrg=<value optimized out>) at /log/RQG/shipjain/trunk/sql/sql_class.cc:216
#9  0x00000000012648d6 in THD::Attachable_trx::~Attachable_trx (this=0x7f8454108a80, __in_chrg=<value optimized out>) at /log/RQG/shipjain/trunk/sql/sql_class.cc:253
#10 0x0000000001269d8a in THD::end_attachable_transaction (this=0x7f8454000b70) at /log/RQG/shipjain/trunk/sql/sql_class.cc:2131
#11 0x00000000014056f4 in dd::Transaction_ro::~Transaction_ro (this=0x7f84d1e71a00, __in_chrg=<value optimized out>)
    at /log/RQG/shipjain/trunk/sql/dd/impl/transaction_impl.h:99
#12 0x00000000014986fe in dd::cache::Storage_adapter::get<dd::Item_name_key, dd::Schema> (thd=0x7f8454000b70, key=..., isolation=ISO_READ_COMMITTED, 
    object=0x7f84d1e71b20) at /log/RQG/shipjain/trunk/sql/dd/impl/cache/storage_adapter.cc:135
#13 0x000000000148ffc2 in dd::cache::Shared_dictionary_cache::get_uncached<dd::Item_name_key, dd::Schema> (this=0x32c8a40, thd=0x7f8454000b70, key=..., 
    isolation=ISO_READ_COMMITTED, object=0x7f84d1e71b20) at /log/RQG/shipjain/trunk/sql/dd/impl/cache/shared_dictionary_cache.cc:55
#14 0x000000000148fdb1 in dd::cache::Shared_dictionary_cache::get<dd::Item_name_key, dd::Schema> (this=0x32c8a40, thd=0x7f8454000b70, key=..., element=0x7f84d1e71b78)
    at /log/RQG/shipjain/trunk/sql/dd/impl/cache/shared_dictionary_cache.cc:37
#15 0x0000000001420a7a in dd::cache::Dictionary_client::acquire<dd::Item_name_key, dd::Schema> (this=0x7f84540042c0, key=..., object=0x7f84d1e72680, 
    local=0x7f84d1e7267f) at /log/RQG/shipjain/trunk/sql/dd/impl/cache/dictionary_client.cc:540
#16 0x000000000141b707 in dd::cache::Dictionary_client::acquire<dd::Schema> (this=0x7f84540042c0, object_name="testdb_N", object=0x7f84d1e73198)
    at /log/RQG/shipjain/trunk/sql/dd/impl/cache/dictionary_client.cc:794
#17 0x0000000001413611 in dd::cache::Dictionary_client::acquire<dd::Function> (this=0x7f84540042c0, schema_name="testdb_N", object_name="f1_2_N", object=0x7f84d1e73d98)
    at /log/RQG/shipjain/trunk/sql/dd/impl/cache/dictionary_client.cc:929
#18 0x0000000001bdd3a1 in dd::find_routine (dd_client=0x7f84540042c0, name=0x7f84d1e74000, type=FUNCTION, routine=0x7f84d1e73d98)
    at /log/RQG/shipjain/trunk/sql/dd/dd_routine.cc:47
#19 0x0000000001b551ab in db_find_routine (thd=0x7f8454000b70, type=FUNCTION, name=0x7f84d1e74000, sphp=0x7f84d1e74260) at /log/RQG/shipjain/trunk/sql/sp.cc:255
#20 0x0000000001b59cce in sp_cache_routine (thd=0x7f8454000b70, type=FUNCTION, name=0x7f84d1e74000, lookup_only=false, sp=0x7f84d1e74260)
    at /log/RQG/shipjain/trunk/sql/sp.cc:1733
#21 0x0000000001b59b22 in sp_cache_routine (thd=0x7f8454000b70, rt=0x7f8454078228, lookup_only=false, sp=0x7f84d1e74260) at /log/RQG/shipjain/trunk/sql/sp.cc:1686
#22 0x0000000001249969 in open_and_process_routine (thd=0x7f8454000b70, prelocking_ctx=0x7f8454002e30, rt=0x7f8454078228, prelocking_strategy=0x7f84d1e74430, 
    has_prelocking_list=false, ot_ctx=0x7f84d1e742f0, need_prelocking=0x7f84d1e7432e, routine_modifies_data=0x7f84d1e7432f)
    at /log/RQG/shipjain/trunk/sql/sql_base.cc:4791
#23 0x000000000124b281 in open_tables (thd=0x7f8454000b70, start=0x7f84d1e743f0, counter=0x7f8454002ed8, flags=0, prelocking_strategy=0x7f84d1e74430)
    at /log/RQG/shipjain/trunk/sql/sql_base.cc:5753
#24 0x000000000124c710 in open_tables_for_query (thd=0x7f8454000b70, tables=0x7f8454008620, flags=0) at /log/RQG/shipjain/trunk/sql/sql_base.cc:6485
#25 0x00000000012af008 in execute_sqlcom_select (thd=0x7f8454000b70, all_tables=0x7f8454008620) at /log/RQG/shipjain/trunk/sql/sql_parse.cc:5798
#26 0x00000000012a8bfe in mysql_execute_command (thd=0x7f8454000b70, first_level=true) at /log/RQG/shipjain/trunk/sql/sql_parse.cc:3485
#27 0x00000000012affff in mysql_parse (thd=0x7f8454000b70, parser_state=0x7f84d1e75620) at /log/RQG/shipjain/trunk/sql/sql_parse.cc:6240
#28 0x00000000012a1ba5 in dispatch_command (thd=0x7f8454000b70, com_data=0x7f84d1e75d70, command=COM_QUERY) at /log/RQG/shipjain/trunk/sql/sql_parse.cc:1446
#29 0x00000000012a0b1f in do_command (thd=0x7f8454000b70) at /log/RQG/shipjain/trunk/sql/sql_parse.cc:1011
#30 0x000000000150064c in handle_connection (arg=0x362f310) at /log/RQG/shipjain/trunk/sql/conn_handler/connection_handler_per_thread.cc:302
#31 0x0000000001d396ce in pfs_spawn_thread (arg=0x3686360) at /log/RQG/shipjain/trunk/storage/perfschema/pfs.cc:2228
#32 0x00007f851ae73851 in start_thread () from /lib64/libpthread.so.0
#33 0x00007f8519bdd67d in clone () from /lib64/libc.so.6

How to repeat:
log and core are at (vitro94.no.oracle.com)

gdb /log/RQG/shipjain/workdir_25842/mysqld /log/RQG/shipjain/workdir_25842:/vardir1_2/data/core.12513

Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0

Fixed in 8.0.0.

Bug affects no released version. No changelog entry needed.