Preset Actions for DBMS Errors and Sybase ASE Logged Alerts

Appendix B

Preset actions for DBMS errors and Sybase ASE logged alerts are listed as follows:

DBMS errors for which an action is preset are listed in Table B-1.
Logged alerts for which an action is preset are listed in Table B-2.

Table B-1 Preset Actions for DBMS Errors

Error Number	Action	Connection State	New State	Message
`601`	`RESTART`	`*`	`*`	`Descriptor for system table in database not found in the descriptor hash table.`
`605`	`RESTART`	`*`	`co`	`Attempt to fetch logical page in database belongs to different object. See errorlog file for further details.`
`623`	`RESTART`	`on`	`*`	`Attempt to retrieve row from page via RID failed because logical page is not a data page.`
`706`	`RESTART`	`on`	`*`	`Process tried to remove PROC_HDR that it does not hold in Pss.`
`707`	`RESTART`	`on`	`*`	`System error detected during attempt to free memory at address ox%1x. See errorlog file for further details.`
`803`	`RESTART`	`on`	`*`	`Unable to place buffer holding logical page in sdes. See errorlog file for further details.`
`804`	`RESTART`	`on`	`co`	`Unable to find buffer holding logical page in sdes.`
`806`	`RESTART`	`on`	`co`	`Could not find virtual page for logical page %ld in database '%S_DBID'.`
`813`	`NONE`	`on`	`co`	`Logical page in database is already hashed. See errorlog file for further details.`
`821`	`RESTART`	`on`	`co`	`Attempt to unhash buffer. See errorlog file for further details.`
`822`	`SWITCH`	`*`	`*`	`Could not start I/O for request BLKIO. See errorlog file for further details.`
`823`	`STOP`	`*`	`*`	`I/O error detected during %S_MSG for %S_BUF.`
`921`	`NONE`	`*`	`*`	`Database has not recovered yet.`
`945`	`RESTART`	`on`	`co`	`Function %s was asked to locate page in database.`
`1207`	`RESTART`	`on`	`co`	`Locksleep called with bad process id. See errorlog file for further details.`
`1265`	`RESTART`	`on`	`*`	`A lock manager routine expected a lock record as an argument but was passed something else.`
`1509`	`STOP`	`on`	`*`	`Row compare failure.`
`1510`	`STOP`	`on`	`*`	`Sort failed: Out of space in database.`
`1602`	`STOP`	`on`	`*`	`Unable to initialize network.`
`1605`	`STOP`	`on`	*	`Failed to open virtual socket for new connections.`
`1813`	`RESTART`	`on`	*	`Cannot open new database. CREATE DATABASE is aborted.`
`3002`	`RESTART`	`on`	`co`	`DUMP DATABASE for database '%.*' failed to remove alarm with ID = %d. See errorlog file for further details.`
`3307`	`RESTART`	`on`	`co`	`Process %d was expected to hold logical lock on page %ld. See errorlog file for further details.`
`4002`	`NONE`	`*`	`co`	`Login failed. Please check fault monitor user id and password specified in the CONNECT_STRING property`
`4067`	`NONE`	`*`	`co`	`Login failed. Please check fault monitor user id and password specified in the CONNECT_STRING property`
`6902`	`SWITCH`	`on`	`co`	`Page timestamp value falls between the old and new timestamps from log.`
`7409`	`SWITCH`	`on`	`*`	`This task tried to sleep waitng for space to become available in the log, but could not.`
`7410`	`SWITCH`	`on`	`*`	`Function called with invalid argument. See errorlog file for further details.`
`7412`	`RESTART`	`on`	`*`	`Space available in the log segment has fallen critically low in database.`
`7413`	`RESTART`	`on`	`*`	`Task(s) are sleeping, waiting for space to become available in the log segment for database.`
`8201`	`RESTART`	`on`	`*`	`Keep count of descriptor was expected to be %d. Instead %d was found.`
`8203`	`RESTART`	`on`	`*`	`Expected to find the descriptor in %s state.`
`8204`	`STOP`	`on`	`*`	`Expected to receive system catalog id.`
`8211`	`RESTART`	`on`	`*`	`Mismatch found between the name and id descriptor hash table.`
`8704`	`RESTART`	`on`	`*`	`Could not get the address lock.`
`17716`	`RESTART`	`on`	`*`	`Could not update the last-chance threshold for database"; }`
`16843058`	`NONE`	*	co	Connection broken.
`16843175`	`NONE`	*	co	Error in performing requested operation
`33620275`	`NONE`	`*`	`co`	`Error in performing requested operation`
`84083972`	`RESTART`	`*`	`co`	`Server is not up, restarting`
`84083974`	`NONE`	`*`	`co`	`Server is recovering`

Table B-2 Preset Actions for Sybase ASE Alerts

Alert String	Action	Connection State	New State	Message
`server: Buffer`	`STOP`	`on`	co	`server error`
`kistartup: could`	`RESTART`	`*`	co	`kistartup: could not create shared memory`
`Kernel: current`	`NONE`	`*`	`co`	`Kernel: current process infected with %d`
`kernel: dstart I/O`	`STOP`	`*`	*	`kernel: dstart I/O request repeatedly delayed; block number: %ld, vdn: %ld. See errorlog file for further details`
`basis_dlock:`	`STOP`	`*`	*	`basis_dlock: file '%s' already in use by a SQL Server`
`Physical memory`	`STOP`	`*`	*	`Physical memory on this machine might be too fragmented`
`server: Warning:`	`NONE`	`*`	co	`OPEN OBJECTS parameter might be too low; attempt was made to free up descriptor in desfree(). Run sp_configure to increase parameter value.`
`kernel: write`	`STOP`	`*`	*	`kernel: write error on virtual disk %d, block %ld. See errorlog file for further details`
`kernel: read`	`STOP`	`*`	*	`kernel: read error on virtual disk %d, block %ld. See errorlog file for further details`
`Stack Guardword`	`SWITCH`	`*`	*	`kernel: *** Stack Guardword corrupted`

Skip Navigation Links
Exit Print View
	Oracle Solaris Cluster Data Service for Sybase ASE Guide