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

Remove/reduce InnoDB note: trying to read page in nonexisting or being-dropped tablespace

    XMLWordPrintable

Details

    Description

      In MariaDB 11.4.5 I'm seeing thousands of InnoDB notes in the error log when importing tables via the ALTER TABLE db.t1 IMPORT TABLESPACE method. I'm running on Debian Bullseye, if it makes a difference.

      2025-04-03 8:53:59 33 [Note] InnoDB: trying to read page [page id: space=1803, page number=0] in nonexisting or being-dropped tablespace
      2025-04-03 8:53:59 33 [Note] InnoDB: trying to read page [page id: space=1803, page number=1] in nonexisting or being-dropped tablespace
      2025-04-03 8:53:59 33 [Note] InnoDB: trying to read page [page id: space=1803, page number=2] in nonexisting or being-dropped tablespace
      2025-04-03 8:53:59 33 [Note] InnoDB: trying to read page [page id: space=1803, page number=3] in nonexisting or being-dropped tablespace
      2025-04-03 8:53:59 33 [Note] InnoDB: trying to read page [page id: space=1803, page number=4] in nonexisting or being-dropped tablespace

      The tables appear to be imported properly; I'm not seeing any immediate problems working with them.

      Is there some way to squelch/reduce theses errors? Or am I missing something in my import process? As expected, log_warnings=0 does not remove them.

      The basic test sequence I'm using is:

          CREATE DATABASE testDb1;
          CREATE DATABASE testDb2;
          CREATE TABLE testDb1.t1 (
              id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
              random_label VARCHAR(60) NOT NULL,
              PRIMARY KEY(id)
          ) ENGINE=InnoDB;
          ( fill t1 with a million rows or so)
          FLUSH TABLES testDb1.t1 FOR EXPORT;
          ( copy t1.frm, t1.cfg, and t1.ibd to testDb2)
          UNLOCK TABLES;
          ALTER TABLE testDb2.t1 IMPORT TABLESPACE;
      

      Attachments

        1. import_test_script.sql
          0.7 kB
          Daniel Ragle
        2. variables.txt
          22 kB
          Daniel Ragle
        3. client_help.txt
          3 kB
          Daniel Ragle
        4. error_log_ouput.log
          2 kB
          Daniel Ragle

        Activity

          People

            Unassigned Unassigned
            dragle Daniel Ragle
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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