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:

Emailer (1997) International Orders (1998) Multiple Passwords (1997) question: webmerchant connection (1997) emailer settings and control questions (1997) Fun with dates (1997) Bug fix time lines ... (2000) Payment Processors (2005) how do we turn off staticpages page creation? (2003) [WebDNA] Rack Mount Server(s) Available (2009) Help! WebCat2 bug (1997) Using [detete] (1998) searchable list archive (1997) Upgrading old WebCat Database Files (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) [/application] error? (1997) Grep Search and Replace (2002) Authenticate (1997) [WebDNA] Data Type Bool (2009) Header Problems (1998)