V4RB Sockets, Threads and Windows Crashes

[Ruslan Zasukhin]

On 3/31/04 11:58 AM, "Cindy Brown" <cindy at kowhaiprogramming.com> wrote:

> Hi Ruslan,
> 
> Further to my last email, I have diagnosed the server database again and
> found the following errors in assessment:
> 
> -----> Field: "Assessment_Style' of type VarBinary
> Problems found!
> 
> ...........Page 2
> (!) ItemCount =3329 is bigger of max possible value =510
> (!) Length of deleted 1020 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1021
> (!) Length of deleted 1532 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1533
> (!) Length of deleted 1534 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1535
> (!) Length of deleted 1536 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1537
> (!) Length of deleted 1542 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1543
> (!) Length of deleted 1544 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1545
> (!) Length of deleted 1546 record is NOT zero
> (!) Length of deleted 1547 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1548
> (!) Length of deleted 1550 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1551
> Next offset must be >=, but it is less. For RecID = 1552
> (!) Length of deleted 1553 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1554
> (!) Length of deleted 1555 record is NOT zero
> (!) Length of deleted 1556 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1557
> Next offset must be >=, but it is less. For RecID = 1558
> (!) Length of deleted 1559 record is NOT zero
> (!) Length of deleted 1560 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1561
> (!) Length of deleted 1562 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1563
> (!) Length of deleted 1564 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1565
> (!) Length of deleted 1584 record is NOT zero
> (!) Length of deleted 1585 record is NOT zero
> (!) Length of deleted 1586 record is NOT zero
> Next offset must be >=, but it is less. For RecID = 1587
> Next offset must be >=, but it is less. For RecID = 1588
> Next offset must be >=, but it is less. For RecID = 1589
> (!) Length of deleted 1590 record is NOT zero
> (!) Length of deleted 1591 record is NOT zero
> 
> 
> This just keeps going down. Hopefully this will give you a bit more of an
> idea of what might be going wrong?

No Cindy,

All this corruptions are just results of your crashes.

Although they show that you DO NOT do flush() after commands that modify
records!!!

If you have execute INSERT, UPDATE, DELETE and flush(),
Then any crash after that cannot corrupt database.

You say that you crashes on Select() i.e. You try to READ later.
But you get corruptions. This sounds for me, like you have not flush() data
BEFORE 


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