SAP Knowledge Base Article - Preview

2705438 - During QUIESCE HOLD a transaction in master raises Error: 2238, Severity: 20, State: 9 - ASE

Symptom

  • The master database is quiesced:  quiesce database master_tag hold master  
        
          server QUIESCE DATABASE command with tag tag_master is being executed by process 478
          server Process 478 successfully executed QUIESCE DATABASE with HOLD option for tag tag_master.
          server Processes trying to issue an I/O operation on the quiesced database(s) will be suspended until the user executes a   
          QUIESCE DATABASE command with the RELEASE option.
     
  • A second user process in the master database opens a transaction while master is quiesced. The transaction is blocked and placed in lock sleep until the quiesce is released.
        
          Your query is blocked because it tried to start a transaction in the 'master' database which is in a quiesced state. Your query will proceed after the DBA
          performs a QUIESCE/PREPARE DATABASE RELEASE.
     
  • At a later point in time, while the quiesce is still active and the second process is in lock sleep the following server error is logged:
      
          server Error: 2238, Severity: 20, State: 9
          server begin lock: Could not acquire LOCK INTERRUPTED due to invalid pointer param number 6, pointer value 0x0


Read more...

Environment

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

 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

lock sleep blocked begin tran 2238 quiesce , 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.