Consultor Eletrônico

Solution ID: P4303

SYMPTOM(s):

Using multi-volume sort files

Error 290 during idxbuild

SYSTEM ERROR: I/O error <n> in <program>, ret <n>, file <n>, addr <n>. (290)

SYSTEM ERROR: I/O error 0 in writeto, ret <n>, file (srt), addr 2147475456. (290)

CAUSE:

You are hitting the 2GB limit on one of the files used for sorting the indexes.

The space for sorting can be huge when you have many indexes on char field(s). This is because strings are not compacted in phase 1 of "idxbuild".

FIX:

Add more entries within the <dbname>.srt file making sure that you specify a fixed size less than 2GB for each entry.
Alternatively you can run idxbuild for less indexes.