Corrupt index

[Ivan Smahin]

On 6/19/2011 6:42 PM, Beatrix Willius wrote:
> Got it!
>
> After adding date it's possible to clean it in my app.

Do you mean data - or there is some issue with date?
"Clean data in the app" - what do you mean be that?
> The loop goes over the main table messages and changes data.
Is there just that index-by-word text field?
Changes - do you mean update with something like NULL or empty string?

> This is actually quite simple and wasn't changed for a long time. Adding a flush after changing data didn't avert the problems.

Flush is about to write data to the disk - nothing more. So until your 
app is not crashed "in the middle" the "flush" cures nothing.

> Only a reindex did. I think this problem must be something newish to Valentina. A version of my app from march 2010 doesn't show the problem.
>

So originally the problem is - "Index corrupt after update" - yes?


-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com