Re: WebDNA deletes major DB data big time
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55755
interpreted = N
texte = Macintosh Plugin version 4.5.1Memory available to WebDNA - Commerce Edition 48,406 K(after all DB's are open)We have something like this happen from time to time.Its always on a Db that has the following specs:46176 records, using 23,769K of RAM13 fieldsPeriodically we get a unable to open the db for insufficient memory, thoughthere is clearly enough memory available at the time.Typically this causes a nuisance as the db is unavailable for reading whilestill allowing it to be written to (its a discussion forum).On a few occasions (3), in conjunction with this error, we ended up with aseverely truncated DB. 46,000 turned into 2000 or so.Backups needed to be called upon.However, even when the DB wasn't truncated, restarting the machine (reboot)was the only way to solve the issue and any records that had been 'added'after the memory error we lost on the reboot.I have since started committing the DB on every addition, which really hitsperformance on a 23 meg DB. But it is the only way I can be secure that newentries wont be lost in the memory void when this occurs.Anyway... Doubt this will help because of the randomness of my issue as wellas everyone elses...but always nice to have someone to share pain with ;-)AlexAlex J McCombie New World MediaChief Information Officer Box 124888/892.6379 MartVille, NY 13111Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer-------------------------------------------------------------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:
Macintosh Plugin version 4.5.1Memory available to WebDNA - Commerce Edition 48,406 K(after all DB's are open)We have something like this happen from time to time.Its always on a Db that has the following specs:46176 records, using 23,769K of RAM13 fieldsPeriodically we get a unable to open the db for insufficient memory, thoughthere is clearly enough memory available at the time.Typically this causes a nuisance as the db is unavailable for reading whilestill allowing it to be written to (its a discussion forum).On a few occasions (3), in conjunction with this error, we ended up with aseverely truncated DB. 46,000 turned into 2000 or so.Backups needed to be called upon.However, even when the DB wasn't truncated, restarting the machine (reboot)was the only way to solve the issue and any records that had been 'added'after the memory error we lost on the reboot.I have since started committing the DB on every addition, which really hitsperformance on a 23 meg DB. But it is the only way I can be secure that newentries wont be lost in the memory void when this occurs.Anyway... Doubt this will help because of the randomness of my issue as wellas everyone elses...but always nice to have someone to share pain with ;-)AlexAlex J McCombie New World MediaChief Information Officer Box 124888/892.6379 MartVille, NY 13111Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer-------------------------------------------------------------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/
Alex McCombie
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:
More news on 5.0 (2003)
Non-Cart Files in Shopping Cart Folder (1997)
Using copyfolder (2001)
Bug Report, maybe (1997)
WebCatalog can't find database (1997)
Anyone have an invoicing system? (1999)
Encrypt/Decrypt (2007)
If search results are blank... (2003)
View order not right (1997)
[WebDNA] Bug in WebDNA or in my brain? (2013)
# fields limited? (1997)
Using Currencies other than Dollars (1997)
Stumpted Again (1997)
WebCat and image maps (1997)
WebCat2 beta 11 - new prefs ... (1997)
Re:emailer 150 (1997)
[Shell]ps -A[/Shell] Linux Webcat Q (2000)
Database on the same server but with different domains (2000)
WebCatalog 4 Install Problems - Not Answered ?? (2000)
Digest Version (2000)