SAP Knowledge Base Article - Preview

2327341 - Upgrade: Load/online database produces a signal 11 or timeslice error - SAP ASE

Symptom

  • Source ASE (12.5.4, 15.0.x, and 15.5) and target ASE (v16.0) on same Operating System (AIX)
  • Databases are replicated
  • You can see some messages like the following in the errorlog:

server Increase the config parameter 'number of open indexes' to avoid descriptor * * may result in performance degradation.

  • Online database commands returns the following message:

Database '<db_name>': beginning upgrade step [ID 7]:
insert rows into syspartitions for each system table and index
ASE is terminating this process.

  • Load database command returns the message:

Backup Server: 4.188.1.1: Database <db_name>: 92190 kilobytes (100%)LOADED.
Backup Server: 3.42.1.1: LOAD is complete (database <db_name>).
ASE is terminating this process.

  • In some cases when issuing online database after dump database, ASE get infected with signal 11 at ibm_get_lock
  • If hit a signal 11 the stacktrace may include modules such as:

obj_updrow()
des_flush()
des__clean()
des__scavenge()
des_scavenge_for()
ind__ides_install()
ind__ides_init_fromrow()
ind_ides_init()
des__fill_common()
des__fill()
des_do_get()
open__byid()
open_user_table()
upgd__do_fill_ptns()
upgd__upgrade_item()
upgd__depends()
upgd__upgrade_item()
upgd__depends()
upgd__upgrade_item()
upgd_upgrade_db()
onl_online_db()
online_database()


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 12.5.4
  • SAP Adaptive Server Enterprise (ASE) 15.x
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • OS: AIX

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

segmentation, fault, stack trace, lddb_main, online_database, SEGV, storage, access, violation, segfault, kisignal,  stack, registers
, KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.