Table record count errors

[Ruslan Zasukhin]

on 1/4/04 1:49 AM, Tim Davis at timdavis at amug.org wrote:

> Hi Ruslan,
> 
>>> I have record insert code that succeeds 99% of the time, but
>>> occasionally I get a server crash and a diagnostic error dealing with
>>> the record count.
>> 
>> Please make log of crash and send to me.
>> 
>> As I understand you do not have way to reproduce?
> 
> No, I don't think I can.
> 
>>> When this occurs, it can take a very long time to
>>> rebuild the db from XML dump. How can these errors be avoided? Could a
>>> self-repair routine be built into the server to fix such record
>>> building anomalies?
>> 
>> Yes, in 2.x we will add REPAIR function that will try fix problem that
>> it
>> can fix.
> 
> Cool!
> 
>>> (!) Table has 208270 physical records but field has 208269
>> 
>> Tim, if this is Boolean field, then diagnose can be wrong.
> 
> There are a bunch of fields and they are not a boolean fields.

Then I think you need add more Flush() calls after your record
modifications.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------