Kbase P125962: Database crashes and broker shuts down abnormally with error (11697)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/04/2010 |
|
Status: Verified
SYMPTOM(s):
Database crashes and broker shuts down abnormally with error (11697)
SYSTEM ERROR: lkTableLockUpdate: Can't find table lock for table number rowid owner , chain (11697)
SYSTEM ERROR: lkTableLockUpdate: Can't find table lock for table number 8 rowid 20765 owner 4835, chain 3415. (11697)
SYSTEM ERROR: The broker is exiting unexpectedly, beginning Abnormal Shutdown. (5292)
Stack trace from _mprosrv reads:
lkTableLockUpdate()
lkfree()
lkrendLockChain()
lkrend()
lkresync()
DBANALYS was run online previously
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
OpenEdge 10.1B02 32-bit Service Pack
OpenEdge 10.1B02 64-bit Service Pack
OpenEdge Category: Database
CAUSE:
Bug# OE00157714
CAUSE:
In 10.1B02 was first introduced an enhancement to dbanalys utility to include online chain analysis. In order for chain analysis to accurately report on the chains, shared table locks are required. Clients locking records then conflict with the table locks granted to the online chanalys.
FIX:
This issue was fixed in 10.1B03, it is suggested to upgrade to 10.1C03 or higher. Refer to Solution P132798 below.
If upgrade is not possible at this time, as a workaround, use the parameter -scan when running proutil's dbanalys utility online.
Syntax:
proutil <dbname> -C dbanalys -scan