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

[PS8QA] Enabling expand_fast_index_creation leads to handle_fatal_signal (sig=11) in dd_write_index

Details

    • Bug
    • Status: Done
    • Critical
    • Resolution: Duplicate
    • 8.0.x
    • None
    • None
    • None

    Description

      SET expand_fast_index_creation=ON;
      ALTER TABLE mysql.db ORDER BY db DESC; 

      Leads to:

      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
      [Current thread is 1 (Thread 0x7fe6f5869700 (LWP 32499))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x00005580787cf307 in my_write_core (sig=sig@entry=11) at stacktrace.cc:278
      #2  0x00005580779a5b25 in handle_fatal_signal (sig=11) at signal_handler.cc:254
      #3  <signal handler called>
      #4  0x0000558078c0f413 in dd_write_index<dd::Index> (index=0x0, dd_index=<optimized out>, dd_space_id=1) at dict/dict0dd.cc:1880
      #5  dd_write_table<dd::Table> (dd_space_id=dd_space_id@entry=1, dd_table=dd_table@entry=0x7fe674c6f2f8, 
          table=table@entry=0x7fe674cfc488) at dict/dict0dd.cc:1921
      #6  0x00005580789915f4 in dd_commit_inplace_alter_table<dd::Table> (new_dd_tab=0x7fe674c6f2f8, old_dd_tab=0x7fe6d3cd3e78, 
          new_table=0x7fe674cfc488, old_info=<synthetic pointer>...) at handler/handler0alter.cc:3903
      #7  ha_innobase::commit_inplace_alter_table (this=0x7fe674cfa028, altered_table=<optimized out>, ha_alter_info=<optimized out>, 
          commit=<optimized out>, old_dd_tab=0x7fe6d3cd3e78, new_dd_tab=0x7fe674c6f2f8) at handler/handler0alter.cc:1226
      #8  0x000055807790ff9a in remove_secondary_keys (alter_info=0x7fe6f58665f0, alter_info=0x7fe6f58665f0, 
          altered_table_def=0x7fe674c6f2f8, table_def=0x7fe6d3cd3e78, table=<optimized out>, create_info=0x7fe6f58664f0, thd=
          0x7fe674c17000) at sql_table.cc:12855
      #9  mysql_alter_table (thd=thd@entry=0x7fe674c17000, new_db=<optimized out>, new_name=<optimized out>, 
          create_info=create_info@entry=0x7fe6f58664f0, table_list=<optimized out>, table_list@entry=0x7fe674c63e90, 
          alter_info=alter_info@entry=0x7fe6f58665f0) at sql_table.cc:14316
      #10 0x0000558077c5fe74 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7fe674c17000) at sql_alter.cc:350
      #11 0x000055807787ad75 in mysql_execute_command (thd=thd@entry=0x7fe674c17000, first_level=first_level@entry=true)
          at sql_parse.cc:4417
      #12 0x000055807787f14b in mysql_parse (thd=thd@entry=0x7fe674c17000, parser_state=parser_state@entry=0x7fe6f5867d40, 
          update_userstat=update_userstat@entry=false) at sql_parse.cc:5139
      #13 0x0000558077881f12 in dispatch_command (thd=thd@entry=0x7fe674c17000, com_data=com_data@entry=0x7fe6f5868c60, command=COM_QUERY)
          at sql_parse.cc:1654
      #14 0x0000558077882c49 in do_command (thd=thd@entry=0x7fe674c17000) at sql_parse.cc:1262
      #15 0x00005580779971c0 in handle_connection (arg=arg@entry=0x7fe67445f730) at conn_handler/connection_handler_per_thread.cc:317
      #16 0x0000558078897caf in pfs_spawn_thread (arg=0x7fe6e8beea20) at pfs.cc:2836
      #17 0x00007fe6f74b36db in start_thread (arg=0x7fe6f5869700) at pthread_create.c:463
      #18 0x00007fe6f598b88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 

      in PS 8.0.12, inc optimized build.

      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 - 27 minutes
                  27m

                  Smart Checklist