innodb does not report filename in I/O error message
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Wishlist
|
Unassigned | |||
5.5 |
Triaged
|
Wishlist
|
Unassigned | |||
5.6 |
Triaged
|
Wishlist
|
Unassigned | |||
5.7 |
Triaged
|
Wishlist
|
Unassigned |
Bug Description
InnoDB experienced an I/O error and crashed but did not report the name of the file it was trying to read
2015-01-18 19:00:57 5260 [ERROR] InnoDB: Tried to read 16384 bytes at offset 536
428544. Was only able to read 0.
2015-01-18 19:00:57 7f6190e5a700 InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means 'Input/output error'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://
2015-01-18 19:00:57 5260 [ERROR] InnoDB: File (unknown): 'read' returned OS error 105. Cannot continue operation
150118 19:00:57 mysqld_safe Number of processes running now: 0
150118 19:00:57 mysqld_safe mysqld restarted
mysql Ver 14.14 Distrib 5.6.22-71.0, for Linux (x86_64) using EditLine wrapper
Server version: 5.6.22-71.0-log Percona Server (GPL), Release 71.0, Revision 726
CentOS release 6.5 (Final)
Linux 2.6.32-
This is easy to confirm by code review:
[openxs@chief percona-5.6]$ grep -rn os_file_ handle_ error_cond_ exit * innobase/ os/os0file. cc:586: os_file_ handle_ error_cond_ exit( innobase/ os/os0file. cc:684: return( os_file_ handle_ error_cond_ exit(name, operation, TRUE, FALSE)); innobase/ os/os0file. cc:700: return( os_file_ handle_ error_cond_ exit( innobase/ os/os0file. cc handle_ error * innobase/ os/os0file. cc:586: os_file_ handle_ error_cond_ exit( innobase/ os/os0file. cc:678: os_file_ handle_ error( innobase/ os/os0file. cc:684: return( os_file_ handle_ error_cond_ exit(name, operation, TRUE, FALSE)); innobase/ os/os0file. cc:692: os_file_ handle_ error_no_ exit( innobase/ os/os0file. cc:700: return( os_file_ handle_ error_cond_ exit( innobase/ os/os0file. cc:841: os_file_ handle_ error(dirname, "opendir"); innobase/ os/os0file. cc:852: os_file_ handle_ error(dirname, "opendir"); innobase/ os/os0file. cc:874: os_file_ handle_ error_no_ exit(NULL, "closedir", FALSE); innobase/ os/os0file. cc:886: os_file_ handle_ error_no_ exit(NULL, "closedir", FALSE); innobase/ os/os0file. cc:958: os_file_ handle_ error_no_ exit(NULL, "readdir_ next_file" , FALSE); innobase/ os/os0file. cc:1044: os_file_ handle_ error_no_ exit(full_ path, "stat", FALSE); innobase/ os/os0file. cc:1094: os_file_ handle_ error_no_ exit( innobase/ os/os0file. cc:1108: os_file_ handle_ error_no_ exit(pathname, "mkdir", FALSE); innobase/ os/os0file. cc:1216: retry = os_file_ handle_ error( innobase/ os/os0file. cc:1283: retry = os_file_ handle_ error( innobase/ os/os0file. cc:1533: os_file_ handle_ error_no_ exit(name, "ioctl", FALSE); innobase/ os/os0file. cc:1704: retry = os_file_ handle_ error_no_ exit( innobase/ os/os0file. cc:1707: retry = os_file_ handle_ error(name, operation); innobase/ os/os0file. cc:1789: retry = os_file_ handle_ error_no_ exit( innobase/ os/os0file. cc:1792: retry = os_file_ handle_ error(name, operation); innobase/ os/os0file. cc:1912: os_file_ handle_ error_no_ exit(name, "delete", FALSE); innobase/ os/os0file. cc:1976: os_file_ handle_ error_no_ exit(name, "delete", FALSE); innobase/ os/os0file. cc:2020: os_file_ handle_ error_no_ exit(oldpath, "rename", FALSE); innobase/ os/os0file. cc:2029: os_file_ handle_ error_no_ exit(oldpath, "rename", FALSE); innobase/ os/os0file. cc:2060: os_file_ handle_ error(NULL, "close"); innobase/ os/os0file. cc:2069: os_file_ handle_ error(NULL, "close"); innobase/ os/os0file. cc:2170: os_file_ handle_ error_no_ exit (name, "posix_fallocate", innobase/ os/os0file. cc:2360: os_file_ handle_ error(NULL, "flush"); innobase/ os/os0file. cc:2414: os_file_ handle_ error(NULL, "flush");
storage/
storage/
storage/
[openxs@chief percona-5.6]$ vi +684 storage/
[openxs@chief percona-5.6]$ grep -rn os_file_
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/
storage/i...