View Incident Report

Serious

Reported By: Harry de Boer
Reported On: 4/7/2007
For: Version 1.02 Build 1

# 2315 Inserting More than 2 Gigabytes of Data into a Table Corrupts the Table

I tried to add a billion records in a testtable with an SP. This encounters in an error (I guess because the veld is only varchar(10)) -after a few hours. When I try to open (or even repair) the table this error occurs.

============================================================================
====
SQL Error (ElevateDB 1.02 Build 1)
============================================================================
====

ElevateDB Error #100 There is an error in the metadata for the table Tbl
(Signature, password, or character set (ANSI/Unicode) mismatch)

The table is about 2Gig, so I guess a lot (maybe all but one record is inserted the right way).

PROCEDURE "addRecords" (IN "RECID1" INTEGER, IN "RECID2" INTEGER, IN "DAT1"
TIMESTAMP, IN "DAT2" TIMESTAMP)
BEGIN
DECLARE Tbl CURSOR FOR stmt;
DECLARE I INTEGER;
DECLARE II INTEGER;
SET I = RECID1;  //is 1
SET II = RECID2; // is 1000000000
PREPARE stmt FROM 'SELECT * FROM Tbl';
OPEN Tbl;
WHILE I <= II DO
  INSERT INTO Tbl (veld1, veld2, veld3, datum1, datum2) VALUES (I, '_' +
  CAST(I AS VARCHAR(10)), CURRENT_TIMESTAMP, DAT1, DAT2); //dat1 and dat2
are valid timestamps
  SET I=I+1;
END WHILE;
CLOSE Tbl;

Comments

There was an integer wraparound issue with a TStream.Seek call internally that was causing the table header in the .EDBTbl file to get overwritten with data that should have been written at the end of the file. Currently, the REPAIR TABLE statement cannot fix this issue because it makes the table appear invalid and EDB will not attempt to repair a table that doesn't appear to be an ElevateDB table.

Resolution

Fixed Problem on 4/10/2007 in version 1.03 build 1

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap