Symptom
* BW Application cored dump.
Following is printed in dev_w56 :
C Thu Feb 13 21:28:31 2014
C DbSlConnect hdl: 1
B Connection 10 opened (DBSL handle 1)
C ERROR: -1 in function DbSlRollback (ROLLBACK) [line 5394]
C (30046) [08S01] [Sybase][ODBC Driver]Connection to Sybase server has been lost. Connection died
C while reading from socket. ERRNO returned 0. All active transactions have been rolled back.
C syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
C ERROR: -1 in function GetTranState (SQLAllocStmt failed) [line 33055]
C evaluation of transaction state failed.
C Rollback Work (99)
B ***LOG BYM=> severe DB error 30046 ; work process in reconnect status [dbsh 1174]
M Thu Feb 13 21:28:32 2014
M si_code = 30
M Sending process ID = 0
M Real user ID of sending process = 0
M ILL_ILLOPC: Illegal opcode
Signal 4 encountered.
C-stack:
SybDisconnect() at 0x9000000289b6458 >>>>>
DbSlDisconnect96() at 0x900000028948874 >>>>>
db_con_reconnect() at 0x100781a54 >>>>>
do_reconnect() at 0x1007a2140
db_rollback() at 0x1007a5aa0
ThIRollBack() at 0x1001ff2fc
ThRBWork() at 0x1002246b0
ab_retdynp__Fi() at 0x10078bbcc
ab_run() at 0x1013498bc
N_ab_run() at 0x10131d850
dynpmcal() at 0x10131be70
* Checking ASE errorlog, we can see when application cored dump, ASE server reported signal 11 (SIGSEGV) at the same time :
Current process (0x13d009f) infected with signal 11 (SIGSEGV)
Address 0x0000000100bc8824 (s_recompile.fdpr.chunk.4+0xa4), siginfo (code, address) = (51, 0x0000000000000188)
**** Saved signal context (0x000000017e5e69d0): ****
__sc_onstack: 0x0, __sc_uerror: 34
uc_sigmask: 0xffffffff1ffef877 0xffffffffffffffff 0xffffffffffffffff 0x7fffffffffffffff
Machine Save State:
PC (iar): 0000000100bc8824 (s_recompile.fdpr.chunk.4+0xa4)
Link Register (lr): 00000001001ea4b8 (s_recompile+0x248)
Stack Pointer (stkp): 000000017e5e6ec8
msr : a00000000000d032 ctr : 00000001004a84ac cr : 44422280
xer : 00000008
r0 : 0000000000000010 r1 : 000000017e5e6ec8 r2 : 0000000110779e90
r3 : 0000000000000000 r4 : 0000000509f49000 r5 : 0000000000000000
r6 : 0000000385091e48 r7 : 0000000000000006 r8 : 0000000000000004
r9 : 000000053ba94d80 r10 : 0000000000000001 r11 : 0000000000000040
r12 : 0000000022422222 r13 : 0000000110af2800 r14 : 00000001100013c0
r15 : 00000000004a0000 r16 : 0000000162959b60 r17 : 0000000162959b60
r18 : 0000000000000008 r19 : 000000035628aaf0 r20 : 0000000000000000
r21 : 0000000000000001 r22 : 0000000000001012 r23 : 0000000000000001
r24 : 0000000000000000 r25 : 0000000509f49000 r26 : 000000038509a208
r27 : 0000000110789040 r28 : 000000038508a208 r29 : 0000000110789038
r30 : 0000000000000000 r31 : 0000000000000000
**** end of signal context ****
************************************
SQL causing error : lk on)'
/* R3:RTAB:0 T:/BIC/F100140 M:800 */
Current statement number: 1 Current line number: 1
************************************
SQL Text: lk on)'
/* R3:RTAB:0 T:/BIC/F100140 M:800 */
SQL Text: INSERT INTO "/BIC/F100140" VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
curdb = 4 tempdb = 6 pstat = 0x10000 p2stat = 0x20101000
p3stat = 0x8800 p4stat = 0x0 p5stat = 0x400008 p6stat = 0x1 p7stat = 0x10000
lasterror = 0 preverror = 0 transtate = 0
curcmd = 195 program = R3B056 04 comm rd ODBC
extended error information: hostname: hlbwprd02 login: SAPSR3
pc: 0x000000010007d014 pcstkwalk+0x7c()
pc: 0x000000010007c930 ucstkgentrace+0x34c()
pc: 0x000000010007bc1c ucbacktrace+0x184()
pc: 0x0000000100f6aa58 terminate_process.fdpr.chunk.4+0x68c()
pc: 0x000000010255f430 kisignal+0x4a8()
pc: 0x0000000100bc8824 s_recompile.fdpr.chunk.4+0xa4()
[Handler pc: 0x00000001005fb5a0 hdl_stack+0x0 installed by the following function:-]
[Handler pc: 0x00000001001d82bc s_handle+0x0 installed by the following function:-]
pc: 0x00000001001ea120 sequencer.fdpr.chunk.1+0xf0()
pc: 0x000000010043b2d8 execproc+0x430()
pc: 0x00000001005151b0 s_execute.fdpr.chunk.49+0xc8()
[Handler pc: 0x00000001005fb5a0 hdl_stack+0x0 installed by the following function:-]
[Handler pc: 0x00000001001d82bc s_handle+0x0 installed by the following function:-]
pc: 0x00000001004a9e4c sequencer+0x44c()
pc: 0x0000000100fc1128 tdsrecv__process_batchparam+0x3cc()
pc: 0x0000000100fbd72c tdsrecv__dynexec_batch+0xb0()
pc: 0x0000000100fba9e8 tdsrecv__dynexec+0x25c()
pc: 0x0000000100fba198 tdsrecv_dynamic.fdpr.chunk.1+0x4d8()
[Handler pc: 0x00000001005b8c08 ut_handle+0x0 installed by the following function:-]
pc: 0x00000001001e9cd0 conn_hdlr.fdpr.chunk.9+0xc()
end of stack trace, spid 193, kpid 20775071, suid 6
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 SP110 for Business Suite
- SAP Business Warehouse - All versions
Product
Keywords
CR#758214, CR 758214, 758214 , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.