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:

                Git Integration

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