Bug #97404 Assertion "temptable..Handler..get_error_message"
Description:
Following sql results in a crash with the debug build (can't reproduce it on release build).
gdb from the debug build:
Core was generated by `/sdc/MS151019-mysql-8.0.18-linux-x86_64-debug/bin/mysqld --no-defaults --basedi'.
Program terminated with signal 6, Aborted.
#0 0x00007fce7d097a61 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
59 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
+bt
#0 0x00007fce7d097a61 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:59
#1 0x00000000048f003d in my_write_core (sig=6) at /sdc/MS-8.0.18_dbg/mysys/stacktrace.cc:305
#2 0x00000000035e030e in handle_fatal_signal (sig=6) at /sdc/MS-8.0.18_dbg/sql/signal_handler.cc:169
#3 <signal handler called>
#4 0x00007fce7aedf337 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:55
#5 0x00007fce7aee0a28 in __GI_abort () at abort.c:90
#6 0x000000000516a6ea in temptable::Handler::init_table_handle_for_HANDLER (this=0x7fce21a5f028) at /sdc/MS-8.0.18_dbg/storage/temptable/src/handler.cc:1137
#7 0x000000000333449a in lock_tables (thd=0x7fce21820000, tables=0x7fce21872e28, count=7, flags=0) at /sdc/MS-8.0.18_dbg/sql/sql_base.cc:6672
#8 0x0000000003475e94 in Sql_cmd_dml::execute (this=0x7fce218733d8, thd=0x7fce21820000) at /sdc/MS-8.0.18_dbg/sql/sql_select.cc:700
#9 0x0000000003413287 in mysql_execute_command (thd=0x7fce21820000, first_level=true) at /sdc/MS-8.0.18_dbg/sql/sql_parse.cc:4453
#10 0x0000000003415bb6 in mysql_parse (thd=0x7fce21820000, parser_state=0x7fce647fcae0) at /sdc/MS-8.0.18_dbg/sql/sql_parse.cc:5257
#11 0x000000000340b046 in dispatch_command (thd=0x7fce21820000, com_data=0x7fce647fdb90, command=COM_QUERY) at /sdc/MS-8.0.18_dbg/sql/sql_parse.cc:1765
#12 0x000000000340958b in do_command (thd=0x7fce21820000) at /sdc/MS-8.0.18_dbg/sql/sql_parse.cc:1273
#13 0x00000000035caf99 in handle_connection (arg=0x7fce2c87a3e0) at /sdc/MS-8.0.18_dbg/sql/conn_handler/connection_handler_per_thread.cc:302
#14 0x00000000050ac3c0 in pfs_spawn_thread (arg=0x7fce7906a6e0) at /sdc/MS-8.0.18_dbg/storage/perfschema/pfs.cc:2854
#15 0x00007fce7d092e65 in start_thread (arg=0x7fce647fe700) at pthread_create.c:307
#16 0x00007fce7afa788d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
(gdb)
How to repeat:
SET @@SESSION.optimizer_switch="derived_merge=off";
lock table mysql.user write;
SELECT * FROM information_schema.ST_GEOMETRY_COLUMNS;
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.