I have 3 Hyper-V servers in a cluster with a SQL2019 VM on one of them.
Recently we got an error in the logs that we cannot find the root cause of.
Could any of you help me in the right direction?
07/29/2020 20:52:57,spid48s,Unknown,The attempt to flush file buffers failed during file close activity.: Operating system error (null) encountered.
07/29/2020 20:52:57,spid48s,Unknown,Error: 17053<c/> Severity: 16<c/> State: 1.
07/29/2020 20:52:57,Logon,Unknown,Login failed for user 'PAS'. Reason: Failed to open the explicitly specified database 'ASGLOBALData'. [CLIENT: 192.168.69.10]
07/29/2020 20:52:57,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 38.
07/29/2020 20:52:57,spid108,Unknown,Database ASGLOBALData was shutdown due to error 9001 in routine 'XdesRMFull::CommitInternal'. Restart for non-snapshot databases will be attempted after all connections to the database are aborted.
07/29/2020 20:52:57,spid108,Unknown,The log for database 'ASGLOBALData' is not available. Check the operating system error log for related error messages. Resolve any errors and restart the database.
07/29/2020 20:52:57,spid108,Unknown,Error: 9001<c/> Severity: 21<c/> State: 4.
07/29/2020 20:52:57,spid8s,Unknown,Write error during log flush.
07/29/2020 20:52:57,spid8s,Unknown,SQLServerLogMgr::LogWriter: Operating system error 1117(The request could not be performed because of an I/O device error.) encountered.
07/29/2020 20:52:57,spid8s,Unknown,Error: 17053<c/> Severity: 16<c/> State: 1.
07/29/2020 20:52:40 Event ID 140 NTFS -
The system failed to flush data to the transaction log. Corruption may occur in VolumeId: E:, DeviceName: \Device\HarddiskVolume6.
(The I/O device reported an I/O error.)
I cannot find any fault in the physical drives or the physical servers themselves.
I'm not fluent in SQL so bear with me 🙂