Kbase P108473: Clients hang on attempts to connect to and also on attempts to disconnect from a database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/09/2005 |
|
Status: Unverified
FACT(s) (Environment):
IBM AIX POWER 5.2
Progress 9.1D
SYMPTOM(s):
Clients hang on attempts to connect to and also on attempts to disconnect from a database
Clients in the database can continue to work without issue
9.1d0910
CAUSE:
Login semaphore is not being released
FIX:
The recommended process is to:
1. make sure a good, reliable backup of the database is available
2. run proshut dbname -by
If the database needs to be brought back up in a more timely fashion, then do step 1 from above and then do either A or B that follow.
A. run proshut dbname -F, or
B. identify the pid of the broker for the database and run kill -9 pid of broker
In each of the above choices, once the database has been shutdown, do the following:
1. run proutil -C dbipcs to identify any remaining shared memory for this database
2. If present, remove shared memory associated with this database by running ipcrm -m (id)
3. run slibclean
4. Verify the bi file has sufficient size to accommodate crash recovery
5. run pro dbname and allow it to proceed through crash recovery
6. close out of procedure editor
7. run proutil dbname -C truncate bi
8. restart the database