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

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 112631
interpreted = N
texte = 214------=_Part_681636_198557936.1458080000662Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: quoted-printableI 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 adm=in area, same everything. Just every now and then this occurs.=20 On Tuesday, March 15, 2016 4:43 PM, Stuart Tremain = wrote:=20 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 t=he content, based on the fact that the site has been operational for many y=ears, I would open the .db file and check the content, also check your erro=r log.txtKind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 16 Mar 2016, at 08:09, Rich Kwas 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?=20 On Tuesday, March 15, 2016 4:01 PM, Stuart Tremain = wrote:=20 From 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 you=r problem ?You can always add=C2=A0[COMMITDATABASE db=3DFileName] after the modificati=on just to make sure.Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 16 Mar 2016, at 07:15, Rich Kwas 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=3DSafe 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 comp=letely 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=3DIf I disable this setting will all changes be written to the db on the HD i=mmediately, =C2=A0without that need for a temporary file?I've been having this issue "again" where a client says they make changes t=o ad listings stored in the database, but then all the changes are gone a f=ew 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 change=d recently or much over that time span...There is no consistency to this issue.It happens (like today) but may not h=appen for days or weeks.I'm wondering if this "temporary file" and the original database on disk ar=e somehow under some circumstances getting out of sync.The db isn't that large, having 2,111 records,151 Fields and using 4,759K o=f ram.I'm wondering if disabling "Safe Write" might be an option to try and preve=nt this in the future.Very frustrating for the client.I can't seem to duplicate it myself,but I b=elieve them when they say it happens.I may have posted about =C2=A0this iss=ue in the past as well.I'm on Windows Server2008 using vers.6.2I 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 se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us ---------------------------------------------------------This message is= sent to you because you are subscribed tothe mailing list .To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reportin=g: support@webdna.us---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us ------=_Part_681636_198557936.1458080000662Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable

I don't seem to have any .db-tmp files anywhere .

They would be in the same "globals " folder as the main database right?<=/span>

I did not have error logging turned on.

Just enabled that.

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

<=div id=3D"yui_3_16_0_1_1458079572343_2904">

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

Are you getting a lot of .db-tmp files bei=ng written for the db ?

If you are then ther=e 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 t=he .db file and check the content, also check your error log.txt

Kind regards

Stu=art Tremain

IDFK Web Developments

AUSTRALIA

webd=na@idfk.com.au

On 16 Mar 2016, at 08:09, R=ich Kwas <richkwasniewski@yahoo.com> wrote:
I already using [COMMITDATABASE db=3DFileNam=e] in all the admin pages where they edit these ads...

Problem still pops up every n=ow 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:

From 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 mod=ification just to make sure.

Kind regards

Stuart Tremain
<=div class=3D"yiv1518430602">IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au=

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

Is it safe to disable ""S=afe Write for Database" in Preferences???

=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D
Safe Write DB:
En=abled by default. Sets the WebDNA engine to create a temporary file when wr=iting the contents of a database to disk. The temporary file contents are t=hen moved to the original database file after the entire database is comple=tely flushed to disk. This helps to eliminate corruption of the original da=tabase file if there is an interruption during the database write process.<=/span>
=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 chang=es be written to the db on the HD immediately, without that need for =a temporary file?

I've been having this issue "aga=in" where a client says they make changes to ad listings stored in the data=base, but then all the changes are gone a few moments later. Like they neve=r were altered in the first place....

This site has been for over 10 years and the admin are=a 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 wond=ering if this "temporary file" and the original database on disk are someho=w 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 h=ave nearly 1gb of unused ram on the server, plenty of hard drive space....<=/div>

I've attached a screen capture of my Preferences in case anything e=lse can be tinkered with.

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

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

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

=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us------=_Part_681636_198557936.1458080000662--. Associated Messages, from the most recent to the oldest:

Re: [WebDNA] "Safe Write for Database" setting.... (Terry Wilson 2016)
Re: [WebDNA] "Safe Write for Database" setting.... ("Terry Wilson" 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Kenneth Grome 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Donovan Brooke 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Rich Kwas 2016)
Re: [WebDNA] "Safe Write for Database" setting.... (Stuart Tremain 2016)

214------=_Part_681636_198557936.1458080000662Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: quoted-printableI 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 adm=in area, same everything. Just every now and then this occurs.=20 On Tuesday, March 15, 2016 4:43 PM, Stuart Tremain = wrote:=20 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 t=he content, based on the fact that the site has been operational for many y=ears, I would open the .db file and check the content, also check your erro=r log.txtKind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 16 Mar 2016, at 08:09, Rich Kwas 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?=20 On Tuesday, March 15, 2016 4:01 PM, Stuart Tremain = wrote:=20 From 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 you=r problem ?You can always add=C2=A0[COMMITDATABASE db=3DFileName] after the modificati=on just to make sure.Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 16 Mar 2016, at 07:15, Rich Kwas 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=3DSafe 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 comp=letely 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=3DIf I disable this setting will all changes be written to the db on the HD i=mmediately, =C2=A0without that need for a temporary file?I've been having this issue "again" where a client says they make changes t=o ad listings stored in the database, but then all the changes are gone a f=ew 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 change=d recently or much over that time span...There is no consistency to this issue.It happens (like today) but may not h=appen for days or weeks.I'm wondering if this "temporary file" and the original database on disk ar=e somehow under some circumstances getting out of sync.The db isn't that large, having 2,111 records,151 Fields and using 4,759K o=f ram.I'm wondering if disabling "Safe Write" might be an option to try and preve=nt this in the future.Very frustrating for the client.I can't seem to duplicate it myself,but I b=elieve them when they say it happens.I may have posted about =C2=A0this iss=ue in the past as well.I'm on Windows Server2008 using vers.6.2I 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 se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us ---------------------------------------------------------This message is= sent to you because you are subscribed tothe mailing list .To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reportin=g: support@webdna.us---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us ------=_Part_681636_198557936.1458080000662Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable