Due to reported BUG report(BUG 73365) i am testing full disk error conditions with MySQL 5.6.19-debug-log.
There were some interesting error messages in error log:
2014-07-23 08:09:59 7f44500f0700 InnoDB: Error: Write to file ./xxx/news.ibd failed at offset 218103808. InnoDB: 1048576 bytes should have been written, only -1 were written. InnoDB: Operating system error number 28. 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 28 means 'No space left on device'.
InnoDB: 1048576 bytes should have been written, only -1
were written.
So what is “-1″ here?
The answer from:
[24 Jul 16:02] David Bennett
The -1 value is an error return from the os_file_pwrite() function in …
[Read more]