SAP Knowledge Base Article - Preview

3082610 - Application in ASE is receiving signal 11 / infected 11 with res_insert yyparse - SAP ASE

Symptom

  • Application is sending a large amount of statements in a language batch with parameters.  
  • Eventually this causes signal 11.
    Stack (Solaris)
      General Registers (uc_mcontext.gregs):
            PC : 0000000080841c14 (_$o1cezqJ0.res_insert+0x1d4)
            Next PC : 0000000080841c18 (_$o1cezqJ0.res_insert+0x1d8)
            CCR : 0000000000000044  Y : 0000000000000000
            ASI : 0000000000000082  FPRS : 0000000000000007
            i0 : 0000000000000001  i1 : 00000100d0ba1988  i2 : 00000000000001ff
      ************************************
      curdb = 4 tempdb = 2 pstat = 0x10000 p2stat = 0x101002
      p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x10 p7stat = 0x10000
      lasterror = 0 preverror = 0 transtate = 1
      curcmd = 0 program = MYAPPLICATION
      extended error information: hostname: myhost login: myuser
      [Handler pc: 0x00000000819427cc ut_handle installed by the following function:-]
      [Handler pc: 0x000000008122c628 pars_hdl installed by the following function:-]
      [Handler pc: 0x00000000819427cc ut_handle installed by the following function:-]
      Current Process is running on Engine 0
      Address 0x0x0000000002d8a7a5 (res_insert+0x819), siginfo (code, address) = (1, 0x(nil))
      **** Saved signal context (0x0x00000001577ec980): ****
      uc_flags: 0x0, uc_link: 0x(nil)
      uc_sigmask: 0x7bfbf027 0xb 0x1 0x0
      uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
      General Registers (uc_mcontext.gregs):
           PC : 0x0000000002d8a7a5 (res_insert+0x819)
              RAX : 0x00000001f4827df8  RBX : 0x0000000157834548
              RCX : 0x00000001c8626800  RDX : (nil)
           RBP : 0x00000001577ece50  RSP : 0x00000001577ecdc0
           R8  : 0x00000000052267e8  R9  : 0x0000000000002e69
           R10 : 0x0000000000000001  R11 : 0x00007ffff60e75f0
           R12 : 0x0000000000d67670  R13 : 0x00007fffffffd860
           R14 : (nil)  R15 : (nil)
           RDI : 0x00000004ff4a3068  RSI : 0x00000001577ecd30
           RIP : 0x0000000002d8a7a5  CSGSFS : 0x0000000000000033
           TRAPNO : 0x000000000000000e  ERR : 0x0000000000000006
           EFL : 0x0000000000010246
      **** end of signal context ****
      ************************************
      SQL causing error : insert into #temp_accounts_currcodes values (@p131236,@p131237) insert into #temp_accounts_currcodes values (@p131238,@p131239) insert into #temp_acco
      ************************************
    00:0006:00000:00033:2021/07/29 13:58:13.06 server  SQL Text: insert into #temp_accounts_currcodes values (@p131236,@p131237) insert into #temp_accounts_currcodes values (@p131238,@p131239) insert into #temp_accounts_currcodes values (@p131240,@p131241) insert into #temp_accounts_currcodes values (@p131242,@p131243) insert into #temp_accounts_currcodes values (@p131244,@p131245) insert into #temp_accounts_currcodes values (@p131246,@p131247) insert into #temp_accounts_currcodes values (@p131248,@p131249) in
      curdb = 4 tempdb = 2 pstat = 0x10000 p2stat = 0x101002
      p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x10 p7stat = 0x10000
      p8stat = 0x8000100 p9stat = 0x4000 p10stat = 0x0
      lasterror = 0 preverror = 0 transtate = 1
      isolation = 1 tranmode = 0 xactcnt = 0 attn = 0 extattn = 0 memusage = 190133
      curcmd = 0 program = bigbatch
      extended error information: hostname: HOSTNAME login: sa
      pc: 0x000000000321db0d pcstkwalk+0x32()
      pc: 0x000000000321d8cd ucstkgentrace+0x2cd()
      pc: 0x0000000003216a30 ucbacktrace+0x12c()
      pc: 0x0000000000d741c1 terminate_process+0x255d()
      pc: 0x000000000329dcd1 kisignal+0x13f8()
      [Handler pc: 0x0x0000000002ec1e18 ut_handle installed by the following function:-]
      pc: 0x0000000002d8a7a5 res_insert+0x819()
      pc: 0x0000000002200731 yyparse+0x91bf6()
      [Handler pc: 0x0x00000000020ae140 pars_hdl installed by the following function:-]
      pc: 0x00000000020acedf sqlpars+0x1303()
      pc: 0x0000000000de6b73 tdsrecv_language+0xa0e()
      [Handler pc: 0x0x0000000002ec1e18 ut_handle installed by the following function:-]
      pc: 0x0000000000e252d5 conn_hdlr+0x5b05()


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.