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
webdna@idfk.com.au




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
webdna@idfk.com.au




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:

Webcatalog Future?!? (2000) frames & carts (1997) Preventing Safari caching (2003) unable to launch acgi in WebCat (1997) Dubble Sku's in a Database (1999) [WebDNA] PayPal Express Checkout (2009) [WebDNA] How WebDNA email sending works... (2012) [protect] on NT? (1997) Here we go again... (2006) Showif for mulitple variations (1997) WebCatalog 3.0.8 Mac OS (2000) WebCatalog2 Feature Feedback (1996) One other big addition... (1997) Preventing Merchant Settling ? (1997) Monthly Reports (2000) BBEdit and WebCatalog 2.0? (1997) Database Security (1998) Logging purchases (1997) Protect (1997) Cart passing in URL.. (2004)