Salesforce

Database is not shutting down after issuing an unconditional shutdown request

« Go Back

Information

 
TitleDatabase is not shutting down after issuing an unconditional shutdown request
URL NameP52026
Article Number000142122
EnvironmentProduct: OpenEdge
Version: All supported versions
OS: All supported platforms
Question/Problem Description
Database is not shutting down after issuing an unconditional shutdown request.
$  proshut dbname -by 
 
Database is stuck in the process of shutting down.

How to shutdown the database when the process is hanging?
Is there any way to shutdown the database if the database is hung?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
When there is a hung client process that does not terminate and prevents the database from shutting down, this would also cause the BI to grow. The following Articles offer troubleshooting suggestions to avoid this situation in future:
Option 1:  Force the database to shutdown

To force a database shutdown immediately, from a different shell where the DLC and PATH are correctly set, run a new PROSHUTwith the -F option:
        
$ proshut -F dbname

Option 2:  Kill the hanging client process.

1. If a PROMON session can still access the database, find the process ID of the client process and kill the process.
  •  Run PROMON to find the user ID
            promon dbname > R&D >Option 1 (Status Displays) > Option 4 (Processes/Clients) > Option 1 (All Processes).
  •  Run PROMON to find the PID of the User 
            promon dbname > Option 1 (User Control) > Option 2 (Match a user number)
  •  Kill the Process using:
            kill -9 <PID>

Once this is done, the next time the database has started it will go through normal crash recovery, provided sufficient BI file space and AI file space (if after-imaging is enabled) are available.
 
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:38 AM

Powered by