2405522 - Signal 10 at address LeOperator::LeOpSaveIOStats - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2405522 - Signal 10 at address LeOperator::LeOpSaveIOStats - SAP ASE

Symptom

  • ASE errorlog reports a signal 10 stack trace at LeOperator::LeOpSaveIOStats
  • Leaving behind a zombie spid
  • Errorlog entries include: 

Current process (0x1df0147) infected with signal 10 (SIGBUS)
Address 0x0000000081d2df58 (void LeOperator::LeOpSaveIOStats(ExeCtxt&,const sdes*const,const short)+0x34)

with a stacktrace including modules:

LeOperator::LeOpSaveIOStats
LeRetnCode LeOperator::LeOpClose
LeRetnCode LeDMLOp::_LeOpClose
LePlanClose
exec_lava
...
end of stack trace, spid 123, kpid 31392071, suid 456
task 31392071 is zombie

  • The SQL Text part of the messages in log may contain reference to use of statement cache by showing parameter 'placeholder' like @@@V0_VCHAR1:

SQL Text: update dbo.my_table set col1='string1', col2='ABC' ...
SQL Text: update dbo.my_table set col1=@@@V0_VCHAR1, col2=@@@V1_VCHAR1 ...

  • The master..sysprocesses table will include an entry for the affected spid with status 'infected'

select login, suid, status from master..sysprocesses

my_user 123 infected


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0

Product

SAP Adaptive Server Enterprise 15.7

Keywords

stacktrace, signal, infected , LeOperator, LeOpSaveIOStats , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.