Re: Occasional failure to open DB file

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43618
interpreted = N
texte = >Sometimes (1-10 times a day) my checkout page reports: > >Error: the database '../db/order.db' could not be found or opened > >The other 99% of the time the same code is loaded, it works fine. > >Given that the path is correct and the DB is certainly open and >working properly in general, what other causes could there be for >WebDNA's failure to access the DB? > >- BrianBrian,We have seen similar results on webcat4 installations in the past. This replaces the thread.debug files that used to appear in webcat3 when a thread could not lock a database for writing.We just switched our order processing to OSX and webcat4 yesterday, so we will see if these start appearing for us shortly.You might try trimming down your orders.db (or archiving old records to a different file) to minimize the time taken for each thread to lock/write/unlock the database.HTH-Dale------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Occasional failure to open DB file (Dale LaFountain 2002)
  2. Occasional failure to open DB file (Brian Fries 2002)
>Sometimes (1-10 times a day) my checkout page reports: > >Error: the database '../db/order.db' could not be found or opened > >The other 99% of the time the same code is loaded, it works fine. > >Given that the path is correct and the DB is certainly open and >working properly in general, what other causes could there be for >WebDNA's failure to access the DB? > >- BrianBrian,We have seen similar results on webcat4 installations in the past. This replaces the thread.debug files that used to appear in webcat3 when a thread could not lock a database for writing.We just switched our order processing to OSX and webcat4 yesterday, so we will see if these start appearing for us shortly.You might try trimming down your orders.db (or archiving old records to a different file) to minimize the time taken for each thread to lock/write/unlock the database.HTH-Dale------------------------------------------------------------- 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://search.smithmicro.com/ 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:

WebCatalog and WebTen (1997) Close Databases Crash? (1998) Search/sort in URL Was: GuestBook example (1997) Best way to handle 404 errors with WebDNA and Web* V (2003) Bit off subject -- Faxing orders (1997) Date search - yes or no (1997) 'does not contain' operator needed ... (1997) default value from Lookup (was Grant, please help me) (1997) Help name our technology! (1997) WebCat2 beta 11 - new prefs ... (1997) Limiting user access to .tmpl files (1997) Help name our technology! (1997) Just Testing (1997) Fun With [TCP Connect] (1998) Nested tags count question (1997) Only charge card when product shipped ? (1997) [WebDNA] sudo and shell (2010) Error Log.db --however (1997) A quickie question (1997) emailer settings and control questions (1997)