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

DELETE HISTORY from a table with transaction-precise versioning causes Assertion `table_list->vers_conditions.type == SYSTEM_TIME_BEFORE' failure

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      create or replace table t1 (
        a int, 
        s bigint unsigned as row start, 
        e bigint unsigned as row end,
        period for system_time (s,e)
      ) engine=InnoDB with system versioning;
       
      insert into t1 (a) values (1);
      delete history from t1;
       
      # Cleanup
      drop table t1;
      truncate table mysql.transaction_registry;
      

      10.3 9f84451d87b

      mysqld: /data/src/10.3/sql/sql_delete.cc:331: bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List<st_order>*, ha_rows, ulonglong, select_result*): Assertion `table_list->vers_conditions.type == SYSTEM_TIME_BEFORE' failed.
      180423  1:08:59 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f6b6e235ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00005595aee7ae82 in mysql_delete (thd=0x7f6b1c000b00, table_list=0x7f6b1c014e30, conds=0x0, order_list=0x7f6b1c005338, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.3/sql/sql_delete.cc:331
      #9  0x00005595ae9fd820 in mysql_execute_command (thd=0x7f6b1c000b00) at /data/src/10.3/sql/sql_parse.cc:4922
      #10 0x00005595aea072a8 in mysql_parse (thd=0x7f6b1c000b00, rawbuf=0x7f6b1c014d58 "delete history from t1", length=22, parser_state=0x7f6b635545d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001
      #11 0x00005595ae9f4a8b in dispatch_command (command=COM_QUERY, thd=0x7f6b1c000b00, packet=0x7f6b1c125fc1 "delete history from t1", packet_length=22, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846
      #12 0x00005595ae9f34ca in do_command (thd=0x7f6b1c000b00) at /data/src/10.3/sql/sql_parse.cc:1391
      #13 0x00005595aeb55fbd in do_handle_one_connection (connect=0x5595b2321ab0) at /data/src/10.3/sql/sql_connect.cc:1402
      #14 0x00005595aeb55d4a in handle_one_connection (arg=0x5595b2321ab0) at /data/src/10.3/sql/sql_connect.cc:1308
      #15 0x00005595aefd99bb in pfs_spawn_thread (arg=0x5595b232a1a0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #16 0x00007f6b6ff0c494 in start_thread (arg=0x7f6b63555700) at pthread_create.c:333
      #17 0x00007f6b6e2f293f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.