InnoDB: Failing assertion: trx->n_mysql_tables_in_use in ha_innobase::external_lock()

--source include/have_log_bin.inc

--source include/have_innodb.inc

SET binlog_format=STATEMENT;

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

CREATE TEMPORARY TABLE t (c TEXT,UNIQUE (c)) ENGINE=INNODB;

LOCK TABLE t READ;

LOAD DATA LOCAL INFILE 'foo' INTO TABLE t  LINES TERMINATED BY '\n';

InnoDB: Failing assertion: trx->n_mysql_tables_in_use

Core was generated by `/test/MD27012026-mariadb-12.2.2-linux-x86_64-opt/bin/mariadbd --no-defaults --m'.

Program terminated with signal SIGABRT, Aborted.

Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 3583293)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89

#3  0x0000732f7164527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x0000732f716288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x00005728b682970b in ut_dbg_assertion_failed (expr=0x5728b73bd218 "trx->n_mysql_tables_in_use", file=0x5728b73bb6ec "/test/12.2_opt/storage/innobase/handler/ha_innodb.cc", line=line@entry=16349) at /test/12.2_opt/storage/innobase/ut/ut0dbg.cc:60

#6  0x00005728b6eff02e in ha_innobase::external_lock (this=0x732e90026be8, thd=0x732e90000c68, lock_type=2)at /test/12.2_opt/storage/innobase/handler/ha_innodb.cc:16349

#7  0x00005728b6bfef2e in handler::ha_external_lock (this=0x732e90026be8, thd=0x732e90000c68, lock_type=2) at /test/12.2_opt/sql/handler.cc:7784

#8  0x00005728b6d30fc4 in handler::ha_external_unlock (this=0x369389, thd=0x732e90000c68) at /test/12.2_opt/sql/handler.h:3621

#9  unlock_external (thd=0x732e90000c68, table=0x732e900132e8, count=<optimized out>) at /test/12.2_opt/sql/lock.cc:791

#10 mysql_unlock_tables (thd=0x732e90000c68, sql_lock=0x732e900132c8, free_lock=true) at /test/12.2_opt/sql/lock.cc:482

#11 0x00005728b690704f in close_thread_tables (thd=thd@entry=0x732e90000c68)at /test/12.2_opt/sql/sql_base.cc:1000

#12 0x00005728b6909687 in Locked_tables_list::unlock_locked_tables (this=0x732e90004ec8, thd=0x732e90000c68)at /test/12.2_opt/sql/sql_base.cc:2723

#13 0x00005728b691f7bb in THD::cleanup (this=0x732e90000c68)at /test/12.2_opt/sql/sql_class.cc:1714

#14 0x00005728b687b1be in unlink_thd (thd=0x369389, thd@entry=0x732e90000c68)at /test/12.2_opt/sql/mysqld.cc:2869

#15 0x00005728b6aa60ed in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5728c6cf45f8, put_in_cache=true)at /test/12.2_opt/sql/sql_connect.cc:1514

#16 0x00005728b6aa5e2f in handle_one_connection (arg=arg@entry=0x5728c6cf45f8)at /test/12.2_opt/sql/sql_connect.cc:1415

#17 0x00005728b6e5ece9 in pfs_spawn_thread (arg=0x5728c6d1f0e8)at /test/12.2_opt/storage/perfschema/pfs.cc:2198

#18 0x0000732f7169caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#19 0x0000732f71729c6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

    Rel    o/d  Build   Commit                                    UniqueID observed

CS  10.6   dbg  140126  33413c631898ecfc97abd51e272330feca55bf03  No bug found

CS  10.6   opt  140126  33413c631898ecfc97abd51e272330feca55bf03  No bug found

CS  10.11  dbg  270126  c0acc3cc8f1ec24e96b1ee192fdf6e4b6ccf4e0a  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

CS  10.11  opt  270126  c0acc3cc8f1ec24e96b1ee192fdf6e4b6ccf4e0a  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

CS  11.4   dbg  270126  ca39e66060d4735f91fd46d9784b4c91ed6746aa  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

CS  11.4   opt  270126  ca39e66060d4735f91fd46d9784b4c91ed6746aa  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

CS  11.8   dbg  140126  01ff5ae6b677bead4c41d91bf5afb25c593a1d02  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

CS  11.8   opt  140126  01ff5ae6b677bead4c41d91bf5afb25c593a1d02  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

CS  12.2   dbg  270126  d640758b9478f4da9ac0023b1ac389ffc23aa9bb  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

CS  12.2   opt  270126  d640758b9478f4da9ac0023b1ac389ffc23aa9bb  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

CS  12.3   dbg  270126  346c7afe9b7071ce9c47892a83d69944b608b3da  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

CS  12.3   opt  270126  346c7afe9b7071ce9c47892a83d69944b608b3da  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

ES  10.6   dbg  151225  bc33b05c6a65de27dbe811a30bc37c207d60ee8e No bug found 

ES  10.6   opt  151225  bc33b05c6a65de27dbe811a30bc37c207d60ee8e No bug found 

ES  11.4   dbg  151225  714f2134597e00f4ff107886cf3a55eff48e4510  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

ES  11.4   opt  151225  714f2134597e00f4ff107886cf3a55eff48e4510  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

ES  11.8   dbg  151225  4008de1a5b06105a64821db7b851328f1b27d99e  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock

ES  11.8   opt  151225  4008de1a5b06105a64821db7b851328f1b27d99e  trx->n_mysql_tables_in_use|SIGABRT|ut_dbg_assertion_failed|ha_innobase::external_lock|handler::ha_external_lock|handler::ha_external_unlock