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
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.
SAP Knowledge Base Article - Preview