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.comhttp://WhosComing.com - a simplified, affordable online reservation systemhttp://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:
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.comhttp://WhosComing.com - a simplified, affordable online reservation systemhttp://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)