Bug #77056 There is no clear error message if innodb_data_file_path is wrong

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.

Hello Daniël,

Thank you for the report.

Thanks,
Umesh

// 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

tagged

Posted by developer:
 
print [ERROR] InnoDB: syntax error in file path or size specified is less than 1 megabyte

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.

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.

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