Icon View Incident Report

Serious Serious
Reported By: Mathias Gerlach
Reported On: 6/22/2011
For: Version 4.30 Build 5
# 3461 Optimizing a Table Can Result in a Hard Loop and Lockup

I recently switched from Delphi 2007 to XE and DBISAM 4.29 Build 3 to 4.30 Build 5.

Now I get an infinite loop using OptimizeTable (with my app and with your Database System Utility). During optimization a new file (55040.dat) will be generated by your engine. This file grows and grows, up to several GB. The original file is only 30 MB.

The problem occurs only with one table. This table has 114 fields (including some BLOB fields) and more than 10000 records. The table seems to be ok and I tested it with a new created table (with the imported data from the old table).


Comments Comments
The problem was caused the changes introduced in incident #3440. There was an error in the buffer manager for exclusively-opened tables that could cause an infinite loop during index navigation combined with heavy updating, such as what occurs during an optimize or an alter.


Resolution Resolution
Fixed Problem on 6/23/2011 in version 4.30 build 6


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image