Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4886

[PS8QA] expand_fast_index_creation sig11 in opt, sig6 (Assertion failure: handler0alter.cc:1114:old_dd_tab != __null) on debug

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

          Activity

            People

              laurynas.biveinis Laurynas Biveinis (Inactive)
              roel.vandepaar Roel Van de Paar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 12 minutes
                  12m

                  Smart Checklist