Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106905
interpreted = N
texte = This is a multi-part message in MIME format. --------------070603000900090405060709 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Tommy, I haven't read through every single thing and don't claim to know what's going on with your server, but a quick glance at the posted code and it appears to me to be a "traffic log" database that records all hits to a (every?) page. This kind of database can obviously get some serious action on a busy server and the database can also grow pretty quickly. Ultimately though, the database is redundant and unnecessary since the web server software (IIS I assume... Windows, right?) does this sort of logging usually by default. If I am correct (and I apologize if I'm not... like I said, I didn't read everything), if it was my problem to deal with I'd completely disable/disconnect this database, if only to troubleshoot, but ultimately to give the server some breathing room, especially if it's a busy one. Hope this helps. -Dan On 7/11/2011 1:03 AM, tommy@enkelthed.dk wrote: > [search db=[path]../../database/online.db&eqDB_IPdatarq=[IPAddress]] > [showIf [numFound]=0] > [append > db=[path]../../database/online.db]DB_IP=[IPAddress]&DB_DATO=[DATE]&DB_TID=[time]&DB_URL=[url][ThisURL]?a=b[FormVariables][hideIf > [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde]&DB_BROWSER=[url][browser][/url]&DB_URL_REF=[url][REFERRER][/url][/append] > [search db=[path]../../database/counter.db&eqDB_DATOdata=[date %Y/%m/%d]] > [showIf [numFound]<1] > [append db=[path]../../database/counter.db]DB_DATO=[date > %Y/%m/%d]&DB_ANTAL=1[/append] > [/showIf] > [showIf [numFound]>0] > > [replacefoundItems]DB_ANTAL=[math][DB_ANTAL]+1[/math][/replacefoundItems] > [/showIf] > [/search] > [/showIf] > [showIf [numFound]=1] > [replace > db=[path]../../database/online.db&eqDB_IPdatarq=[IPAddress]]DB_DATO=[DATE]&DB_TID=[time]&DB_URL=[url][ThisURL]?a=b[FormVariables][hideIf > [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde][/replace] > [/showIf] > [/search] --------------070603000900090405060709 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Tommy,
I haven't read through every single thing and don't claim to know what's going on with your server, but a quick glance at the posted code and it appears to me to be a "traffic log" database that records all hits to a (every?) page. This kind of database can obviously get some serious action on a busy server and the database can also grow pretty quickly. Ultimately though, the database is redundant and unnecessary since the web server software (IIS I assume... Windows, right?) does this sort of logging usually by default.
If I am correct (and I apologize if I'm not... like I said, I didn't read everything), if it was my problem to deal with I'd completely disable/disconnect this database, if only to troubleshoot, but ultimately to give the server some breathing room, especially if it's a busy one.
Hope this helps.
-Dan
On 7/11/2011 1:03 AM,
tommy@enkelthed.dk wrote:
[search db=[path]../../database/online.db&eqDB_IPdatarq=[IPAddress]] [showIf [numFound]=0] [append db=[path]../../database/online.db]DB_IP=[IPAddress]&DB_DATO=[DATE]&DB_TID=[time]&DB_URL=[url][ThisURL]?a=b[FormVariables][hideIf [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde]&DB_BROWSER=[url][browser][/url]&DB_URL_REF=[url][REFERRER][/url][/append] [search db=[path]../../database/counter.db&eqDB_DATOdata=[date %Y/%m/%d]] [showIf [numFound]<1] [append db=[path]../../database/counter.db]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/append] [/showIf] [showIf [numFound]>0] [replacefoundItems]DB_ANTAL=[math][DB_ANTAL]+1[/math][/replacefoundItems] [/showIf] [/search] [/showIf] [showIf [numFound]=1] [replace db=[path]../../database/online.db&eqDB_IPdatarq=[IPAddress]]DB_DATO=[DATE]&DB_TID=[time]&DB_URL=[url][ThisURL]?a=b[FormVariables][hideIf [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde][/replace] [/showIf] [/search]
--------------070603000900090405060709--
Associated Messages, from the most recent to the oldest:
This is a multi-part message in MIME format. --------------070603000900090405060709 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Tommy, I haven't read through every single thing and don't claim to know what's going on with your server, but a quick glance at the posted code and it appears to me to be a "traffic log" database that records all hits to a (every?) page. This kind of database can obviously get some serious action on a busy server and the database can also grow pretty quickly. Ultimately though, the database is redundant and unnecessary since the web server software (IIS I assume... Windows, right?) does this sort of logging usually by default. If I am correct (and I apologize if I'm not... like I said, I didn't read everything), if it was my problem to deal with I'd completely disable/disconnect this database, if only to troubleshoot, but ultimately to give the server some breathing room, especially if it's a busy one. Hope this helps. -Dan On 7/11/2011 1:03 AM, tommy@enkelthed.dk wrote: > [search db=[path]../../database/online.db&eqDB_IPdatarq=
[ipaddress]] > [showIf [numFound]=0] > [append > db=[path]../../database/online.db]DB_IP=
[ipaddress]&DB_DATO=
[date]&DB_TID=
[time]&DB_URL=
[url][thisurl]?a=b
[formvariables][hideIf > [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde]&DB_BROWSER=
[url][browser][/url]&DB_URL_REF=
[url][referrer][/url][/append] > [search db=[path]../../database/counter.db&eqDB_DATOdata=[date %Y/%m/%d]] > [showIf [numFound]<1] > [append db=[path]../../database/counter.db]DB_DATO=[date > %Y/%m/%d]&DB_ANTAL=1[/append] > [/showIf] > [showIf [numFound]>0] > >
[replacefounditems]DB_ANTAL=
[math][DB_ANTAL]+1[/math][/replacefoundItems] > [/showIf] > [/search] > [/showIf] > [showIf [numFound]=1] > [replace > db=[path]../../database/online.db&eqDB_IPdatarq=
[ipaddress]]DB_DATO=
[date]&DB_TID=
[time]&DB_URL=
[url][thisurl]?a=b
[formvariables][hideIf > [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde][/replace] > [/showIf] > [/search] --------------070603000900090405060709 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
Tommy,
I haven't read through every single thing and don't claim to know what's going on with your server, but a quick glance at the posted code and it appears to me to be a "traffic log" database that records all hits to a (every?) page. This kind of database can obviously get some serious action on a busy server and the database can also grow pretty quickly. Ultimately though, the database is redundant and unnecessary since the web server software (IIS I assume... Windows, right?) does this sort of logging usually by default.
If I am correct (and I apologize if I'm not... like I said, I didn't read everything), if it was my problem to deal with I'd completely disable/disconnect this database, if only to troubleshoot, but ultimately to give the server some breathing room, especially if it's a busy one.
Hope this helps.
-Dan
On 7/11/2011 1:03 AM,
tommy@enkelthed.dk wrote:
[search db=[path]../../database/online.db&eqDB_IPdatarq=[ipaddress]] [showIf [numFound]=0] [append db=[path]../../database/online.db]DB_IP=[ipaddress]&DB_DATO=[date]&DB_TID=[time]&DB_URL=[url][thisurl]?a=b[formvariables][hideIf [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde]&DB_BROWSER=[url][browser][/url]&DB_URL_REF=[url][referrer][/url][/append] [search db=[path]../../database/counter.db&eqDB_DATOdata=[date %Y/%m/%d]] [showIf [numFound]<1] [append db=[path]../../database/counter.db]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/append] [/showIf] [showIf [numFound]>0] [replacefounditems]DB_ANTAL=[math][DB_ANTAL]+1[/math][/replacefoundItems] [/showIf] [/search] [/showIf] [showIf [numFound]=1] [replace db=[path]../../database/online.db&eqDB_IPdatarq=[ipaddress]]DB_DATO=[date]&DB_TID=[time]&DB_URL=[url][thisurl]?a=b[formvariables][hideIf [name]=template]&[name]=[value][/hideIf][/FormVariables][/url]&DB_KUNDEID=[kunde][/replace] [/showIf] [/search]
--------------070603000900090405060709--
Dan Strong
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:
Banners and sort of random display (1997)
[OT] Mac OSX hardware test software (2004)
[OT] WebDNA Family Album (2004)
much help needed NEWBIE alert (2000)
For those of you not on the WebCatalog Beta... (1997)
[ShowIf] a either fields are blank (1998)
Speed Test Results Dell 2650 Xeon 2.4ghz (2002)
Can [writefile] files be served thru webcat? (2000)
Interesting speed comparison .. (2003)
Payment Processors (2005)
Bug with periods in [math] variable names (2001)
[WebDNA] listfiles problem (2011)
Frames and WebCat (1997)
Can he do that? (1998)
Validation (2000)
Exclamation point (1997)
OT: ASP Developer (1999)
Simple way to create unique SKU (1997)
emailer truncates last letter! (1997)
Odd error in logs (1998)