Hi,

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).

If necessary I can provide you the file by email.

Hope you can fix this problem soon because my clients waiting for a solution.

Regards
Mathias

Mathias


I suggest you contact Tim directly via email, phone or Skype rather than waiting for him to visit the ngs.

Roy Lambert [Team Elevate]

Mathias,

Answered via email:

<< 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).

If necessary I can provide you the file by email. >>

Please send me the table files (.dat, .idx, .blb) as a .zip file and I'll
take a look.  I recently fixed a buffer issue with exclusively-opened tables
for 4.30 B5 due to this fix:

http://www.elevatesoft.com/incident?action=viewrep&category=dbisam&release=4.30&incident=3440

and I think your problem is the same thing.  I'll confirm this here, and
then I'll be doing a new build of DBISAM shortly.

Tim Young
Elevate Software
www.elevatesoft.com