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:
Version 4? (2000)
Forms Search Questions (1997)
Roundup function? (1997)
instant cookies? (1999)
WebCatalog/WebMerchant Manuals Available (1998)
WC Database Format (1997)
RAM variables (1997)
Variables for chat (1997)
test 2 (2004)
Multiple Pulldowns (1997)
WebCatalog2 Feature Feedback (1996)
syntax question, not in online refernce (1997)
Type 11 errors setting up WebCAt 2 (1997)
Exclamation point (1997)
Configuring E-mail (1997)
Server slowing down. (1997)
Configuring E-mail (1997)
Help! WebCat2 bug (1997)
WebDNA Solutions ... sorry! (1997)
Wild WebCat 98 Contest! (1998)