3804324 - ASE unresponsive due to timeslice and spinlock – SAP ASE

• ASE is unresponsive, logging in through isql is not possible and new connection to ASE cannot be made
  
  
• From ASE error logs
  
  timeslice -1001, current process infected at 0x1ebeace (pausenonatomic)
  This Adaptive Server process has had 142 major and 8755161 minor page faults since boot.
  Stack functions :
  (null)+
  kmrtmsg+
  smget+
  audproc+
  
  kernel  Warning: The internal timer is operational and has recovered from previous failure.
  Process id xx killed by Hostname , Host process id .
  server  Process 'x' has been terminated because it exceeded the maximum login time allowed. This process used a temporary administrative connection which is allowed a maximum login period of 'x' minutes.
  
  
• Auditing is enabled and audit queue size is high
  
  
• It requires a server restart to restore service.

Adaptive Server Enterprise 16.0 SP04 PL07

timeslice, spinlock, smget, audproc, audit queue size , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem