[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:

Stopping bad HTML propagation ? (1997) Template Encryption (1998) [showif] problem (1999) Page Breaks in Word (2003) protect tag on NT IIS (1997) Summing fields (1997) Emailer Erreur 551 (2001) It just Does't add up!!! (1997) # fields limited? (1997) ampersand (1998) Where's Cart Created ? (1997) Nested tags count question (1997) Caching [include] files ... (1997) WebObjects (1998) Help wanted (1998) WebCat editing, SiteGuard & SiteEdit (1997) Re:2nd WebCatalog2 Feature Request (1996) Is the list server working? (1998) Snake Bites (1997) lineitem variables (1999)