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