SAP Knowledge Base Article - Preview

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

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) 15.7 and 16.0
  • IBM AIX

Product

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

Keywords

CR771055, 771055 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.