Error 605 - stale read

We're running SQL Server 2K sp3a on 2003 Server. Our user databases are on
an HP SAN. During heavy data warehouse ETL DTS operations we occasionally
get I/O errors such as:
DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005)
Error string: I/O error (bad page ID) detected during read at offset
0x0000020a472000 in file 'W:\SQLServer\Data\ColleagueRaw_Data.MDF'.
Running DBCC CHECKDB after a processing failure sometimes shows consistency
errors with the table associated with the I/O failure. Running DBCC again
without the REPAIR_REBUILD option will then not show any errors.
Running SQLIOStress fails with stale read errors such as:
ERROR: Stale read check failure. Page image returned does not match
previous write.
Running SQLIOStress on different boxes against the SAN results in the same
errors. Write caching is not enabled on the SAN.
Does anyone have any ideas'
Thanks much!whit wrote:
> We're running SQL Server 2K sp3a on 2003 Server. Our user databases
> are on an HP SAN. During heavy data warehouse ETL DTS operations we
> occasionally get I/O errors such as:
> DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259
> (80004005) Error string: I/O error (bad page ID) detected during
> read at offset 0x0000020a472000 in file
> 'W:\SQLServer\Data\ColleagueRaw_Data.MDF'.
> Running DBCC CHECKDB after a processing failure sometimes shows
> consistency errors with the table associated with the I/O failure.
> Running DBCC again without the REPAIR_REBUILD option will then not
> show any errors.
> Running SQLIOStress fails with stale read errors such as:
> ERROR: Stale read check failure. Page image returned does not match
> previous write.
> Running SQLIOStress on different boxes against the SAN results in the
> same errors. Write caching is not enabled on the SAN.
> Does anyone have any ideas'
Looks like a MS PSS (http://support.microsoft.com) case, they should be able
to help you.
You may also want to read this:
PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
Problems
http://support.microsoft.com/defaul...kb;en-us;826433
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.