Database Flush Command not working

[Ivan Smahin]

On Aug 5, 2013, at 6:13 PM, william humphrey <bill at bluewatermaritime.com> wrote:

> That is what I do. I'm not calling Flush in my app because of that
> setting. I also did a diagnose of the database and it is ok.

But you wrote

> When I use just the flush command I do not see the change in what is
> written to the hard drive.

So you called db.Flush from your app and then realize that you can set vServer's
FLUSHEACHDATACHANGES = 1 to avoid calling flush from app.
In both cases you did not see that db is really flushed.
Correct?


> When this occurs in the logs then the database is written to the hard drive:
> 
> Mon Aug  5 2013 10:44:42.331021 (TID 4351606784): (UID 20) Database
> 'goleta' has been successfully opened.
> Mon Aug  5 2013 10:45:06.243656 (TID 4353216512): (UID 20) Database
> 'b_l_database' has been successfully closed.
> Mon Aug  5 2013 10:45:06.243843 (TID 4351070208): (UID 20) Database:
> b_l_database; User: sa: OK
> Mon Aug  5 2013 10:45:06.244006 (TID 4352679936): (UID 20) Database
> 'b_l_database.vdb' remoteID 29878016 unregistered.
> Mon Aug  5 2013 10:45:06.244025 (TID 4352679936): (UID 20) Closing
> database 'b_l_database': OK
> Mon Aug  5 2013 10:45:06.244036 (TID 4352679936): (UID 20) Database
> 'b_l_database' object memory released.
> Mon Aug  5 2013 10:45:06.246694 (TID 4353216512): (UID 20) Database
> 'goleta' has been successfully closed.
> Mon Aug  5 2013 10:45:06.246859 (TID 4351070208): (UID 20) Database:
> goleta; User: sa: OK
> Mon Aug  5 2013 10:45:06.247006 (TID 4352679936): (UID 20) Database
> 'goleta.vdb' remoteID 90443360 unregistered.
> Mon Aug  5 2013 10:45:06.247036 (TID 4352679936): (UID 20) Closing
> database 'goleta': OK
> Mon Aug  5 2013 10:45:06.247047 (TID 4352679936): (UID 20) Database
> 'goleta' object memory released.
> Mon Aug  5 2013 10:45:06.247314 (TID 4351070208): (UID 20) Database
> '(null)' remoteID 25535440 unregistered.
> Mon Aug  5 2013 10:45:06.247334 (TID 4351070208): (UID 20) Closing
> database '(null)': OK
> 

This is vServer log. Speaking of  ""Wrong ref for ...," I told about V4REV log.
I'm just about to check that your call to db.Flush was correct.

Also please clarify what do you call to change the database in particular?
Is it SQL like db.SQLExecute ... or API like table.AddRecord...? 

Could you show me your code just to avoid a lot of such questions?

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