Server Error Messages 800 - 899
806
870 10 WARNING!!! Y o u may have to change the log I/O size for the database ` % .*s ' . Current
setting is `%dK' and the cache `%.*s' does not have a `%dK' memory pool.
Explanation: This is an informational message. Unless otherwise specified, no action
is required. Contact your System Administrator about any warning issued in the message.
871 20 Process %d is trying to release a latch on buffer 0x%x (dbid: %d, pageno: %d) without
holding a latch on the buffer.
Explanation: Adaptive Server encountered an internal error affecting the current
process. Reconnect to Adaptive Server. Report the error to your System Administrator so
dbcc diagnostics can be run.
872 20 Process %d is trying to get a %s latch on buffer 0x%x (dbid: %d, pageno: %d) while
already holding a %s latch on the buffer.
Explanation: Adaptive Server encountered an internal error affecting the current
process. Reconnect to Adaptive Server. Report the error to your System Administrator so
dbcc diagnostics can be run.
873 20 Process %d is requesting %s latch on buffer 0x%x (dbid: %d, pageno: %d) while holding
%d latches. A process can hold only %d latches at a time.
Explanation: Adaptive Server encountered an internal error affecting the current
process. Reconnect to Adaptive Server. Report the error to your System Administrator so
dbcc diagnostics can be run.
874 20 Process %d is trying to unkeep buffer 0x%x (dbid: % d, pageno: %d) without releasing the
%s latch it holds on t he buffer.
Explanation: Adaptive Server encountered an internal error affecting the current
process. Reconnect to Adaptive Server. Report the error to your System Administrator so
dbcc diagnostics can be run. This is an informational message. Unless otherwise
specified, no action is required. Contact your System Administrator about any warning
issued in the message.
875 20 Unable to grab a buffer to allocate a page to the log in database id %d. Tried %d buffers
in the wash but found them to be pinned (either directly or indirectly). See the error log
for more information.
Explanation: Adaptive Server encountered an internal error affecting the current
process. Reconnect to Adaptive Server. Report the error to your System Administrator so
dbcc diagnostics can be run.
876 20 The process is holding log semaphore on database %d and is about to sleep on
mass=0x%x with stat=0x%x for page=%ld which is being writte n by some ot her proc ess
that needs the log semaphore. This causes a deadlock, and c an only be cleared by a reboot.
Explanation: Adaptive Server encountered an internal error affecting the current
process. The System Administrator can clear the problem by restarting the server.
878 21 Task %d was expected to hold latch on buffer 0x%x of page %ld in database %d.
Explanation: Adaptive Server encountered an internal error affecting all processes in
the current database. Report the error to your System Administrator. Adaptive Server
must be restarted and dbcc diagnostics run.
Number Severity Text and Explanation