[WebDNA] Failed to aquire lock on database - Possible deadlock averted

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107765
interpreted = N
texte = This is a multi-part message in MIME format. --------------010303010200080408090607 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Hello talk. So we are at it again, after a period of still reoccuring problems, I've=20 come to this yet again. I've read all the previous replys to this question (also posted by me)=20 and Im pretty sure I've done as was suggested, however there is no change= . So, I keep getting: An unknown error occurred: DBError ../../database/online.db Failed to aquire lock on database - Possible deadlock averted The complete code [showif [showstat]!false] [hideif [ipaddress]~192.168.] [!] ---------------- T=C6LLER TIL STATESTIK ----------------- [/!] [search db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[IPAddress]] [showIf [numFound]=3D0] [Replace=20 db=3D[path]../../database/counter.db&eqDB_DATOdatarq=3DdontFind2ForceAppe= ndHaveAniceDay]DB_DATO=3D[date=20 %Y/%m/%d]&DB_ANTAL=3D1[/Replace] [search db=3D[path]../../database/counter.db&eqDB_DATOdata=3D[date=20 %Y/%m/%d]] [showIf [numFound]<1] [append db=3D[path]../../database/test.db]DB_DATO=3D[date=20 %Y/%m/%d]&DB_ANTAL=3D1[/append] [!][append db=3D[path]../../database/counter.db]DB_DATO=3D[d= ate=20 %Y/%m/%d]&DB_ANTAL=3D1[/append][/!] [Replace=20 db=3D[path]../../database/counter.db&eqDB_DATOdatarq=3DdontFind2ForceAppe= ndHaveAniceDay]DB_DATO=3D[date=20 %Y/%m/%d]&DB_ANTAL=3D1[/Replace] [/showIf] [showIf [numFound]>0] =20 [replacefoundItems]DB_ANTAL=3D[math][DB_ANTAL]+1[/math][/replacefoundItem= s] [/showIf] [/search] [/showIf] [showIf [numFound]=3D1] [replace=20 db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[IPAddress]]DB_DATO=3D= [DATE]&DB_TID=3D[time]&DB_URL=3D[url][ThisURL]?a=3Db[FormVariables][hideI= f=20 [name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][/url]&DB_KUN= DEID=3D[kunde][/replace] [/showIf] [/search] [/hideif] [/showif] It performs replaces now, instead of appends as before - but it would=20 appear as this has not helped anything. Any suggestions? Ill add, this is the final time I am touching this "feature", it the=20 combined experience of the talk list, cant come up with something that=20 works inspite of the way this particular feature is implemented, ill=20 remove it and deal with the fall out. I suspect the user would rather=20 have a working page, than a page where he can see how many are logged in=20 within the last 60 mins, but where the user is experience errors.. /Tommy --------------010303010200080408090607 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
Hello talk.

So we are at it again, after a period of still reoccuring problems, I've come to this yet again.

I've read all the previous replys to this question (also posted by me) and Im pretty sure I've done as was suggested, however there is no change.

So, I keep getting:

An unknown error occurred:
DBError
../../database/online.db
Failed to aquire lock on database - Possible deadlock averted


The complete code

[showif [showstat]!false]
[hideif [ipaddress]~192.168.]
[!] ---------------- TÆLLER TIL STATESTIK ----------------- [/!]
[search db=[path]../../database/online.db&eqDB_IPdatarq=[IPAddress]]
[showIf [numFound]=0]
    [Replace db=[path]../../database/counter.db&eqDB_DATOdatarq=dontFind2ForceAppendHaveAniceDay]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/Replace]
    [search db=[path]../../database/counter.db&eqDB_DATOdata=[date %Y/%m/%d]]
        [showIf [numFound]<1]
            [append db=[path]../../database/test.db]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/append]
            [!][append db=[path]../../database/counter.db]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/append][/!]
            [Replace db=[path]../../database/counter.db&eqDB_DATOdatarq=dontFind2ForceAppendHaveAniceDay]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/Replace]
        [/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]
[/hideif]
[/showif]

It performs replaces now, instead of appends as before - but it would appear as this has not helped anything.

Any suggestions?

Ill add, this is the final time I am touching this "feature", it the combined experience of the talk list, cant come up with something that works inspite of the way this particular feature is implemented, ill remove it and deal with the fall out. I suspect the user would rather have a working page, than a page where he can see how many are logged in within the last 60 mins, but where the user is experience errors..

/Tommy
 --------------010303010200080408090607-- Associated Messages, from the most recent to the oldest:

    
  1. [WebDNA] Failed to aquire lock on database - Possible deadlock averted (Tommy Bell 2011)
This is a multi-part message in MIME format. --------------010303010200080408090607 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Hello talk. So we are at it again, after a period of still reoccuring problems, I've=20 come to this yet again. I've read all the previous replys to this question (also posted by me)=20 and Im pretty sure I've done as was suggested, however there is no change= . So, I keep getting: An unknown error occurred: DBError ../../database/online.db Failed to aquire lock on database - Possible deadlock averted The complete code [showif [showstat]!false] [hideif [ipaddress]~192.168.] [!] ---------------- T=C6LLER TIL STATESTIK ----------------- [/!] [search db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[ipaddress]] [showIf [numFound]=3D0] [Replace=20 db=3D[path]../../database/counter.db&eqDB_DATOdatarq=3DdontFind2ForceAppe= ndHaveAniceDay]DB_DATO=3D[date=20 %Y/%m/%d]&DB_ANTAL=3D1[/Replace] [search db=3D[path]../../database/counter.db&eqDB_DATOdata=3D[date=20 %Y/%m/%d]] [showIf [numFound]<1] [append db=3D[path]../../database/test.db]DB_DATO=3D[date=20 %Y/%m/%d]&DB_ANTAL=3D1[/append] [!][append db=3D[path]../../database/counter.db]DB_DATO=3D[d= ate=20 %Y/%m/%d]&DB_ANTAL=3D1[/append][/!] [Replace=20 db=3D[path]../../database/counter.db&eqDB_DATOdatarq=3DdontFind2ForceAppe= ndHaveAniceDay]DB_DATO=3D[date=20 %Y/%m/%d]&DB_ANTAL=3D1[/Replace] [/showIf] [showIf [numFound]>0] =20 [replacefounditems]DB_ANTAL=3D[math][DB_ANTAL]+1[/math][/replacefoundItem= s] [/showIf] [/search] [/showIf] [showIf [numFound]=3D1] [replace=20 db=3D[path]../../database/online.db&eqDB_IPdatarq=3D[ipaddress]]DB_DATO=3D= [date]&DB_TID=3D[time]&DB_URL=3D[url][thisurl]?a=3Db[formvariables][hideI= f=20 [name]=3Dtemplate]&[name]=3D[value][/hideIf][/FormVariables][/url]&DB_KUN= DEID=3D[kunde][/replace] [/showIf] [/search] [/hideif] [/showif] It performs replaces now, instead of appends as before - but it would=20 appear as this has not helped anything. Any suggestions? Ill add, this is the final time I am touching this "feature", it the=20 combined experience of the Talk List, cant come up with something that=20 works inspite of the way this particular feature is implemented, ill=20 remove it and deal with the fall out. I suspect the user would rather=20 have a working page, than a page where he can see how many are logged in=20 within the last 60 mins, but where the user is experience errors.. /Tommy --------------010303010200080408090607 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
Hello talk.

So we are at it again, after a period of still reoccuring problems, I've come to this yet again.

I've read all the previous replys to this question (also posted by me) and Im pretty sure I've done as was suggested, however there is no change.

So, I keep getting:

An unknown error occurred:
DBError
../../database/online.db
Failed to aquire lock on database - Possible deadlock averted


The complete code

[showif [showstat]!false]
[hideif [ipaddress]~192.168.]
[!] ---------------- TÆLLER TIL STATESTIK ----------------- [/!]
[search db=[path]../../database/online.db&eqDB_IPdatarq=[ipaddress]]
[showIf [numFound]=0]
    [Replace db=[path]../../database/counter.db&eqDB_DATOdatarq=dontFind2ForceAppendHaveAniceDay]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/Replace]
    [search db=[path]../../database/counter.db&eqDB_DATOdata=[date %Y/%m/%d]]
        [showIf [numFound]<1]
            [append db=[path]../../database/test.db]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/append]
            [!][append db=[path]../../database/counter.db]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/append][/!]
            [Replace db=[path]../../database/counter.db&eqDB_DATOdatarq=dontFind2ForceAppendHaveAniceDay]DB_DATO=[date %Y/%m/%d]&DB_ANTAL=1[/Replace]
        [/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]
[/hideif]
[/showif]

It performs replaces now, instead of appends as before - but it would appear as this has not helped anything.

Any suggestions?

Ill add, this is the final time I am touching this "feature", it the combined experience of the Talk List, cant come up with something that works inspite of the way this particular feature is implemented, ill remove it and deal with the fall out. I suspect the user would rather have a working page, than a page where he can see how many are logged in within the last 60 mins, but where the user is experience errors..

/Tommy
 --------------010303010200080408090607-- Tommy Bell

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:

more on my bbs (1997) Tab Delimited Files / FM Pro (1997) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) Generating Options for a Form. (1997) Search design (1997) Help! WebCat2 bug (1997) How reliable is WebDNA? (2004) [WebDNA] opinions on [switch] [case]... (2009) Re:quit command on NT (1997) Fwd: Problems with Webcatalog Plug-in (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Server Speeds - a whole another world [OT] (2002) authenticating a second user (1997) WC2.0 Memory Requirements (1997) WebCatalog for guestbook ? (1997) unable to launch acgi in WebCat (1997) [quantity] and quantity[lineindex] (2000) international time (1997) Problems with v4.01 email (2000) Clickable maps and WebCatalog? (1996)