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: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 11.8.6
    • N/A
    • Scripts & Clients
    • Linux Debian
    • Not for Release Notes

    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:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1h
                1h

                Git Integration

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