Bug #77056 There is no clear error message if innodb_data_file_path is wrong
Submitted: 16 May 2015 6:57 Modified: 20 May 2015 13:48
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.7.7-rc, 5.7.8, 8.0.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: regression

[16 May 2015 6:57] Daniël van Eeden 
Description:
If you set innodb_data_file_path to:

"ibdata1:12M:ibdata2:12M:autoextend"

instead of

"ibdata1:12M;ibdata2:12M:autoextend"

And then there is no clear error in the error log about what went wrong:
2015-05-16T06:49:05.306263Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2015-05-16T06:49:05.306333Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-05-16T06:49:05.306357Z 0 [ERROR] Failed to initialize plugins.
2015-05-16T06:49:05.306373Z 0 [ERROR] Aborting

How to repeat:
Set innodb_data_file_path to something invalid.

Suggested fix:
Return a more specific and useful error.
[18 May 2015 7:32] MySQL Verification Team 
Hello Daniël,

Thank you for the report.

Thanks,
Umesh
[18 May 2015 7:33] MySQL Verification Team 
// 5.6.26 (it complains syntax issue)

2015-05-18 09:26:02 8469 [ERROR] InnoDB: syntax error in innodb_data_file_path or size specified is less than 1 megabyte
2015-05-18 09:26:02 8469 [ERROR] Plugin 'InnoDB' init function returned error.
2015-05-18 09:26:02 8469 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-05-18 09:26:02 8469 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-05-18 09:26:02 8469 [ERROR] Aborting

// 5.8.0 - affected

2015-05-18T07:17:41.115737Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2015-05-18T07:17:41.115758Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-05-18T07:17:41.115763Z 0 [ERROR] Failed to initialize plugins.
2015-05-18T07:17:41.115766Z 0 [ERROR] Aborting

// 5.7.8 - affected

2015-05-18T07:21:38.986648Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2015-05-18T07:21:38.986677Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-05-18T07:21:38.986682Z 0 [ERROR] Failed to initialize plugins.
2015-05-18T07:21:38.986684Z 0 [ERROR] Aborting
[18 May 2015 13:57] Daniël van Eeden 
tagged
[20 May 2015 7:02] Shaohua Wang 
Posted by developer:
 
print [ERROR] InnoDB: syntax error in file path or size specified is less than 1 megabyte
[20 May 2015 13:48] Daniel Price 
Posted by developer:
 
Fixed as of the upcoming 5.7.8, 5.8.0 release, and here's the changelog entry:

Starting the server with an invalid "innodb_data_file_path" setting did
not produce a sufficiently informative error message. 

Thank you for the bug report.
[20 May 2015 13:50] Daniel Price 
Posted by developer:
 
commit 09aa7d7ef26fbc5e9c58b486fdd29cf7250f751a
Author: Shaohua Wang <shaohua.wang@oracle.com>
Date:   Wed May 20 12:55:29 2015 +0800

    BUG#21103446        THERE IS NO CLEAR ERROR MESSAGE IF INNODB_DATA_FILE_PATH
    
    Print error message: syntax error in file path.
[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