Kbase P43596: SQL-92 server crashes on while SQL-92 clients extensively use Sequence authorization
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/30/2008 |
|
Status: Verified
SYMPTOM(s):
SQL-92 server crashes on memory violation and after a while the JDBC application hangs
SYSTEM ERROR: Memory violation. (49)
Disconnecting client <number> of dead server <number>. (2526)
Disconnecting dead server <number>. (2525)
JDBC application hangs at different places coded by different programmers
The application extensively uses sequence authorization
When aborting the hanging JDBC application, the records remain locked
Unable to disconnect JDBC user from promon or proshut
Database has to be shut down to recover
FACT(s) (Environment):
IBM AIX
Progress 9.1D
CAUSE:
Bug# OE00095657
CAUSE:
Memory access violation in freeing a cache entry for authorization for access to sequences. Sequence authorizations are added to a cache, however the memory entries in this cache were being freed while still in the cache. Hence, depending on platform and memory reuse scheme for the particular platform, the individual cache entries could get corrupted.
FIX:
Upgrade to 9.1D08, 10.0A or later.