Symptom
- Running a select with large number of "OR" clauses.
- The auditing is enable on the ASE.
- Client received error 3626:
Msg 3626, Level 17, State 1:
Server 'ASE', Line 1:
The transaction was aborted because it used too much stack space. Either use sp_configure to increase the stack size, or break the query into smaller pieces. - ASE errorlog reports the following errors:
stack overflow first chance handler for task 717555369 (spid 25226) at line 2847 in file /pbilam001_bld2/ase160sp02pl08x_oneoff/SMP/porttree/svr/sql/generic/source/sequencer/colnames.c, current top of stack: 0x2aacd5c5f698. Cleanup will be attempted
task 717555369 prstack: 0x2aacd5c58710 prstackbound: 0x2aacd5c58710 prguardbound: 0x2aacd5c5f710
stack_abort: kpid 717555369 spawn a stack tracer task with kpid 1256791322
pc: 0x00002d1dcce5f850 ()
stack overflow first chance handler for task 717555369 (spid 25226) at line 5653 in file /pbilam001_bld2/ase160sp02pl08x_oneoff/SMP/porttree/svr/sql/generic/source/sequencer/protect.c, current top of stack: 0x2aacd5c5f638. Cleanup will be attempted
task 717555369 prstack: 0x2aacd5c58710 prstackbound: 0x2aacd5c58710 prguardbound: 0x2aacd5c5f710
stack_abort: kpid 717555369 spawn a stack tracer task with kpid 1289318589
kernel pc: 0x00002d1dcce5f850 () - Under trace flag 3687, the sql generate the following stack in errorlog:
stack overflow first chance handler for task 2293778 (spid 17) at line 5653 in file /pbilam001_bld2/ase160sp02pl08x_oneoff/SMP/porttree/svr/sql/generic/source/sequencer/protect.c, current top of stack: 0x16ab993d8. Cleanup will be attempted
task 2293778 prstack: 0x16ab97430 prstackbound: 0x16ab97430 prguardbound: 0x16ab99430
stack_abort: kpid 2293778 spawn a stack tracer task with kpid 2424851
upsleepgeneric+0x513()
upwait+0x58()
stack_abort+0xca()
stack_oflow+0x16a()
prot__add_param+0x450()
prot__add_param+0x1a8()
prot__add_param+0x1a8()
...
prot__add_param+0x1a8()
prot__add_param_driver+0x59()
prot_desc+0x4e1()
colnames_driver+0x14a()
s_normquery+0x135()
s__call_normquery+0x66()
s_normalize+0x67e()
sequencer+0x2a1()
tdsrecv_language+0x1df()
conn_hdlr+0xe98()
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
stack_oflow,prot__add_param,CR 824984 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
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.