Bug #97839 | CREATE TABLE fails with key_block_size=2 and O_DIRECT | ||
---|---|---|---|
Submitted: | 2 Dec 2019 2:30 | Modified: | 4 Dec 2019 2:23 |
Reporter: | zhai weixiang (OCA) | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[2 Dec 2019 2:30]
zhai weixiang
[3 Dec 2019 13:03]
MySQL Verification Team
HI Mr. weixiang, Thank you for your bug report. However, this is not a bug. The error message has been changed several times, so far in order to make it perfectly easy to understand, which is what we have now. Also, checking for free disk space has been denied for many, many times since year 2000, for a very, very good reason. Simply, another connection, or (altogether) another program could be writing new data or removing old files simultaneously with that particular InnoDB thread. Not a bug.
[4 Dec 2019 2:23]
zhai weixiang
Hey, Sinisa thank you for your comment. Actually my point is: it should give a more clear message. because people may get confused by it since the disk is actually not full. And the reason leading to failure is very clear: the block size is 4k and O_DIRECT requires aligned write. It should throw proper error message in this case.
[4 Dec 2019 13:11]
MySQL Verification Team
Well, it simply can't be done. This is due to the fact that the operating system returns the same errno whether it is out of disk space , has problem with alignments, runs out of quota, etc, etc ......