Database Flush Command not working

Ivan Smahin ivan_smahin at paradigmasoft.com
Mon Aug 5 03:41:51 CDT 2013


Hi William,

On Aug 4, 2013, at 9:21 PM, william humphrey <bill at bluewatermaritime.com> wrote:

> I have figured out why I'm not getting the answer I want about the
> "flush" command. I can see that the new data is added to the database
> but the database is held in ram so when the computer (or just my copy
> of LiveCode) crashes those changes are lost.
> 
> How do I tell vServer to write the database to the hard drive (which
> it does when I close the database). Is there another command similar
> to "Flush" but is "Commit" to hard drive?
> 
> Sometimes I do hours of work and the computer crashes and I lose all that work.
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> 


The only case I see when "flush" does not affect database is incorrect dbRef param in
get VDatabase_Flush( dbRef ) call.
Please check it.
Btw, it would be something like this ""Wrong ref for ..." in V4REV log.

Also, please diagnose your db (just in case) - is it healthy or not.

What about another (fresh) database - do you see changes after "Flush"?
I mean is this issue specific to particular db instance / server?

I can assist you via TeamViewer if you need it.
-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com



More information about the Valentina mailing list