Bug #77055 Datafile info for system tablespace (space 0) is incomplete

• Submitted: 16 May 2015 6:53
• Modified: 14 Jul 2015 6:25
• Reporter: Daniël van Eeden (OCA)
• Status: Duplicate
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.7.7-rc, 5.7.8, 8.0.0
• OS: Any
• CPU Architecture: Any

[16 May 2015 6:53] Daniël van Eeden

Description:
This is a follow-up on Bug #69323

Only the first datafile is listed for space=0.

I would expect all datafiles to be listed there.

How to repeat:
mysql> select * from information_schema.innodb_sys_datafiles where space=0;
+-------+-----------+
| SPACE | PATH      |
+-------+-----------+
|     0 | ./ibdata1 |
+-------+-----------+
1 row in set (0.01 sec)

mysql> select @@global.innodb_data_file_path;
+------------------------------------+
| @@global.innodb_data_file_path     |
+------------------------------------+
| ibdata1:12M;ibdata2:12M:autoextend |
+------------------------------------+
1 row in set (0.00 sec)

[18 May 2015 7:07] MySQL Verification Team

Hello Daniël,

Thank you for the report.

Thanks,
Umesh

[18 May 2015 7:10] MySQL Verification Team

// 5.7.8
mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.7.8                                                   |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.7.8-rc-enterprise-commercial-advanced                 |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | linux-glibc2.5                                          |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

mysql> select * from information_schema.innodb_sys_datafiles where space=0;
+-------+-----------+
| SPACE | PATH      |
+-------+-----------+
|     0 | ./ibdata1 |
+-------+-----------+
1 row in set (0.01 sec)

mysql> select @@global.innodb_data_file_path;
+------------------------------------+
| @@global.innodb_data_file_path     |
+------------------------------------+
| ibdata1:12M;ibdata2:12M:autoextend |
+------------------------------------+
1 row in set (0.00 sec)

// 5.8.0

mysql>  show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.8.0                                                   |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.8.0-m17-enterprise-commercial-advanced                |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | Linux                                                   |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

mysql> select * from information_schema.innodb_sys_datafiles where space=0;
+-------+-----------+
| SPACE | PATH      |
+-------+-----------+
|     0 | ./ibdata1 |
+-------+-----------+
1 row in set (0.00 sec)

mysql> select @@global.innodb_data_file_path;
+------------------------------------+
| @@global.innodb_data_file_path     |
+------------------------------------+
| ibdata1:12M;ibdata2:12M:autoextend |
+------------------------------------+
1 row in set (0.00 sec)

[14 Jul 2015 6:25] Erlend Dahl

[4 Jun 18:36] Daniel Price

Posted by developer:
 
Fixed as of the upcoming 5.7.8 release, and here's the changelog entry:

The INFORMATION_SCHEMA.FILES table now reports metadata for all InnoDB
tablespace types including file-per-table tablespaces, general
tablespaces, the system tablespace, temporary table tablespaces, and undo
tablespaces (if present). System tablespace and temporary table tablespace
metadata is no longer reported by the INFORMATION_SCHEMA.INNODB__SYS_TABLESPACES and
INFORMATION_SCHEMA.INNODB_SYS_DATAFILES tables. However, these tables
continue to provide metadata for file-per-table and general tablespaces.

Duplicate of Bug#77032 InnoDB: Only one datafile per tablespace is dispayed in I_S.INNODB_SYS_DATAFILES

[18 Jun 2016 21:26] Omer Barnir

Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0