Assertion `!table->part_info' failed in bool open_temporary_table(THD*, TABLE_LIST*)
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:
Kathy Williamson April 22, 2020 at 11:51 AM
MySQL 5.6 is scheduled for EOL in Feb 2021. At this time, we do not believe that this issue will be fixed prior to EOL. If you believe this issue is important enough to be be fixed prior to EOL, or that it also affects a later version, please leave a comment and we will consider the new information.
KennT March 31, 2017 at 12:13 AM
It looks like there is a temporary table that is partitioned. Not sure how it is getting here.
The error occurs here:
#ifdef WITH_PARTITION_STORAGE_ENGINE
if (tl->partition_names)
{
/* Partitioned temporary tables is not supported. */
DBUG_ASSERT(!table->part_info);
my_error(ER_PARTITION_CLAUSE_ON_NONPARTITIONED, MYF(0));
DBUG_RETURN(true);
}
#endif
Won't Do
Details
Details
Assignee
KennT
KennT(Deactivated)Reporter
Ramesh Sivaraman
Ramesh Sivaraman(Deactivated)Labels
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created March 29, 2017 at 12:14 PM
Updated March 6, 2024 at 11:22 PM
Resolved April 22, 2020 at 11:51 AM
GDB info
#0 0x00007ff0dc3a3771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 #1 0x0000000000af8484 in my_write_core (sig=6) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/mysys/stacktrace.c:424 #2 0x000000000075bf72 in handle_fatal_signal (sig=6) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/signal_handler.cc:248 #3 <signal handler called> #4 0x00007ff0da52b5d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #5 0x00007ff0da52ccc8 in __GI_abort () at abort.c:90 #6 0x00007ff0da524546 in __assert_fail_base (fmt=0x7ff0da674128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xf0b748 "!table->part_info", file=file@entry=0xf0a168 "/ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_base.cc", line=line@entry=6644, function=function@entry=0xf0d380 <open_temporary_table(THD*, TABLE_LIST*)::__PRETTY_FUNCTION__> "bool open_temporary_table(THD*, TABLE_LIST*)") at assert.c:92 #7 0x00007ff0da5245f2 in __GI___assert_fail (assertion=0xf0b748 "!table->part_info", file=0xf0a168 "/ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_base.cc", line=6644, function=0xf0d380 <open_temporary_table(THD*, TABLE_LIST*)::__PRETTY_FUNCTION__> "bool open_temporary_table(THD*, TABLE_LIST*)") at assert.c:101 #8 0x00000000007a41d0 in open_temporary_table (thd=0x7ff0b335f000, tl=0x7ff0ab81f270) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_base.cc:6644 #9 0x00000000007a43df in open_temporary_tables (thd=0x7ff0b335f000, tl_list=0x7ff0ab81f270) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_base.cc:6708 #10 0x00000000008134df in mysql_execute_command (thd=0x7ff0b335f000) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:3327 #11 0x00000000008218c9 in mysql_parse (thd=0x7ff0b335f000, rawbuf=0x7ff0ab81f010 "SELECT * FROM t1 PARTITION (p2)", length=32, parser_state=0x7ff0dc8c64b0) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:7922 #12 0x0000000000820b4e in wsrep_mysql_parse (thd=0x7ff0b335f000, rawbuf=0x7ff0ab81f010 "SELECT * FROM t1 PARTITION (p2)", length=32, parser_state=0x7ff0dc8c64b0) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:7622 #13 0x000000000080f940 in dispatch_command (command=COM_QUERY, thd=0x7ff0b335f000, packet=0x7ff0b3363001 "SELECT * FROM t1 PARTITION (p2);", packet_length=33) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:1739 #14 0x000000000080dedd in do_command (thd=0x7ff0b335f000) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_parse.cc:1186 #15 0x00000000007d4627 in do_handle_one_connection (thd_arg=0x7ff0d4371000) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_connect.cc:1580 #16 0x00000000007d431b in handle_one_connection (arg=0x7ff0d4371000) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/sql/sql_connect.cc:1477 #17 0x0000000000b40fb1 in pfs_spawn_thread (arg=0x7ff0c2f6a5c0) at /ssd/ramesh/perf/qa/percona-xtradb-cluster/storage/perfschema/pfs.cc:1860 #18 0x00007ff0dc39edf5 in start_thread (arg=0x7ff0dc8c7700) at pthread_create.c:308 #19 0x00007ff0da5ec1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113