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

Assertion failure: handler0alter.cc:3703:table->has_instant_cols()

    XMLWordPrintable

    Details

      Description

      # mysqld options required for replay:  --expand_fast_index_creation=ON
      CREATE DATABASE test;
      USE test;
      CREATE TABLE t1(c1 CHAR (1));
      ALTER TABLE t1 ADD COLUMN c2 INT;
      ALTER TABLE t1 CHANGE c1 c1 BLOB;
      ALTER TABLE t1 ADD INDEX(c1(1));
      ALTER TABLE t1 ADD c4 BLOB AFTER c2;
      ALTER TABLE t1 CHANGE c1 c1 NUMERIC UNSIGNED;

      Leads to;

      Core was generated by `/sda/PS050219-percona-server-8.0.13-4-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 0x7f52d684a700 (LWP 31733))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x000055cd674131db in my_write_core (sig=6) at /git/PS-8.0-trunk_dbg/mysys/stacktrace.cc:278
      #2  0x000055cd662c959a in handle_fatal_signal (sig=6) at /git/PS-8.0-trunk_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  0x00007f52d688b801 in __GI_abort () at abort.c:79
      #6  0x000055cd678ee2ce in ut_dbg_assertion_failed (expr=0x55cd68b5e8d6 "table->has_instant_cols()", 
          file=0x55cd68b5da18 "/git/PS-8.0-trunk_dbg/storage/innobase/handler/handler0alter.cc", line=3703)
          at /git/PS-8.0-trunk_dbg/storage/innobase/ut/ut0dbg.cc:90
      #7  0x000055cd6766c3f1 in dd_commit_inplace_update_instant_meta (table=0x7f52a42068b8, old_dd_tab=0x7f52a426ab88, 
          new_dd_tab=0x7f52a426a888) at /git/PS-8.0-trunk_dbg/storage/innobase/handler/handler0alter.cc:3703
      #8  0x000055cd67666bc0 in ha_innobase::commit_inplace_alter_table (this=0x7f524d81f028, altered_table=0x7f52a40ebe20, 
          ha_alter_info=0x7f52d6845520, commit=true, old_dd_tab=0x7f52a426ab88, new_dd_tab=0x7f52a426a888)
          at /git/PS-8.0-trunk_dbg/storage/innobase/handler/handler0alter.cc:1249
      #9  0x000055cd65d5f4c9 in handler::ha_commit_inplace_alter_table (this=0x7f524d81f028, altered_table=0x7f52a40ebe20, 
          ha_alter_info=0x7f52d6845520, commit=true, old_table_def=0x7f52a426ab88, new_table_def=0x7f52a426a888)
          at /git/PS-8.0-trunk_dbg/sql/handler.cc:4995
      #10 0x000055cd661bbb4e in remove_secondary_keys (thd=0x7f52a4024000, create_info=0x7f52d68476d0, table=0x7f52a40ebe20, 
          alter_info=0x7f52d68477e0, table_def=0x7f52a426ab88, altered_table_def=0x7f52a426a888, dd_disabled_sec_keys=0x7f52d68459b0)
          at /git/PS-8.0-trunk_dbg/sql/sql_table.cc:13953
      #11 0x000055cd661c100a in mysql_alter_table (thd=0x7f52a4024000, new_db=0x7f52a4073438 "test", new_name=0x0, 
          create_info=0x7f52d68476d0, table_list=0x7f52a4072ea0, alter_info=0x7f52d68477e0) at /git/PS-8.0-trunk_dbg/sql/sql_table.cc:15615
      #12 0x000055cd66016a8a in Sql_cmd_alter_table::execute (this=0x7f52a4073540, thd=0x7f52a4024000)
          at /git/PS-8.0-trunk_dbg/sql/sql_alter.cc:363
      #13 0x000055cd660f7f63 in mysql_execute_command (thd=0x7f52a4024000, first_level=true) at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:4530
      #14 0x000055cd660fa695 in mysql_parse (thd=0x7f52a4024000, parser_state=0x7f52d68492a0, update_userstat=false, 
          force_primary_storage_engine=false) at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:5271
      #15 0x000055cd660ef592 in dispatch_command (thd=0x7f52a4024000, com_data=0x7f52d6849c70, command=COM_QUERY)
          at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:1734
      #16 0x000055cd660edb29 in do_command (thd=0x7f52a4024000) at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:1290
      #17 0x000055cd662b2d88 in handle_connection (arg=0x7f52872ea2b0)
          at /git/PS-8.0-trunk_dbg/sql/conn_handler/connection_handler_per_thread.cc:317
      #18 0x000055cd675091cc in pfs_spawn_thread (arg=0x7f52c1b35a20) at /git/PS-8.0-trunk_dbg/storage/perfschema/pfs.cc:2836
      #19 0x00007f52d869a6db in start_thread (arg=0x7f52d684a700) at pthread_create.c:463
      #20 0x00007f52d696c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                satya.bodapati Satya Bodapati
                Reporter:
                roel.vandepaar Roel Van de Paar (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                3 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 - 6 hours, 55 minutes
                    6h 55m