Corruption - more info

[Kem Tekinay]

On 3/13/06 6:31 AM, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

> 1) ho many tables/fields/indexes do you have ?
>     if you have a lots - then just set cache to 10MB

It's the same structure that I sent to you. 6 tables, 7 BinaryLinks.

> 100MB cache this is too many I think.
> 10-20MB will work good for 99% of cases.

That's fine, but if I make the cache larger, it just takes longer to
corrupt.

> I think secret is somehow in your tables and fields.
>
> So we need to get at least your compiled application,

I'd be happy to send you the whole app along with a username and password to
access the account that holds the records. Or do you need me to trim it
down?

Also, my app uses Einhugur's UtilLib. Is that a problem?

> I prefer test on 3MB cache and amount of record enough to get problem.

3 MB was the same as 1 MB. The database corrupted after 66 records:

> ==========> Field: AddressTo , type VarChar
> ==========> IndexFile
> PAGE (0, 0) Inventory pages OK.
> Index Inventory pages OK.
> 
> PAGE (3, 2) OK.
> 
> All right!  ( IndexFile )
> 
> .....> VarCharFile
> (!) FirstRecID is not correct Must be 66 but it is 33
> (!) RefFile is not correct. Must be rebuilt.
> (!) Total number of records on VarChar pages does not match table's record
> count.
> 
> Problems found!  ( VarCharFile )
> 
> 
> Problems found!  ( Field: AddressTo , type VarChar )

__________________________________________________________________________
Kem Tekinay                                                 (212) 201-1465
MacTechnologies Consulting                              Fax (914) 242-7294
545 Eighth Avenue, Suite 401                          Pager (917) 491-5546
New York, New York 10018                    http://www.mactechnologies.com

To join the MacTechnologies Consulting mailing list, send an e-mail to:
  mactechnologies_consulting-subscribe at yahoogroups.com