3147969 - Signal 11 at LeScanOp::_LeOpShowOp when running sp_showplan - SAP ASE

• Running concurrent batch jobs with drop and create same permanent table in tempdb. The execution of these batch jobs often hit error 267.
  
  
• Another spid is collecting showplan for these batch jobs may hit the infected with signal 11 with the following stacks:
  
  Current process (0x3d1d1e65) infected with signal 11 (SIGSEGV)
  Address 0x0x00000000009119e8 (LeScanOp::_LeOpShowOp(ExeCtxt&, int)+0x236), siginfo (code, address) = (1, 0x0x00000000000006e0)
  
  pcstkwalk
  ucstkgentrace
  ucbacktrace
  terminate_process
  kisignal
  LeScanOp::_LeOpShowOp(ExeCtxt&, int)
  LeOperator::LeOpShowOp(ExeCtxt&, int)
  LeEmitSndOp::_LeOpShowOp(ExeCtxt&, int)
  LeOperator::LeOpShowOp(ExeCtxt&, int)
  le_showPlanOp
  showMainE_STEPs
  showE_STMT
  showplan
  show_plan
  LeRun
  LeEvals::LeEvRun(LeRunMode, LeRunStack*, short, LeDataRow*, unsigned char*, int*)
  LeScalarOp::_LeOpNext(ExeCtxt&)
  LeEmitNoSndOp::_LeOpNext(ExeCtxt&)
  LePlanNext
  exec_lava
  s_execute
  
  
• Multiple infected with signal 11 messages may report in the errorlog. SIGSEGV address and offset address are the same from different spids.
  
  For example: grep -A 1 "signal 11" errorlog
  00:0028:00000:03240:2022/01/31 10:13:54.16 kernel  Current process (0x43dd2d20) infected with signal 11 (SIGSEGV)
  00:0028:00000:03240:2022/01/31 10:13:54.18 kernel  Address 0x0x00000000009119e8 (LeScanOp::_LeOpShowOp(ExeCtxt&, int)+0x236), siginfo (code, address) = (1, 0x0x00000000000006e0)
  --
  00:0017:00000:05327:2022/02/01 07:22:38.29 kernel  Current process (0x4b9b382b) infected with signal 11 (SIGSEGV)
  00:0017:00000:05327:2022/02/01 07:22:38.29 kernel  Address 0x0x00000000009119e8 (LeScanOp::_LeOpShowOp(ExeCtxt&, int)+0x236), siginfo (code, address) = (1, 0x0x00000000000006e0)
  --
  00:0020:00000:10487:2022/02/01 07:39:43.48 kernel  Current process (0x271b1bba) infected with signal 11 (SIGSEGV)
  00:0020:00000:10487:2022/02/01 07:39:43.48 kernel  Address 0x0x00000000009119e8 (LeScanOp::_LeOpShowOp(ExeCtxt&, int)+0x236), siginfo (code, address) = (1, 0x0x00000000000006e0)
  
  

SAP Adaptive Server Enterprise (ASE)

signal 11 error, SIGSEGV, LeScanOp::_LeOpShowOp, sp_showplan error, error log, concurrent batch jobs, tempdb table drop, tempdb table create, error 267, stack trace, infected process, CR 826160, spid infected, errorlog analysis, memory corruption, database crash, query object dropped, concurrent operations, sp_showplan issue, tempdb contention, SAP ASE troubleshooting , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error