MySQL Bugs: #91120: MySQL8.0.11: ibdata1 file size can't be more than 4G

Bug #91120	MySQL8.0.11: ibdata1 file size can't be more than 4G
Submitted:	4 Jun 2018 2:37	Modified:	29 Jul 2019 9:08
Reporter:	Yann Chen	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S1 (Critical)
Version:	MySQL8.0.11GA	OS:	CentOS (CentOS release 6.5 (Final))
Assigned to:		CPU Architecture:	x86
Tags:	MySQL8;ibdata;system tablespace

Description:
Version: MySQL8.0.11GA 

my.cnf: 
innodb_data_file_path=ibdata1:4800M;ibdata2:1000M:autoextend 

Initializing the Data Directory Manually using mysqld 
the ibdata1 file size is 704M not the 4800M 

-rw-r----- 1 mysql mysql 704M Jun 4 09:30 ibdata1 
-rw-r----- 1 mysql mysql 1000M Jun 4 09:30 ibdata2 

error log: 
2018-06-04T01:30:20.326117Z 1 [Note] [MY-012265] [InnoDB] InnoDB: Setting file '/home/mysqldata/ibdata1' size to 4800 MB. Physically writing the file full; Please wait ... 
2018-06-04T01:30:20.327594Z 1 [Note] [MY-012651] [InnoDB] InnoDB: Progress in MB: 
100 200 300 400 500 600 700 
2018-06-04T01:30:21.892689Z 1 [Note] [MY-012266] [InnoDB] InnoDB: File '/home/mysqldata/ibdata1' size is now 4800 MB. 
2018-06-04T01:30:21.892848Z 1 [Note] [MY-012265] [InnoDB] InnoDB: Setting file '/home/mysqldata/ibdata2' size to 1000 MB. Physically writing the file full; Please wait ... 
2018-06-04T01:30:21.894114Z 1 [Note] [MY-012651] [InnoDB] InnoDB: Progress in MB: 
100 200 300 400 500 600 700 800 900 1000 
2018-06-04T01:30:24.787992Z 1 [Note] [MY-012266] [InnoDB] InnoDB: File '/home/mysqldata/ibdata2' size is now 1000 MB.

How to repeat:
set ibdata file size more than 4G;
mysqld --initialize-insecure --user=/mysql --datadir=/home/mysqldata/;

Hello Yen!

Thank you for the report and feedback!

Thanks,
Umesh

Fixed in 8.0.17 under the heading of

Bug#27538464 MORE THAN 2G SYSTEM TABLESPACE (IBDATA) IS NOT CREATED WHEN INITIALIZING