possible bug?

Joseph Morgan joseph at checkos.com
Wed Apr 9 11:27:07 CDT 2008


Ok I reindex and same problem so I diagnose and here is the text:

==========> Field: accountName , type Text
==========> IndexFile
PAGE (0, 0) Inventory pages OK.
Index Inventory pages OK.

PAGE (3, 2) At least one value counter is wrong. Values have wrong  
order.

Problems found!  ( IndexFile )

.....> SegmentFile:

All right!  ( SegmentFile: )


Problems found!  ( Field: accountName , type Text )


Same thing?


On Apr 9, 2008, at 2:01 AM, Ivan Smahin wrote:

> Hello Joseph,
>
> Wednesday, April 9, 2008, 9:46:45 AM, you wrote:
>
>> Hi Ivan,
>
>>> Could you diagnose database firstly?
>
>> yes now I did and here's what was in the text file:
>
>> PAGE (3, 2) At least one value counter is wrong. Values have wrong
>> order.
>
>> Problems found!  ( IndexFile )
>
> .....>> SegmentFile:
>
>> All right!  ( SegmentFile: )
>
>
>> Problems found!  ( Field: accountName , type Text )
>
> This is explanation - broken index.
> Please do reindex.
> The one of possible way is just issue sql command:
>
> REINDEX DATABASE
>
>
>>> Do you have Index-By-Words on this field?
>
>> originally no so I changed to to yes and still the problem remains.
> No - you should not use IndexByWords just because of something going
> wrong :) There is just special sort of index. I was just wondering it
> is so or not.
>
> -- 
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina



More information about the Valentina mailing list