20
I/O error detected on disk buffer 0x%X for page request %ld, dbid %d.
When you issue dbcc commands such as dbcc checkalloc or dbcc checkdb, Adaptive Server reads a specified number of pages from disk into disk buffers so that consistency checks can be carried out on the pages. Error 9004 is raised when the server attempts a synchronous disk read during dbcc processing, but the request fails with an I/O error.
Check the server error log for similar errors from other operations,
such as an 823 error when running a query ("I/O
error detected during %S_MSG for %S_BUF.")
or sddone errors ("sddone:write
error on virtual disk %d"). Refer
to the write-ups for those errors elsewhere in this manual for more
information. Since Adaptive Server reports 9004 and similar errors
when its I/O operation receives an unsuccessful return value,
these errors can be an early warning of disk problems.
Check your disks as follows:
Note the database ID shown in the 9004 message text.
Identify the affected devices using the steps shown in “Determining the physical device on which a database resides” in the chapter “Other Useful Tasks” in the most recent version of Troubleshooting and Disaster Recovery.
Examine the availability and condition of the devices using your standard operating system procedures.
See “Checking the operating system error log” in the chapter “Other Useful Tasks” in the most recent version of Troubleshooting and Disaster Recovery if you need assistance in locating the system log.
All versions
