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 for Me (Login required).

Search for additional results

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