SAP Knowledge Base Article - Preview

1928214 - ASE 15.0.3 is infected with signal 11 in function bt_gc_cmtdelonly() - SAP ASE

Symptom

  •  ASE 15.0.3 or above may hit a stacktrace on signal 11 on bt__gc_cmtdelonly and contains most of the following modules:
       bt__gc_cmtdelonly+0x13c()
       bt__traverseandinsert+0x68()
       bt_insert+0x174()
       dol__ncinsert+0x3d4()
       obj_newrow+0x3b4()
       crt_main__fdpr_8+0x7fc()
       s__crtinto+0x164()
  • 00:04:00000:01998:2013/03/14 02:30:47.98 kernel  Address 0x0x0000000000af37b7 (bt__gc_cmtdelonly+0x287), siginfo (code, address) = (1, 0x(nil))
    00:04:00000:01998:2013/03/14 02:30:47.98 server  Maxdumps (5) reached for signal 11. Not performing shared memory dump.
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  ************************************
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  SQL causing error : sel_AnyProductComplete @num_tr=@p1 , @typ_op=@p2, @with_contract=@p3ì
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  Current Procedure: sel_opt_flex_1_Complete
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  Current statement number: 7 Current line number: 82
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  ************************************
    00:04:00000:01998:2013/03/14 02:30:47.98 server  SQL Text: sel_AnyProductComplete @num_tr=@p1 , @typ_op=@p2, @with_contract=@p3ì
    00:04:00000:01998:2013/03/14 02:30:47.98 server  SQL Text: select * into #tmp_sel_complement from tmp_sel_complement where 1=2
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  curdb = 27 tempdb = 27 pstat = 0x10000 p2stat = 0x101002
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  lasterror = 0 preverror = 0 transtate = 0
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  curcmd = 195 program =                         
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  extended error information: hostname:  login:
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  pc: 0x000000000176740f pcstkwalk+0x30()
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  pc: 0x0000000001767205 ucstkgentrace+0x1a5()
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  pc: 0x0000000001706771 ucbacktrace+0x43()
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  pc: 0x000000000074360e terminate_process+0xd5e()
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  pc: 0x0000000001733d03 kisignal+0x3b3()
    00:04:00000:01998:2013/03/14 02:30:47.98 kernel  pc: 0x0000000000af37b7 bt__gc_cmtdelonly+0x287()
    00:04:00000:01998:2013/03/14 02:30:47.99 kernel  pc: 0x000000000198c307 bt__insert_into_leaf+0x177()
    00:04:00000:01998:2013/03/14 02:30:47.99 kernel  pc: 0x000000000198bef0 bt__traverseandinsert+0x50()
    00:04:00000:01998:2013/03/14 02:30:47.99 kernel  pc: 0x0000000000af5168 bt_insert+0x1a8()
    00:04:00000:01998:2013/03/14 02:30:47.99 kernel  pc: 0x0000000000ad406b dol__ncinsert+0x24b()
    00:04:00000:01998:2013/03/14 02:30:47.99 kernel  pc: 0x0000000001950acf dol_insert+0xeef()
    00:04:00000:01998:2013/03/14 02:30:47.99 kernel  pc: 0x000000000195f0f5 ins_insert+0x2a5()
  • Error 644 can also be seen at the time of the issue.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.0.3
  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver
  • Solaris on Sparc 64bit
  • Solaris on x86_64 64bit

Product

SAP Adaptive Server Enterprise 16.0

Keywords

signal 11, error 614, function, bt_gc_cmtdelonly(), stacktrace, CR612661, CR#612661, 612661 , 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 for Me (Login required).

Search for additional results

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