Kbase P13752: Database crashes with ODBC client connected; memory violation
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/29/2010 |
|
Status: Unverified
SYMPTOM(s):
Database server shuts down with ODBC client application still attached
Database shut down abnormally.
Client processes terminating as result of abnormal shutdown
OID cores after _mprosrv has been shutdown
OID processes core dump as a result of the abnormal shutdown instead of proper termination process.
Memory violation for OIB process
nsahrecv + 0x9c [/usr/dlc/bin/_prooidv] from protrace file
Database log file shows:
11:51:49 BROKER 0: Disconnecting dead user 15. (2527)
11:51:49 BROKER 0: Begin transaction backout. (2252)
11:51:49 BROKER 0: Transaction backout completed. (2253)
11:51:49 BROKER 0: Disconnecting dead user 25. (2527)
11:51:49 BROKER 0: SYSTEM ERROR: Releasing regular latch. latchId: 27 (5028)
11:51:49 BROKER 0: User 25 died holding 1 shared memory locks. (2522)
SYSTEM ERROR: Memory violation. (49)
FACT(s) (Environment):
Progress 8.2x
Progress 8.3E
UNIX
CAUSE:
Bug# 20010608-002
CAUSE:
If an ODBC client is connected to a database that is shutting down, for whatever reason, a memory violation and core file are produced. There is no database corruption as a result.
FIX:
Migrate to Progress 9.1x or later and use SQL-92 instead of SQL-89
There are no plans to fix this issue in Progress 8.X.