Re: [WebDNA] "Safe Write for Database" setting....

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112634
interpreted = N
texte = 217 --Apple-Mail-CD0227E9-BCE4-4E84-A787-C63AC7F4FEE2 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable This means that you haven't had any issues with your database. (No need to m= ess with safe write) =20 Watch that your error logs don't get too big, now that you've turned them on= ..=20 Lots of stuff can change on a server in 10 years ;-) (Even if you don't touc= h it) I'd start with Stuart's suggestion.=20 D. Brooke Mobile > On Mar 15, 2016, at 5:13 PM, Rich Kwas wrote: >=20 > I don't seem to have any .db-tmp files anywhere . > They would be in the same "globals " folder as the main database right? >=20 > I did not have error logging turned on. > Just enabled that. >=20 > Nothings changed in this site really for years and years. Same db, same ad= min area, same everything. Just every now and then this occurs. >=20 >=20 >=20 >=20 > On Tuesday, March 15, 2016 4:43 PM, Stuart Tremain wr= ote: >=20 >=20 > Are you getting a lot of .db-tmp files being written for the db ? >=20 > If you are then there could be a problem with either your code or some of t= he content, based on the fact that the site has been operational for many ye= ars, I would open the .db file and check the content, also check your error l= og.txt >=20 > Kind regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >> On 16 Mar 2016, at 08:09, Rich Kwas wrote: >>=20 >> I already using [COMMITDATABASE db=3DFileName] in all the admin pages whe= re they edit these ads... >>=20 >> Problem still pops up every now and then, like today again. >>=20 >> Thoughts on the "Safe Write" setting? >>=20 >>=20 >> On Tuesday, March 15, 2016 4:01 PM, Stuart Tremain w= rote: >>=20 >>=20 >> =46rom memory, there was a bug in =E2=80=9CAutomatically commit databases= to disk after modification=E2=80=9D, I wonder if this was associated with y= our problem ? >>=20 >> You can always add [COMMITDATABASE db=3DFileName] after the modification j= ust to make sure. >>=20 >> Kind regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 16 Mar 2016, at 07:15, Rich Kwas wrote: >>>=20 >>> Is it safe to disable ""Safe Write for Database" in Preferences??? >>>=20 >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> Safe Write DB: >>> Enabled by default. Sets the WebDNA engine to create a temporary file wh= en writing the contents of a database to disk. The temporary file contents a= re then moved to the original database file after the entire database is com= pletely flushed to disk. This helps to eliminate corruption of the original d= atabase file if there is an interruption during the database write process. >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D >>>=20 >>> If I disable this setting will all changes be written to the db on the H= D immediately, without that need for a temporary file? >>>=20 >>> I've been having this issue "again" where a client says they make change= s to ad listings stored in the database, but then all the changes are gone a= few moments later. Like they never were altered in the first place.... >>>=20 >>> This site has been for over 10 years and the admin area has not been cha= nged recently or much over that time span... >>>=20 >>> There is no consistency to this issue. >>> It happens (like today) but may not happen for days or weeks. >>>=20 >>> I'm wondering if this "temporary file" and the original database on disk= are somehow under some circumstances getting out of sync. >>>=20 >>> The db isn't that large, having 2,111 records,151 Fields and using 4,759= K of ram. >>>=20 >>> I'm wondering if disabling "Safe Write" might be an option to try and pr= event this in the future. >>>=20 >>> Very frustrating for the client.I can't seem to duplicate it myself,but I= believe them when they say it happens.I may have posted about this issue i= n the past as well. >>>=20 >>>=20 >>> I'm on Windows Server2008 using vers.6.2 >>> I have nearly 1gb of unused ram on the server, plenty of hard drive spac= e.... >>>=20 >>>=20 >>> I've attached a screen capture of my Preferences in case anything else c= an be tinkered with. >>>=20 >>>=20 >>> --------------------------------------------------------- This message i= s sent to you because you are subscribed to the mailing list . To unsubscrib= e, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Report= ing: support@webdna.us >>=20 >> --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscribe= , E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us >>=20 >>=20 >> --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscribe= , E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us >=20 > --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe, E= -mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting:= support@webdna.us >=20 >=20 > --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe, E= -mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting:= support@webdna.us --Apple-Mail-CD0227E9-BCE4-4E84-A787-C63AC7F4FEE2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
This means that you haven't had any is= sues with your database. (No need to mess with safe write)   

Wat= ch that your error logs don't get too big, now that you've turned them on.&n= bsp;

Lots of stuff can change on a server in 10 years ;-) (Even if you don'= t touch it)

I'd start with Stuart's suggestion. 

D. Brooke Mobi= le

On Mar 15, 2016, at 5:13 PM, Rich Kwas <richkwasniewski@yahoo.com> wrote:
I don't seem to have any .db-tmp files anywhere .
They would be in the same "globals " folder as the main database r= ight?

I did not have error logging turned on.
Just enabled that.

Nothings changed in this site really for years and years. Same db, sa= me admin area, same everything. Just every now and then this occurs.<= /div>




On= Tuesday, March 15, 2016 4:43 PM, Stuart Tremain <webdna@idfk.com.au> wrote:


<= div class=3D"y_msg_container">
Are you getting= a lot of .db-tmp files being written for the db ?

If you are then there could be a problem with either your code or some o= f the content, based on the fact that the site has been operational for many= years, I would open the .db file and check the content, also check your err= or log.txt

Kind regards

Stuart Trem= ain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au=





On 16 Mar 2016, at 08:09, Rich= Kwas <richkwasniewski@yahoo.com> wrote:

I already using [COMMITDATABASE db=3DFileName] in all the= admin pages where they edit these ads...

<= /div>
Problem still pops up every now and then, like t= oday again.

Th= oughts on the "Safe Write" setting?


On Tuesday, March 15, 2016 4:01 PM, Stuart Tremain= <webdna@idfk.com.au> wrote:


= =46rom memory, there was a bug in =E2=80=9CAutomatically commit databases to= disk after modification=E2=80=9D, I wonder if this was associated with your= problem ?

You can always add [COMMITDATA= BASE db=3DFileName] after the modification just to make sure.

Kin= d regards

Stuart Tremain
IDFK Web Developments
A= USTRALIA
webdna@idfk.com.au





On 16 M= ar 2016, at 07:15, Rich Kwas <richkwasniewski@yahoo.com&g= t; wrote:

Is it safe to disable ""Safe Write for Dat= abase" in Preferences???

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D

Safe Write DB:=

Enabled by default. Sets the WebDNA en= gine to create a temporary file when writing the contents of a database to d= isk. The temporary file contents are then moved to the original database fil= e after the entire database is completely flushed to disk. This helps to eli= minate corruption of the original database file if there is an interruption d= uring the database write process.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D

If I disable this setting= will all changes be written to the db on the HD immediately,  without t= hat need for a temporary file?

I've been having this issue "= again" where a client says they make changes to ad listings stored in the da= tabase, but then all the changes are gone a few moments later. Like they nev= er were altered in the first place....

This site has been for over 10 years and the admin area ha= s not been changed recently or much over that time span...

There i= s no consistency to this issue.
It happens (like today= ) but may not happen for days or weeks.

I'm wondering if this "te= mporary file" and the original database on disk are somehow under some circu= mstances getting out of sync.

The db isn't that large, having 2,111= records,151 Fields and using 4,759K of ram.

I'm wondering if di= sabling "Safe Write" might be an option to try and prevent this in the futur= e.

Very frustrating for the client.I can't seem to duplicate it m= yself,but I believe them when they say it happens.I may have posted about &n= bsp;this issue in the past as well.


I'm on Windows Server2008 using vers.6.= 2
I have nearly 1gb of unused ram on the server, plent= y of hard drive space....


I've attached a screen capture of my Preferences i= n case anything else can be tinkered with.


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webd= na.us/list/talk@webdna.us Bug Reporting: support@webdna.us<webdna.jpg= >

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webd= na.us/list/talk@webdna.us Bug Reporting: support@webdna.us


=
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webd= na.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.= webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.= webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --Apple-Mail-CD0227E9-BCE4-4E84-A787-C63AC7F4FEE2-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] "Safe Write for Database" setting.... (Terry Wilson 2016)
  2. Re: [WebDNA] "Safe Write for Database" setting.... ("Terry Wilson" 2016)
  3. Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke 2016)
  4. Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas 2016)
  5. Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke 2016)
  6. Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain 2016)
  7. Re: [WebDNA] "Safe Write for Database" setting.... (Kenneth Grome 2016)
  8. Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas 2016)
  9. Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain 2016)
  10. Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke 2016)
  11. Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas 2016)
  12. Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain 2016)
217 --Apple-Mail-CD0227E9-BCE4-4E84-A787-C63AC7F4FEE2 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable This means that you haven't had any issues with your database. (No need to m= ess with safe write) =20 Watch that your error logs don't get too big, now that you've turned them on= ..=20 Lots of stuff can change on a server in 10 years ;-) (Even if you don't touc= h it) I'd start with Stuart's suggestion.=20 D. Brooke Mobile > On Mar 15, 2016, at 5:13 PM, Rich Kwas wrote: >=20 > I don't seem to have any .db-tmp files anywhere . > They would be in the same "globals " folder as the main database right? >=20 > I did not have error logging turned on. > Just enabled that. >=20 > Nothings changed in this site really for years and years. Same db, same ad= min area, same everything. Just every now and then this occurs. >=20 >=20 >=20 >=20 > On Tuesday, March 15, 2016 4:43 PM, Stuart Tremain wr= ote: >=20 >=20 > Are you getting a lot of .db-tmp files being written for the db ? >=20 > If you are then there could be a problem with either your code or some of t= he content, based on the fact that the site has been operational for many ye= ars, I would open the .db file and check the content, also check your error l= og.txt >=20 > Kind regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >> On 16 Mar 2016, at 08:09, Rich Kwas wrote: >>=20 >> I already using [COMMITDATABASE db=3DFileName] in all the admin pages whe= re they edit these ads... >>=20 >> Problem still pops up every now and then, like today again. >>=20 >> Thoughts on the "Safe Write" setting? >>=20 >>=20 >> On Tuesday, March 15, 2016 4:01 PM, Stuart Tremain w= rote: >>=20 >>=20 >> =46rom memory, there was a bug in =E2=80=9CAutomatically commit databases= to disk after modification=E2=80=9D, I wonder if this was associated with y= our problem ? >>=20 >> You can always add [COMMITDATABASE db=3DFileName] after the modification j= ust to make sure. >>=20 >> Kind regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 16 Mar 2016, at 07:15, Rich Kwas wrote: >>>=20 >>> Is it safe to disable ""Safe Write for Database" in Preferences??? >>>=20 >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >>> Safe Write DB: >>> Enabled by default. Sets the WebDNA engine to create a temporary file wh= en writing the contents of a database to disk. The temporary file contents a= re then moved to the original database file after the entire database is com= pletely flushed to disk. This helps to eliminate corruption of the original d= atabase file if there is an interruption during the database write process. >>> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D >>>=20 >>> If I disable this setting will all changes be written to the db on the H= D immediately, without that need for a temporary file? >>>=20 >>> I've been having this issue "again" where a client says they make change= s to ad listings stored in the database, but then all the changes are gone a= few moments later. Like they never were altered in the first place.... >>>=20 >>> This site has been for over 10 years and the admin area has not been cha= nged recently or much over that time span... >>>=20 >>> There is no consistency to this issue. >>> It happens (like today) but may not happen for days or weeks. >>>=20 >>> I'm wondering if this "temporary file" and the original database on disk= are somehow under some circumstances getting out of sync. >>>=20 >>> The db isn't that large, having 2,111 records,151 Fields and using 4,759= K of ram. >>>=20 >>> I'm wondering if disabling "Safe Write" might be an option to try and pr= event this in the future. >>>=20 >>> Very frustrating for the client.I can't seem to duplicate it myself,but I= believe them when they say it happens.I may have posted about this issue i= n the past as well. >>>=20 >>>=20 >>> I'm on Windows Server2008 using vers.6.2 >>> I have nearly 1gb of unused ram on the server, plenty of hard drive spac= e.... >>>=20 >>>=20 >>> I've attached a screen capture of my Preferences in case anything else c= an be tinkered with. >>>=20 >>>=20 >>> --------------------------------------------------------- This message i= s sent to you because you are subscribed to the mailing list . To unsubscrib= e, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Report= ing: support@webdna.us >>=20 >> --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscribe= , E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us >>=20 >>=20 >> --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscribe= , E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti= ng: support@webdna.us >=20 > --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe, E= -mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting:= support@webdna.us >=20 >=20 > --------------------------------------------------------- This message is s= ent to you because you are subscribed to the mailing list . To unsubscribe, E= -mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting:= support@webdna.us --Apple-Mail-CD0227E9-BCE4-4E84-A787-C63AC7F4FEE2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
This means that you haven't had any is= sues with your database. (No need to mess with safe write)   

Wat= ch that your error logs don't get too big, now that you've turned them on.&n= bsp;

Lots of stuff can change on a server in 10 years ;-) (Even if you don'= t touch it)

I'd start with Stuart's suggestion. 

D. Brooke Mobi= le

On Mar 15, 2016, at 5:13 PM, Rich Kwas <richkwasniewski@yahoo.com> wrote:
I don't seem to have any .db-tmp files anywhere .
They would be in the same "globals " folder as the main database r= ight?

I did not have error logging turned on.
Just enabled that.

Nothings changed in this site really for years and years. Same db, sa= me admin area, same everything. Just every now and then this occurs.<= /div>




On= Tuesday, March 15, 2016 4:43 PM, Stuart Tremain <webdna@idfk.com.au> wrote:


<= div class=3D"y_msg_container">
Are you getting= a lot of .db-tmp files being written for the db ?

If you are then there could be a problem with either your code or some o= f the content, based on the fact that the site has been operational for many= years, I would open the .db file and check the content, also check your err= or log.txt

Kind regards

Stuart Trem= ain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au=





On 16 Mar 2016, at 08:09, Rich= Kwas <richkwasniewski@yahoo.com> wrote:

I already using [COMMITDATABASE db=3DFileName] in all the= admin pages where they edit these ads...

<= /div>
Problem still pops up every now and then, like t= oday again.

Th= oughts on the "Safe Write" setting?


On Tuesday, March 15, 2016 4:01 PM, Stuart Tremain= <webdna@idfk.com.au> wrote:


= =46rom memory, there was a bug in =E2=80=9CAutomatically commit databases to= disk after modification=E2=80=9D, I wonder if this was associated with your= problem ?

You can always add [COMMITDATA= BASE db=3DFileName] after the modification just to make sure.

Kin= d regards

Stuart Tremain
IDFK Web Developments
A= USTRALIA
webdna@idfk.com.au





On 16 M= ar 2016, at 07:15, Rich Kwas <richkwasniewski@yahoo.com&g= t; wrote:

Is it safe to disable ""Safe Write for Dat= abase" in Preferences???

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D

Safe Write DB:=

Enabled by default. Sets the WebDNA en= gine to create a temporary file when writing the contents of a database to d= isk. The temporary file contents are then moved to the original database fil= e after the entire database is completely flushed to disk. This helps to eli= minate corruption of the original database file if there is an interruption d= uring the database write process.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D

If I disable this setting= will all changes be written to the db on the HD immediately,  without t= hat need for a temporary file?

I've been having this issue "= again" where a client says they make changes to ad listings stored in the da= tabase, but then all the changes are gone a few moments later. Like they nev= er were altered in the first place....

This site has been for over 10 years and the admin area ha= s not been changed recently or much over that time span...

There i= s no consistency to this issue.
It happens (like today= ) but may not happen for days or weeks.

I'm wondering if this "te= mporary file" and the original database on disk are somehow under some circu= mstances getting out of sync.

The db isn't that large, having 2,111= records,151 Fields and using 4,759K of ram.

I'm wondering if di= sabling "Safe Write" might be an option to try and prevent this in the futur= e.

Very frustrating for the client.I can't seem to duplicate it m= yself,but I believe them when they say it happens.I may have posted about &n= bsp;this issue in the past as well.


I'm on Windows Server2008 using vers.6.= 2
I have nearly 1gb of unused ram on the server, plent= y of hard drive space....


I've attached a screen capture of my Preferences i= n case anything else can be tinkered with.


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webd= na.us/list/talk@webdna.us Bug Reporting: support@webdna.us<webdna.jpg= >

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webd= na.us/list/talk@webdna.us Bug Reporting: support@webdna.us


=
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.webd= na.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to:=20 archives: http://mail.= webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.= webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --Apple-Mail-CD0227E9-BCE4-4E84-A787-C63AC7F4FEE2-- . Donovan Brooke

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Grep issue (2003) [text] prob (1998) Searching multiple Databases (1997) in conversions.db crashes unix webcat (1999) Number of Line Items (1998) Unexpected error (1997) OT: Weird table rendering w/ WebCat in Explorer (2005) A dynamic database. (1997) hyperlinking unique input strings on the fly when displaying in HTML (2000) Email Set-Up? (1997) [PROTECT... (2000) Error Msg (1997) TCP Connect (2000) Sun doesn't have an emailer app? (2000) Request Time Out (1997) WebCatalog and directory indexing (1998) [WebDNA] Ajax, JS and WebDNA - A joint toturial ;-) (2010) Browser Check for WebDNA compatability (1999) Db path (2004) SQL statements (2002)