Database Flush Command not working

william humphrey bill at bluewatermaritime.com
Sat Jan 22 13:04:19 CST 2011


If I am using livecard to enter my data, as I do always, and something goes
wrong with livecard which is a crash that affects the whole system and
requires a reboot then all the data that was entered into vServer through
livecard from after the last time I closed and opened livecard is lost.

This started happening since my last update of valentina vServer and vRev
(about six months ago). At that time I also had problems getting the init of
vServer to realize that I wanted it to remain open longer than the ten
minute default. I was able to change that default to 2000 minutes and last
month I change the default of flush in vServer init to flush after any edit.

But still when I have a crash that brings down the whole system I lose all
data that was entered since last open and close of database. This includes
data that I could see in vStudio.

I have studied the logs from immediately before the crash and there is no
indication of a database flush ever occurring.

Line in log after crash looks like this:

Wed Jan 19 2011 19:09:50.897328 (TID 2954915840): (UID 15) BLOB
's_agents_signature' remoteID 20498240 registered.
Wed Jan 19 2011 19:09:51.676063 (TID 2954915840): (UID 15) ERROR 0x71000:
line 1:188: unexpected end of file
--------------
line in log after proper shutdown looks like this:
Wed Jan 19 2011 20:52:02.911693 (TID 2954383360): (UID 15) BLOB
's_agents_signature' remoteID 20828928 unregistered.
Wed Jan 19 2011 20:52:02.911724 (TID 2954383360): (UID 15) Database
'b_l_database.vdb' remoteID 20822816 unregistered.
Wed Jan 19 2011 20:52:02.911747 (TID 2954383360): (UID 15) Closing database
'b_l_database': OK
Wed Jan 19 2011 20:52:02.911767 (TID 2954383360): (UID 15) Database
'b_l_database.vdb' object memory released.
Wed Jan 19 2011 20:52:02.917514 (TID 2954915840): (UID 15) Closing
connection. ( Connections available: '5')

-----------

sometimes log looks like this (unexplained random happens several times on
start-up):

Wed Jan 19 2011 20:07:58.716364 (TID 2688906560): ERROR: Address already in
use
Wed Jan 19 2011 20:07:58.716523 (TID 2688906560): Shutting down server...
Wed Jan 19 2011 20:07:58.716715 (TID 2688906560): Server terminated


On Sat, Jan 22, 2011 at 2:42 PM, Ruslan Zasukhin <
ruslan_zasukhin at valentina-db.com> wrote:

> On 1/22/11 12:46 PM, "Ivan Smahin" <ivan_smahin at paradigmasoft.com> wrote:
>
> > On 1/22/2011 12:05 AM, william humphrey wrote:
> >> I did the show properties. The flusheachdatachanges is "1". That's
> >> nice feature show properties. I can see the version of my server there
> >> too.
> >>
> >> So I'm back to needing a way to be sure the database changes are saved
> >> from within livecode since the flush setting in vserver is not doing
> >> the job.
> >>
> >
> > No idea. It works for me and others.
>
> May be there is sense from start?
>
> Why William, you think it not works ?
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110122/a1667ac1/attachment.htm>


More information about the Valentina mailing list