SAP Knowledge Base Article - Preview

2155018 - A cursor fetch raises signal 11 with stacktrace including ind_rowcopy and level0__getnextrow with error 9504 - SAP ASE

Symptom

  • ASE errorlog shows a signal 11 including stack trace functions ind_rowcopy and level0__getnextrow
  • The stacktrace shows that the failed process was processing a cursor:

SQL Text: DECLARE cursor_name CURSOR FOR

  • Within the stacktrace sequence, 'lasterror' shows error 9504 (lasterror = 9504) which means that an isolation level 0 cursor scan has failed
    • Error 9504 is "An isolation level 0 cursor scan has failed on an attempted restart for cursor '...'.  The cursor is being closed.
  • The stack trace includes the following functions:

...
ind_rowcopy
level0__getnextrow
level0_restart
....
curs_fetch

  • The server stacktrace can be generated from various starting points as indicated below, but the defining elements are the ones above
    • Known sequences include a segmentation fault at function (1) ind__itagsetup or (2) text 

1.
Current process (0x40b10400) infected with signal 11 (SIGSEGV)
Address 0x00000000803dc730 (ind__itagsetup+0x30) ...

  • Note: An example of a complete stacktrace of this variety is available under Attachments

    2.
    Current process (0x255014d) infected with signal 11 (SIGSEGV)
    Address 0x0000000100669b1c (text.fdpr.chunk.4+0x18)               -- AIX platform
    Address 0x0000000100669b1c (text+0x12) 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR#609943, CR609943, 609943, traceflag, trace , flag, 457, insensitive, sensitive, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stack, registers , 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 for Me (Login required).

Search for additional results

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