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

Warning of full history partition is one command late

    XMLWordPrintable

Details

    Description

      Reproduce

      # Truncate partitioned
      create or replace table t (a int) with system versioning
      partition by system_time limit 1 partitions 3;
      insert into t values (1);
      update t set a= 2;
      update t set a= 3;
      delete history from t;
      Warnings:
      Warning	4114	Versioned table `test`.`t`: last HISTORY partition (`p1`) is out of LIMIT, need more HISTORY partitions
      # The above warning is one command late (MDEV-20345) ^^^
      

      Optimize calling vers_set_hist_part()

      1. Look for TODO in `ha_partition::external_lock()` and `ha_partition::start_stmt()` and add more excluding conditions.

      2. Add test cases for INSERT SELECT, REPLACE SELECT, etc.

      3. Test INSERT and history modification setting. Should limits be followed when inserting into history partition?

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              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.