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

Import dumps to an newer MariaDB server loses data history

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.8.6
    • None
    • Scripts & Clients
    • Linux Debian

    Description

      Hello,

      Here is what I am trying to do.
      On my Debian 12 server I have MariaDB version 10.11 running.
      I have there a database with system-versioned tables.
      So I make my dumps using the -H / --dump-history option.

      Then I am trying to load the dump content into another Debian server, of course with the historical data.
      I tried with different MariaDB releases, always on Debian servers (12 and 13).

      • If I load the dumps into (another) MariaDB 10.11.* or 11.4.* it works fine.
      • If I try with MariaDB 11.8 (or later), I can't see my data anymore... The "select *" query gives an empty set.
        When I add "FOR SYSTEM_TIME ALL" I then can see it all.
        So the data is probably not lost in the process, but how can I see it normally?

      I have read the docs on these topics but I am unable to find a solution to my issue.

      Thanks a lot for any help.

      Attachments

        Activity

          People

            shipjain Shipra Jain
            pbeaumadier Pierre Beaumadier
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.