Bug #118670 add partition crash

• Submitted: 16 Jul 9:23
• Reporter: Alice Alice
• Status: Open
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 8.0.41
• OS: Any
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[16 Jul 9:23] Alice Alice

Description:
do add partition crash:

error log:
/sda/percona//8.0_source/sql/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x2097a7e]
/sda/percona//8.0_source/sql/bin/mysqld(print_fatal_signal(int)+0x35f) [0xfdb1cf]
/sda/percona//8.0_source/sql/bin/mysqld(my_server_abort()+0x6e) [0xfdb30e]
/sda/percona//8.0_source/sql/bin/mysqld(my_abort()+0xa) [0x209214a]
/sda/percona//8.0_source/sql/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x312) [0x22a69c2]
/sda/percona//8.0_source/sql/bin/mysqld(dict_table_close(dict_table_t*, bool, bool)+0x288) [0x2366cc8]
/sda/percona//8.0_source/sql/bin/mysqld(dd_table_close(dict_table_t*, THD*, MDL_ticket**, bool)+0x18) [0x2371608]
/sda/percona//8.0_source/sql/bin/mysqld(Ha_innopart_share::close_table_parts(dict_table_t**, unsigned int)+0x33) [0x2102d93]
/sda/percona//8.0_source/sql/bin/mysqld(Ha_innopart_share::close_table_parts()+0x25) [0x2102dd5]
/sda/percona//8.0_source/sql/bin/mysqld(ha_innopart::close()+0x34) [0x21047c4]
/sda/percona//8.0_source/sql/bin/mysqld(closefrm(TABLE*, bool)+0x189) [0xf7ceb9]
/sda/percona//8.0_source/sql/bin/mysqld(intern_close_table(TABLE*)+0x3a) [0xdc9fea]
/sda/percona//8.0_source/sql/bin/mysqld() [0xdd1729]
/sda/percona//8.0_source/sql/bin/mysqld(close_thread_tables(THD*)+0x2cb) [0xdd1d5b]
/sda/percona//8.0_source/sql/bin/mysqld(mysql_execute_command(THD*, bool)+0xc84) [0xe771e4]
/sda/percona//8.0_source/sql/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x4f4) [0xe7acd4]
/sda/percona//8.0_source/sql/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0xd24) [0xe7bf94]
/sda/percona//8.0_source/sql/bin/mysqld(do_command(THD*)+0x1fe) [0xe7e39e]
/sda/percona//8.0_source/sql/bin/mysqld() [0xfcbca8]
/sda/percona//8.0_source/sql/bin/mysqld() [0x2710ec5]
/usr/lib64/libpthread.so.0(+0x8f3b) [0x7fed57b85f3b]
/usr/lib64/libc.so.6(clone+0x40) [0x7fed56d3b840]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fec54211fb0): ALTER TABLE tt_15_p ADD PARTITION PARTITIONS 2
Connection ID (thread ID): 55
Status: NOT_KILLED

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file

the stack:
#0  0x00007fed57b8d281 in pthread_kill () from /usr/lib64/libpthread.so.0
#1  0x0000000000fdb26d in handle_fatal_signal ()
#2  <signal handler called>
#3  0x00007fed56c7c78b in raise () from /usr/lib64/libc.so.6
#4  0x00007fed56c7dab1 in abort () from /usr/lib64/libc.so.6
#5  0x0000000000c81e01 in my_server_abort() [clone .cold] ()
#6  0x000000000209214a in my_abort() ()
#7  0x00000000022a69c2 in ut_dbg_assertion_failed(char const*, char const*, unsigned long) ()
#8  0x0000000002366cc8 in dict_table_close(dict_table_t*, bool, bool) ()
#9  0x0000000002371608 in dd_table_close(dict_table_t*, THD*, MDL_ticket**, bool) ()
#10 0x0000000002102d93 in Ha_innopart_share::close_table_parts(dict_table_t**, unsigned int) ()
#11 0x0000000002102dd5 in Ha_innopart_share::close_table_parts() ()
#12 0x00000000021047c4 in ha_innopart::close() ()
#13 0x0000000000f7ceb9 in closefrm(TABLE*, bool) ()
#14 0x0000000000dc9fea in intern_close_table(TABLE*) ()
#15 0x0000000000dd1729 in release_or_close_table(THD*, TABLE*) ()
#16 0x0000000000dd1d5b in close_thread_tables(THD*) ()
#17 0x0000000000e771e4 in mysql_execute_command(THD*, bool) ()
#18 0x0000000000e7acd4 in dispatch_sql_command(THD*, Parser_state*) ()
#19 0x0000000000e7bf94 in dispatch_command(THD*, COM_DATA const*, enum_server_command) ()
#20 0x0000000000e7e39e in do_command(THD*) ()
#21 0x0000000000fcbca8 in handle_connection ()
#22 0x0000000002710ec5 in pfs_spawn_thread ()
#23 0x00007fed57b85f3b in ?? () from /usr/lib64/libpthread.so.0
#24 0x00007fed56d3b840 in clone () from /usr/lib64/libc.so.6
(gdb) 

How to repeat:
Unclear

Suggested fix:
run pstress Occasionally occurs