Sporadic database errors

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61239
interpreted = N
texte = We are using a banner rotating system built with WebDNA. It's being used on our newspaper Web site so the traffic is sometimes very very high. We're receiving this error every now and then, not all the time: An unknown error occurred: DBError mydatabase.db Database file could not be found or opened The database in fact does exist so that leads us to believe that it could not be opened, could this be due to so many connections to it at the same time? We've also tried using [exclusivelock] to ensure everyone gets a fair connection to the db but we receive a similar error for the that sometimes too. It seems like no matter what we do we are getting these errors every so often. Does anyone have any ideas for our situation? If this is because too many people are connected to that database at one time is there anything we can do to stop the error from showing and handling it another way? Or maybe we should be closing the database after a modification is made? Any help would be appreciated. Thank you. Justin Carroll ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sporadic database errors ( Scott Szretter 2005)
  2. Sporadic database errors ( Justin Carroll 2005)
We are using a banner rotating system built with WebDNA. It's being used on our newspaper Web site so the traffic is sometimes very very high. We're receiving this error every now and then, not all the time: An unknown error occurred: DBError mydatabase.db Database file could not be found or opened The database in fact does exist so that leads us to believe that it could not be opened, could this be due to so many connections to it at the same time? We've also tried using [exclusivelock] to ensure everyone gets a fair connection to the db but we receive a similar error for the that sometimes too. It seems like no matter what we do we are getting these errors every so often. Does anyone have any ideas for our situation? If this is because too many people are connected to that database at one time is there anything we can do to stop the error from showing and handling it another way? Or maybe we should be closing the database after a modification is made? Any help would be appreciated. Thank you. Justin Carroll ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Justin Carroll

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:

Command=Showcart? (2000) shipcost (1997) tcpconnect (1999) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) [WebDNA] WebDNA as cgi app (was WebSite Examples) (2008) WebCat2final1 crashes (1997) I'm Sorry - OFF TOPIC (2000) Merry Christmas! :) (1998) Webcat+Webstar+Firesite - Encrypted Templates ? (2001) Add more fields to an existent data base (1997) error message (2000) Separate SSL Server (1997) The Guru Speaks-very long reply (1998) No luck with taxes (1997) What file? (1997) [CART] inside a [LOOP] (1997) [SEARCH] Context for SKU prices not working... (1998) Replace context problem ... (1997) For Grant: Webcatalog 4.0 - When will we be able to beta (2000) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)