Re: 4.0.2b5 not finding databases under load

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 36065
interpreted = N
texte = > >Error: the database '^inc/banners/db/banners.db' could not be >found or opened > >This sounds like the symptoms of a true deadlock (especially since >you say it goes away on its own after a while). Is it possible to >get me the database and the code that both reads and writes to it? >Perhaps that code comes from different pages, perhaps not. > >I'll see if I can pump up the error messages to display something >more interesting, perhaps output to the error log as well. > >In the meantime, you might want to experiment with wrapping >[exclusivelock db=^inc/banners/db/banners.db] around the chunk of >code that does the update to the db. If you have other dbs that you >are updating at that time, put them into the list of dbs to >exclusivelock. > >-- >Grant Hulbert, Director of Engineering **********************************I already have an exclusivelock around most of my banner include, including the part that does the replace.I have also seen the same problem on at least two other databases.Having more debugging info displayed or logged would be useful.I'll send you the code and db later tonight.-Dale -- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.com/############################################################# This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to Associated Messages, from the most recent to the oldest:

    
  1. Re: 4.0.2b5 not finding databases under load (Dale LaFountain 2000)
  2. Re: 4.0.2b5 not finding databases under load (Grant Hulbert 2000)
  3. Re: 4.0.2b5 not finding databases under load (Alex McCombie 2000)
  4. 4.0.2b5 not finding databases under load (Dale LaFountain 2000)
> >Error: the database '^inc/banners/db/banners.db' could not be >found or opened > >This sounds like the symptoms of a true deadlock (especially since >you say it goes away on its own after a while). Is it possible to >get me the database and the code that both reads and writes to it? >Perhaps that code comes from different pages, perhaps not. > >I'll see if I can pump up the error messages to display something >more interesting, perhaps output to the error log as well. > >In the meantime, you might want to experiment with wrapping >[exclusivelock db=^inc/banners/db/banners.db] around the chunk of >code that does the update to the db. If you have other dbs that you >are updating at that time, put them into the list of dbs to >exclusivelock. > >-- >Grant Hulbert, Director of Engineering **********************************I already have an exclusivelock around most of my banner include, including the part that does the replace.I have also seen the same problem on at least two other databases.Having more debugging info displayed or logged would be useful.I'll send you the code and db later tonight.-Dale -- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.com/############################################################# This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to To switch to the INDEX mode, E-mail to Send administrative queries to Dale LaFountain

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:

Emailer (WebCat2) (1997) Can I invoke an ssi plugin from within a webcat page (1997) What are SMSI's upgrade policies? (2003) Odd (2001) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) ColdFusion v. WebDNA (2004) problem: mail changed (1997) Cookie set browser session. (1998) Createfolder / writefile problem (2004) WebCat2: Formulas.db question (1997) still having shipCost.db Problem (1997) Configuring E-mail (1997) japanese characters (1997) Interpret twice? (1997) Limiting user access to .tmpl files (1997) Sort Floating Point Number (2008) How much is too much? I can never remember the answer. (2002) autosensing lanague selection (1997) [include ...] behavior (1997) 800x600 (2003)