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:

WebCat cannot handle compatible search parameters? (1997) WebCatb15 Mac CGI -- [purchase] (1997) Forms Search Questions (1997) Removing [showif] makes a big difference in speed (1997) SetLineItem LineItem where out thou? (2000) Looking up two prices in Formulas.db (1997) Newbie Tax Question (1997) international time (1997) How true is this? (1999) test (2008) Emailer port change (1997) Include (1998) Multiple prices (1997) Viewing Changes (1998) Max Record length restated as maybe bug (1997) sort problems....bug or brain fart? (1997) UPDATE PROBLEM (1997) [cart] not being interpreted inside [founditems] (1997) Summing fields (1997) Sandbox Question (2003)