2155018 - A cursor fetch raises signal 11 stacktrace at ind__itagsetup and error 9504 - ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2155018 - A cursor fetch raises signal 11 stacktrace at ind__itagsetup and error 9504 - ASE

Symptom

  • The server stacktrace generated includes a segmentation fault at function ind__itagsetup().  Also, as shown in the stack is 'lasterror' 9504.  Error 9504 indicates that an isolation level 0 cursor scan has failed.

kernel  Current process (0x40b10400) infected with signal 11 (SIGSEGV)
kernel  Address 0x00000000803dc730 (ind__itagsetup+0x30), siginfo (code, address) = (1, 0x0000000000000298)
kernel  **** Saved signal context (0x000001000e614180): ****
kernel  uc_flags: 0x2f, uc_link: 0x0
kernel  uc_sigmask: 0xefbe7877 0xfff7 0x0 0x0
kernel  uc_stack: ss_sp: 0xffffffff79a00000, ss_size: 0x2080768, ss_flags: 0x0
kernel  General Registers (uc_mcontext.gregs):
kernel       i6 : 000001000e613e21  i7 : 00000000803fbb34
kernel       previous stack frame : 000001000e614620
kernel  **** end of signal context ****
kernel  ************************************
kernel  SQL causing error :     AND value_date = @value_date
kernel  Current statement number: 55 Current line number: 385
kernel  ************************************
server  SQL Text:     AND vdate = @vdate
server  SQL Text: DECLARE cur_sp CURSOR FOR
server  SQL Text: DER BY s.prtf_id
kernel  curdb = 4 tempdb = 2 pstat = 0x10010000 p2stat = 0x101000
kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
kernel  lasterror = 9504 preverror = 0 transtate = 1
kernel  curcmd = 264 program =
kernel  extended error information: hostname: test.com login: admin
kernel  pc: 0x000000008142522c pcstkwalk+0x18
kernel  pc: 0x0000000081425074 ucstkgentrace+0x23c
kernel  pc: 0x0000000081421420 ucbacktrace+0xd0
kernel  pc: 0x00000000807d1e24 terminate_process+0x1638
kernel  pc: 0x000000008146be80 kisignal+0x438
kernel  pc: 0x00000000803dc730 ind__itagsetup+0x30
kernel  pc: 0x00000000803fbb34 ind_rowcopy+0x74
kernel  pc: 0x0000000080adef50 level0__getnextrow+0x88
kernel  pc: 0x0000000080adeeb4 level0_restart+0x2b8
kernel  pc: 0x00000000804d51e8 _$o1cexmE0.getnext+0x1094
kernel  pc: 0x00000000803dbe74 LeRetnCode LeScanOp::_LeOpNext(ExeCtxt&)+0xb4
kernel  pc: 0x000000008193f1ec LeRetnCode LeOperator::LeOpNext(ExeCtxt&)+0x64
kernel  pc: 0x0000000081932200 LeRetnCode LeNLJOp::_LeOpNext(ExeCtxt&)+0x90
kernel  pc: 0x000000008193f1ec LeRetnCode LeOperator::LeOpNext(ExeCtxt&)+0x64
kernel  pc: 0x0000000080505388 LeRetnCode LeEmitSndOp::_LeOpNext(ExeCtxt&)+0x1a8
kernel  pc: 0x000000008193f1ec LeRetnCode LeOperator::LeOpNext(ExeCtxt&)+0x64
kernel  pc: 0x00000000803e3bf8 LePlanNext+0xb8
kernel  pc: 0x00000000803e3050 exec_lava+0x3d0
kernel  pc: 0x000000008054315c curs_fetch+0xdc
kernel  pc: 0x00000000803dfee8 s_execute+0x2928
kernel  pc: 0x00000000805ae214 _$o1ceycZ0.sequencer+0xa54
kernel  pc: 0x000000008053416c execproc+0x40c
kernel  pc: 0x0000000080504414 execrpc+0x714
kernel  pc: 0x0000000080534de0 tdsrecv_rpc+0x20
kernel  pc: 0x0000000080531d94 _$o1cexvX0.conn_hdlr+0x294
kernel  pc: 0x00000000814534a4 _coldstart
kernel  end of stack trace, spid 418, kpid 1085342720, suid 55

  •  The stack is 'lasterror' is a 9504

Error 9504 Severity 16 State x
An isolation level 0 cursor scan has failed on an attempted restart for cursor `%.*s', table `%.*s', index id `%d'.  The cursor is being closed.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP122

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , memory corruption , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.