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

mysqldump: dump and restore historical data

Details

    Description

      Backup through mysqldump loses historical data from versioned tables.

      mysqldump does not read historical rows from the versioned tables, it runs SELECT, not SELECT .. FOR SYSTEM_TIME ALL. But even if we fixed it, it would still be impossible to load this data back, since we are dealing either with invisible columns into which we can't insert at all, or with virtual columns for which values are ignored. So, for now it becomes a known limitation which needs to be documented.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29730 mysqldump --dump-history creates broken dump if there are precision-versioned tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29736 mysqldump sets system_versioning_insert_history=1 twice and doesn't restore previous value

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29737 mysqldump doesn't check for --tz-utc when it accepts --dump-history

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29828 Indicate that --dump-history only applies to timestamp-based versioning

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          duplicates

          Task - A task that needs to be done. MDEV-23125 Backfilling System Versioned Tables

          • Major - Major loss of function.
          • Closed
          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16733 mysqldump --tab and --xml options are conflicting

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Task - A task that needs to be done. MDEV-16734 LOAD DATA and system_versioning_modify_history

          • Major - Major loss of function.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-15923 option to control who can set session @@timestamp

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-16546 System versioning setting to allow history modification

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16684 Wrong timestamps on restore from mysqldump --compact

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Task - A task that needs to be done. MDEV-16798 need mysqldump option to include SYSTEM VERSIONING historical records in backups

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-29547 prepare 10.11.0 preview releases

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-16355 Add option for mysqldump to read data as of specific timestamp from system-versioned tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-16766 mysqldump: dump history in XML

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29741 SHOW BINLOG EVENTS shows garbage with system_versioning_insert_history=on

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29750 Triggers can modify history

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Aleksey Midenkov made transition -
            Open In Progress
            		53d 18h 30m 1
            Aleksey Midenkov made transition -
            In Progress In Review
            		28d 1h 55m 1
            Sergei Golubchik made transition -
            In Review In Testing
            		1524d 7h 53m 1
            Sergei Golubchik made transition -
            Stalled In Testing
            		1m 10s 1
            Elena Stepanova made transition -
            In Testing Stalled
            		33d 52m 2
            Sergei Golubchik made transition -
            Stalled Closed
            		5d 16h 48m 1

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              9 Vote for this issue
              Watchers:
              20 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.