Kbase P16143: Query crashes with errors 163 and 290 on srt files
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Windows NT
SYMPTOM(s):
Query crashes with errors 163 and 290 on srt files
Query performance is very slow
Client is disconnected from a database
SYSTEM ERROR: Seek error <value>, file <value>, addr <value>. (163)
SYSTEM ERROR: Seek error 22, file 7, addr -2147483648. (163)
SYSTEM ERROR: I/O error <n> in <program>, ret <n>, file <n>, addr <n>. (290)
The addr values in the 163 and 290 errors are close to the amount of free disk space.
Srt files are close to 2 GB of size in the application working directory
Query outputs large amount of data
CAUSE:
Query contains either non-indexed read or a bad choice of indexes.
The bad choice of indexing caused the processing to be slow, large srt files to be created. The srt files will consume all the free disk space, and when they try to expand the application crashes with the 163 and 290 errors.
Checking the available disk space after the crash is not valid because temporary files such as srt are erased during the cleanup process of a shutdown.
FIX:
Analyze index usage and design the queries with the most efficient index.
If necessary break the query in smaller parts or add indexes to the DB to avoid the non-indexed data.