Re: [WebDNA] DBServer.exe Max CPU

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111628
interpreted = N
texte = --Apple-Mail=_75251C2B-55C3-4B68-862D-7FE4A09F8A94 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 In each sandbox preferences panel turn on =E2=80=9CLog Error = Messages=E2=80=9D, this will then create an ErrorLog.txt file in each = directory of each website when an error happens. Then when the server = maxes out you will need to go through the 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 = give you a central location for the errors to save you running all over = the place. I have mine writing to a MySQL data 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&uid=3Dxxxx&pwd=3Dxxxx&co= nn_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]', '[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] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@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 they 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 Windows 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 = 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 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 = avail. Does anyone know what causes this?=20 >>=20 >> Thanks, Eddie >> --------------------------------------------------------- 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 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=_75251C2B-55C3-4B68-862D-7FE4A09F8A94 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 In each sandbox preferences panel turn on =E2=80=9CLog Error = Messages=E2=80=9D, this will then create an ErrorLog.txt file in each = directory of each website when an error happens. Then when the server = maxes out you will need to go through the 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 give you a central location for the = errors to save you running all over the place.

I have mine writing to a MySQL data = 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&uid=3Dxxxx&pwd=3Dxx= xx&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]', '[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]




Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA




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

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 they 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 = 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 Talk List = <talk@webdna.us>Subject: = Re: [WebDNA] DBServer.exe Max CPU

Anything in your = error logs ?


Regards

Stuart Tremain
IDFK = Web Developments
AUSTRALIA




On 22 = Oct 2014, at 7:15 am, 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 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 = avail. Does anyone know what causes this? 

Thanks, Eddie
--------------------------------------------------------- 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 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=_75251C2B-55C3-4B68-862D-7FE4A09F8A94-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] DBServer.exe Max CPU (Eddie Z 2014)
  2. Re: [WebDNA] DBServer.exe Max CPU (Stuart Tremain 2014)
  3. Re: [WebDNA] DBServer.exe Max CPU (Eddie Z 2014)
  4. Re: [WebDNA] DBServer.exe Max CPU (Stuart Tremain 2014)
  5. Re: [WebDNA] DBServer.exe Max CPU (William DeVaul 2014)
  6. [WebDNA] DBServer.exe Max CPU (Eddie Z 2014)
--Apple-Mail=_75251C2B-55C3-4B68-862D-7FE4A09F8A94 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 In each sandbox preferences panel turn on =E2=80=9CLog Error = Messages=E2=80=9D, this will then create an ErrorLog.txt file in each = directory of each website when an error happens. Then when the server = maxes out you will need to go through the 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 = give you a central location for the errors to save you running all over = the place. I have mine writing to a MySQL data 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&uid=3Dxxxx&pwd=3Dxxxx&co= nn_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]', '[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] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@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 they 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 Windows 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 = 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 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 = avail. Does anyone know what causes this?=20 >>=20 >> Thanks, Eddie >> --------------------------------------------------------- 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 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=_75251C2B-55C3-4B68-862D-7FE4A09F8A94 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 In each sandbox preferences panel turn on =E2=80=9CLog Error = Messages=E2=80=9D, this will then create an ErrorLog.txt file in each = directory of each website when an error happens. Then when the server = maxes out you will need to go through the 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 give you a central location for the = errors to save you running all over the place.

I have mine writing to a MySQL data = 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&uid=3Dxxxx&pwd=3Dxx= xx&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]', '[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]




Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA




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

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 they 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 = 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 Talk List = <talk@webdna.us>Subject: = Re: [WebDNA] DBServer.exe Max CPU

Anything in your = error logs ?


Regards

Stuart Tremain
IDFK = Web Developments
AUSTRALIA




On 22 = Oct 2014, at 7:15 am, 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 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 = avail. Does anyone know what causes this? 

Thanks, Eddie
--------------------------------------------------------- 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 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=_75251C2B-55C3-4B68-862D-7FE4A09F8A94-- 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:

turning every 5th line red (1999) [WebDNA] Can I do something with webdna to pass-protect an (2009) WebCat & WebTen (1997) Help: how do I process results of a multiple select list (wastest) (2002) [INCLUDE] Limitations (1998) WebCatalog Hosting (1996) Scoping rules in WebDNA 4.0 (2000) TCPSend/Replace DB Records (2002) WebCat for Unix?? (1997) Hierarchy of form/text/math variables (renamed thread) (2000) WebCat2 Append problem (B14Macacgi) (1997) Running _every_ page through WebCat-error.html (1997) Searching Records by Company (2000) [ShowNext] (1997) need help with [sendmail] and [showif]s (1998) Webcat 3 Bug?!?! Netscape + Protect + Posted Form (1998) Trigger Error (2001) [what] [am] [I] [missing]? (2003) moved shoppingCarts folder... now there's nothing in it. (2001) We have Proof (1997)