Hello,
I have a SQL Server 2019, running on a Hyper-V machine in a Failover Cluster, with build 15.0.4261.1. I keep on getting Event ID 824:
"SQL Server detected a logical consistency-based I/O error: stale page (a page read returned a log sequence number (LSN) (104:6736:1) that is older than the last one that was written (0:0:0)). It occurred during a read of page (1:23063) in database ID 2 at offset 0x0000000b42e000 in file 'D:\SQLData\MSSQL15.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'. Additional messages in the SQL Server error log or operating system error log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online."
I have tried the following:
Database consistency checks on all Databases, which come back clean
Stopping SQL Services, deleting the TempDB files and starting them again to recreate the temp DB files since this is the database always referenced
Check the SAN that is hosting the Hyper-V cluster, found a bad hard drive and replaced it, there are no longer any errors on the SAN, but the SQL server is still giving me the same error message.
Checked the ILO of the host Server and no hardware errors are being reported.
Checked the event logs for driver errors in the SQL server and cannot find any.
Long story short Event ID 824 is supposed to be either a database error, which I see no signs of or an I/O sub-system which I don't see any signs of. What else should I do what I have not tried already?
In addition, no other databases are having this error besides the tempdb, which is on the same drive as all the other databases, which indicates that it is not a hardware issue, but as I mentioned before, I have deleted and recreated the Tempdb files which indicates that it is not a database issue.