Kbase P97768: _sqlsrv2 causes database crash with errors 49, 1124, 10560, 10561
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/11/2008 |
|
Status: Verified
SYMPTOM(s):
_sqlsrv2 process crashed
Database crashed
SYSTEM ERROR: Memory violation. (49)
Wrong db-Block <num> vs. <num> (DbKey: <num>) (rmFTL014)
** Save file named core for analysis by Progress Software Corporation. (439)
SYSTEM ERROR: wrong dbkey in block. Found <dbkey>, should be <dbkey> (1124)
<func-name>: Error occurred in area <num>, block number: <num>, extent<name>: . (10560)
bmReleaseBuffer: Error occurred in area <num>, block number: <num>, extent<name>: . (10560)
Writing block <num> to log file. Please save and send the log file to Progress Software Corp. for investigation. (10561)
FACT(s) (Environment):
Progress/OpenEdge Product Family
All Supported Operating Systems
CAUSE:
A third party program tied up the _sqlsrv2 port causing the _sqlsrv2 process to die. To ensure data integrity, the database then shut down.
FIX:
1. Restart the database. It will go through crash recovery.
2. Reconnect the SQL user and a new _sqlsrv2 process will be spawned.
3. The Database Repair Utility should be run when the database can be stopped to check for database corruption. Or make a copy of the database and run dbrpr against it.