View Incident Report

Minor

Reported By: Piotr Front
Reported On: 9/24/2012
For: Version 2.10 Build 1

# 3636 Verify/Repair Functionality Incorrectly Reporting/Fixing Non-Error Condition with BLOB Columns

There is a serious bug with blobs...

Steps to reproduce:

1) Create table
2) Open table in EDB-Manager, add one row, set to "BLOB" field data with size greater than "blob block size". Commit.
3) Close table.
4) Repair table - everything is ok in logs
5) Open table again and set "BLOB" field value to null or set data with size less than existent.
6) Close table
7) Repair again -

Verification of the table Blobs started at 2012-09-24 13:12:14.923
Verification error for the Blobs table file .\Database\.\TEST2\Blobs.AxDBBlb (Invalid BLOB block 1 total size (0)) - Fixed
Verification error for the column BLOB in the Blobs table (Invalid BLOB size in the row 1 (172593)) - Fixed
Verification of the table Blobs ended at 2012-09-24 13:12:14.930

CREATE TABLE "Blobs"
(
"ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
"BLOB" BLOB,
"CLOB" CLOB COLLATE "UNI_CI"
)
VERSION 1.00
READWRITE
UNENCRYPTED
INDEX PAGE SIZE 8192
BLOB BLOCK SIZE 1024
PUBLISH BLOCK SIZE 1024
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768

Comments

The verify/repair was incorrectly reporting/fixing the first condition (0 total size), and then the second portion of the verify/repair was then fixing the "fix" caused in the first step. This is why there was always two errors in the log.

Resolution

Fixed Problem on 10/3/2012 in version 2.11 build 1

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
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