Error 823



Message text

I/O error detected during %S_MSG for %S_BUF.

NoteThis 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. It usually means you have disk problems. The parameters in the error message refer to internal Sybase structures and do not often help determine which device is involved. However, additional kernel messages in Adaptive Server’s error log recorded before the 823 error was raised should indicate which device is involved.

Causes of the 823 error can include the following:


Check the accessibility and condition of the device in question. Once you have identified and corrected the problem, execute the dbcc checkdb and dbcc checkalloc commands to ensure that no other damage was caused by the bad device.

AIX systems only

Error 823 may occur if the disk device is run under the logical volume manager (LVM), vstart is equal to 2 and the size is not shortened by 2. vstart needs to be equal to 2 because the first AIX block (1 AIX block equals 2 Sybase pages) has to be available for the LVM control block (LVCB).

NoteYou may encounter false 823 errors when you perform I/O operations on the IBM Regatta family of servers. This is caused by a cache line synchronization problem on this family of servers. See TechNote 1023360 for details and the solution from IBM. Also, on AIX 5.3 false 823 errors can occur on any IBM servers (not just Regattas) due to IBM APAR IY80355, which may show up on any version that does not include the fix in Adaptive Server Enterprise version 12.5.2 ESD #2, version 12.5.3 ESD #1, and version 15.0.x).

Versions in which this error is raised

All versions