Arch Linux

Spider.007

Member

Registered: 2004-06-20

Posts: 1,175

4.17.3 mariadb - Page cache invalidation failure on direct I/O

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)

loqs

Member

Registered: 2014-03-06

Posts: 17,368

Re: 4.17.3 mariadb - Page cache invalidation failure on direct I/O

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?

Spider.007

Member

Registered: 2004-06-20

Posts: 1,175

Re: 4.17.3 mariadb - Page cache invalidation failure on direct I/O

@loqs, yes that is very likely. As this happens only once every few days, I'm not 100% sure

Spider.007

Member

Registered: 2004-06-20

Posts: 1,175

Re: 4.17.3 mariadb - Page cache invalidation failure on direct I/O

fwiw, I fixed this by specifying

innodb_flush_method = ALL_O_DIRECT