View Incident Report

Minor

Reported By: Kevin Koehne
Reported On: 7/2/2012
For: Version 2.08 Build 3

# 3595 REPAIR TABLE Statement Not Repairing Two Rows Pointing to Same BLOB Correctly

If I run a repair on all of the tables in a database, it indicates that it's fixed all of the problems. However, there is
one table that has a bunch of errors that, even though Repair indicates the error was fixed, re-running Repair on the table gives the same error:

"Verification error for the column Description in the tbllogfiles table (Invalid BLOB row version in the row 157511 (157512))"

Comments

The problem was that there were two rows pointing to the same BLOB. This would cause the repair to update the row version for the BLOB to match the second row. Of course, when the repair was run again, the first row would then complain about the row version being incorrect, and update the BLOB's row version again. The second row would then experience the same problem, rinse and repeat.

Resolution

Fixed Problem on 7/4/2012 in version 2.09 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