Assertion `binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES' failed in THD::reset_for_next_command

origin/10.5 718f18599a9bcf1e7c2d3f18416fca4f7124d00d 2020-03-26T16:05:25+02:00

debug build with ASAN

Assert hit during RQG testing

mysqld: sql/sql_parse.cc:7444: void THD::reset_for_next_command(bool): Assertion `binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES' failed.

200326 14:50:05 [ERROR] mysqld got signal 6 ;

...

Query (0x62b0000a1238): SELECT * FROM `table0_innodb_int_autoinc` AS X WHERE X.`col_char_12_key` IN ( 127, 'y', 's', 230, 'n' ) LIMIT 6  /* E_R Thread1 QNO 35521 CON_ID 12 */

...

Status: NOT_KILLED

Thread 1 (Thread 0x7fa5b53d0300 (LWP 69908)):

#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57

#1  0x000055a8b419f774 in my_write_core (sig=6) at mysys/stacktrace.c:518

#2  0x000055a8b2c2f7b8 in handle_fatal_signal (sig=6) at sql/signal_handler.cc:325

#3  <signal handler called>

#4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51

#5  0x00007fa5d2865801 in __GI_abort () at abort.c:79

#6  0x00007fa5d285539a in __assert_fail_base (fmt=0x7fa5d29dc7d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55a8b46346a0 "binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES", file=file@entry=0x55a8b46309e0 "sql/sql_parse.cc", line=line@entry=7444, function=function@entry=0x55a8b4637f00 <THD::reset_for_next_command(bool)::__PRETTY_FUNCTION__> "void THD::reset_for_next_command(bool)") at assert.c:92

#7  0x00007fa5d2855412 in __GI___assert_fail (assertion=0x55a8b46346a0 "binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES", file=0x55a8b46309e0 "sql/sql_parse.cc", line=7444, function=0x55a8b4637f00 <THD::reset_for_next_command(bool)::__PRETTY_FUNCTION__> "void THD::reset_for_next_command(bool)") at assert.c:101

#8  0x000055a8b2492d74 in THD::reset_for_next_command (this=0x62b00009a218, do_clear_error=true) at sql/sql_parse.cc:7443

#9  0x000055a8b2495de0 in mysql_parse (thd=0x62b00009a218, rawbuf=0x62b0000a1238 "SELECT * FROM `table0_innodb_int_autoinc` AS X WHERE X.`col_char_12_key` IN ( 127, 'y', 's', 230, 'n' ) LIMIT 6  /* E_R Thread1 QNO 35521 CON_ID 12 */", length=150, parser_state=0x7fa5b53ce8f0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:7894

#10 0x000055a8b246bce7 in dispatch_command (command=COM_QUERY, thd=0x62b00009a218, packet=0x629000b59219 "SELECT * FROM `table0_innodb_int_autoinc` AS X WHERE X.`col_char_12_key` IN ( 127, 'y', 's', 230, 'n' ) LIMIT 6  /* E_R Thread1 QNO 35521 CON_ID 12 */ ", packet_length=151, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1839

#11 0x000055a8b2468682 in do_command (thd=0x62b00009a218) at sql/sql_parse.cc:1358

#12 0x000055a8b288db4d in do_handle_one_connection (connect=0x608000003a38, put_in_cache=true) at sql/sql_connect.cc:1422

#13 0x000055a8b288d3e9 in handle_one_connection (arg=0x6080000036b8) at sql/sql_connect.cc:1319

#14 0x000055a8b3537f8b in pfs_spawn_thread (arg=0x615000004918) at storage/perfschema/pfs.cc:2201

#15 0x00007fa5d37606db in start_thread (arg=0x7fa5b53d0300) at pthread_create.c:463

#16 0x00007fa5d294688f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Hitting this assert seems to be rare.