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.