Table record count errors

Tim Davis timdavis at amug.org
Sat Jan 3 16:49:34 CST 2004


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.

Tim



More information about the Valentina mailing list