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

[PS8QA] Using ALTER ... ROW_FORMAT=TOKUDB_QUICKLZ leads to InnoDB: Assertion failure: ha_innodb.cc:12198:m_form->s->row_type == m_create_info->row_type

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 8.0.NEXT
    • Fix Version/s: 8.0.NEXT
    • Component/s: TokuDB
    • Labels:
      None

      Description

      CREATE DATABASE test;
      USE test;
      CREATE TEMPORARY TABLE t0(ID INT);
      ALTER TABLE t0 ROW_FORMAT=TOKUDB_QUICKLZ; 

      Leads to (on optimized build);

      8.0.12>ALTER TABLE t0 ROW_FORMAT=TOKUDB_QUICKLZ;
      ERROR 1031 (HY000): Table storage engine for '#sql-6e6e_9' doesn't have this option
      

      And (on debug build);

      2018-09-22T02:23:34.514022Z 8 [ERROR] [MY-000000] [InnoDB] InnoDB: Assertion failure: ha_innodb.cc:12198:m_form->s->row_type == m_create_info->row_type 
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x000056461c93d431 in my_write_core (sig=6) at /git/PS-8.0.12_dbg/mysys/stacktrace.cc:278
      #2  0x000056461b684933 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  0x00007f67ad499801 in __GI_abort () at abort.c:79
      #6  0x000056461cdfa2d1 in ut_dbg_assertion_failed (expr=0x56461dfb6ce8 "m_form->s->row_type == m_create_info->row_type", 
          file=0x56461dfb1340 "/git/PS-8.0.12_dbg/storage/innobase/handler/ha_innodb.cc", line=12198)
          at /git/PS-8.0.12_dbg/storage/innobase/ut/ut0dbg.cc:90
      #7  0x000056461cb34d86 in create_table_info_t::initialize (this=0x7f67ad4505f0)
          at /git/PS-8.0.12_dbg/storage/innobase/handler/ha_innodb.cc:12198
      #8  0x000056461cb53c38 in innobase_basic_ddl::create_impl<dd::Table> (thd=0x7f677a024000, 
          name=0x7f67ad455014 "/sda/PS190918-percona-server-8.0.12-1-linux-x86_64-debug/data/#sql5715_8_1", form=0x7f67ad450fe0, 
          create_info=0x7f67ad455720, dd_tab=0x7f677a079a78, file_per_table=true, evictable=true, skip_strict=false, old_flags=0, 
          old_flags2=0) at /git/PS-8.0.12_dbg/storage/innobase/handler/ha_innodb.cc:12813
      #9  0x000056461cb38307 in ha_innobase::create (this=0x7f677a146028, 
          name=0x7f67ad455014 "/sda/PS190918-percona-server-8.0.12-1-linux-x86_64-debug/data/#sql5715_8_1", form=0x7f67ad450fe0, 
          create_info=0x7f67ad455720, table_def=0x7f677a079a78) at /git/PS-8.0.12_dbg/storage/innobase/handler/ha_innodb.cc:13779
      #10 0x000056461b81143e in handler::ha_create (this=0x7f677a146028, 
          name=0x7f67ad455014 "/sda/PS190918-percona-server-8.0.12-1-linux-x86_64-debug/data/#sql5715_8_1", form=0x7f67ad450fe0, 
          info=0x7f67ad455720, table_def=0x7f677a079a78) at /git/PS-8.0.12_dbg/sql/handler.cc:4930
      #11 0x000056461b812157 in ha_create_table (thd=0x7f677a024000, 
          path=0x7f67ad455014 "/sda/PS190918-percona-server-8.0.12-1-linux-x86_64-debug/data/#sql5715_8_1", db=0x7f677a0e92e8 "test", 
          table_name=0x7f67ad4547b0 "#sql-5715_8", create_info=0x7f67ad455720, create_fields=0x7f67ad4558c0, update_create_info=false, 
          is_temp_table=true, table_def=0x7f677a079a78) at /git/PS-8.0.12_dbg/sql/handler.cc:5156
      #12 0x000056461b58d156 in mysql_alter_table (thd=0x7f677a024000, new_db=0x7f677a0e92e8 "test", new_name=0x0, 
          create_info=0x7f67ad455720, table_list=0x7f677a0e8d60, alter_info=0x7f67ad455820) at /git/PS-8.0.12_dbg/sql/sql_table.cc:14243
      #13 0x000056461ba6a0a8 in Sql_cmd_alter_table::execute (this=0x7f677a0e92f0, thd=0x7f677a024000)
          at /git/PS-8.0.12_dbg/sql/sql_alter.cc:350
      #14 0x000056461b4cc5df in mysql_execute_command (thd=0x7f677a024000, first_level=true) at /git/PS-8.0.12_dbg/sql/sql_parse.cc:4417
      #15 0x000056461b4cebdd in mysql_parse (thd=0x7f677a024000, parser_state=0x7f67ad4572a0, update_userstat=false)
          at /git/PS-8.0.12_dbg/sql/sql_parse.cc:5139
      #16 0x000056461b4c3d69 in dispatch_command (thd=0x7f677a024000, com_data=0x7f67ad457c70, command=COM_QUERY)
          at /git/PS-8.0.12_dbg/sql/sql_parse.cc:1654
      #17 0x000056461b4c2558 in do_command (thd=0x7f677a024000) at /git/PS-8.0.12_dbg/sql/sql_parse.cc:1262
      #18 0x000056461b671156 in handle_connection (arg=0x7f6723c259d0)
          at /git/PS-8.0.12_dbg/sql/conn_handler/connection_handler_per_thread.cc:317
      #19 0x000056461ca2eb76 in pfs_spawn_thread (arg=0x7f675c4a1420) at /git/PS-8.0.12_dbg/storage/perfschema/pfs.cc:2836
      #20 0x00007f67af0a26db in start_thread (arg=0x7f67ad458700) at pthread_create.c:463
      #21 0x00007f67ad57a88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      Please also add MTR testcase

       

        Attachments

          Activity

            People

            • Assignee:
              george.lorch George Lorch
              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 - 7 hours, 52 minutes
                7h 52m