Re: [WebDNA] DBServer.exe Max CPU

This WebDNA talk-list message is from

2014

It keeps the original formatting. numero = 111629
interpreted = N
texte = > This message is in MIME format. Since your mail reader does not understandthis format, some or all of this message may not be legible.--B_3496871845_54550488Content-type: text/plain;charset="ISO-8859-1"Content-transfer-encoding: quoted-printableThanks for the help.I don't use sandboxes, so they are all in the main directory and use one bi=gerror log. I turned it on and have watched it for the past day. It did aler=tme to an error on one of my forms that I was't aware of, but that didn'tsolve my issue. I am also getting a lot of errors that say "securitypreferences do not allow remote access to files with that extension" and al=lof the links have /talkback/ listed after them. Those don't coincide with m=yserver CPU time though. Still trying to problem solve.I hope I don't need to reinstall as I still host with Smith Micro and thepeople left there have no idea how to handle WebDNA.EddieFrom: Stuart Tremain Reply-To: Date: Tuesday, October 21, 2014 5:17 PMTo: WebDNA Talk List Subject: Re: [WebDNA] DBServer.exe Max CPUIn each sandbox preferences panel turn on =B3Log Error Messages=B2, this willthen create an ErrorLog.txt file in each directory of each website when anerror happens. Then when the server maxes out you will need to go throughthe directories looking for the ErrorLog.txt files to find what is going on=.You can edit the ErrorTemplate in the root of the sandbox directory to giveyou a central location for the errors to save you running all over theplace.I have mine writing to a MySQL data base, this captures all errors from allservers that I run into one place - very handy :)[SQLConnect dbType=3DMySQL&host=3Ddb.xxxx.com &database=3Dxxxx&uid=3Dxxxx&pwd=3Dxxxx&conn_var=3DTOP3DATA][/SQLConnect][SQLExecute conn_ref=3DTOP3DATA&result_var=3DRES-ERRORLOG]INSERT into errorlog =(E_DATE, E_TIME, E_COMMAND, E_CART, E_IPADDRESS, E_IPADDRESS2,E_ERRORMESSAGE, E_URL, E_SOURCEFILE, E_SERVER ) values ( '[DATE %Y-%m-%d]','[TIME]', '[GREP search=3D[\'\;]&replace=3D ][command][/GREP]', '[GREPsearch=3D[\'\;]&replace=3D ][cart][/GREP]', '[THISIPADDRESS]', '[IPADDRESS]','[GREP search=3D[\'\;]&replace=3D ][errormessage][/GREP]', '[GREPsearch=3D[\'\;]&replace=3D ][thisurl][/GREP]', '[GREP search=3D[\'\;]&replace=3D][sourcefile][/GREP]', '1' ) ; [/SQLExecute]RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.au> On 22 Oct 2014, at 8:43 am, Eddie Z wrote:>=20> The error log in the WebCatalogEngine folder doesn't show anything in it =since> 2013. I also cleared out my EmailCompleted and EmailLog folders since the=y> were pretty large. My web stats haven't shown any spikes. I'm running out= of> places to look. Are there other error logs I should be looking at? I'm Wi=ndows> dumb.>=20> Thanks, Eddie>=20> From: Stuart Tremain > Reply-To: > Date: Tuesday, October 21, 2014 4:16 PM> To: WebDNA Talk List > Subject: Re: [WebDNA] DBServer.exe Max CPU>=20> Anything in your error logs ?>=20>=20> Regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au>=20>=20>=20>=20>> On 22 Oct 2014, at 7:15 am, Eddie Z wrote:>>=20>> I've been coasting along on the same Windows Server 2003 and WebDNA 6 fo=r>> many, many years now without any issues. Over the past two weeks the>> DBServer.exe process keeps maxing out my CPU and I have no idea what's>> causing it. I've only seen it happen on my server a couple of times over= the>> years, but right now it is happening daily. I took some guesses at>> troubleshooting and archived some older, larger databases, but to no ava=il.>> Does anyone know what causes this?>>=20>> Thanks, Eddie>> --------------------------------------------------------- This message i=s>> sent to you because you are subscribed to the mailing list . To unsubscr=ibe,>> E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Repor=ting:>> 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--------------------------------------------------------- This message issent to you because you are subscribed to the mailing list . To unsubscribe=,E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us BugReporting: support@webdna.us--B_3496871845_54550488Content-type: text/html;charset="ISO-8859-1"Content-transfer-encoding: quoted-printable

Thanks for the help.

I don't use sandboxes, so they are all in the main directo=ry and use one big error log. I turned it on and have watched it for the pas=t day. It did alert me to an error on one of my forms that I was't aware of,= but that didn't solve my issue. I am also getting a lot of errors that say ="security preferences do not allow remote access to files with that extensio=n" and all of the links have /talkback/ listed after them. Those don't coinc=ide with my server CPU time though. Still trying to problem solve.

I hope I don't need to reinstall as I still host with Smith =Micro and the people left there have no idea how to handle WebDNA.

Eddie

From: = Stuart Tremain <webdna@idfk.c=om.au>
Reply-To: <talk@webdna.us>
Date: Tuesday, October 21, 2014 5:17 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: =Re: [WebDNA] DBServer.exe Max CPU

In each sandbox preferences panel turn on “Log Error Messag=es”, this will then create an ErrorLog.txt file in each directory of e=ach website when an error happens. Then when the server maxes out you will n=eed to go through the directories looking for the ErrorLog.txt files to find= what is going on.

You can edi=t the ErrorTemplate in the root of the sandbox directory to give you a centr=al location for the errors to save you running all over the place.

I have mine writing to a MySQL da=ta base, this captures all errors from all servers that I run into one place= - very handy :)

[SQLConnect dbType=3DMySQL&host=3Ddb.xxxx.com&database=3Dxxxx&ui=d=3Dxxxx&pwd=3Dxxxx&conn_var=3DTOP3DATA][/SQLConnect]

[=SQLExecute conn_ref=3DTOP3DATA&result_var=3DRES-ERRORLOG]INSERT into errorlo=g ( E_DATE, E_TIME, E_COMMAND, E_CART, E_IPADDRESS, E_IPADDRESS2, E_ER=RORMESSAGE, E_URL, E_SOURCEFILE, E_SERVER ) values ( '[DATE %Y-%m-%d]', '[TI=ME]', '[GREP search=3D[\'\;]&replace=3D ][command][/GREP]', '[GREP search=3D[\='\;]&replace=3D ][cart][/GREP]', '[THISIPADDRESS]', '[IPADDRESS]', '[GREP =search=3D[\'\;]&replace=3D ][errormessage][/GREP]', '[GREP search=3D[\'\;]&=;replace=3D ][thisurl][/GREP]', '[GREP search=3D[\'\;]&replace=3D ][sourcefile=][/GREP]', '1' ) ; [/SQLExecute]

<=br class=3D"">

Regards

Stuart Tremain

IDFK Web Developments

AUSTRALIA

webdna@idfk.com.au

On 22 Oct 2014, at 8:43 am, =Eddie Z <eddie@thinksite.co=m> wrote:

The error log in the WebCatalogEngine folder doesn't sh=ow anything in it since 2013. I also cleared out my EmailCompleted and Email=Log folders since they were pretty large. My web stats haven't shown any spi=kes. I'm running out of places to look. Are there other error logs I should =be looking at? I'm Windows dumb.

Thanks, Eddie

From: Stuart Tremain <webdna@idfk.com.au>
Reply-To: <talk@webdna.us>
Date: Tuesday, October 21, 2014 4:16= PM
To: WebDNA T=alk List <talk@webdna.us>=
Subject: Re: [W=ebDNA] DBServer.exe Max CPU

Anything in your error =logs ?

Regards

Stuart Tremain
IDFK Web Developments
=AUSTRALIA
we=bdna@idfk.com.au

On 22 Oct 2014, at 7:15 a=m, Eddie Z <eddie@thinksite=.com> wrote:

I've been coasting along on the same Windows Server =2003 and WebDNA 6 for many, many years now without any issues. Over the past= two weeks the DBServer.exe process keeps maxing out my CPU and I have no id=ea what's causing it. I've only seen it happen on my server a couple of= times over the years, but right now it is happening daily. I took some= guesses at troubleshooting and archived some older, larger databases, but t=o no avail. Does anyone know what causes this?

Thanks, Eddie
---------------------------------------------------------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.u=s

---------------------------------------------------------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.u=s
---------------------------------------------------------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.u=s

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

Re: [WebDNA] DBServer.exe Max CPU (Eddie Z 2014)
Re: [WebDNA] DBServer.exe Max CPU (Stuart Tremain 2014)
Re: [WebDNA] DBServer.exe Max CPU (Eddie Z 2014)
Re: [WebDNA] DBServer.exe Max CPU (Stuart Tremain 2014)
Re: [WebDNA] DBServer.exe Max CPU (William DeVaul 2014)
[WebDNA] DBServer.exe Max CPU (Eddie Z 2014)

> This message is in MIME format. Since your mail reader does not understandthis format, some or all of this message may not be legible.--B_3496871845_54550488Content-type: text/plain;charset="ISO-8859-1"Content-transfer-encoding: quoted-printableThanks for the help.I don't use sandboxes, so they are all in the main directory and use one bi=gerror log. I turned it on and have watched it for the past day. It did aler=tme to an error on one of my forms that I was't aware of, but that didn'tsolve my issue. I am also getting a lot of errors that say "securitypreferences do not allow remote access to files with that extension" and al=lof the links have /talkback/ listed after them. Those don't coincide with m=yserver CPU time though. Still trying to problem solve.I hope I don't need to reinstall as I still host with Smith Micro and thepeople left there have no idea how to handle WebDNA.EddieFrom: Stuart Tremain Reply-To: Date: Tuesday, October 21, 2014 5:17 PMTo: WebDNA Talk List Subject: Re: [WebDNA] DBServer.exe Max CPUIn each sandbox preferences panel turn on =B3Log Error Messages=B2, this willthen create an ErrorLog.txt file in each directory of each website when anerror happens. Then when the server maxes out you will need to go throughthe directories looking for the ErrorLog.txt files to find what is going on=.You can edit the ErrorTemplate in the root of the sandbox directory to giveyou a central location for the errors to save you running all over theplace.I have mine writing to a MySQL data base, this captures all errors from allservers that I run into one place - very handy :)[SQLConnect dbType=3DMySQL&host=3Ddb.xxxx.com &database=3Dxxxx&uid=3Dxxxx&pwd=3Dxxxx&conn_var=3DTOP3DATA][/SQLConnect][SQLExecute conn_ref=3DTOP3DATA&result_var=3DRES-ERRORLOG]INSERT into errorlog =(E_DATE, E_TIME, E_COMMAND, E_CART, E_IPADDRESS, E_IPADDRESS2,E_ERRORMESSAGE, E_URL, E_SOURCEFILE, E_SERVER ) values ( '[DATE %Y-%m-%d]','[time]', '[GREP search=3D[\'\;]&replace=3D ][command][/GREP]', '[GREPsearch=3D[\'\;]&replace=3D ][cart][/GREP]', '[THISIPADDRESS]', '[ipaddress]','[GREP search=3D[\'\;]&replace=3D ][errormessage][/GREP]', '[GREPsearch=3D[\'\;]&replace=3D ][thisurl][/GREP]', '[GREP search=3D[\'\;]&replace=3D][sourcefile][/GREP]', '1' ) ; [/SQLExecute]RegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.au> On 22 Oct 2014, at 8:43 am, Eddie Z wrote:>=20> The error log in the WebCatalogEngine folder doesn't show anything in it =since> 2013. I also cleared out my EmailCompleted and EmailLog folders since the=y> were pretty large. My web stats haven't shown any spikes. I'm running out= of> places to look. Are there other error logs I should be looking at? I'm Wi=ndows> dumb.>=20> Thanks, Eddie>=20> From: Stuart Tremain > Reply-To: > Date: Tuesday, October 21, 2014 4:16 PM> To: WebDNA Talk List > Subject: Re: [WebDNA] DBServer.exe Max CPU>=20> Anything in your error logs ?>=20>=20> Regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au>=20>=20>=20>=20>> On 22 Oct 2014, at 7:15 am, Eddie Z wrote:>>=20>> I've been coasting along on the same Windows Server 2003 and WebDNA 6 fo=r>> many, many years now without any issues. Over the past two weeks the>> DBServer.exe process keeps maxing out my CPU and I have no idea what's>> causing it. I've only seen it happen on my server a couple of times over= the>> years, but right now it is happening daily. I took some guesses at>> troubleshooting and archived some older, larger databases, but to no ava=il.>> Does anyone know what causes this?>>=20>> Thanks, Eddie>> --------------------------------------------------------- This message i=s>> sent to you because you are subscribed to the mailing list . To unsubscr=ibe,>> E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Repor=ting:>> 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--------------------------------------------------------- This message issent to you because you are subscribed to the mailing list . To unsubscribe=,E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us BugReporting: support@webdna.us--B_3496871845_54550488Content-type: text/html;charset="ISO-8859-1"Content-transfer-encoding: quoted-printable

Thanks for the help.

I hope I don't need to reinstall as I still host with Smith =Micro and the people left there have no idea how to handle WebDNA.

Eddie

From: = Stuart Tremain <webdna@idfk.c=om.au>
Reply-To: <talk@webdna.us>
Date: Tuesday, October 21, 2014 5:17 PM
To: WebDNA Talk List <talk@webdna.us>
Subject: =Re: [WebDNA] DBServer.exe Max CPU

You can edi=t the ErrorTemplate in the root of the sandbox directory to give you a centr=al location for the errors to save you running all over the place.

I have mine writing to a MySQL da=ta base, this captures all errors from all servers that I run into one place= - very handy :)

[SQLConnect dbType=3DMySQL&host=3Ddb.xxxx.com&database=3Dxxxx&ui=d=3Dxxxx&pwd=3Dxxxx&conn_var=3DTOP3DATA][/SQLConnect]

[=SQLExecute conn_ref=3DTOP3DATA&result_var=3DRES-ERRORLOG]INSERT into errorlo=g ( E_DATE, E_TIME, E_COMMAND, E_CART, E_IPADDRESS, E_IPADDRESS2, E_ER=RORMESSAGE, E_URL, E_SOURCEFILE, E_SERVER ) values ( '[DATE %Y-%m-%d]', '[TI=ME]', '[GREP search=3D[\'\;]&replace=3D ][command][/GREP]', '[GREP search=3D[\='\;]&replace=3D ][cart][/GREP]', '[THISIPADDRESS]', '[ipaddress]', '[GREP =search=3D[\'\;]&replace=3D ][errormessage][/GREP]', '[GREP search=3D[\'\;]&=;replace=3D ][thisurl][/GREP]', '[GREP search=3D[\'\;]&replace=3D ][sourcefile=][/GREP]', '1' ) ; [/SQLExecute]

<=br class=3D"">

Regards

Stuart Tremain

IDFK Web Developments

AUSTRALIA

webdna@idfk.com.au

On 22 Oct 2014, at 8:43 am, =Eddie Z <eddie@thinksite.co=m> wrote:

The error log in the WebCatalogEngine folder doesn't sh=ow anything in it since 2013. I also cleared out my EmailCompleted and Email=Log folders since they were pretty large. My web stats haven't shown any spi=kes. I'm running out of places to look. Are there other error logs I should =be looking at? I'm Windows dumb.

Thanks, Eddie

From: Stuart Tremain <webdna@idfk.com.au>
Reply-To: <talk@webdna.us>
Date: Tuesday, October 21, 2014 4:16= PM
To: WebDNA T=alk List <talk@webdna.us>=
Subject: Re: [W=ebDNA] DBServer.exe Max CPU

Anything in your error =logs ?

Regards

Stuart Tremain
IDFK Web Developments
=AUSTRALIA
we=bdna@idfk.com.au

On 22 Oct 2014, at 7:15 a=m, Eddie Z <eddie@thinksite=.com> wrote:

I've been coasting along on the same Windows Server =2003 and WebDNA 6 for many, many years now without any issues. Over the past= two weeks the DBServer.exe process keeps maxing out my CPU and I have no id=ea what's causing it. I've only seen it happen on my server a couple of= times over the years, but right now it is happening daily. I took some= guesses at troubleshooting and archived some older, larger databases, but t=o no avail. Does anyone know what causes this?

Thanks, Eddie
---------------------------------------------------------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.u=s

---------------------------------------------------------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.u=s
---------------------------------------------------------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.u=s

DOWNLOAD WEBDNA NOW!

Re: [WebDNA] DBServer.exe Max CPU

2014

Top Articles:

Related Readings: