Draft: InnoDB: Assertion failure in trx0i_s.cc line 1167 upon SELECT * FROM information_schema.innodb_trx

This failure was observed first by Sujatha.  It caused a SEGV on 10.5.8-enterprise.

After adding a SELECT * FROM information_schema.innodb_trx to some RQG grammar

I was able to hit the problem on some 10.6 development too.

 2021-03-11 19:40:38 0 [Note] InnoDB: Completed resizing buffer pool at 210311 19:40:38.

       # I mention this because the resizing operation was error prone in the last 2 - 3 weeks.

# 2021-03-11T19:43:27 [3351230] | 2021-03-11 19:40:38 0x7f1edda88300  InnoDB: Assertion failure in file /Server/bb-10.6-uring/storage/innobase/trx/trx0i_s.cc line 1167

??:0(__interceptor_tcgetattr)[0x7f1efae2fd30]

# 2021-03-11T19:43:27 [3351230] | /Server_bin/bb-10.6-uring_asan/bin/mysqld(my_print_stacktrace+0xec)[0x5603cb31aa42]

# 2021-03-11T19:43:27 [3351230] | /Server_bin/bb-10.6-uring_asan/bin/mysqld(handle_fatal_signal+0xa1a)[0x5603c9ed4aa9]

# 2021-03-11T19:43:27 [3351230] | sigaction.c:0(__restore_rt)[0x7f1efac7d3c0]

# 2021-03-11T19:43:27 [3351230] | ??:0(gsignal)[0x7f1efa76318b]

# 2021-03-11T19:43:27 [3351230] | ??:0(abort)[0x7f1efa742859]

# 2021-03-11T19:43:27 [3351230] | /Server_bin/bb-10.6-uring_asan/bin/mysqld(+0x30d5be3)[0x5603cae46be3]

# 2021-03-11T19:43:27 [3351230] | /Server_bin/bb-10.6-uring_asan/bin/mysqld(+0x3047258)[0x5603cadb8258]

# 2021-03-11T19:43:27 [3351230] | /Server_bin/bb-10.6-uring_asan/bin/mysqld(+0x3047517)[0x5603cadb8517]

# 2021-03-11T19:43:27 [3351230] | ut/ut0dbg.cc:60(_sub_D_00099_0)[0x5603cadb9153]

# 2021-03-11T19:43:27 [3351230] | trx/trx0i_s.cc:1167(fetch_data_into_cache_low(trx_i_s_cache_t*, trx_t const*))[0x5603cadb862d]

# 2021-03-11T19:43:27 [3351230] | trx/trx0i_s.cc:1202(fetch_data_into_cache(trx_i_s_cache_t*)::{lambda(trx_t const&)#1}::operator()(trx_t const&) const)[0x5603cadb8773]

# 2021-03-11T19:43:27 [3351230] | include/trx0sys.h:830(void thread_safe_trx_ilist_t::for_each<fetch_data_into_cache(trx_i_s_cache_t*)::{lambda(trx_t const&)#1}>(fetch_data_into_cache(trx_i_s_cache_t*)::{lambda(trx_t const&)#1}&&) const)[0x5603caa3c943]

# 2021-03-11T19:43:27 [3351230] | trx/trx0i_s.cc:1196(fetch_data_into_cache(trx_i_s_cache_t*))[0x5603c993999d]

# 2021-03-11T19:43:27 [3351230] | trx/trx0i_s.cc:1225(trx_i_s_possibly_fetch_data_into_cache(trx_i_s_cache_t*))[0x5603c9817c6e]

# 2021-03-11T19:43:27 [3351230] | handler/i_s.cc:974(trx_i_s_common_fill_table(THD*, TABLE_LIST*, Item*))[0x5603c9815d42]

# 2021-03-11T19:43:27 [3351230] | sql/sql_show.cc:8725(get_schema_tables_result(JOIN*, enum_schema_table_state))[0x5603c9819820]

# 2021-03-11T19:43:27 [3351230] | sql/sql_select.cc:4433(JOIN::exec_inner())[0x5603c97ef8ec]

# 2021-03-11T19:43:27 [3351230] | sql/sql_parse.cc:6230(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5603c976c5b9]

# 2021-03-11T19:43:27 [3351230] | sql/sql_parse.cc:3926(mysql_execute_command(THD*))[0x5603c975b9ac]

# 2021-03-11T19:43:27 [3351230] | sql/sql_parse.cc:7998(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5603c97767fb]

# 2021-03-11T19:43:27 [3351230] | sql/sql_parse.cc:1888(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5603c974ef17]

# 2021-03-11T19:43:27 [3351230] | sql/sql_parse.cc:1397(do_command(THD*, bool))[0x5603c974c1e9]

# 2021-03-11T19:43:27 [3351230] | sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x5603c9b3958c]

# 2021-03-11T19:43:27 [3351230] | sql/sql_connect.cc:1314(handle_one_connection)[0x5603c9b38eee]

# 2021-03-11T19:43:27 [3351230] | perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5603ca7590cd]

# 2021-03-11T19:43:27 [3351230] | nptl/pthread_create.c:478(start_thread)[0x7f1efac71609]

# 2021-03-11T19:43:27 [3351230] | ??:0(clone)[0x7f1efa83f293]

# 2021-03-11T19:43:27 [3351230] |

# 2021-03-11T19:43:27 [3351230] | Trying to get some variables.

# 2021-03-11T19:43:27 [3351230] | Some pointers may be invalid and cause the dump to abort.

# 2021-03-11T19:43:27 [3351230] | Query (0x62b000069238): SELECT * FROM information_schema.innodb_trx /* E_R Thread1 QNO 5623 CON_ID 408 */

I will add more information soon.