24
I/O error detected for device '%.*s' (with physical name '%.*s', and virtual device number %d).
This error may be caused by a hardware problem.
This error occurs when Adaptive Server encounters an I/O error on a read or write request made to a Sybase device. The error is accompanied by error 823 and is seen during dbcc operations.
The parameters in the error message refer to the Sybase logical device name, the physical operating system location of the device, and the virtual device number (a unique identifier for the device).
Error 849 is related to:
Hardware problems on a disk where a Sybase device resides.
A disk mirroring problem in Adaptive Server. Disk mirrors allow an Adaptive Server database device to be duplicated, that is, all writes to the device are also copied to a separate physical device. If an I/O to a mirrored device fails, Adaptive Server “unmirrors” the bad device and continues to run unmirrored. Due to the disk mirroring problem, while a disk failure in the primary device unmirrors the device, it does not stop the server from initiating further I/O’s to the unmirrored device, raising error 849.
Check your operating system logs for any information about hardware problems on a disk containing a Sybase device. Because error 849 accompanies and provides supporting data for 823 errors, refer to “Error 823” for more troubleshooting information. In the event of hardware failure, you will need to restore the affected databases from clean backups.
If your site uses disk mirroring, error 849 may indicate that Adaptive Server continued to issue I/O’s to a failed primary device. Contact Sybase Technical Support for assistance.
When calling Sybase Technical Support, have available the information listed in “Reporting errors”.
All versions
