SAP Knowledge Base Article - Preview

2072912 - Signal 11 in modules search_tbt and strncopy - SAP ASE for BS

Symptom

  • You are running applications on the SAP ASE database
  • While generating a stack trace error on the ASE, a SIGSEGV (Signal 11) or timeslice error is observed in search_tbt() or strncpy().
    Below is an example of the stacktrace when this problem occurs:

00:0009:00000:03817:2014/09/19 09:25:54.73 kernel  Current process (0xb2f0486) infected with signal 11 (SIGSEGV)
00:0009:00000:03817:2014/09/19 09:25:54.77 kernel  Address 0x00000001007e68a8 (strncpy+0xec), siginfo (code, address) = (50, 0x000000013e53e000)
00:0009:00000:03817:2014/09/19 09:25:54.77 kernel  **** Saved signal context (0x00000001ba00dfc0): ****
00:0009:00000:03817:2014/09/19 09:25:54.77 kernel  __sc_onstack: 0x0, __sc_uerror: 55
00:0009:00000:03817:2014/09/19 09:25:54.77 kernel  uc_sigmask: 0xffffffff1ffef877 0xffffffffffffffff 0xffffffffffffffff 0x7fffffffffffffff
00:0009:00000:03817:2014/09/19 09:25:54.77 kernel  Machine Save State:
00:0009:00000:03817:2014/09/19 09:25:54.77 kernel  PC (iar): 00000001007e68a8 (strncpy+0xec)
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  Link Register (lr): 0000000100f6a4c8 (search_tbt+0x1ec)
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  Stack Pointer (stkp): 00000001ba00e4b0
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  msr : a00000000000d032  ctr : ffffffffd318cbe8  cr  : 22424822
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  xer : 20000050
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r0  : 0000000000000002  r1  : 00000001ba00e4b0  r2  : 0000000110778458
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r3  : 00000001116ce5b0  r4  : 00000001c6388bd3  r5  : 000000013e53dfff
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r6  : 0000000000000000  r7  : 0000000000000000  r8  : 0000000000000000
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r9  : 0000000000000000  r10 : 0000000102c0355c  r11 : 0000000000000000
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r12 : 00000001005acbe8  r13 : 0000000110b80800  r14 : 000000000000013d
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r15 : 000000000000013d  r16 : 00000004c0bf0508  r17 : 00000004c0c00508
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r18 : 00000001ba011f88  r19 : 0000000000000000  r20 : 0000000000000000
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r21 : 0000000110786c00  r22 : 00000001e0a155d0  r23 : 0000000110786c18
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r24 : 00000001ba00e7c7  r25 : 00000001116ce5b0  r26 : 0000000000000241
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r27 : 00000001ba00e7c7  r28 : ffffffffffffffff  r29 : 0000000000000241
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  r30 : ffffffffffffc638  r31 : 0000000000000000
00:0009:00000:03817:2014/09/19 09:25:54.79 kernel  **** end of signal context ****
00:0009:00000:03817:2014/09/19 09:25:54.82 kernel  ************************************
00:0009:00000:03817:2014/09/19 09:25:54.82 kernel  SQL causing error : SELECT spid=SUBSTRING(convert(varchar(80),spid),1,4), LoginName=SUBSTRING(convert(varchar(80),LoginName),1,9), ElapsedTime=SUBSTRING(convert(varchar(8
00:0009:00000:03817:2014/09/19 09:25:54.82 kernel  ************************************
00:0009:00000:03817:2014/09/19 09:25:54.82 server  SQL Text: SELECT spid=SUBSTRING(convert(varchar(80),spid),1,4), LoginName=SUBSTRING(convert(varchar(80),LoginName),1,9), ElapsedTime=SUBSTRING(convert(varchar(80),ElapsedTime),1,11), CPU_Time=SUBSTRING(convert(varchar(80),CPU_Time),1,8), Physical_Reads=SUBSTRING(convert(varchar(80),Physical_Reads),1,14), LocksHeld=SUBSTRING(convert(varchar(80),LocksHeld),1,9), SQLText=SUBSTRING(convert(varchar(255),SQLText),1,252) FROM #conn_elapse  
00:0009:00000:03817:2014/09/19 09:25:54.82 kernel  curdb = 1 tempdb = 2 pstat = 0x10000 p2stat = 0x101010
00:0009:00000:03817:2014/09/19 09:25:54.82 kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
00:0009:00000:03817:2014/09/19 09:25:54.82 kernel  lasterror = 0 preverror = 0 transtate = 1
00:0009:00000:03817:2014/09/19 09:25:54.82 kernel  curcmd = 317 program = isql                         
00:0009:00000:03817:2014/09/19 09:25:54.82 kernel  extended error information: hostname: HOSTNAMELOCALHOSTXXXXXXXX login: sa
00:0038:00000:03817:2014/09/19 09:25:54.82 kernel  pc: 0x000000010007dd18 pcstkwalk+0x7c()
00:0038:00000:03817:2014/09/19 09:25:54.82 kernel  pc: 0x000000010007d634 ucstkgentrace+0x34c()
00:0038:00000:03817:2014/09/19 09:25:54.82 kernel  pc: 0x000000010007c920 ucbacktrace+0x184()
00:0038:00000:03817:2014/09/19 09:25:54.85 kernel  pc: 0x00000001000fda90 terminate_process.fdpr.chunk.2+0x798()
00:0038:00000:03817:2014/09/19 09:25:54.86 kernel  pc: 0x0000000102ad102c kisignal+0x4b8()
00:0038:00000:03817:2014/09/19 09:25:54.86 kernel  pc: 0x00000001007e68a8 strncpy+0xec()
00:0038:00000:03817:2014/09/19 09:25:54.86 kernel  pc: 0x0000000100f6a898 addr_to_name+0x13c()
00:0038:00000:03817:2014/09/19 09:25:54.86 kernel  pc: 0x000000010007ebf4 pcdescformat+0xa8()
00:0038:00000:03817:2014/09/19 09:25:54.86 kernel  pc: 0x000000010007f000 pcdescprint@AF20_9+0x2c()
00:0038:00000:03817:2014/09/19 09:25:54.87 kernel  pc: 0x000000010007e4cc pcstkprint+0x1ec()
00:0038:00000:03817:2014/09/19 09:25:54.87 kernel  pc: 0x000000010007d44c ucstkgentrace+0x164()
00:0038:00000:03817:2014/09/19 09:25:54.87 kernel  pc: 0x0000000100e55b10 d_stacktrace_args+0x1f4()
00:0038:00000:03817:2014/09/19 09:25:54.87 kernel  pc: 0x0000000100e55620 d_stacktrace+0x180()
00:0038:00000:03817:2014/09/19 09:25:54.87 kernel  [Handler pc: 0x0000000100a9c3d8 hdl_backout_msg installed by the following function:-]
00:0038:00000:03817:2014/09/19 09:25:54.88 kernel  pc: 0x0000000101872794 exec_dbcc.fdpr.chunk.8+0x1e08()
00:0038:00000:03817:2014/09/19 09:25:54.91 kernel  pc: 0x0000000100a30414 s_execute.fdpr.chunk.72+0x8()
00:0038:00000:03817:2014/09/19 09:25:54.91 kernel  [Handler pc: 0x0000000100a9c390 hdl_stack installed by the following function:-]
00:0038:00000:03817:2014/09/19 09:25:54.91 kernel  [Handler pc: 0x0000000100a9c818 s_handle installed by the following function:-]
00:0038:00000:03817:2014/09/19 09:25:54.95 kernel  pc: 0x00000001008970d4 sequencer+0x44c()
00:0038:00000:03817:2014/09/19 09:25:54.97 kernel  pc: 0x00000001007b0bfc tdsrecv_language+0x208()
00:0038:00000:03817:2014/09/19 09:25:54.97 kernel  [Handler pc: 0x00000001009ef5b4 ut_handle installed by the following function:-]
00:0038:00000:03817:2014/09/19 09:25:54.97 kernel  pc: 0x00000001007b085c conn_hdlr.fdpr.chunk.9+0xc4()
00:0038:00000:03817:2014/09/19 09:25:54.97 kernel  end of stack trace, spid 3817, kpid 187630726, suid 7


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP NetWeaver (NW) - All versions
  • OS : IBM AIX

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

CR771055, CR#771055, 771055 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.