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 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

Adaptive Server Enterprise (ASE) 15.7 SP 110

Product

SAP Adaptive Server Enterprise 15.7

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.