Details
-
Bug
-
Status: Done
-
Critical
-
Resolution: Duplicate
-
None
-
None
-
None
-
None
Description
CREATE DATABASE test; USE test; SET SESSION expand_fast_index_creation=ON; CREATE TEMPORARY TABLE t0(c0 INT); ALTER TABLE t0 ADD KEY i0(c0);
Leads to:
2018-09-22T04:13:53.817388Z 0 [System] [MY-010931] [Server] /sda/PS190918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld: ready for connections. Version: '8.0.12-1-debug' socket: '/sda/PS190918-percona-server-8.0.12-1-linux-x86_64-debug/socket.sock' port: 11954 MySQL Community Server (GPL). 2018-09-22T04:13:59.249728Z 8 [ERROR] [MY-000000] [InnoDB] InnoDB: Assertion failure: handler0alter.cc:1114:old_dd_tab != __null Core was generated by `/sda/PS190918-percona-server-8.0.12-1-linux-x86_64-debug/bin/mysqld --no-defaul'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 [Current thread is 1 (Thread 0x7fe1a75a6700 (LWP 19194))] (gdb) bt #0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x0000559a9a5bc431 in my_write_core (sig=6) at /git/PS-8.0.12_dbg/mysys/stacktrace.cc:278 #2 0x0000559a99303933 in handle_fatal_signal (sig=6) at /git/PS-8.0.12_dbg/sql/signal_handler.cc:254 #3 <signal handler called> #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51 #5 0x00007fe1a75e7801 in __GI_abort () at abort.c:79 #6 0x0000559a9aa792d1 in ut_dbg_assertion_failed (expr=0x559a9bc462e1 "old_dd_tab != __null", file=0x559a9bc45f40 "/git/PS-8.0.12_dbg/storage/innobase/handler/handler0alter.cc", line=1114) at /git/PS-8.0.12_dbg/storage/innobase/ut/ut0dbg.cc:90 #7 0x0000559a9a8062bd in ha_innobase::prepare_inplace_alter_table (this=0x7fe174146028, altered_table=0x7fe1740c2a20, ha_alter_info=0x7fe1a759fa20, old_dd_tab=0x0, new_dd_tab=0x7fe174079a78) at /git/PS-8.0.12_dbg/storage/innobase/handler/handler0alter.cc:1114 #8 0x0000559a9948ff7c in handler::ha_prepare_inplace_alter_table (this=0x7fe174146028, altered_table=0x7fe1740c2a20, ha_alter_info=0x7fe1a759fa20, old_table_def=0x0, new_table_def=0x7fe174079a78) at /git/PS-8.0.12_dbg/sql/handler.cc:4791 #9 0x0000559a99207e6e in remove_secondary_keys (thd=0x7fe174024000, create_info=0x7fe1a75a3720, table=0x7fe1740c2a20, alter_info=0x7fe1a75a3820, table_def=0x0, altered_table_def=0x7fe174079a78) at /git/PS-8.0.12_dbg/sql/sql_table.cc:12851 #10 0x0000559a9920c544 in mysql_alter_table (thd=0x7fe174024000, new_db=0x7fe1740e9380 "test", new_name=0x0, create_info=0x7fe1a75a3720, table_list=0x7fe1740e8df8, alter_info=0x7fe1a75a3820) at /git/PS-8.0.12_dbg/sql/sql_table.cc:14316 #11 0x0000559a996e90a8 in Sql_cmd_alter_table::execute (this=0x7fe1740e94b0, thd=0x7fe174024000) at /git/PS-8.0.12_dbg/sql/sql_alter.cc:350 #12 0x0000559a9914b5df in mysql_execute_command (thd=0x7fe174024000, first_level=true) at /git/PS-8.0.12_dbg/sql/sql_parse.cc:4417 #13 0x0000559a9914dbdd in mysql_parse (thd=0x7fe174024000, parser_state=0x7fe1a75a52a0, update_userstat=false) at /git/PS-8.0.12_dbg/sql/sql_parse.cc:5139 #14 0x0000559a99142d69 in dispatch_command (thd=0x7fe174024000, com_data=0x7fe1a75a5c70, command=COM_QUERY) at /git/PS-8.0.12_dbg/sql/sql_parse.cc:1654 #15 0x0000559a99141558 in do_command (thd=0x7fe174024000) at /git/PS-8.0.12_dbg/sql/sql_parse.cc:1262 #16 0x0000559a992f0156 in handle_connection (arg=0x7fe11dc259d0) at /git/PS-8.0.12_dbg/sql/conn_handler/connection_handler_per_thread.cc:317 #17 0x0000559a9a6adb76 in pfs_spawn_thread (arg=0x7fe1564a1420) at /git/PS-8.0.12_dbg/storage/perfschema/pfs.cc:2836 #18 0x00007fe1a91f06db in start_thread (arg=0x7fe1a75a6700) at pthread_create.c:463 #19 0x00007fe1a76c888f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
On PS 8.0.12 debug, and leads to:
2018-09-22T04:16:35.965143Z 0 [System] [MY-010931] [Server] /sda/PS190918-percona-server-8.0.12-1-linux-x86_64-opt/bin/mysqld: ready for connections. Version: '8.0.12-1' socket: '/sda/PS190918-percona-server-8.0.12-1-linux-x86_64-opt/socket.sock' port: 10875 MySQL Community Server (GPL). 04:16:44 UTC - mysqld got signal 11 ; Core was generated by `/sda/PS190918-percona-server-8.0.12-1-linux-x86_64-opt/bin/mysqld --no-defaults'. Program terminated with signal SIGSEGV, Segmentation fault. #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 57 [Current thread is 1 (Thread 0x7f918c280700 (LWP 27786))] (gdb) bt #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x0000559da1c13307 in my_write_core (sig=sig@entry=11) at stacktrace.cc:278 #2 0x0000559da0de9b25 in handle_fatal_signal (sig=11) at signal_handler.cc:254 #3 <signal handler called> #4 dd_table_has_instant_cols (table=...) at include/dict0dd.h:349 #5 0x0000559da1dc7162 in dd_commit_inplace_update_instant_meta (table=table@entry=0x7f910aceb888, old_dd_tab=old_dd_tab@entry=0x0, new_dd_tab=new_dd_tab@entry=0x7f910ac6fa78) at handler/handler0alter.cc:3785 #6 0x0000559da1dd5626 in ha_innobase::commit_inplace_alter_table (this=0x7f910ad44028, altered_table=<optimized out>, ha_alter_info=<optimized out>, commit=<optimized out>, old_dd_tab=0x0, new_dd_tab=0x7f910ac6fa78) at handler/handler0alter.cc:1229 #7 0x0000559da0d53f9a in remove_secondary_keys (alter_info=0x7f918c27d5f0, alter_info=0x7f918c27d5f0, altered_table_def=0x7f910ac6fa78, table_def=0x0, table=<optimized out>, create_info=0x7f918c27d4f0, thd=0x7f910ac17000) at sql_table.cc:12855 #8 mysql_alter_table (thd=thd@entry=0x7f910ac17000, new_db=<optimized out>, new_name=<optimized out>, create_info=create_info@entry=0x7f918c27d4f0, table_list=<optimized out>, table_list@entry=0x7f910acd9df8, alter_info=alter_info@entry=0x7f918c27d5f0) at sql_table.cc:14316 #9 0x0000559da10a3e74 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7f910ac17000) at sql_alter.cc:350 #10 0x0000559da0cbed75 in mysql_execute_command (thd=thd@entry=0x7f910ac17000, first_level=first_level@entry=true) at sql_parse.cc:4417 #11 0x0000559da0cc314b in mysql_parse (thd=thd@entry=0x7f910ac17000, parser_state=parser_state@entry=0x7f918c27ed40, update_userstat=update_userstat@entry=false) at sql_parse.cc:5139 #12 0x0000559da0cc5f12 in dispatch_command (thd=thd@entry=0x7f910ac17000, com_data=com_data@entry=0x7f918c27fc60, command=COM_QUERY) at sql_parse.cc:1654 #13 0x0000559da0cc6c49 in do_command (thd=thd@entry=0x7f910ac17000) at sql_parse.cc:1262 #14 0x0000559da0ddb1c0 in handle_connection (arg=arg@entry=0x7f910a45f730) at conn_handler/connection_handler_per_thread.cc:317 #15 0x0000559da1cdbcaf in pfs_spawn_thread (arg=0x7f9143bd4a20) at pfs.cc:2836 #16 0x00007f918deca6db in start_thread (arg=0x7f918c280700) at pthread_create.c:463 #17 0x00007f918c3a288f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
On PS 8.0.12 optimized.
Attachments
Issue Links
- duplicates
-
PS-4892 Re-implement expanded fast index creation in 8.0 DD
-
- Done
-