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

[PS8QA] dd::Table::enum_row_format dd::dd_get_new_row_format(row_type): Assertion `0' failed.

    XMLWordPrintable

    Details

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

      Description

      CREATE DATABASE test;
      USE test;
      CREATE TABLE t1(c1 CHAR (1));
      ALTER TABLE t1 ROW_FORMAT=TOKUDB_FAST; 

      Leads to;

      8.0.12>ALTER TABLE t1 ROW_FORMAT=TOKUDB_FAST;
      ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE' 

      On a bit older (19 September) build of PS 8.0.12.

      And, it crashes on latest build (5 October);

      mysqld: /git/PS-8.0-trunk_dbg/sql/dd/dd_table.cc:1747: dd::Table::enum_row_format dd::dd_get_new_row_format(row_type): Assertion `0' failed.
      18:10:26 UTC - mysqld got signal 6 ;
      
      Core was generated by `/sda/PS051018-percona-server-8.0.12-1-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 0x7f34e35e9700 (LWP 22035))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
      #1  0x000055985324c7fd in my_write_core (sig=6) at /git/PS-8.0-trunk_dbg/mysys/stacktrace.cc:278
      #2  0x0000559851f939d7 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  0x00007f34e362a801 in __GI_abort () at abort.c:79
      #6  0x00007f34e361a39a in __assert_fail_base (fmt=0x7f34e37a17d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", 
          assertion=assertion@entry=0x559854721430 "0", file=file@entry=0x559854720d78 "/git/PS-8.0-trunk_dbg/sql/dd/dd_table.cc", 
          line=line@entry=1747, 
          function=function@entry=0x559854722040 <dd::dd_get_new_row_format(row_type)::__PRETTY_FUNCTION__> "dd::Table::enum_row_format dd::dd_get_new_row_format(row_type)") at assert.c:92
      #7  0x00007f34e361a412 in __GI___assert_fail (assertion=0x559854721430 "0", 
          file=0x559854720d78 "/git/PS-8.0-trunk_dbg/sql/dd/dd_table.cc", line=1747, 
          function=0x559854722040 <dd::dd_get_new_row_format(row_type)::__PRETTY_FUNCTION__> "dd::Table::enum_row_format dd::dd_get_new_row_format(row_type)") at assert.c:101
      #8  0x0000559852f5328e in dd::dd_get_new_row_format (old_format=ROW_TYPE_TOKU_LZMA) at /git/PS-8.0-trunk_dbg/sql/dd/dd_table.cc:1747
      #9  0x0000559852f5417b in dd::fill_dd_table_from_create_info (thd=0x7f34afc24000, tab_obj=0x7f34afc7c9f8, table_name="#sql-55b2_8", 
          schema_name="test", create_info=0x7f34e35e6720, create_fields=..., keyinfo=0x7f34afdb4240, keys=1, 
          keys_onoff=Alter_info::LEAVE_AS_IS, fk_keyinfo=0x7f34afdb4300, fk_keys=0, file=0x7f34afdb29a0)
          at /git/PS-8.0-trunk_dbg/sql/dd/dd_table.cc:1994
      #10 0x0000559852f55cbe in dd::create_dd_user_table (thd=0x7f34afc24000, sch_obj=..., table_name="#sql-55b2_8", 
          create_info=0x7f34e35e6720, create_fields=..., keyinfo=0x7f34afdb4240, keys=1, keys_onoff=Alter_info::LEAVE_AS_IS, 
          fk_keyinfo=0x7f34afdb4300, fk_keys=0, file=0x7f34afdb29a0) at /git/PS-8.0-trunk_dbg/sql/dd/dd_table.cc:2247
      #11 0x0000559852f55e5c in dd::create_table (thd=0x7f34afc24000, sch_obj=..., table_name="#sql-55b2_8", create_info=0x7f34e35e6720, 
          create_fields=..., keyinfo=0x7f34afdb4240, keys=1, keys_onoff=Alter_info::LEAVE_AS_IS, fk_keyinfo=0x7f34afdb4300, fk_keys=0, 
          file=0x7f34afdb29a0) at /git/PS-8.0-trunk_dbg/sql/dd/dd_table.cc:2270
      #12 0x0000559851e72c7c in rea_create_base_table (thd=0x7f34afc24000, path=0x7f34e35e6014 "./test/#sql-55b2_8", sch_obj=..., 
          db=0x7f34afc712d8 "test", table_name=0x7f34e35e57b0 "#sql-55b2_8", create_info=0x7f34e35e6720, create_fields=..., keys=1, 
          key_info=0x7f34afdb4240, keys_onoff=Alter_info::LEAVE_AS_IS, fk_keys=0, fk_key_info=0x7f34afdb4300, file=0x7f34afdb29a0, 
          no_ha_table=true, do_not_store_in_dd=true, part_info=0x0, binlog_to_trx_cache=0x0, table_def_ptr=0x7f34e35e2cd0,  
          post_ddl_ht=0x0) at /git/PS-8.0-trunk_dbg/sql/sql_table.cc:900
      #13 0x0000559851e84dbb in create_table_impl (thd=0x7f34afc24000, schema=..., db=0x7f34afc712d8 "test", 
          table_name=0x7f34e35e57b0 "#sql-55b2_8", error_table_name=0x7f34afc709e0 "t1", path=0x7f34e35e6014 "./test/#sql-55b2_8", 
          create_info=0x7f34e35e6720, alter_info=0x7f34e35e6820, internal_tmp_table=true, select_field_count=0, find_parent_keys=true, 
          no_ha_table=true, do_not_store_in_dd=true, is_trans=0x0, key_info=0x7f34e35e2cc0, key_count=0x7f34e35e2c6c, 
          keys_onoff=Alter_info::LEAVE_AS_IS, fk_key_info=0x7f34e35e2cc8, fk_key_count=0x7f34e35e2c70, existing_fk_info=0x7f34afdb2998, 
          existing_fk_count=0, existing_fk_table=0x7f34afc7baf8, fk_max_generated_name_number=0, table_def=0x7f34e35e2cd0, 
          post_ddl_ht=0x0) at /git/PS-8.0-trunk_dbg/sql/sql_table.cc:7118
      #14 0x0000559851e9b3b4 in mysql_alter_table (thd=0x7f34afc24000, new_db=0x7f34afc712d8 "test", new_name=0x0, 
          create_info=0x7f34e35e6720, table_list=0x7f34afc70d50, alter_info=0x7f34e35e6820)
          at /git/PS-8.0-trunk_dbg/sql/sql_table.cc:13842
      #15 0x000055985237948c in Sql_cmd_alter_table::execute (this=0x7f34afc712e0, thd=0x7f34afc24000)
          at /git/PS-8.0-trunk_dbg/sql/sql_alter.cc:350
      #16 0x0000559851ddb92d in mysql_execute_command (thd=0x7f34afc24000, first_level=true)
          at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:4417
      #17 0x0000559851dddf2b in mysql_parse (thd=0x7f34afc24000, parser_state=0x7f34e35e82a0, update_userstat=false)
          at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:5139
      #18 0x0000559851dd30b7 in dispatch_command (thd=0x7f34afc24000, com_data=0x7f34e35e8c70, command=COM_QUERY)
          at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:1654
      #19 0x0000559851dd18a6 in do_command (thd=0x7f34afc24000) at /git/PS-8.0-trunk_dbg/sql/sql_parse.cc:1262
      #20 0x0000559851f801fa in handle_connection (arg=0x7f34590259d0)
          at /git/PS-8.0-trunk_dbg/sql/conn_handler/connection_handler_per_thread.cc:317
      #21 0x000055985333df42 in pfs_spawn_thread (arg=0x7f3491ca1420) at /git/PS-8.0-trunk_dbg/storage/perfschema/pfs.cc:2836
      #22 0x00007f34e52336db in start_thread (arg=0x7f34e35e9700) at pthread_create.c:463
      #23 0x00007f34e370b88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      Whereas it fails on MS 8.0.12

      8.0.12>ALTER TABLE t1 ROW_FORMAT=TOKUDB_FAST;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TOKUDB_FAST' at line 1
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                george.lorch George Lorch
                Reporter:
                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 - 7 minutes
                  7m