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.