Login | Sign Up
ErrorKey - Search engine for Error codes and messages     
  Unix Solaris  [ 182 result(s) ]
 823 Severity Level 24  -  I/O error detected during %S_MSG for %S_BUF.  SYBASE SQL Server
This error occurs when SQL 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 SQL Server’s error log recorded before the 823 error should indicate which device is involved.
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. SunOS 4.x (Sun Solaris 1.x) The 823 error can also appear if the Sun operating system is not configured correctly for asynchronous I/O. SQL Servers running on Sun machines can use asynchronous I/O on raw partitions without any special kernel enhancements such as the MtXinu DBM or Sun DBE. A SQL Server running on a SunOS 4.1 or later operating system attempts to do asynchronous I/O on raw partitions. Successful use of asynchronous I/O requires that the UNIX kernel be configured to support it. Two options must be included in the Sun operating system kernel configuration file when the kernel is built. These are: options LWP # kernel threads options ASYNCHIO # asynch I/O (requires LWP) You can find examples of how to set these options in the original GENERIC configuration file usually found in /sys/{sun3, sun4}/conf. The exact location of these files may vary. Do not comment out these options. An improperly configured kernel causes SQL Server to fail the first time it attempts to do I/O to a raw partition. For example, if your master device is on a raw partition, and you attempt to start SQL Server with that master device, SQL Server displays the following message: kernel: read error on virtual disk 0 block 28 kernel: inval