Symptom
- ASE errorlog reports a signal 10 in the module LeOperator::LeOpSaveIOStats() together with a stack trace
Current process (0x1df0147) infected with signal 10 (SIGBUS)
Address 0x0000000081d2df58 (void LeOperator::LeOpSaveIOStats(ExeCtxt&,const sdes*const,const short)+0x34)
- It is leaving behind a zombie spid or shutting down the ASE:
task 31392071 is zombie
- The stacktrace includes the following modules:
LeOperator::LeOpSaveIOStats
LeRetnCode LeOperator::LeOpClose
LeRetnCode LeDMLOp::_LeOpClose
LePlanClose
exec_lava
Note: A complete stack trace is available under Attachments.
- 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'.
if you run "select login, suid, status from master..sysprocesses", you may see:
my_user 123 infected
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0
Product
Keywords
stacktrace, signal, infected, LeOperator, LeOpSaveIOStats, kisignal, stacktrace, registers, "bus error" , KBA , 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.