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

Useless warning "InnoDB: Allocated tablespace ID <id> for <tablename>, old maximum was 0" during backup stage

Details

    Description

      We can often see warnings like this:

      2021-12-09  4:00:59 0 [Warning] InnoDB: Allocated tablespace ID 40667422 for db/tablename, old maximum was 0

      upon startup of MariaDB server (after crash recovery, while preparing the backup etc). What is the point to warn DBA about this?

      From quick code review (see fil_space_create( ) function, storage/innobase/fil/fil0fil.cc line 1254 in current 10.4 on GitHub, for example) it seems to be written once as soon as there is any other tablespace that the 0 one. Next tablespace will produce no warning.

      So, why is it a warning, not even Info, and what is the point to give it (and then suppress in the tests)?

      If the warning is something to ignore, can we get rid of it in non-debug builds or in mariabackup at least? If it has a point, can we document what does it mean for production DBA?

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Julien Fritsch made transition -
          Open Needs Feedback
          		12d 9h 15m 1
          Vladislav Lesin made transition -
          Open Confirmed
          		29d 17h 52m 1
          Vladislav Lesin made transition -
          Confirmed In Progress
          		54d 20h 40m 1
          Vladislav Lesin made transition -
          In Progress Needs Feedback
          		1d 3h 58m 1
          Valerii Kravchuk made transition -
          Needs Feedback Open
          		4h 25m 2
          Vladislav Lesin made transition -
          Open In Progress
          		2h 19m 1
          Vladislav Lesin made transition -
          In Progress Closed
          		1d 18h 32m 1

          People

            vlad.lesin Vladislav Lesin
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.