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)

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error