Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-1741

PS startup displays errors for databases excluded during partial backup

Details

    • Yes

    Description

      Start PS8.0.13-3 and add some databases

      source /home/mchawla/percona-qa/sample_db/world.sql
      source /home/mchawla/percona-qa/sample_db/sakila.sql

      Take backup of specific databases "test sakila mysql sys". Exclude the databases world and performance_schema from backup.

      ./xtrabackup --user=root --password='' --backup --databases='test sakila mysql sys' --target-dir=$HOME/dbbackup_PS8 -S $HOME/PS201218-percona-server-8.0.13-3-linux-x86_64-debug/socket.sock --datadir=$HOME/PS201218-percona-server-8.0.13-3-linux-x86_64-debug/data

      Prepare the backup

      ./xtrabackup --prepare --target-dir=$HOME/dbbackup_PS8

      Stop PS and move the data dir to another location.

      Restore the backup

      ./xtrabackup --copy-back --target-dir=$HOME/dbbackup_PS8 --datadir=$HOME/PS201218-percona-server-8.0.13-3-linux-x86_64-debug/data

      Start PS. The following errors are displayed in logs for world database:

      2019-01-03T05:27:57.930193Z 1 [Warning] [MY-012351] [InnoDB] Tablespace 2, name 'world/City', file './world/City.ibd' is missing!
      2019-01-03T05:27:57.930227Z 1 [Warning] [MY-012351] [InnoDB] Tablespace 3, name 'world/Country', file './world/Country.ibd' is missing!
      2019-01-03T05:27:57.930241Z 1 [Warning] [MY-012351] [InnoDB] Tablespace 4, name 'world/CountryLanguage', file './world/CountryLanguage.ibd' is missing!

      Observation:

      There are no errors displayed for performance_schema. The PS recreates the database and all tables, but no database files are created in data directory.

      Attachments

        Activity

          People

            Unassigned Unassigned
            manish.chawla Manish Chawla
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 5 hours, 33 minutes
                1d 5h 33m

                Smart Checklist