Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14673

Assertion `part_elem->type() == partition_element::AS_OF_NOW' failed in check_partition_info

    XMLWordPrintable

Details

    Description

      CREATE OR REPLACE TABLE t1 (i INT) ENGINE=MyISAM WITH SYSTEM VERSIONING
      PARTITION BY system_time INTERVAL 1 DAY (PARTITION p0, PARTITION pn AS OF CURRENT_TIMESTAMP);
      

      bb-10.3-temporal 2ae2876a6ce4b1e4

      mysqld: /data/src/bb-10.3-temporal/sql/partition_info.cc:2092: bool partition_info::check_partition_info(THD*, handlerton**, handler*, HA_CREATE_INFO*, bool): Assertion `part_elem->type() == partition_element::AS_OF_NOW' failed.
      171216 14:07:43 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f9ddaef7ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00005616a83622f4 in partition_info::check_partition_info (this=0x7f9d4c0146b0, thd=0x7f9d4c000b00, eng_type=0x7f9dd81e14f0, file=0x7f9d4c015638, info=0x7f9dd81e3800, add_or_reorg_part=false) at /data/src/bb-10.3-temporal/sql/partition_info.cc:2092
      #9  0x00005616a82f2e0a in mysql_create_frm_image (thd=0x7f9d4c000b00, db=0x7f9d4c013fa8 "db", table_name=0x7f9d4c013938 "t1", create_info=0x7f9dd81e3800, alter_info=0x7f9dd81e3750, create_table_mode=0, key_info=0x7f9dd81e2b30, key_count=0x7f9dd81e2b24, frm=0x7f9dd81e2b40) at /data/src/bb-10.3-temporal/sql/sql_table.cc:4522
      #10 0x00005616a82f3e2c in create_table_impl (thd=0x7f9d4c000b00, orig_db=0x7f9d4c013fa8 "db", orig_table_name=0x7f9d4c013938 "t1", db=0x7f9d4c013fa8 "db", table_name=0x7f9d4c013938 "t1", path=0x7f9dd81e2b50 "./db/t1", options=..., create_info=0x7f9dd81e3800, alter_info=0x7f9dd81e3750, create_table_mode=0, is_trans=0x7f9dd81e2dae, key_info=0x7f9dd81e2b30, key_count=0x7f9dd81e2b24, frm=0x7f9dd81e2b40) at /data/src/bb-10.3-temporal/sql/sql_table.cc:4876
      #11 0x00005616a82f4486 in mysql_create_table_no_lock (thd=0x7f9d4c000b00, db=0x7f9d4c013fa8 "db", table_name=0x7f9d4c013938 "t1", create_info=0x7f9dd81e3800, alter_info=0x7f9dd81e3750, is_trans=0x7f9dd81e2dae, create_table_mode=0, table_list=0x7f9d4c013970) at /data/src/bb-10.3-temporal/sql/sql_table.cc:4992
      #12 0x00005616a82f4826 in mysql_create_table (thd=0x7f9d4c000b00, create_table=0x7f9d4c013970, create_info=0x7f9dd81e3800, alter_info=0x7f9dd81e3750) at /data/src/bb-10.3-temporal/sql/sql_table.cc:5067
      #13 0x00005616a8225377 in mysql_execute_command (thd=0x7f9d4c000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:4259
      #14 0x00005616a82310e4 in mysql_parse (thd=0x7f9d4c000b00, rawbuf=0x7f9d4c013778 "CREATE OR REPLACE TABLE t1 (i INT) ENGINE=MyISAM WITH SYSTEM VERSIONING PARTITION BY system_time INTERVAL 1 DAY (PARTITION p0, PARTITION pn AS OF CURRENT_TIMESTAMP)", length=164, parser_state=0x7f9dd81e4640, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7988
      #15 0x00005616a821e8a7 in dispatch_command (command=COM_QUERY, thd=0x7f9d4c000b00, packet=0x7f9d4c01b9a1 "CREATE OR REPLACE TABLE t1 (i INT) ENGINE=MyISAM WITH SYSTEM VERSIONING PARTITION BY system_time INTERVAL 1 DAY (PARTITION p0, PARTITION pn AS OF CURRENT_TIMESTAMP)", packet_length=164, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1826
      #16 0x00005616a821d2db in do_command (thd=0x7f9d4c000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1371
      #17 0x00005616a8383ada in do_handle_one_connection (connect=0x5616ac470db0) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
      #18 0x00005616a8383867 in handle_one_connection (arg=0x5616ac470db0) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
      #19 0x00007f9ddcbce494 in start_thread (arg=0x7f9dd81e5700) at pthread_create.c:333
      #20 0x00007f9ddafb493f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Activity

          People

            midenok Aleksey Midenkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.