| Bug #86293 | [ERROR] InnoDB: Assertion failure: pars0pars.cc:778:sym_node->table != NULL | ||
|---|---|---|---|
| Submitted: | 12 May 2017 5:32 | Modified: | 12 May 2017 11:22 |
| Reporter: | Roel Van de Paar | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S6 (Debug Builds) |
| Version: | 8.0.1 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | debug | ||
[12 May 2017 10:23]
Roel Van de Paar
Additional testcase & stack
DROP DATABASE test;
CREATE DATABASE pfscset_test;
ALTER TABLE mysql.innodb_index_stats RENAME TO mysql.innodb_index_stats_;
USE pfscset_test;
CREATE TABLE t1(c1 INT);
Core was generated by `/sda/MS120517-mysql-8.0.1-dmr-linux-x86_64-debug/bin/mysqld --no-defaults --cor'.
Program terminated with signal 6, Aborted.
#0 0x00007fa130bd2741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0 0x00007fa130bd2741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000002609fc9 in my_write_core (sig=6) at /git/mysql-8.0.1-dmr_dbg/mysys/stacktrace.cc:291
#2 0x0000000001d14c5c in handle_fatal_signal (sig=6) at /git/mysql-8.0.1-dmr_dbg/sql/signal_handler.cc:231
#3 <signal handler called>
#4 0x00007fa12ef661d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fa12ef678c8 in __GI_abort () at abort.c:90
#6 0x0000000002995cbe in ut_dbg_assertion_failed (expr=0x362a9ef "sym_node->table != NULL",
file=0x362a690 "/git/mysql-8.0.1-dmr_dbg/storage/innobase/pars/pars0pars.cc", line=778)
at /git/mysql-8.0.1-dmr_dbg/storage/innobase/ut/ut0dbg.cc:60
#7 0x000000000286ec57 in pars_retrieve_table_def (sym_node=0x7fa0e9d9c420)
at /git/mysql-8.0.1-dmr_dbg/storage/innobase/pars/pars0pars.cc:778
#8 0x000000000286f577 in pars_update_statement (node=0x7fa0e9d9c558, cursor_sym=0x0, search_cond=0x7fa0e9d9d298)
at /git/mysql-8.0.1-dmr_dbg/storage/innobase/pars/pars0pars.cc:1183
#9 0x0000000002b02294 in yyparse () at pars0grm.y:399
#10 0x0000000002870d01 in pars_sql (info=0x7fa0e9c7feb8,
str=0x36a3750 "PROCEDURE INDEX_STATS_SAVE () IS\nBEGIN\nDELETE FROM \"mysql/innodb_index_stats\"\nWHERE\ndatabase_name = :database_name AND\ntable_name = :table_name AND\nindex_name = :index_name AND\nstat_name = :stat_name;"...)
at /git/mysql-8.0.1-dmr_dbg/storage/innobase/pars/pars0pars.cc:2049
#11 0x0000000002875bed in que_eval_sql (info=0x7fa0e9c7feb8,
sql=0x36a3750 "PROCEDURE INDEX_STATS_SAVE () IS\nBEGIN\nDELETE FROM \"mysql/innodb_index_stats\"\nWHERE\ndatabase_name = :database_name AND\ntable_name = :table_name AND\nindex_name = :index_name AND\nstat_name = :stat_name;"..., reserve_dict_mutex=0,
trx=0x7fa11b001140) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/que/que0que.cc:1216
#12 0x0000000002a75ecc in dict_stats_exec_sql (pinfo=0x7fa0e9c7feb8,
sql=0x36a3750 "PROCEDURE INDEX_STATS_SAVE () IS\nBEGIN\nDELETE FROM \"mysql/innodb_index_stats\"\nWHERE\ndatabase_name = :database_name AND\ntable_name = :table_name AND\nindex_name = :index_name AND\nstat_name = :stat_name;"..., trx=0x7fa11b001140)
at /git/mysql-8.0.1-dmr_dbg/storage/innobase/dict/dict0stats.cc:204
#13 0x0000000002a79778 in dict_stats_save_index_stat (index=0x7fa0e9cf81d8, last_update=1494583045,
stat_name=0x7fa1311be1f0 "n_diff_pfx01", stat_value=0, sample_size=0x7fa0e9cc0b78, stat_description=0x7fa1311bddf0 "DB_ROW_ID",
trx=0x7fa11b001140) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/dict/dict0stats.cc:2232
#14 0x0000000002a79e3b in dict_stats_save (table_orig=0x7fa0e9ca4cb8, only_for_index=0x0)
at /git/mysql-8.0.1-dmr_dbg/storage/innobase/dict/dict0stats.cc:2399
#15 0x0000000002a7b21f in dict_stats_update (table=0x7fa0e9ca4cb8, stats_upd_option=DICT_STATS_EMPTY_TABLE)
at /git/mysql-8.0.1-dmr_dbg/storage/innobase/dict/dict0stats.cc:3001
#16 0x000000000276ec21 in create_table_info_t::create_table_update_dict (this=0x7fa1311be970)
at /git/mysql-8.0.1-dmr_dbg/storage/innobase/handler/ha_innodb.cc:12890
#17 0x000000000276f46d in ha_innobase::create (this=0x7fa0e9dd4030, name=0x7fa1311c1500 "./pfscset_test/t1", form=0x7fa1311bf570,
create_info=0x7fa1311c2480, table_def=0x7fa0e9cad3f8, file_per_table=true)
at /git/mysql-8.0.1-dmr_dbg/storage/innobase/handler/ha_innodb.cc:13048
#18 0x000000000276f61e in ha_innobase::create (this=0x7fa0e9dd4030, name=0x7fa1311c1500 "./pfscset_test/t1", form=0x7fa1311bf570,
create_info=0x7fa1311c2480, table_def=0x7fa0e9cad3f8) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/handler/ha_innodb.cc:13118
#19 0x0000000001e4f3aa in handler::ha_create (this=0x7fa0e9dd4030, name=0x7fa1311c1500 "./pfscset_test/t1", form=0x7fa1311bf570,
info=0x7fa1311c2480, table_def=0x7fa0e9cad3f8) at /git/mysql-8.0.1-dmr_dbg/sql/handler.cc:5227
#20 0x0000000001e4f964 in ha_create_table (thd=0x7fa0e9c19000, path=0x7fa1311c1500 "./pfscset_test/t1",
db=0x7fa0e9c31160 "pfscset_test", table_name=0x7fa0e9c30990 "t1", create_info=0x7fa1311c2480, update_create_info=false,
is_temp_table=false, table_def=0x7fa0e9cad3f8) at /git/mysql-8.0.1-dmr_dbg/sql/handler.cc:5390
#21 0x0000000001aa16b2 in rea_create_base_table (thd=0x7fa0e9c19000, path=0x7fa1311c1500 "./pfscset_test/t1",
db=0x7fa0e9c31160 "pfscset_test", table_name=0x7fa0e9c30990 "t1", create_info=0x7fa1311c2480, create_fields=..., keys=0,
key_info=0x7fa0e9c31620, keys_onoff=Alter_info::ENABLE, fk_keys=0, fk_key_info=0x7fa0e9c31620, file=0x7fa0e9d93030,
no_ha_table=false, part_info=0x0, binlog_to_trx_cache=0x7fa1311c243e, post_ddl_ht=0x7fa1311c2430)
at /git/mysql-8.0.1-dmr_dbg/sql/sql_table.cc:2283
#22 0x0000000001aadb04 in create_table_impl (thd=0x7fa0e9c19000, db=0x7fa0e9c31160 "pfscset_test", table_name=0x7fa0e9c30990 "t1",
error_table_name=0x7fa0e9c30990 "t1", path=0x7fa1311c1500 "./pfscset_test/t1", create_info=0x7fa1311c2480,
alter_info=0x7fa1311c2570, internal_tmp_table=false, select_field_count=0, no_ha_table=false, is_trans=0x7fa1311c243e,
key_info=0x7fa1311c1728, key_count=0x7fa1311c1724, keys_onoff=Alter_info::ENABLE, fk_key_info=0x7fa1311c1718,
fk_key_count=0x7fa1311c1714, existing_fk_info=0x0, existing_fk_count=0, tmp_table_def=0x7fa1311c1708, post_ddl_ht=0x7fa1311c2430)
at /git/mysql-8.0.1-dmr_dbg/sql/sql_table.cc:7577
#23 0x0000000001aae023 in mysql_create_table_no_lock (thd=0x7fa0e9c19000, db=0x7fa0e9c31160 "pfscset_test",
table_name=0x7fa0e9c30990 "t1", create_info=0x7fa1311c2480, alter_info=0x7fa1311c2570, select_field_count=0,
is_trans=0x7fa1311c243e, post_ddl_ht=0x7fa1311c2430) at /git/mysql-8.0.1-dmr_dbg/sql/sql_table.cc:7673
#24 0x0000000001aae1d1 in mysql_create_table (thd=0x7fa0e9c19000, create_table=0x7fa0e9c30be0, create_info=0x7fa1311c2480,
alter_info=0x7fa1311c2570) at /git/mysql-8.0.1-dmr_dbg/sql/sql_table.cc:7723
#25 0x0000000002011de8 in Sql_cmd_create_table::execute (this=0x7fa0e9c30bc0, thd=0x7fa0e9c19000)
at /git/mysql-8.0.1-dmr_dbg/sql/sql_cmd_ddl_table.cc:328
#26 0x0000000001a22100 in mysql_execute_command (thd=0x7fa0e9c19000, first_level=true)
at /git/mysql-8.0.1-dmr_dbg/sql/sql_parse.cc:3346
#27 0x0000000001a276ad in mysql_parse (thd=0x7fa0e9c19000, parser_state=0x7fa1311c4480)
at /git/mysql-8.0.1-dmr_dbg/sql/sql_parse.cc:5333
#28 0x0000000001a1dd3e in dispatch_command (thd=0x7fa0e9c19000, com_data=0x7fa1311c4c80, command=COM_QUERY)
at /git/mysql-8.0.1-dmr_dbg/sql/sql_parse.cc:1593
#29 0x0000000001a1cbc5 in do_command (thd=0x7fa0e9c19000) at /git/mysql-8.0.1-dmr_dbg/sql/sql_parse.cc:1180
#30 0x0000000001d06d36 in handle_connection (arg=0x7fa11ff4e400)
at /git/mysql-8.0.1-dmr_dbg/sql/conn_handler/connection_handler_per_thread.cc:322
#31 0x000000000263cdae in pfs_spawn_thread (arg=0x7fa0e9695f20) at /git/mysql-8.0.1-dmr_dbg/storage/perfschema/pfs.cc:2407
#32 0x00007fa130bcddc5 in start_thread (arg=0x7fa1311c5700) at pthread_create.c:308
#33 0x00007fa12f02873d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
[12 May 2017 11:22]
MySQL Verification Team
Thank you for the bug report. Not repeatable with most recent source server: c:\dbs>8.0\bin\mysql -uroot -p Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 8.0.1-dmr-debug MySQL Community Server - Debug (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> DROP DATABASE test; ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist mysql> CREATE DATABASE d0; Query OK, 1 row affected (0.11 sec) mysql> create table d0.t0(a int key)engine=InnoDB; Query OK, 0 rows affected (0.32 sec) mysql> ALTER TABLE mysql.innodb_index_stats RENAME TO mysql.innodb_index_stats_; Query OK, 0 rows affected (0.18 sec) mysql> drop database if exists d0; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> 2017-05-12T11:09:49.717078Z 0 [Note] bin\mysqld-debug.exe: ready for connections. Version: '8.0.1-dmr-debug' socket: '' port: 3306 MySQL Community Server - Debug (GPL) 2017-05-12T11:11:26.520577Z 5 [ERROR] InnoDB: Assertion failure: pars0pars.cc:778:sym_node->table != NULL InnoDB: thread 9284 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. abort() has been called11:11:26 UTC - mysqld got exception 0x80000003 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68074 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x17a0f2254d0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... 7ff6910bef45 mysqld-debug.exe!my_sigabrt_handler()[my_thr_init.cc:474] 7ffa42671c01 ucrtbased.dll!raise() 7ffa426737d9 ucrtbased.dll!abort() 7ff691362624 mysqld-debug.exe!ut_dbg_assertion_failed()[ut0dbg.cc:61] 7ff691630a33 mysqld-debug.exe!pars_retrieve_table_def()[pars0pars.cc:778] 7ff69162c8dc mysqld-debug.exe!pars_update_statement()[pars0pars.cc:1184] 7ff6916f2e4d mysqld-debug.exe!yyparse()[pars0grm.y:396] 7ff69162b4ad mysqld-debug.exe!pars_sql()[pars0pars.cc:2051] 7ff691610dec mysqld-debug.exe!que_eval_sql()[que0que.cc:1216] 7ff691506fd7 mysqld-debug.exe!dict_stats_exec_sql()[dict0stats.cc:204] 7ff69150dca2 mysqld-debug.exe!dict_stats_delete_from_index_stats()[dict0stats.cc:3247] 7ff691501c05 mysqld-debug.exe!dict_stats_drop_table()[dict0stats.cc:3299] 7ff6914ed0ee mysqld-debug.exe!row_drop_table_for_mysql()[row0mysql.cc:4348] 7ff691169c86 mysqld-debug.exe!ha_innobase::delete_table()[ha_innodb.cc:13483] 7ff69116974a mysqld-debug.exe!ha_innobase::delete_table()[ha_innodb.cc:13391] 7ff68fc9c4a9 mysqld-debug.exe!handler::ha_delete_table()[handler.cc:5195] 7ff68fca73fb mysqld-debug.exe!ha_delete_table()[handler.cc:2656] 7ff68ff50e15 mysqld-debug.exe!drop_base_table()[sql_table.cc:3620] 7ff68ff40e7d mysqld-debug.exe!mysql_rm_table_no_locks()[sql_table.cc:3974] 7ff6902bf979 mysqld-debug.exe!mysql_rm_db()[sql_db.cc:635] 7ff68ff1a57f mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:3607] 7ff68ff166f3 mysqld-debug.exe!mysql_parse()[sql_parse.cc:5333] 7ff68ff2039b mysqld-debug.exe!dispatch_command()[sql_parse.cc:1595] 7ff68ff1f086 mysqld-debug.exe!do_command()[sql_parse.cc:1180] 7ff68fc3bdaa mysqld-debug.exe!handle_connection()[connection_handler_per_thread.cc:322] 7ff6917bb372 mysqld-debug.exe!pfs_spawn_thread()[pfs.cc:2409] 7ff6910bd8a7 mysqld-debug.exe!win_thread_start()[my_thread.cc:42] 7ffa4267b0a8 ucrtbased.dll!_register_onexit_function() 7ffa4267ad31 ucrtbased.dll!_register_onexit_function() 7ffa6af18364 KERNEL32.DLL!BaseThreadInitThunk() 7ffa6c2f70d1 ntdll.dll!RtlUserThreadStart() Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (17a0f32b280): drop database if exists d0 Connection ID (thread ID): 5 Status: NOT_KILLED c:\dbs>c:\dbs\8.0\bin\mysql -uroot --port=3580 -p --prompt="mysql 8.0 > " Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 8.0.2-dmr-debug Source distribution 2017-apr-19 Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 8.0 > DROP DATABASE test; ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist mysql 8.0 > CREATE DATABASE d0; Query OK, 1 row affected (0.09 sec) mysql 8.0 > create table d0.t0(a int key)engine=InnoDB; Query OK, 0 rows affected (0.39 sec) mysql 8.0 > ALTER TABLE mysql.innodb_index_stats RENAME TO mysql.innodb_index_stats_; ERROR 1148 (42000): The used command is not allowed with this MySQL version mysql 8.0 > drop database if exists d0; Query OK, 1 row affected (0.50 sec) mysql 8.0 >
[12 May 2017 11:24]
MySQL Verification Team
c:\dbs>c:\dbs\8.0\bin\mysql -uroot --port=3580 -p --prompt="mysql 8.0 > " Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 8.0.2-dmr-debug Source distribution 2017-apr-19 Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 8.0 > DROP DATABASE test; ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist mysql 8.0 > CREATE DATABASE pfscset_test; Query OK, 1 row affected (0.10 sec) mysql 8.0 > ALTER TABLE mysql.innodb_index_stats RENAME TO mysql.innodb_index_stats_; ERROR 1148 (42000): The used command is not allowed with this MySQL version mysql 8.0 > USE pfscset_test; Database changed mysql 8.0 > CREATE TABLE t1(c1 INT); Query OK, 0 rows affected (0.51 sec) mysql 8.0 >
[23 Nov 2023 8:18]
Fan Lyu
we still meet this full text bug at least by 8.0.28.
SQL is SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_BEING_DELETED
stack belike:
(gdb) bt
#0 0x0000ffffa45daa40 in pthread_kill () from /usr/lib64/libpthread.so.0
#1 0x00000000020e255c in my_write_core (sig=<optimized out>) at ../../../include/my_thread.h:78
#2 0x0000000000deb7ec in handle_fatal_signal (sig=6) at ../../../sql/signal_handler.cc:211
#3 <signal handler called>
#4 0x0000ffffa404a470 in raise () from /usr/lib64/libc.so.6
#5 0x0000ffffa404b81c in abort () from /usr/lib64/libc.so.6
#6 0x0000000000deb984 in my_server_abort () at ../../../sql/signal_handler.cc:267
#7 0x00000000020de094 in my_abort () at ../../../mysys/my_init.cc:259
#8 0x00000000023a75b0 in ut_dbg_assertion_failed (expr=expr@entry=0x3414608 "sym_node->table != nullptr",
file=file@entry=0x3414368 "../../../../storage/innobase/pars/pars0pars.cc", line=line@entry=733) at ../../../../storage/innobase/ut/ut0dbg.cc:99
#9 0x00000000023033b4 in pars_retrieve_table_def (sym_node=0xffff628e84c8) at ../../../../storage/innobase/pars/pars0pars.cc:733
#10 pars_retrieve_table_def (sym_node=0xffff628e84c8) at ../../../../storage/innobase/pars/pars0pars.cc:711
#11 0x0000000002303474 in pars_retrieve_table_list_defs (sym_node=0xffff628e84c8) at ../../../../storage/innobase/pars/pars0pars.cc:749
#12 pars_select_statement (select_node=0xffff628e83e8, table_list=0xffff628e84c8, search_cond=0x0, for_update=0x0, lock_shared=0x0, order_by=0x0)
at ../../../../storage/innobase/pars/pars0pars.cc:859
#13 0x0000000000b9cab0 in yyparse () at pars0grm.y:319
#14 0x0000000002302850 in pars_sql (info=info@entry=0xffff5e4aff88,
str=str@entry=0xffff29d3bb20 "PROCEDURE P() IS\nDECLARE FUNCTION my_func;\nDECLARE CURSOR c IS SELECT doc_id FROM $table_name;\nBEGIN\n\nOPEN c;\nWHILE 1 = 1 LOOP\n FETCH c INTO my_func();\n IF c % NOTFOUND THEN\n EXIT;\n END IF;\nEND "...) at ../../../../storage/innobase/pars/pars0pars.cc:1731
#15 0x000000000253c208 in fts_parse_sql (fts_table=fts_table@entry=0xffff62dfa8a0, info=info@entry=0xffff5e4aff88,
sql=sql@entry=0x3439bf8 "DECLARE FUNCTION my_func;\nDECLARE CURSOR c IS SELECT doc_id FROM $table_name;\nBEGIN\n\nOPEN c;\nWHILE 1 = 1 LOOP\n FETCH c INTO my_func();\n IF c % NOTFOUND THEN\n EXIT;\n END IF;\nEND LOOP;\nCLOSE c;") at ../../../../storage/innobase/fts/fts0sql.cc:232
#16 0x000000000252c5d8 in fts_table_fetch_doc_ids (trx=trx@entry=0xffff8ba04598, fts_table=fts_table@entry=0xffff62dfa8a0, doc_ids=doc_ids@entry=0xffff5e4afc88)
at ../../../../storage/innobase/fts/fts0opt.cc:928
#17 0x0000000002274fa8 in i_s_fts_deleted_generic_fill (thd=0xffff92155000, being_deleted=<optimized out>, tables=<optimized out>, tables=<optimized out>)
at ../../../../storage/innobase/handler/i_s.cc:2633
#18 0x0000000000d20618 in do_fill_information_schema_table (thd=0xffff92155000, table_list=0xffff287bf430, condition=0x0) at ../../../sql/sql_show.cc:4759
#19 0x00000000011d3288 in MaterializeInformationSchemaTableIterator::Init (this=0xffff287c5010) at ../../../sql/iterators/row_iterator.h:195
#20 0x0000000000adbcd8 in MaterializeIterator::MaterializeQueryBlock (this=0xffff287c5038, query_block=..., stored_rows=0xffff62dfafd0)
at /opt/hw/gcc-10.3/include/c++/10/bits/unique_ptr.h:421
#21 0x00000000011d3588 in MaterializeIterator::Init (this=0xffff287c5038) at ../../../sql/iterators/composite_iterators.cc:660
#22 0x00000000011d3e60 in LimitOffsetIterator::Init (this=0xffff287c50d0) at /opt/hw/gcc-10.3/include/c++/10/bits/unique_ptr.h:421
#23 0x0000000000a7576c in Query_expression::ExecuteIteratorQuery (this=0xffff287bddb8, thd=0xffff92155000) at ../../../sql/sql_union.cc:1177
#24 0x0000000000a75334 in Query_expression::execute (this=this@entry=0xffff287bddb8, thd=thd@entry=0xffff92155000) at ../../../sql/sql_union.cc:1353
#25 0x0000000000a67c24 in Sql_cmd_dml::execute_inner (thd=0xffff92155000, this=0xffff287bfeb0) at ../../../sql/sql_select.cc:786
#26 Sql_cmd_dml::execute (this=0xffff287bfeb0, thd=0xffff92155000) at ../../../sql/sql_select.cc:586
#27 0x0000000000a58aec in mysql_execute_command (thd=0xffff92155000, first_level=false) at ../../../sql/sql_parse.cc:4945
#28 0x0000000000a5e3e0 in dispatch_sql_command (thd=0xffff92155000, parser_state=<optimized out>) at ../../../sql/sql_parse.cc:5597
#29 0x0000000000a5f8d0 in dispatch_command (thd=0xffff92155000, com_data=<optimized out>, command=COM_QUERY) at ../../../sql/sql_parse.cc:2141
#30 0x0000000000a5ef4c in do_command (thd=thd@entry=0xffff92155000) at ../../../sql/sql_parse.cc:1367
#31 0x0000000000bae960 in threadpool_process_request (thd=0xffff92155000) at ../../../../plugin/threadpool/threadpool_common.cc:242
--Type <RET> for more, q to quit, c to continue without paging--
#32 0x0000000000baf398 in handle_event (connection=0xffff9383b7a8) at ../../../../plugin/threadpool/threadpool_unix.cc:1578
#33 worker_main (param=param@entry=0x50c1c00 <all_groups+7168>) at ../../../../plugin/threadpool/threadpool_unix.cc:1624
#34 0x000000000262f684 in pfs_spawn_thread (arg=0xffffa3c4a168) at ../../../../storage/perfschema/pfs.cc:2948
#35 0x0000ffffa45d37ac in ?? () from /usr/lib64/libpthread.so.0
#36 0x0000ffffa40e947c in ?? () from /usr/lib64/libc.so.6
[23 Nov 2023 8:40]
MySQL Verification Team
This bug report relies on unsupported behaviour: ALTER TABLE mysql.innodb_index_stats RENAME TO mysql.innodb_index_stats_; Modifying system table structures is not supported. Please don't do it.
Description: Version: '8.0.1-dmr-debug' socket: '/sda/MS120517-mysql-8.0.1-dmr-linux-x86_64-debug/socket.sock' port: 12055 MySQL Community Server (GPL) 2017-05-12T04:56:53.773314Z 3 [ERROR] InnoDB: Assertion failure: pars0pars.cc:778:sym_node->table != NULL InnoDB: thread 140149099603712 InnoDB: We intentionally generate a memory trap. Core was generated by `/sda/MS120517-mysql-8.0.1-dmr-linux-x86_64-debug/bin/mysqld --no-defaults --cor'. Program terminated with signal 6, Aborted. #0 0x00007f7700ecf741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid), (gdb) bt #0 0x00007f7700ecf741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 #1 0x0000000002609fc9 in my_write_core (sig=6) at /git/mysql-8.0.1-dmr_dbg/mysys/stacktrace.cc:291 #2 0x0000000001d14c5c in handle_fatal_signal (sig=6) at /git/mysql-8.0.1-dmr_dbg/sql/signal_handler.cc:231 #3 <signal handler called> #4 0x00007f76ff2631d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #5 0x00007f76ff2648c8 in __GI_abort () at abort.c:90 #6 0x0000000002995cbe in ut_dbg_assertion_failed (expr=0x362a9ef "sym_node->table != NULL", file=0x362a690 "/git/mysql-8.0.1-dmr_dbg/storage/innobase/pars/pars0pars.cc", line=778) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/ut/ut0dbg.cc:60 #7 0x000000000286ec57 in pars_retrieve_table_def (sym_node=0x7f76b9e20348) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/pars/pars0pars.cc:778 #8 0x000000000286f577 in pars_update_statement (node=0x7f76b9e20480, cursor_sym=0x0, search_cond=0x7f76b9e20b40) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/pars/pars0pars.cc:1183 #9 0x0000000002b02294 in yyparse () at pars0grm.y:399 #10 0x0000000002870d01 in pars_sql (info=0x7f76b9c807b8, str=0x36a45c0 "PROCEDURE DELETE_FROM_INDEX_STATS () IS\nBEGIN\nDELETE FROM \"mysql/innodb_index_stats\" WHERE\ndatabase_name = :database_name AND\ntable_name = :table_name;\nEND;\n") at /git/mysql-8.0.1-dmr_dbg/storage/innobase/pars/pars0pars.cc:2049 #11 0x0000000002875bed in que_eval_sql (info=0x7f76b9c807b8, sql=0x36a45c0 "PROCEDURE DELETE_FROM_INDEX_STATS () IS\nBEGIN\nDELETE FROM \"mysql/innodb_index_stats\" WHERE\ndatabase_name = :database_name AND\ntable_name = :table_name;\nEND;\n", reserve_dict_mutex=0, trx=0x7f76eb401140) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/que/que0que.cc:1216 #12 0x0000000002a75ecc in dict_stats_exec_sql (pinfo=0x7f76b9c807b8, sql=0x36a45c0 "PROCEDURE DELETE_FROM_INDEX_STATS () IS\nBEGIN\nDELETE FROM \"mysql/innodb_index_stats\" WHERE\ndatabase_name = :database_name AND\ntable_name = :table_name;\nEND;\n", trx=0x7f76eb401140) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/dict/dict0stats.cc:204 #13 0x0000000002a7ba14 in dict_stats_delete_from_index_stats (database_name=0x7f77014ba7a0 "d0", table_name=0x7f77014ba870 "t0") at /git/mysql-8.0.1-dmr_dbg/storage/innobase/dict/dict0stats.cc:3254 #14 0x0000000002a7bb7f in dict_stats_drop_table (db_and_table=0x7f77014bb5e0 "d0/t0", errstr=0x7f77014bab10 "", errstr_sz=1024) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/dict/dict0stats.cc:3299 #15 0x00000000028cd5cb in row_drop_table_for_mysql (name=0x7f77014bb5e0 "d0/t0", trx=0x7f76eb400cf8, sqlcom=SQLCOM_DROP_DB, nonatomic=true, handler=0x0) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/row/row0mysql.cc:4348 #16 0x000000000277069a in ha_innobase::delete_table (this=0x7f76b9d92030, name=0x7f77014bccb0 "./d0/t0", table_def=0x7f76b9cad3f8, sqlcom=SQLCOM_DROP_DB) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/handler/ha_innodb.cc:13484 #17 0x0000000002770339 in ha_innobase::delete_table (this=0x7f76b9d92030, name=0x7f77014bccb0 "./d0/t0", table_def=0x7f76b9cad3f8) at /git/mysql-8.0.1-dmr_dbg/storage/innobase/handler/ha_innodb.cc:13390 #18 0x0000000001e4f2bf in handler::ha_delete_table (this=0x7f76b9d92030, name=0x7f77014bccb0 "./d0/t0", table_def=0x7f76b9cad3f8) at /git/mysql-8.0.1-dmr_dbg/sql/handler.cc:5194 #19 0x0000000001e481b0 in ha_delete_table (thd=0x7f76b9c19000, table_type=0x7f76fd40ed20, path=0x7f77014bccb0 "./d0/t0", db=0x7f76b9c310c8 "d0", alias=0x7f76b9c310d0 "t0", table_def=0x7f76b9cad3f8, generate_warning=false) at /git/mysql-8.0.1-dmr_dbg/sql/handler.cc:2656 #20 0x0000000001aa3d19 in drop_base_table (thd=0x7f76b9c19000, drop_ctx=..., table=0x7f76b9c30b48, atomic=true, post_ddl_htons=0x7f77014beda0) at /git/mysql-8.0.1-dmr_dbg/sql/sql_table.cc:3621 #21 0x0000000001aa4924 in mysql_rm_table_no_locks (thd=0x7f76b9c19000, tables=0x7f76b9c30b48, if_exists=true, drop_temporary=false, drop_database=true, dropped_non_atomic_flag=0x7f77014c026f, post_ddl_htons=0x7f77014beda0, dropped_atomic=0x7f77014bed70) at /git/mysql-8.0.1-dmr_dbg/sql/sql_table.cc:3974 #22 0x00000000019c7639 in mysql_rm_db (thd=0x7f76b9c19000, db=..., if_exists=true) at /git/mysql-8.0.1-dmr_dbg/sql/sql_db.cc:637 #23 0x0000000001a22d50 in mysql_execute_command (thd=0x7f76b9c19000, first_level=true) at /git/mysql-8.0.1-dmr_dbg/sql/sql_parse.cc:3607 #24 0x0000000001a276ad in mysql_parse (thd=0x7f76b9c19000, parser_state=0x7f77014c1480) at /git/mysql-8.0.1-dmr_dbg/sql/sql_parse.cc:5333 #25 0x0000000001a1dd3e in dispatch_command (thd=0x7f76b9c19000, com_data=0x7f77014c1c80, command=COM_QUERY) at /git/mysql-8.0.1-dmr_dbg/sql/sql_parse.cc:1593 #26 0x0000000001a1cbc5 in do_command (thd=0x7f76b9c19000) at /git/mysql-8.0.1-dmr_dbg/sql/sql_parse.cc:1180 #27 0x0000000001d06d36 in handle_connection (arg=0x7f76f034e400) at /git/mysql-8.0.1-dmr_dbg/sql/conn_handler/connection_handler_per_thread.cc:322 #28 0x000000000263cdae in pfs_spawn_thread (arg=0x7f76b9695f20) at /git/mysql-8.0.1-dmr_dbg/storage/perfschema/pfs.cc:2407 #29 0x00007f7700ecadc5 in start_thread (arg=0x7f77014c2700) at pthread_create.c:308 #30 0x00007f76ff32573d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113 How to repeat: DROP DATABASE test; CREATE DATABASE d0; create table d0.t0(a int key)engine=InnoDB; ALTER TABLE mysql.innodb_index_stats RENAME TO mysql.innodb_index_stats_; drop database if exists d0;