SAP Knowledge Base Article - Preview

2572913 - ASE dump transaction failing when triggered from threshold procedure - SAP ASE on BS

Symptom

  • You have implemented log free threshold procedure suggested by SAP Note 1801984 free up space in the transaction log that has been filled due to a long running transaction (sp_thresholdaction_logfreespace)
  • ASE SP version is >= ASE 16 SP02 PL01, which support full database encryption.
  • SID database is encrypted.
  • ASE error log is reporting signal 11 and stacktrace for sp_thresholdaction_logfreespace procedure when trying to dump transaction, involving those modules:

    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel Current process (0x72701a5) infected with signal 11 (SIGSEGV)
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel Address 0x0x0000000001a3d73d (dmpx__find_dmpxact_type+0x7d), siginfo (code, address) = (1, 0x0x000000000000003a)
    .....
    .....
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel Current statement number: 17 Current line number: 4
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel ************************************
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx server SQL Text: saptools..sp_thresholdaction_logfreespace <SID>, logsegment, xx
    00:0008:00000:00212:2017/02/24 22:57:00.16 server SQL Text:

                     dump transaction @dbname using config = '<SID>LOG'
    .....
    .....
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel pc: 0x0000000001a3d73d dmpx__find_dmpxact_type+0x7d()
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel pc: 0x0000000001a3a4d1 dmpx__setup+0x101()
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel [Handler pc: 0x0x0000000000b0fb3a dpdb_handle installed by the following function:-]
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel pc: 0x0000000001a394ce dmpx_truncatemain+0x1ce()
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel pc: 0x0000000001a391f3 dmpxact+0x63()

  • As per ASE and Backup Server logs, this doesn't happens on each dumps but at least the third time the dump is triggered thru the threshold procedure.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

Keywords

transaction, dump, signal 11, dmpx__find_dmpxact_type, sp_thresholdaction_logfreespace, 806252 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.