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
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.