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

Cannot store the history separately for the transaction precise history tables.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.14
    • Fix Version/s: 10.4, 10.5
    • Labels:
      None
    • Environment:
      CentOS Linux release 7.8.2003 (Core)

      Description

      For the tables with transaction precise history cannot put history data into own partition(s).

      Meaning the maintenance and cleanup of the huge tables is unefficient and very heavy task.

      Meaning in turn transaction precise history is not really usable feature for production environment:

      MariaDB [db]> CREATE TABLE t(
      -> x INT,
      -> start_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW START,
      -> end_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW END,
      -> PERIOD FOR SYSTEM_TIME(start_trxid, end_trxid)
      -> ) WITH SYSTEM VERSIONING
      -> PARTITION BY SYSTEM_TIME LIMIT 100000 (
      -> PARTITION p_hist HISTORY,
      -> PARTITION p_cur CURRENT
      -> );
      ERROR 4110 (HY000): `start_trxid` must be of type TIMESTAMP(6) for system-versioned table `t`

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              ykantoni YURII KANTONISTOV
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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