SAP Knowledge Base Article - Preview

2447629 - Signal 11 in dol_update / decompress_column_by_coloff or error 644 / 2601 on sysdatabases on alter database - SAP ASE

Symptom

  • Run 'alter database' command changing options 'set compression' and 'lob_compression' in a single command :

 alter database my_db set compression = page, lob_compression = 101
 go

  • ASE errorlog shows entries inlcuding :
Current process infected with signal 11 (SIGSEGV)
Address hex# (dol_update+0x18bd)
SQL causing error : alter database testdb set compression = page, lob_compression = 101
dol_update
update
update_row
altdb__changeoption
alterdb
  • ASE errorlog shows the following error:
Current process infected with signal 11 (SIGSEGV)
Address hex# (decompress_column_by_coloff+0x7f)
decompress_column_by_coloff
set_do_keys
dol_ncdelete
dol_update
dol_def_update
dodeferred
update_row
altdb__changeoption
alterdb
  • Error 644 returned to client and shown in ASE errorlog
Msg 644, Level 21, State 5:
Server 'ASE', Line 1:
Index row entry for data row id (x, y) is missing from index page 1234 of index id 2 of table 'sysdatabases' in database 'master'. Xactid is (456,1). Drop and re-create the index.

  • Error 2601 returned to client
Message: 2601, State 6, Severity 14
Server 'ASE', Line 1:
Attempt to insert duplicate key row in object 'sysdatabases' with unique index 'ncsysdatabases'.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

altdb__changeoption , dol_update , update , update_row , altdb__changeoption, alterdb , altdb__changeoption, decompress_column_by_coloff, set_do_keys, dol_ncdelete, dol_update, dol_def_update, dodeferred, update_row , KBA , 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.