SAP Knowledge Base Article - Preview

1986882 - BW application cored dump and SYB ASE report infected with signal 11 (SIGSEGV) at s_recompile() - SAP ASE for BW

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

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 for Me (Login required).

Search for additional results

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