You are not logged in.
I've seen this message twice now, but I can't find much about it. Under certain load, my mariadb explodes, logging:
Page cache invalidation failure on direct I/O. Possible data corruption due to collision with buffered I/O!
139891023111936 [ERROR] InnoDB: The OS said file flush did not succeed
File: /var/lib/mysql/xxx.ibd PID: 35623 Comm: kworker/20:2
Is this a bug? Can I work around this? I have never seen this message before, this machine has been running for years without any issues
Last edited by Spider.007 (2018-07-13 09:29:58)
Offline
Was the update to 4.17.3 the first update to the 4.17 series for that system? Has the system been updated to a newer 4.17 release since?
Offline
@loqs, yes that is very likely. As this happens only once every few days, I'm not 100% sure
Offline
fwiw, I fixed this by specifying
innodb_flush_method = ALL_O_DIRECT
Offline