Select bug or bad indices

[Chris Jones]

So I re-indexed the problem table again and ran diagnosis on it, I am an
error box that says:

"Kernel error: 0x83504.  Unique violation of index " S".

Running diagnosis  again I get:

Field: fldKeyword. Index record count (246125) differ from field one
(323470).
Field: fldKeyword. Index have 77345 missing records.


Problems found!  ( Table: tblKeyword )


This is Valentina server 5.4.3



On Thu, Nov 14, 2013 at 5:31 PM, Chris Jones <cjones at daz3d.com> wrote:

>
> So I did two queries against a server running 5.4.3 server, her are the
> queries and the tune-up output:
>
> SELECT * FROM tblKeyword WHERE fldKeyword = 'Monie.duf';
>
> FOUND in the QueryPool: NO
> FOR SQL QUERY TIME = 140 :
>    DO SELECT : TIME = 140 : ROWS = 0
>    DO SIMPLE SELECT : TIME = 140 : ROWS = 0
>    DO Single Table Without GROUP BY : TIME = 140 : ROWS = 0
>   FOR Table [tblKeyword]  DO resolve WHERE statement : TIME = 140 : ROWS =
> 0
>   FOR Field [fldKeyword]  DO FindValue(Monie.duf) :  USES INDEX = TRUE :
> TIME = 140 : ROWS = 0
>    DO Cursor Creation : TIME = 0 :
>
>
> SELECT * FROM tblKeyword WHERE 'Monie.duf' = fldKeyword;
>
> FOR SQL QUERY TIME = 249 :
> DO SELECT : TIME = 249 : ROWS = 1
>    DO SIMPLE SELECT : TIME = 249 : ROWS = 1
>    DO Single Table Without GROUP BY : TIME = 249 : ROWS = 1
>   FOR Table [tblKeyword]  DO resolve WHERE statement : TIME = 249 : ROWS =
> 1
>   FOR EXPR  DO Scan of column : TIME = 249 : ROWS = 1
>    DO Cursor Creation : TIME = 0 :
>    DO Record Locks : TIME = 0 :
>
> They seem the same to me, but one returns a result and the other returns
> nothing.  I just re-indexed this table.
>
> Am I missing something?
>
> --
> Christopher Jones
> Software Developer
> DAZ 3D
>



-- 
Christopher Jones
Software Developer
DAZ 3D
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131114/e47dbbc0/attachment.html>