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

Upstream bug #71725: after upgrading from 5.5, existing tables not present in INNODB_SYS_TABLESPACES

    XMLWordPrintable

    Details

      Description

      This upstream bug is verified, but not yet fixed:

      https://bugs.mysql.com/bug.php?id=71725

      Some users are reporting similar behavior in MariaDB 10.1.24, so this may be the cause. See here for an example:

      MariaDB [(none)]> use appdb;
      Database changed
      MariaDB [appdb]> SELECT t.TABLE_SCHEMA, t.TABLE_NAME, ist.SPACE,
      -> CASE ist.SPACE
      -> WHEN 0 THEN 'innodb_file_per_table=OFF'
      -> ELSE 'innodb_file_per_table=ON'
      -> END AS innodb_file_per_table_value
      -> FROM information_schema.INNODB_SYS_TABLES ist
      -> JOIN information_schema.TABLES t
      -> ON ist.NAME = CONCAT(t.TABLE_SCHEMA, '/', t.TABLE_NAME)
      -> AND t.ENGINE = 'InnoDB'
      -> WHERE t.TABLE_SCHEMA='appdb'
      -> AND t.TABLE_NAME in ('tab2','tab1');
      +--------------+--------------+--------+-----------------------------+
      | TABLE_SCHEMA | TABLE_NAME | SPACE | innodb_file_per_table_value |
      +--------------+--------------+--------+-----------------------------+
      | appdb | tab1 | 80590 | innodb_file_per_table=ON |
      | appdb | tab2 | 80586 | innodb_file_per_table=ON |
      +--------------+--------------+--------+-----------------------------+
      2 rows in set (0.03 sec)
       
      MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLES WHERE NAME = 'appdb/tab2'\G
      *************************** 1. row ***************************
      TABLE_ID: 80598
      NAME: appdb/tab2
      FLAG: 1
      N_COLS: 17
      SPACE: 80586
      FILE_FORMAT: Antelope
      ROW_FORMAT: Compact
      ZIP_PAGE_SIZE: 0
      1 row in set (0.02 sec)
       
      MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLESPACES WHERE NAME = 'appdb/tab2'\G
      Empty set (0.01 sec)
       
      MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLES WHERE NAME = 'appdb/tab1'\G
      *************************** 1. row ***************************
      TABLE_ID: 80602
      NAME: appdb/tab1
      FLAG: 1
      N_COLS: 17
      SPACE: 80590
      FILE_FORMAT: Antelope
      ROW_FORMAT: Compact
      ZIP_PAGE_SIZE: 0
      1 row in set (0.01 sec)
       
      MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLESPACES WHERE NAME = 'appdb/tab1'\G
      Empty set (0.01 sec)
       
      MariaDB [appdb]> SELECT * FROM information_schema.INNODB_SYS_TABLESPACES WHERE SPACE IN(80586, 80590)\G
      Empty set (0.01 sec)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: