Icon View Incident Report

Serious Serious
Reported By: Brian Martin
Reported On: 10/21/2008
For: Version 4.27 Build 3
# 2996 Updating BLOB Columns with Optimistic Locking Enabled Can Cause BLOB Corruption

We have recently upgraded our product to use Delphi 2007 and DBISAM4 (build 3) we are running this client server at a couple of site but we are getting a problem which is occurring with regular frequency at one of these clients.

DBISAM Engine Error # 8963 BLOB block buffers corrupt in the table 'service'

We have run the repair a number of times and each time this has fixed the problem although obviously this looses the data in that field. This field contains call notes for an ongoing job so it is frequently being appended to and is used in any disputes (so is quite a key field for our clients).


Comments Comments
This issue was caused by optimistic locking and certain update patterns, which is why it was particularly hard to isolate. The fix also involved a redesign of the way BLOB blocks are re-used in the engine.


Resolution Resolution
Fixed Problem on 5/25/2009 in version 4.28 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image