Bug #88464 Could read about error spotted in 5.7 in 8.0 DOC, but not in 5.7 doc
Submitted: 13 Nov 2017 14:48 Modified: 17 Nov 2017 14:07
Reporter: Shahriyar Rzayev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S2 (Serious)
Version:5.7.19, 5.7.20 OS:Any
Assigned to: CPU Architecture:Any

[13 Nov 2017 14:48] Shahriyar Rzayev
Description:
Got following error in 5.7.19 on Windows 7:

2017-11-11T23:32:07.931542Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2017-11-11T23:32:07.934543Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mobile\partners.ibd' OS error: 71
2017-11-11T23:32:07.937543Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mobile/partners`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2017-11-11T23:32:07.941543Z 0 [Warning] InnoDB: Ignoring tablespace `mobile/partners` because it could not be opened.
2017-11-11T23:32:23.874454Z 3 [ERROR] [FATAL] InnoDB: Tablespace id is 175 in the data dictionary but in file .\mobile\product.ibd it is 142!

Searched and found exact error in 8.0 DOC:

https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html

But could not find same thing in 5.7 DOC:

https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html

How to repeat:
See description.

Suggested fix:
Add same error strings into 5.7 DOC as well for clarity.
[14 Nov 2017 6:45] MySQL Verification Team
Hello Shahriyar,

Thank you for the report.

Thanks,
Umesh
[17 Nov 2017 14:07] Daniel Price
Posted by developer:
 
Cannot Open Data File content was added to the MySQL 5.7 manual. 
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html

The change should appear online soon.
Thank you for the bug report.