SAP Knowledge Base Article - Preview

2266313 - User session may hang on commands using an in-memory tempdb - SAP ASE

Symptom

  • A user session hangs in sleep status
  • No error nor messages are received
  • When using In Memory Temporary Database (IMDB) 
  • The IMDB is running out of space
  • The monitoring table monProcessWaits shows the process (spid) is waiting on one of the following events: 
    • event 338 "page allocation is waiting for mass destruction" 
    • event 337 "page allocation is waiting for mass destruction"
    • event 339 "waiting for mass destruction to complete"
       
      For example:

      SELECT * FROM dbo.monProcessWaits where WaitEventID in (338,337,339)

      SPID   InstanceID                KPID   ServerUserID OrigServerUserID    WaitEventID Waits  WaitTime
      197    0                   1618412203              3174                        0                337    1     31971350
      324    0                      36372758                    0                        0                339    7                  1
      523    0                      36634904                    0                        0                339    5                  1

  • executing:
    dbcc traceon(3604)
    go
    dbcc stack (spid#) -- shows
    go
    • getpage_with_validation
    • getpage__noscan
    • pg_latchoam
    • pg__updateoam
    • pg__allocate_in_oamcreate


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

imdb, hang, MASS_DESTROY, MASS_STAT, "in memory", temporary, database, hung, 793963, CR793963, 803099, CR803099 , 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.