View Incident Report

Serious

Reported By: Roy Lambert
Reported On: 11/5/2014
For: Version 2.18 Build 1

# 4124 New Rows that Re-Use BLOB Column Space from Deleted Rows Can Result in Invalid Verification Errors

I'm seeing errors like the following in my tables during a VERIFY TABLE execution, and I don't know what's causing them.

Steps to reproduce:

1. Build a nice big table with BLOBs
2. Delete all rows from the table using DELETE FROM not EMPTY TABLE
3. Insert some news rows with BLOB data

Verification of the table EMails started at 2014-10-24 08:18:08.557
Verification error for the column _Recipients in the EMails table (Invalid BLOB size in the row 63236 (59)) - Not Fixed
Verification error for the column _Recipients in the EMails table (Invalid BLOB row version in the row 63236 (2987)) - Not Fixed
Verification error for the column _Recipients in the EMails table (Invalid BLOB size in the row 63235 (52)) - Not Fixed
Verification error for the column _Recipients in the EMails table (Invalid BLOB row version in the row 63235 (2988)) - Not Fixed
Verification of the table EMails ended at 2014-10-24 08:18:29.391

Comments

The problem was caused by the verification incorrectly reporting the BLOB columns of re-used rows as having corruption issues. These are *invalid*, and there is no corruption in the rows or BLOBs. Simply updating to 2.18 B2 or higher will fix the problem.

Resolution

Fixed Problem on 11/18/2014 in version 2.18 build 2

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