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

[PS8QA] ALTER TABLE ... COMPRESSED WITH COMPRESSION_DICTIONARY crash | handle_fatal_signal (sig=11) in mysql_alter_table

Details

    • Bug
    • Status: Done
    • Critical
    • Resolution: Duplicate
    • None
    • None
    • None
    • None

    Description

      # mysqld options required for replay: --sql_mode= 
      CREATE DATABASE test;
      USE test;
      create TABLE t1 as select * from mysql.user where user=0;
      ALTER TABLE t1 MODIFY COLUMN a BLOB COLUMN_FORMAT COMPRESSED WITH COMPRESSION_DICTIONARY numbers;
      

      or 

      CREATE DATABASE test;
      USE test;
      CREATE TABLE t1(c1 INT,c2 CHAR(1),c3 INT(1),c4 CHAR(1) KEY,c5 INT UNIQUE KEY,c6 DECIMAL(0,0) DEFAULT 3.141592);
      ALTER TABLE t1 MODIFY COLUMN a CHAR(1)COLUMN_FORMAT COMPRESSED;
      

      or 

      CREATE DATABASE test;
      USE test;
      CREATE TABLE t1(c_1vb BINARY (1),c_2vb VARBINARY (1),KEY (c_1vb(1))) ROW_FORMAT=DYNAMIC,engine=InnoDB;
      ALTER TABLE t1 CHANGE COLUMN a a BLOB COLUMN_FORMAT COMPRESSED WITH COMPRESSION_DICTIONARY unknown,ALGORITHM=DEFAULT;
      

      or

      CREATE DATABASE test;
      USE test;
      CREATE TABLE t1 SELECT 1;
      ALTER TABLE t1 ADD COLUMN b BLOB COLUMN_FORMAT COMPRESSED WITH COMPRESSION_DICTIONARY dict1 AFTER id,ALGORITHM=COPY;
      

      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 0x7fe37263d700 (LWP 16768))]
      (gdb) bt
      #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1 0x000055d6ff636797 in my_write_core (sig=sig@entry=11) at stacktrace.cc:278
      #2 0x000055d6fe80d825 in handle_fatal_signal (sig=11) at signal_handler.cc:254
      #3 <signal handler called>
      #4 0x000055d6fe772d6f in mysql_alter_table (thd=thd@entry=0x7fe2f0c17000, new_db=<optimized out>, new_name=<optimized out>, 
      create_info=create_info@entry=0x7fe37263a4f0, table_list=<optimized out>, table_list@entry=0x7fe2f0c63fc8, 
      alter_info=alter_info@entry=0x7fe37263a5f0) at sql_table.cc:13616
      #5 0x000055d6feac7264 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x7fe2f0c17000) at sql_alter.cc:350
      #6 0x000055d6fe6e2da5 in mysql_execute_command (thd=thd@entry=0x7fe2f0c17000, first_level=first_level@entry=true)
      at sql_parse.cc:4417
      #7 0x000055d6fe6e717b in mysql_parse (thd=thd@entry=0x7fe2f0c17000, parser_state=parser_state@entry=0x7fe37263bd40, 
      update_userstat=update_userstat@entry=false) at sql_parse.cc:5139
      #8 0x000055d6fe6e9f42 in dispatch_command (thd=thd@entry=0x7fe2f0c17000, com_data=com_data@entry=0x7fe37263cc60, command=COM_QUERY)
      at sql_parse.cc:1654
      #9 0x000055d6fe6eac79 in do_command (thd=thd@entry=0x7fe2f0c17000) at sql_parse.cc:1262
      #10 0x000055d6fe7feec0 in handle_connection (arg=arg@entry=0x7fe2f045e730) at conn_handler/connection_handler_per_thread.cc:317
      #11 0x000055d6ff6ff13f in pfs_spawn_thread (arg=0x7fe329bd2a20) at pfs.cc:2836
      #12 0x00007fe3742876db in start_thread (arg=0x7fe37263d700) at pthread_create.c:463
      #13 0x00007fe37275f88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      At commit

      3090827ad35245f98c2054afbac6eb6293852924

      In optimized/release 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 - 24 minutes
                  24m

                  Smart Checklist