Icon View Incident Report

Serious Serious
Reported By: Thomas Kowalski
Reported On: 6/3/1999
For: Version 1.14 Build 1
# 431 Loading Data Larger Than 256k Into a BLOB Field Causes Corruption of Blocks

I found some problems with blob-fields. I have a simple test program to load images into the database (fieldtype: binary or blob). If I load 500 images, the database size is 10 MByte. Now I delete all records. The resulting database size is also 10 MByte. After this I load the same 500 picture again. The resulting Database size in this case: 20 Mbyte!!!??? A delete on the new records produces the dbisam-errormessage: #8711.


Comments Comments
The problem was with loading data that was larger than 256k into a BLOB field. Loading data less than 256k in size would not cause this problem. The problem was related to block buffers being prematurely flushed to disk and the result would be corrupted block buffers and a situation where BLOB blocks not being re-used properly.


Resolution Resolution
Fixed Problem on 6/8/1999 in version 1.15 build 1
Image