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 ONE Support launchpad (Login required).

Search for additional results

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