Kbase P39888: Running script to shutdown databases and the process hung.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/01/2009 |
|
Status: Verified
SYMPTOM(s):
Running script to shutdown databases and the process hung.
Users were hanging as they attempted connections prior to the shutdown attempt.
They have five databases that users connect to.
They have tried killing users that show a logout but still had a process.
They have had an outstanding resource issue on this server for over six months.
Version of AIX is 4.1.5
Progress patch level is 7.3E13
We can access four of the five databases in this group.
There are other databases not affected by this issue.
Ran proshut dbname -by -F to shut down the four databases we had access to.
All attempts to shutdown the fifth database failed.
FACT(s) (Environment):
IBM AIX
Progress 7.3E
CHANGE:
The _mprosrv and _mprshut processes for the fifth database are hung.
FIX:
To shut down the hung processes:
1. Run ps -ef | grep dbname
2. Identify the pids for these hung processes.
3. Run kill -9 on the pids.
4. Run proutil -C dbipcs to locate the PID of any shared memory for this database.
5. Run ipcrm -m ID.
6. Remove the lock file.
7. Pro dbname on the problem database.
8. Close the single user session.
9. Run the normal script to restart this group of five databases