What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: Database monitoring

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 63538
interpreted = N
texte = Thanks for the reply John. We dont have any triggers running on these DB's at all. As far as timeframe, it has happened at several different times during the day, nothing that constitutes a pattern that we can follow. The funny thing is that we had an entire record disappear yesterday, then today it reappeared. These problems just started when we moved over to a new server cluster. We have 2 App servers that retrieves data from the data server. I am wondering if there isnt some kind of conflict/caching happening there causing this. -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John Peacock Sent: Thursday, December 01, 2005 2:53 PM To: WebDNA Talk Subject: Re: Database monitoring Eric Miller wrote: > Does anyone know of a script or a way to monitor events that happen to a > WebDNA database. We are experiencing some strange things (Field data in > records disappearing, database locking, etc) and it would be nice to catch > what random process is causing this. The only process that accesses WebDNA databases is... WebDNA! If you have eliminated automated triggers (which have a known problem with sandboxes in 6.0 I believe?), then the only other place is some less-well traveled section of your website, possibly caused by some search engine spider walking your pages in an odd fashion. If you can determine some time frame during which this occurs (once an hour, once a day, etc), you can turn on the "Technical Support Information" option on the Preferences page; this writes a line prior to interpreting any page. And then you have to sift though that data for a clue. It will be a lot of data, so don't leave it on for long if you are short of diskspace. In my experience, the majority of problems are code which assumes some external variable is set to reasonable value (for example, code that will work with hostnames but not IP addresses). Believe it or not but it usually is something very stupid and simple, and it will often leap out at you from the debug file. If you make it a habit of always validating all form variables for reasonable values, you will be much less likely to have any problems. HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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 monitoring ( "Eric Miller" 2005)
  2. Re: Database monitoring ( John Peacock 2005)
  3. Re: Database monitoring ( "Eric Miller" 2005)
  4. Re: Database monitoring ( John Peacock 2005)
  5. Re: Database monitoring ( Clint Davis 2005)
  6. Database monitoring ( "Eric Miller" 2005)
Thanks for the reply John. We dont have any triggers running on these DB's at all. As far as timeframe, it has happened at several different times during the day, nothing that constitutes a pattern that we can follow. The funny thing is that we had an entire record disappear yesterday, then today it reappeared. These problems just started when we moved over to a new server cluster. We have 2 App servers that retrieves data from the data server. I am wondering if there isnt some kind of conflict/caching happening there causing this. -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John Peacock Sent: Thursday, December 01, 2005 2:53 PM To: WebDNA Talk Subject: Re: Database monitoring Eric Miller wrote: > Does anyone know of a script or a way to monitor events that happen to a > WebDNA database. We are experiencing some strange things (Field data in > records disappearing, database locking, etc) and it would be nice to catch > what random process is causing this. The only process that accesses WebDNA databases is... WebDNA! If you have eliminated automated triggers (which have a known problem with sandboxes in 6.0 I believe?), then the only other place is some less-well traveled section of your website, possibly caused by some search engine spider walking your pages in an odd fashion. If you can determine some time frame during which this occurs (once an hour, once a day, etc), you can turn on the "Technical Support Information" option on the Preferences page; this writes a line prior to interpreting any page. And then you have to sift though that data for a clue. It will be a lot of data, so don't leave it on for long if you are short of diskspace. In my experience, the majority of problems are code which assumes some external variable is set to reasonable value (for example, code that will work with hostnames but not IP addresses). Believe it or not but it usually is something very stupid and simple, and it will often leap out at you from the debug file. If you make it a habit of always validating all form variables for reasonable values, you will be much less likely to have any problems. HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/ "Eric Miller"

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:

Nested tags count question (1997) Date format question (1998) RE: Error -108 (1997) Error upgrading to webDNA 5.1e (2003) The beginning (1997) New servers and new inline cache (1997) webmerchant and check cashing (1998) WebCat2 - storing unformatted date data? (1997) Web Catalog 2 demo (1997) Banner DNA (1997) RE: WebDNA-Talk searchable? (1997) Bug? (1997) Summing a field full of numbers ... (1997) RE: redirect with more than 256 characters (1999) WC TableGrinder (1997) Help!!!! Purchases not going through! (1997) _ in front of field name (1998) apostrophe in search item (1997) Multi-processor Mac info ... (1997) Re[2]: WebCatalog 3.0.8 Mac OS (2000)