SAP Knowledge Base Article - Preview

2787020 - Signal 11 in dcomp__ce_decode_col() when DBCC CHECKDB runs on archive database - SAP ASE 16.0

Symptom

  • Running DBCC CHECKDB on an archive database for an encrypted database caused multiple "infected with signal 11" errors and Error 9829 together with stack traces.
  • Errors observed are:
     
    • Signal 11 (SEGV) in the module dcomp__ce_decode_col() when running DBCC CHECKDB in the archive database:

Current process (0x59ef00b6) infected with signal 11 (SIGSEGV)
Address 0x0x0000000000981564 (dcomp__ce_decode_col+0x97), siginfo (code, address) = (1, 0x0x0000000000000004)

   followed by a stack trace with the following functions:

dcomp__ce_decode_col
decompress__column_by_colinfo
decompress_column_by_colid
bt_copykeyval_datarow
dol_bt_copykeyval_dp
bt__copykeyval_dp
bt__check_keys
bt__do_dfs
bt__do_dfs
bt__do_dfs
bt_index_check
check__index
check_indexes
checktable
checkdb

    • Error 9829 when DBCC CHECKDB is restarted:

Error: 9829, Severity: 22, State: 4
Compressed data row 0x2a9a8c2d2 in objid 121816515, dbid 8 is corrupted

   followed by a stack trace with the following functions:

decompress__column_by_colinfo
decompress_column_by_colid
bt_copykeyval_datarow
dol_bt_copykeyval_dp
bt__copykeyval_dp
bt__check_keys
bt__do_dfs
bt__do_dfs
bt__do_dfs
bt_index_check
check__index
check_indexes
checktable
checkdb

    • Signal 11 (SEGV) in the module dol__index_decompress_row() for same spid

Current process (0xd10069) infected with signal 11 (SIGSEGV)
Address 0x0x0000000000983e85 (dol__index_decompress_row+0x134), siginfo (code, address) = (1, 0x(nil))

   followed by a stack trace with the following functions:

dol__index_decompress_row
index_decompress_row
bt__lfrow_cmp
bt__row_and_rid_compare
bt__notboundby1stkey
bt__unwind
bt__traverse
bt__getstartpg
bt_getnext
dol_bt_getnext
getnext
sdes_scan_setup
ptn_pdes_init
ind__ides_init_fromrow
ind_ides_init
des__fill_common
des(float, int, long, long)
des_do_get
get_name
checktable
checkdb

  • Rebooting ASE cleared the issue.
  • DBCC CHECKDB runs fine when there is no other activity in the ASE server.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

SEGV, segmentation, kisignal, stacktrace,  storage, access, violation, fault, segfault,  registers, CR#817881, CR817881, 817881, encryption , 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.