Re: [WebDNA] Crashing Database
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106170
interpreted = N
texte = I would suggest checking your code. The reason I say this is that because I recently found some bad code in a database updating script that I have had running for several years. Because the database had grown substantially over that period, I "knew" it was a corrupted database! As it turns out I had a single ] bracket missing from a search context that when encountered didn't error out it would simply take my server to it's knees and eventually force a server restart. After adding the missing ] on [/search Everything works fine now. The code in question had been in place for over two years and I just recently found the mistake. Marc On 1/24/2011 5:16 PM, World Wide Art wrote: > Hi all, > > We have a database (about 12MB) that will crash/lock up the server. > We have moved from a PPC to an Intel (mac) computer and still have > the same problem. Sometimes (not always) when we update this > database (always the same one) WebDNA locks up. The server will > still serve pages that don't require database access, all others are > dead. The only way to fix the problem is to re-start the computer. > Re-starting Apache does not work. Any ideas to solve this problem > would be greatly appreciated? > > Thanks, > david. > > World Wide Art, Art Gallery and Custom Framing > questions@world-wide-art.com
> Disney Preferred Animation Art Gallery > Specializing in Limited Editions by Today's Top Artists and Custom > Conservation Framing. > http://www.world-wide-art.com > 1-800-518-8453 or 1-510-538-8453 > > > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list . To unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us -- ------------------------------------------- Marc Thompson Software Engineer Media Solutions University Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu -------------------------------------------
Associated Messages, from the most recent to the oldest:
I would suggest checking your code. The reason I say this is that because I recently found some bad code in a database updating script that I have had running for several years. Because the database had grown substantially over that period, I "knew" it was a corrupted database! As it turns out I had a single ] bracket missing from a search context that when encountered didn't error out it would simply take my server to it's knees and eventually force a server restart. After adding the missing ] on [/search Everything works fine now. The code in question had been in place for over two years and I just recently found the mistake. Marc On 1/24/2011 5:16 PM, World Wide Art wrote: > Hi all, > > We have a database (about 12MB) that will crash/lock up the server. > We have moved from a PPC to an Intel (mac) computer and still have > the same problem. Sometimes (not always) when we update this > database (always the same one) WebDNA locks up. The server will > still serve pages that don't require database access, all others are > dead. The only way to fix the problem is to re-start the computer. > Re-starting Apache does not work. Any ideas to solve this problem > would be greatly appreciated? > > Thanks, > david. > > World Wide Art, Art Gallery and Custom Framing > questions@world-wide-art.com > Disney Preferred Animation Art Gallery > Specializing in Limited Editions by Today's Top Artists and Custom > Conservation Framing. > http://www.world-wide-art.com > 1-800-518-8453 or 1-510-538-8453 > > > --------------------------------------------------------- This > message is sent to you because you are subscribed to the mailing > list . To unsubscribe, E-mail to: archives: > http://mail.webdna.us/list/talk@webdna.us Bug Reporting: > support@webdna.us -- ------------------------------------------- Marc Thompson Software Engineer Media Solutions University Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu -------------------------------------------
Marc Thompson
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:
Unix webcat perms & multiple versions of same db in cache issue (2000)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Possible to reset Linux file permissions w/in webcat [shell] ? (2000)
[BoldWords] WebCat.acgib15Mac (1997)
TEXTAREA and sendmail (1998)
Summing fields (1997)
WebCatalog for Postcards ? (1997)
Force leading zeros (1998)
[WebDNA] [middle] (2015)
(1997)
WebDNA Solutions --> Date format suggestions (1998)
Multiple catalog databases and showcart (1997)
Thanks and Big News!!! (1997)
[WebDNA] maybe silly suggestion? [founditems] (2015)
Smith Micro - no competition (2000)
Navigator 4.01 (1997)
[taxrate] question (1997)
Reversed words (1997)
Formulas.db (1997)
math on date? (1997)