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

[PS8QA] ALTER TABLE ... ADD INDEX ... LOCK crash | handle_fatal_signal (sig=11) in dd_table_has_instant_cols

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: 8.0
    • Fix Version/s: None
    • Component/s: None

      Description

      CREATE DATABASE test;
      USE test;
      SET SESSION expand_fast_index_creation=ON;
      CREATE TEMPORARY TABLE t1(c1 BLOB);
      alter TABLE t1 add b char;
      ALTER TABLE t1 ADD INDEX i1(b),LOCK=DEFAULT;
      

      Leads to

      Core was generated by `/sda/PS010918-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
      [Current thread is 1 (Thread 0x7f335d45e700 (LWP 16387))]
      (gdb) bt
      #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1 0x000055f87da21797 in my_write_core (sig=sig@entry=11) at stacktrace.cc:278
      #2 0x000055f87cbf8825 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 0x000055f87dbd51f2 in dd_commit_inplace_update_instant_meta (table=table@entry=0x7f32dbceb488, old_dd_tab=old_dd_tab@entry=0x0, 
      new_dd_tab=new_dd_tab@entry=0x7f32dbc84578) at handler/handler0alter.cc:3785
      #6 0x000055f87dbe36b6 in ha_innobase::commit_inplace_alter_table (this=0x7f32dbce0028, altered_table=<optimized out>, 
      ha_alter_info=<optimized out>, commit=<optimized out>, old_dd_tab=0x0, new_dd_tab=0x7f32dbc84578)
      at handler/handler0alter.cc:1229
      #7 0x000055f87cb62c4a in remove_secondary_keys (alter_info=0x7f335d45b5f0, alter_info=0x7f335d45b5f0, 
      altered_table_def=0x7f32dbc84578, table_def=0x0, table=<optimized out>, create_info=0x7f335d45b4f0, thd=0x7f32dbc17000)
      at sql_table.cc:12855
      #8 mysql_alter_table (thd=thd@entry=0x7f32dbc17000, new_db=<optimized out>, new_name=<optimized out>, 
      create_info=create_info@entry=0x7f335d45b4f0, table_list=<optimized out>, table_list@entry=0x7f32dbc6fe10, 
      alter_info=alter_info@entry=0x7f335d45b5f0) at sql_table.cc:14316
      #9 0x000055f87ceb2264 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7f32dbc17000) at sql_alter.cc:350
      #10 0x000055f87cacdda5 in mysql_execute_command (thd=thd@entry=0x7f32dbc17000, first_level=first_level@entry=true)
      at sql_parse.cc:4417
      #11 0x000055f87cad217b in mysql_parse (thd=thd@entry=0x7f32dbc17000, parser_state=parser_state@entry=0x7f335d45cd40, 
      update_userstat=update_userstat@entry=false) at sql_parse.cc:5139
      #12 0x000055f87cad4f42 in dispatch_command (thd=thd@entry=0x7f32dbc17000, com_data=com_data@entry=0x7f335d45dc60, command=COM_QUERY)
      at sql_parse.cc:1654
      #13 0x000055f87cad5c79 in do_command (thd=thd@entry=0x7f32dbc17000) at sql_parse.cc:1262
      #14 0x000055f87cbe9ec0 in handle_connection (arg=arg@entry=0x7f32db45e730) at conn_handler/connection_handler_per_thread.cc:317
      #15 0x000055f87daea13f in pfs_spawn_thread (arg=0x7f3314bd2a20) at pfs.cc:2836
      #16 0x00007f335f0a86db in start_thread (arg=0x7f335d45e700) at pthread_create.c:463
      #17 0x00007f335d58088f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      At commit

      3090827ad35245f98c2054afbac6eb6293852924

      In optimized/release build. Upstream is not affected in debug nor optimized.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                roel.vandepaar Roel Van de Paar
              • 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 - 11 minutes
                  11m