SAP Knowledge Base Article - Preview

2785031 - Signal 11 in proc_setdb() and Error 9970 occur during DBCC CHECKSTORAGE execution - SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.