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

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112633
interpreted = N
texte = 216 --Apple-Mail=_608C0FEE-9EA9-41E4-B01C-76462A05DCF6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Reboot !! Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 16 Mar 2016, at 09:13, 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 admin area, same everything. Just every now and then this occurs. >=20 >=20 >=20 >=20 > On Tuesday, March 15, 2016 4:43 PM, Stuart Tremain = wrote: >=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 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 error log.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 = where 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 = > wrote: >>=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 your problem ? >>=20 >> You can always add [COMMITDATABASE db=3DFileName] after the = modification just 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 when writing = the contents of a database to disk. The temporary file contents are then = moved to the original database file after the entire database is = completely flushed to disk. This helps to eliminate corruption of the = original database 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 HD immediately, without that need for a temporary file? >>>=20 >>> I've been having this issue "again" where a client says they make = changes 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 = changed 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,759K of ram. >>>=20 >>> I'm wondering if disabling "Safe Write" might be an option to try = and prevent 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 in 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 = space.... >>>=20 >>>=20 >>> I've attached a screen capture of my Preferences in case anything = else can be tinkered with. >>>=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 Reporting: = 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 Reporting: = 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 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 >=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 Reporting: = support@webdna.us --Apple-Mail=_608C0FEE-9EA9-41E4-B01C-76462A05DCF6 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Reboot !!


Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA





On 16 Mar 2016, at 09:13, 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 right?

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

Nothings changed in = this site really for years and years. Same db, same admin area, same = everything. Just every now and then this occurs.




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

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 of 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 error log.txt

Kind regards
Stuart Tremain
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...

Problem still pops = up every now and then, like today again.

Thoughts 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 [COMMITDATABASE db=3DFileName] after the modification = just to make sure.

Kind = regards

Stuart = Tremain
IDFK Web = Developments
AUSTRALIA





On 16 Mar = 2016, at 07:15, Rich Kwas <richkwasniewski@yahoo.com>= ; wrote:

Is it = safe to disable ""Safe Write for Database" 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 engine to create a temporary file when writing the contents of a = database to disk. The temporary file contents are then moved to the = original database file after the entire database is completely flushed = to disk. This helps to eliminate corruption of the original database = 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

If I disable this setting will = all changes be written to the db on the HD immediately,  without = that 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 database, but then all the changes are gone a = few moments later. Like they never were altered in the first = place....

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

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

I'm wondering if = this "temporary file" and the original database on disk are somehow = under some circumstances 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 = disabling "Safe Write" might be an option to try and prevent this in the = future.

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 in the past = as well.


I'm on Windows = Server2008 using vers.6.2
I have nearly 1gb of = unused ram on the server, plenty of hard drive space....


I've attached a = screen capture of my Preferences in 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.webdna.us/l= ist/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.webdna.us/l= ist/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/l= ist/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=_608C0FEE-9EA9-41E4-B01C-76462A05DCF6-- . 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)
216 --Apple-Mail=_608C0FEE-9EA9-41E4-B01C-76462A05DCF6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Reboot !! Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 16 Mar 2016, at 09:13, 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 admin area, same everything. Just every now and then this occurs. >=20 >=20 >=20 >=20 > On Tuesday, March 15, 2016 4:43 PM, Stuart Tremain = wrote: >=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 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 error log.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 = where 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 = > wrote: >>=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 your problem ? >>=20 >> You can always add [COMMITDATABASE db=3DFileName] after the = modification just 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 when writing = the contents of a database to disk. The temporary file contents are then = moved to the original database file after the entire database is = completely flushed to disk. This helps to eliminate corruption of the = original database 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 HD immediately, without that need for a temporary file? >>>=20 >>> I've been having this issue "again" where a client says they make = changes 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 = changed 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,759K of ram. >>>=20 >>> I'm wondering if disabling "Safe Write" might be an option to try = and prevent 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 in 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 = space.... >>>=20 >>>=20 >>> I've attached a screen capture of my Preferences in case anything = else can be tinkered with. >>>=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 Reporting: = 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 Reporting: = 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 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 >=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 Reporting: = support@webdna.us --Apple-Mail=_608C0FEE-9EA9-41E4-B01C-76462A05DCF6 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Reboot !!


Kind regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA





On 16 Mar 2016, at 09:13, 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 right?

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

Nothings changed in = this site really for years and years. Same db, same admin area, same = everything. Just every now and then this occurs.




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

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 of 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 error log.txt

Kind regards
Stuart Tremain
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...

Problem still pops = up every now and then, like today again.

Thoughts 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 [COMMITDATABASE db=3DFileName] after the modification = just to make sure.

Kind = regards

Stuart = Tremain
IDFK Web = Developments
AUSTRALIA





On 16 Mar = 2016, at 07:15, Rich Kwas <richkwasniewski@yahoo.com>= ; wrote:

Is it = safe to disable ""Safe Write for Database" 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 engine to create a temporary file when writing the contents of a = database to disk. The temporary file contents are then moved to the = original database file after the entire database is completely flushed = to disk. This helps to eliminate corruption of the original database = 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

If I disable this setting will = all changes be written to the db on the HD immediately,  without = that 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 database, but then all the changes are gone a = few moments later. Like they never were altered in the first = place....

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

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

I'm wondering if = this "temporary file" and the original database on disk are somehow = under some circumstances 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 = disabling "Safe Write" might be an option to try and prevent this in the = future.

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 in the past = as well.


I'm on Windows = Server2008 using vers.6.2
I have nearly 1gb of = unused ram on the server, plenty of hard drive space....


I've attached a = screen capture of my Preferences in 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.webdna.us/l= ist/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.webdna.us/l= ist/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/l= ist/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=_608C0FEE-9EA9-41E4-B01C-76462A05DCF6-- . Stuart Tremain

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:

WebCatalog [FoundItems] Problem - AGAIN - (1997) Upgrading old WebCat Database Files (1997) Add a field to the error log? (1997) Order not created error (1997) Cart Creation (2003) Listfiles (2004) select multiple (1997) Frames and WebCat (1997) POP3 communication [OT?] (2003) Web Logs (1998) WebSTAR 2.1 freezes my Mac (1997) Search design (1997) [include] affect on filepaths for links? (1997) Autoreturn Submit? (1997) Reserved words - Enhancement request (2000) Help formatting search results w/ table (1997) New public beta available (1997) Encypt Question - Making New Users.db (1999) [WebDNA] Working WebDNA 7 configuration (2011) More on the email templates (1997)