Kbase P84079: Attempted connection to a 9.1B or 9.1C database hangs when idxfix is running online.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/06/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1B
Progress 9.1C
UNIX
Windows
SYMPTOM(s):
Attempted client connection to a database hangs when idxfix is running online.
Subsequent client connections can not be established once the idxfix operation completes.
CAUSE:
Bug# OE00070505
CAUSE:
While index fix is holding shared index locks, the client's requirement for a exclusive lock on the same index has to wait till index fix releases it. Since index fix has to hold shared index locks to guarantee atomicity of the operation(yield locks during index fix may have impact on other utilities) and client need an exclusive lock to prevent others to load cache into the same table entry
FIX:
There are two alternative fixes, where shared shema lock has been added to the utilities:
1) Upgrade to one of the following 9.1C patches:
Linux 9.1C09
HP-UX11 9.1C10
Unix V4 9.1C11
HP_UX 64-bit 9.1C12
IBM Aix 9.1C12
Compaq Tru64 9.1C12
Sun Solaris 9.1C13
Win NT 9.1C18
Sun Solaris Intel 9.1C09
2) Upgrade to 9.1D or later.