Icon View Incident Report

Serious Serious
Reported By: Joerg Philipp
Reported On: 4/24/2002
For: Version 3.10 Build 1
# 1113 8708 Error on Blob Open Can Cause Blob Pointer Corruption

After an error 8708 (Record has been changed or deleted by another user), sometimes the table is corrupted. The repair gives a "Invalid BLOB offset in BLOB file for physical record..." message, and the memo field in this record is lost. To verify the problem,
create the table using the SQL below.

Then open the table twice with dbsys. In the first instance of dbsys change the memo field of the first record and post the changes. Then go to the second instance of dbsys und try to open this memo. You will get an error 8708, that is ok. Now you go to the second record and change the value of the string field "Name". When you post the change, you will get an error 8708, and the table is corrupted.

CREATE TABLE "test_memo.DAT"
(
"Number" AUTOINC,
"Name" CHARACTER(20),
"Text" BLOB(0 , 1),
PRIMARY KEY ("Number") COMPRESS NONE
LANGUAGE "ANSI Standard" SORT "Default Order"
USER MAJOR VERSION 1
);
 
INSERT INTO "test_memo.DAT" VALUES (Null, Null , "hallo"); 
INSERT INTO "test_memo.DAT" VALUES (Null, Null , Null);




Resolution Resolution
Fixed Problem on 4/28/2002 in version 3.11 build 1
Image