Re: [WebDNA] online.db deadlock: your current options ...
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106926
interpreted = N
texte = I just had a though ..... it could be virus checking software that is = causing the problem ! If you disallow the SW from accessing .db files that may solve the = problem. I must check my own configuration !! Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 11/07/2011, at 10:39 PM, Kenneth Grome wrote: >> With regards to duplicating the error, I tried forcing >> the issue on our previous webserver, we still have this >> computer - it is just tucked away ready to be gutted and >> recycled - and I could not replicate the error.=20 >=20 > This probably just confirms that the problem is in a recent=20 > Windows update, especially if the old server has NOT been=20 > updated. >=20 >=20 >> With regarding to the MSSQL and the online.db lock, I >> don't think they related the online.db has no relation >> to the MSSQL server, the MSSQL handles a lot of other >> things >=20 > There is no WebDNA access to a SQL db in the code you=20 > posted, so unless WebDNA is accessing SQL somewhere=20 > elsewhere (and creating this problem there) you're wasting=20 > yout time looking at SQL issues. >=20 >=20 >> I am considering moving this functionality into >> MSSQL, as that would at least resolve the deadlock >> problem, or so I hope. >=20 > It would, assuming the deadlock issue occurs only when=20 > WebDNA cannot access its online.db file. =20 >=20 > But WebDNA is faster than SQL so you may end up with SQL=20 > "not keeping up" with your web traffic if you make this=20 > change, so it probably wouldn't hurt to look at other=20 > options first ... >=20 >=20 >> I am not sure how to have anyone look at it, when I am=20 >> not able to determine where the problem(s) originate ... >=20 > We (I) think it's a Windows config issue, or some other=20 > software on the server that is improperly blocking WebDNA's=20 > access to the "online.db" file. =20 >=20 > If this is true you could do more online research to=20 > possibly learn which software is "doing the wrong thing"=20 > then reconfigure or get rid of that software. And if this=20 > still doesn't help I suppose you could hire a Windows expert=20 > to figure out what's going on and then fix it for you.=20 >=20 > ------------------- >=20 > Or just skip all this diagnostic stuff and convert the=20 > online.db functions to SQL as you suggested above. =20 >=20 > It is entirely possible that SQL will not be overloaded by=20 > your heavy web traffic, and if this is the case your deadlock=20 > problem will be eliminated once and for all -- at least on=20 > the online.db.=20 >=20 > Sincerely, > Kenneth Grome > --------------------------------------------------------- > 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
Associated Messages, from the most recent to the oldest:
I just had a though ..... it could be virus checking software that is = causing the problem ! If you disallow the SW from accessing .db files that may solve the = problem. I must check my own configuration !! Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 11/07/2011, at 10:39 PM, Kenneth Grome wrote: >> With regards to duplicating the error, I tried forcing >> the issue on our previous webserver, we still have this >> computer - it is just tucked away ready to be gutted and >> recycled - and I could not replicate the error.=20 >=20 > This probably just confirms that the problem is in a recent=20 > Windows update, especially if the old server has NOT been=20 > updated. >=20 >=20 >> With regarding to the MSSQL and the online.db lock, I >> don't think they related the online.db has no relation >> to the MSSQL server, the MSSQL handles a lot of other >> things >=20 > There is no WebDNA access to a SQL db in the code you=20 > posted, so unless WebDNA is accessing SQL somewhere=20 > elsewhere (and creating this problem there) you're wasting=20 > yout time looking at SQL issues. >=20 >=20 >> I am considering moving this functionality into >> MSSQL, as that would at least resolve the deadlock >> problem, or so I hope. >=20 > It would, assuming the deadlock issue occurs only when=20 > WebDNA cannot access its online.db file. =20 >=20 > But WebDNA is faster than SQL so you may end up with SQL=20 > "not keeping up" with your web traffic if you make this=20 > change, so it probably wouldn't hurt to look at other=20 > options first ... >=20 >=20 >> I am not sure how to have anyone look at it, when I am=20 >> not able to determine where the problem(s) originate ... >=20 > We (I) think it's a Windows config issue, or some other=20 > software on the server that is improperly blocking WebDNA's=20 > access to the "online.db" file. =20 >=20 > If this is true you could do more online research to=20 > possibly learn which software is "doing the wrong thing"=20 > then reconfigure or get rid of that software. And if this=20 > still doesn't help I suppose you could hire a Windows expert=20 > to figure out what's going on and then fix it for you.=20 >=20 > ------------------- >=20 > Or just skip all this diagnostic stuff and convert the=20 > online.db functions to SQL as you suggested above. =20 >=20 > It is entirely possible that SQL will not be overloaded by=20 > your heavy web traffic, and if this is the case your deadlock=20 > problem will be eliminated once and for all -- at least on=20 > the online.db.=20 >=20 > Sincerely, > Kenneth Grome > --------------------------------------------------------- > 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
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:
Queertrons? (1997)
Simple way to create unique SKU (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
CSS in HTML emails? (2003)
[Summary] re: Emailer setup (1997)
Claris HomePage messes up the code (1997)
Multiple Passwords (1997)
Calendar (1997)
Upgrading from 2.1 to 3.0.7 (2000)
url .. (2003)
[protect] on NT? (1997)
Perl programmer needed [OT] (2002)
Sort Floating Point Number (2008)
Document section in storebuilder site (2004)
[showif],[refferer],[include] in errormessages.db (2002)
Convertchars Problem (2004)
[WebDNA] WebDNA.us site speed (2011)
Using Plug-In while running 1.6.1 (1997)
Alternating colors (1997)