Kbase P154178: Database crashing periodically with 1124 errors.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/10/2009 |
|
Status: Verified
SYMPTOM(s):
(9450) bkioRead:Insufficient disk space during Read, fd 1156, len 4096, offset 126544, file <path>_100.d3.
(9446) SYSTEM ERROR: bkioRead: Bad file descriptor was used during Read, fd 1156, len 4096, offset 126544, file <path>_100.d3.
(9445) SYSTEM ERROR: read wrong dbkey at offset 518324224 in file <path>ata_100.d3
found 113633408, expected 147269376, retrying. area 100
(10560) bkRead: Error occurred in area 100, block number: 1150541, extent: .
(10561) Writing block 1150541 to log file. Please save and send the log file to Progress Software Corp. for investigation.
0000: 80e8 c506 037f 0100 0000 0000 0a00 0000
SQLREMC 221: (-----) Disconnected due to shutdown of primary database
SQLSRV2 2: (-----) Error in rss_cleanup: error code -20034 was returned by dsmUserDisconnect.
(10672) The Source database is crashing. Fathom Replication cannot continue
(1124) SYSTEM ERROR: Wrong dbkey in block. Found 113633408, should be 147269376 in area 100.
(4232) Corrupt block detected when attempting to release a buffer.
(10560) bmReleaseBuffer: Error occurred in area 100, block number: 1150541, extent: .
(10561) Writing block 1150541 to log file
0000: 80e8 c506 037f 0100 0000 0000 0a00 0000
(1124) SYSTEM ERROR: Wrong dbkey in block. Found 113633408, should be 147269376 in area 100.
(5029) SYSTEM ERROR: Releasing multiplexed latch. latchId: 34618952
(2522) User 235 died holding 1 shared memory locks.
(2249) Begin ABNORMAL shutdown code 2
(2251) Destroyed user 15 pid 5536.
(2527) Disconnecting dead user 88.
(334) Multi-user session end
Database crashing periodically with 1124 errors.
FACT(s) (Environment):
Database scans clean with proutil dbname -C dbrpr (options from Scan menu for find bad records and find bad blocks for all areas).
dbtool dbname also scans clean when selecting option 5 to Validate database blocks.
Windows
OpenEdge 10.1x
CAUSE:
Anti-virus software is scanning files when they are being accessed.
FIX:
Put the directory/folder containing all extents that are associated with the database on an exclusion list. This will prevent the files from being scanned when reading or writing database blocks from/to disk.