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

"RENAME TABLE" causes "Ignoring data file ... with space ID xxxx, since the redo log references ... with space ID xxxx."

    XMLWordPrintable

Details

    Description

      Hi,

      I do a daily "snapshot" restore of my daily backup performed by MariaBackup.

      I've just noticed that I see *LOADS* of messages like:

      Ignoring data file 'database1/table1.ibd' with space ID 25508, since the redo log references database1/table1.ibd with space ID 25506.

      On tables that some jobs perform a "RENAME TABLE", to swap with a new version of them.

      I've been seeing this since very long ago, but became more noticeable now that there is a job that does "RENAME TABLE" every 5 minutes.

      Is this normal?
      Does this mean anything bad to the database or backups? Or to the 'restored' database?

      Is there any risk of corruption because of this, or loss of data/tables?

      Thank you.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              nunop Nuno
              Votes:
              0 Vote for this issue
              Watchers:
              2 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 - 0.5h
                  0.5h

                  Git Integration

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