Kbase P156729: Database periodically shutting down abnormally with errors.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/09/2010 |
|
Status: Verified
SYMPTOM(s):
Database periodically shutting down abnormally with errors.
(9450) bkioRead:Insufficient disk space during Read, fd 800, len 4096, offset 63028, file G:\qaddb\rmi_25.d2.
(9446) SYSTEM ERROR: bkioRead: Bad file descriptor was used during Read, fd 800, len 4096, offset 63028, file
(9445) SYSTEM ERROR: read wrong dbkey at offset 258162688 in file G:\qaddb\rmi_25.d2
(4229) Corrupt block detected when reading from database.
(1124) SYSTEM ERROR: Wrong dbkey in block. Found 8149600, should be 12034240 in area 25.
<func-name>: Error occurred in area <num>, block number: <num>, extent<name>: . (10560)
The errors occur at different times.
The errors occur at different file offsets in different areas.
Data from running perfmon shows the following around the times when the database error occur:
A spike in the amount of disk reads and writes per second.
A spike in the disk queue length.
A spike in the number of pooled page bytes.
A spike in the number of page reads per second.
Windows Event logs for Application and System do not show any errors around the times when the database errors occur.
FACT(s) (Environment):
Windows
OpenEdge 10.1B
CAUSE:
There is not enough memory available to the Windows Paged Pool when the server is very busy and demand for memory is high.
FIX:
Increase the Windows PagedPoolSize value to allow a larger paged pool. A setting of 0xFFFFFFFF will allocate the maximum Paged Pool in lieu of other resources to the computer.