Re: Database Not Writing Fully to Disk

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 69177
interpreted = N
texte = When this has happened to me in the past, it was because my disk was full. (Log files that I had not purged filled it up.) Terry >Hi, > >I'm experiencing an intermittent issue (maybe 3 times in a year) where our >products database gets partially written back to disk. It seems to occur >after a page hangs (I inevitably have to restart the engine or reboot). >There are several templates that can make changes to this database -- a few >of them do use exclusive locks. It happened again just yesterday. We were >inputting a very large order internally (over 100 items). The page locked >up and that's when it seemed to occur. The strange thing is, this page was >only writing to the shopping cart and only accessing the products.db for >info. > >At this point, I'm just hoping someone can point me in a new direction in >trying to figure this out. I already commit to the database each time I >write to it. I've been wondering if there may be a problem with using >exclusive lock (on select pages only -- perhaps I should be using it on >everything?). > >Any advice you can offer would be greatly appreciated. > >Thanks, > >Tana -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- 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: Database Not Writing Fully to Disk ( Terry Wilson 2007)
  2. Re: Database Not Writing Fully to Disk ( Donovan Brooke 2007)
  3. Database Not Writing Fully to Disk ( "Tana Adams" 2007)
When this has happened to me in the past, it was because my disk was full. (Log files that I had not purged filled it up.) Terry >Hi, > >I'm experiencing an intermittent issue (maybe 3 times in a year) where our >products database gets partially written back to disk. It seems to occur >after a page hangs (I inevitably have to restart the engine or reboot). >There are several templates that can make changes to this database -- a few >of them do use exclusive locks. It happened again just yesterday. We were >inputting a very large order internally (over 100 items). The page locked >up and that's when it seemed to occur. The strange thing is, this page was >only writing to the shopping cart and only accessing the products.db for >info. > >At this point, I'm just hoping someone can point me in a new direction in >trying to figure this out. I already commit to the database each time I >write to it. I've been wondering if there may be a problem with using >exclusive lock (on select pages only -- perhaps I should be using it on >everything?). > >Any advice you can offer would be greatly appreciated. > >Thanks, > >Tana -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- 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/ Terry Wilson

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:

[WebDNA] WebDNA 7 and Deprecated command (2011) WebCat2b12 CGI Mac - [shownext] problem (1997) Passing Cart variable to subdirectory files? (1997) Country & Ship-to address & other fields ? (1997) Emailer help....! (1997) New servers and new inline cache (1997) synching databases on multiple servers (1997) system crashes, event log (1997) [Sum] function? (1997) Some Questions (1997) unusual search problem (1998) WCS Newbie question (1997) Show items based on login Password (2003) WebCatalog for guestbook ? (1997) Sort Order on a page search (1997) Templates for Customer Database? (1997) Using Applescript to process WebCatalog functions (1998) Re1000001: Setting up shop (1997) 2.0 Info (1997) Emailer again & again (1997)