Symptom
- The dbccdb database is configured to use DBCC CHECKSTORAGE command and other related system stored procedures.
- The error "process infected with signal 11" in the module proc_setdb() with a stacktrace may be reported in the SAP ASE error log:
Current Process is running on Engine 5
Address 0x0x0000000001e46914 (proc_setdb+0x144), siginfo (code, address) = (1, 0x0x0000000000001250
- When DBCC CHECKSTORAGE is run, and DBCC CHECKSTORAGE aborts with a 9970 error or may hang:
1> dbcc checkstorage(<database name>)
2> go
Checking <database name>: Logical pagesize is <page size> bytes
A non-recoverable error has occurred in the CHECKSTORAGE operation. The operation has been aborted.
Msg 9970, Level 20, State 1:
Server '<server name>', Line 1:
DBCC cannot update the finish time in dbcc_operation_log table for this operation(opid = '1') of database '<database name>'. This can be patched by executing sp_dbcc_patch_finishtime.
DBCC CHECKSTORAGE for database '<database name>' encountered an error. Some results may not be available. Correct the problems reported and reexecute the CHECKSTORAGE command.
Transaction has been aborted.
- The stack trace includes functions:
proc_setdb
proc_get
s_getTreeOrPlan
des__fill_common
des
des_do_get
open__byid
open_user_table
pchk_wt_main
kw_exec
kw_member
Note: A complete stack trace is available under Attachments.
Read more...
Environment
-
SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
Product
Keywords
CR818971, CR#818971, 818971, dbcc checkstorage, 9970, worker process, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, registers , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview