Ignoring an Error Whose Effects Are Minor

If the effects of an error to which the server fault monitor responds are minor, ignoring the error might be less disruptive than responding to the error.

For example, see the following error message:

Unable to find buffer 0x%lx holding logical page %ld in sdes 0x%lx 
kept buffer pool for object '%.*s'.

The preset action for Sybase ASE error 804, Unable to find buffer 0x%lx holding logical page %ld in sdes 0x%lx kept buffer pool for object '%.*s'. is restart. This error occurs when Adaptive Server cannot find the pointer to a buffer header in a session descriptor. This error can be transient. In this situation, consider specifying that the server fault monitor ignore the error.

The following example shows an entry in a custom action file for ignoring a DBMS error.

Example 2 Ignoring a DBMS Error

{
ERROR_TYPE=DBMS_ERROR;
ERROR=804;
ACTION=none;
CONNECTION_STATE=*;
NEW_STATE=*;
MESSAGE="Unable to find buffer 0x%lx holding logical page %ld in sdes 
0x%lx kept buffer pool for object '%.*s'.";
}

This example shows an entry in a custom action file that overrides the preset action for DBMS error 804. This entry specifies the following behavior:

• The server fault monitor ignores DBMS error 804.

• This entry applies regardless of the state of the connection between the database and the server fault monitor when the error is detected.

• The state of the connection between the database and the server fault monitor must remain unchanged after the error is detected.

• No additional message is printed to the resource's log file when this error is detected.