1986882 - BW application cored dump and SYB ASE report infected with signal 11 (SIGSEGV) at s_recompile.fdpr.chunk.4+0xa4 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1986882 - BW application cored dump and SYB ASE report infected with signal 11 (SIGSEGV) at s_recompile.fdpr.chunk.4+0xa4

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 r                                                
    C  olled 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 :

     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  Current process (0x13d009f) infected with signal 11 (SIGSEGV)
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  Address 0x0000000100bc8824 (s_recompile.fdpr.chunk.4+0xa4), siginfo (code, address) = (51, 0x0000000000000188)
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  **** Saved signal context (0x000000017e5e69d0): ****
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  __sc_onstack: 0x0, __sc_uerror: 34
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  uc_sigmask: 0xffffffff1ffef877 0xffffffffffffffff 0xffffffffffffffff 0x7fffffffffffffff
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  Machine Save State:
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   PC (iar): 0000000100bc8824 (s_recompile.fdpr.chunk.4+0xa4)
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   Link Register (lr): 00000001001ea4b8 (s_recompile+0x248)
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   Stack Pointer (stkp): 000000017e5e6ec8
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   msr : a00000000000d032  ctr : 00000001004a84ac  cr  : 44422280
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   xer : 00000008
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r0  : 0000000000000010  r1  : 000000017e5e6ec8  r2  : 0000000110779e90
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r3  : 0000000000000000  r4  : 0000000509f49000  r5  : 0000000000000000
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r6  : 0000000385091e48  r7  : 0000000000000006  r8  : 0000000000000004
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r9  : 000000053ba94d80  r10 : 0000000000000001  r11 : 0000000000000040
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r12 : 0000000022422222  r13 : 0000000110af2800  r14 : 00000001100013c0
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r15 : 00000000004a0000  r16 : 0000000162959b60  r17 : 0000000162959b60
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r18 : 0000000000000008  r19 : 000000035628aaf0  r20 : 0000000000000000
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r21 : 0000000000000001  r22 : 0000000000001012  r23 : 0000000000000001
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r24 : 0000000000000000  r25 : 0000000509f49000  r26 : 000000038509a208
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r27 : 0000000110789040  r28 : 000000038508a208  r29 : 0000000110789038
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel   r30 : 0000000000000000  r31 : 0000000000000000
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  **** end of signal context ****
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  ************************************
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  SQL causing error : lk on)'
     /* R3:RTAB:0 T:/BIC/F100140 M:800 */

     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  Current statement number: 1 Current line number: 1
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  ************************************
     00:0007:00000:00193:2014/02/13 21:28:31.45 server  SQL Text: lk on)'
     /* R3:RTAB:0 T:/BIC/F100140 M:800 */
     00:0007:00000:00193:2014/02/13 21:28:31.45 server  SQL Text:  INSERT INTO "/BIC/F100140"  VALUES       ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) 
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  curdb = 4 tempdb = 6 pstat = 0x10000 p2stat = 0x20101000
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  p3stat = 0x8800 p4stat = 0x0 p5stat = 0x400008 p6stat = 0x1 p7stat = 0x10000
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  lasterror = 0 preverror = 0 transtate = 0
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  curcmd = 195 program = R3B056 04 comm rd ODBC       
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  extended error information: hostname: hlbwprd02 login: SAPSR3
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x000000010007d014 pcstkwalk+0x7c()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x000000010007c930 ucstkgentrace+0x34c()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x000000010007bc1c ucbacktrace+0x184()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x0000000100f6aa58 terminate_process.fdpr.chunk.4+0x68c()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x000000010255f430 kisignal+0x4a8()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x0000000100bc8824 s_recompile.fdpr.chunk.4+0xa4()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  [Handler pc: 0x00000001005fb5a0 hdl_stack+0x0 installed by the following function:-]
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  [Handler pc: 0x00000001001d82bc s_handle+0x0 installed by the following function:-]
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x00000001001ea120 sequencer.fdpr.chunk.1+0xf0()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x000000010043b2d8 execproc+0x430()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x00000001005151b0 s_execute.fdpr.chunk.49+0xc8()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  [Handler pc: 0x00000001005fb5a0 hdl_stack+0x0 installed by the following function:-]
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  [Handler pc: 0x00000001001d82bc s_handle+0x0 installed by the following function:-]
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x00000001004a9e4c sequencer+0x44c()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x0000000100fc1128 tdsrecv__process_batchparam+0x3cc()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x0000000100fbd72c tdsrecv__dynexec_batch+0xb0()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x0000000100fba9e8 tdsrecv__dynexec+0x25c()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x0000000100fba198 tdsrecv_dynamic.fdpr.chunk.1+0x4d8()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  [Handler pc: 0x00000001005b8c08 ut_handle+0x0 installed by the following function:-]
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  pc: 0x00000001001e9cd0 conn_hdlr.fdpr.chunk.9+0xc()
     00:0007:00000:00193:2014/02/13 21:28:31.45 kernel  end of stack trace, spid 193, kpid 20775071, suid 6


Read more...

Environment

Adaptive Server Enterprise/15.7/EBF 21984 SMP SP110 /P/RS6000/AIX 6.1/ase157sp11x/

Product

SAP Adaptive Server Enterprise 15.7

Keywords

CR#758214, CR 758214, 758214 , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , Problem

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.