SQL Server Linux: fsync and Buffered I/O

Moved from: bobsql.com


I was asked to validate  the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article


An example of the error: The application does a buffered write and receives success. (This means data can be stored in file system cache, non-stable media.)  An fsync/fdatasync is used to make sure the data is stored in stable media.  The stable media write(s) occurs during the sync operation and can fail for any number of reasons (out of disk space, lost connectivity to SAN, etc.) reporting an EIO error.


The issue, as described in the link, is that