Select bug or bad indices

[Chris Jones]

@Beatrix : The database with indexes is around 400 mb.

@Ivan:
I can send the database if you can tell me the best way to do so, zipped
its about 75 mb.


On Fri, Nov 15, 2013 at 6:16 AM, Beatrix Willius <bwillius at gmx.de> wrote:

> Hi,
>
> doesn’t that sound like my bug from
>
> http://www.valentina-db.com/bt/view.php?id=6621
>
> ???
>
> How large is your database? I only got this with really really large (>20
> GB) databases.
>
> On 15.11.2013, at 03:19, Chris Jones <cjones at daz3d.com> wrote:
>
> 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 )
>
>
> Mit freundlichen Grüßen/Regards
>
> Trixi Willius
>
> http://www.mothsoftware.com
> Mail Archiver X: The email archiving solution for professionals
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>


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