Please check if ALL_O_DIRECT is ON if InnoDB log I/O fails with errno == 22 "Invalid argument"
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
| 5.5 |
Fix Released
|
Medium
|
Laurynas Biveinis | |||
| 5.6 |
Fix Released
|
Medium
|
Laurynas Biveinis | |||
| 5.7 |
Fix Released
|
Medium
|
Laurynas Biveinis | |||
Bug Description
In case, described in bug #1155156, MySQL Server fails with errno == 22 "Invalid argument", because innodb_flush_method was set to ALL_O_DIRECT and logs became unusable due to bug #1529885.
Issue here is what error message is not clear and does not shed light on what really was going on. Also, even if bug #1155156 will be fixed, suggested error message would not help in case if reason of the error would be ALL_O_DIRECT. Therefore it is better to have one more check in code: for ALL_O_DIRECT and if reason of failure is this add additional message into error log which will ask the user to file a bug with us with innodb-
workaround suggest to remove ALL_O_DIRECT.
| tags: | added: xtradb |
| Laurynas Biveinis (laurynas-biveinis) wrote | #1 |
| Sveta Smirnova (svetasmirnova) wrote | #2 |
| Laurynas Biveinis (laurynas-biveinis) wrote | #3 |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #4 |
Sveta, a tentative fix produces the following output in the error log, please check if OK (the very first and the very last lines come from context that is likely to be different in the real occurences, this is a simulated testcase error). The line with innodb_
InnoDB: Database physically writes the file full: wait...
160506 15:16:43 InnoDB: Error: Write to file ./ib_logfile0 failed at offset 0 0.
InnoDB: 1048576 bytes should have been written, only 0 were written.
InnoDB: Operating system error number 22.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 22 means 'Invalid argument'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://
InnoDB: the error might be caused by redo log I/O not satisfying innodb_
InnoDB: this might be caused by an incompatible non-default innodb_
InnoDB: please file a bug at https:/
InnoDB: a possible workaround is to change innodb_flush_method value to something else than ALL_O_DIRECT.
InnoDB: Error in creating ./ib_logfile0: probably out of disk space
160506 15:16:43 [ERROR] Plugin 'InnoDB' init function returned error.