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

Search for additional results

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