Re: WebDNA dying and trashing my databases - still crashing

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61445
interpreted = N
texte = Installed the patched version tonight. Here are the logs: ---- Mar 14 18:06:37 bear WebDNAMonitor[2002]: WebDNA [12049] stop This is where I stopped WebDNA to upgrade. Mar 14 18:07:29 bear WebDNAMonitor[14474]: WebDNA starts with process pid [14475] This is restarting after the upgrade. Mar 14 20:52:59 bear WebDNA[14475]: WebDNA receives signal SIGSEGV Mar 14 20:52:59 bear WebDNAMonitor[14474]: WebDNA restarts with pid [26953] Mar 14 20:56:52 bear WebDNA[26953]: WebDNA receives signal SIGSEGV Mar 14 20:56:52 bear WebDNAMonitor[14474]: WebDNA restarts with pid [27265] Mar 14 21:11:31 bear WebDNA[27265]: WebDNA receives signal SIGSEGV Mar 14 21:11:31 bear WebDNAMonitor[14474]: WebDNA restarts with pid [28428] After 40 minutes of accessing a MySQL db. This is not a good thing. The code is searching a webdna db, pulling 1 record, then copying some fields to a mysql db. Then updating a flag in the orignal webdna db to mark this record as having been copied over already. The html page reloads every 5 seconds to copy the next record (should be a load issue at that rate). ---- Scott Anderson wrote: > The 6.0a patch does include the following fixes: > > Fixed: [founditems] context used without a wrapping [search], [sql], or > [sqlresults] context crashes the WebDNA engine. > Fixed: [SQLExecute] - 'selecting' the same field more than once, in an SQL > 'select' statement crashes the WebDNA engine. > > > The patch can be downloaded here: > http://webdna.smithmicro.com/default.tpl?PageID=57&PageName=Updates/Patches& > ParentID=50 > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of > lists > Sent: Monday, March 14, 2005 08:28 AM > To: WebDNA Talk > Subject: Re: WebDNA dying and trashing my databases > > > >>This looks like the error messages I am seeing on RedHat 4 >>with Apache 2.0.52 and WenDNA 6.0a. > > > I am also using apache 2.0x but never found 6.0a, just > running 6.0. > > What I have discovered is that this only happens when also > accessing a mysql db. This happened again 4 more times last > night (meaning trashing my db's 4 times). Have been forced > to run backups on my dbs every hour now. > > Maybe the mysql support isn't all that it is cracked up to > be? > > In my case, I am searching a WebDNA db, pulling a single > record, then inserting a few of the fields into a mysql db. > > When WebDNA dies, mysql keeps running fine (my ad server is > still running on this mysql server). > > Anyone have any suggestions? Is anyone making heavy use of > WebDNA and mysql? > > >>Nitai >> >>-- >>Redakto - Content Management that simply works >>Content Management & eBusiness Systems >> >>ComputerOil® AG >>Dammstrasse 7 >>5400 Baden / Switzerland >>Telefon +41 (0)844 44 55 66 >> >>info@computeroil.com >>http://computeroil.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: WebDNA dying and trashing my databases - still crashing ( eLists 2005)
Installed the patched version tonight. Here are the logs: ---- Mar 14 18:06:37 bear WebDNAMonitor[2002]: WebDNA [12049] stop This is where I stopped WebDNA to upgrade. Mar 14 18:07:29 bear WebDNAMonitor[14474]: WebDNA starts with process pid [14475] This is restarting after the upgrade. Mar 14 20:52:59 bear WebDNA[14475]: WebDNA receives signal SIGSEGV Mar 14 20:52:59 bear WebDNAMonitor[14474]: WebDNA restarts with pid [26953] Mar 14 20:56:52 bear WebDNA[26953]: WebDNA receives signal SIGSEGV Mar 14 20:56:52 bear WebDNAMonitor[14474]: WebDNA restarts with pid [27265] Mar 14 21:11:31 bear WebDNA[27265]: WebDNA receives signal SIGSEGV Mar 14 21:11:31 bear WebDNAMonitor[14474]: WebDNA restarts with pid [28428] After 40 minutes of accessing a MySQL db. This is not a good thing. The code is searching a webdna db, pulling 1 record, then copying some fields to a mysql db. Then updating a flag in the orignal webdna db to mark this record as having been copied over already. The html page reloads every 5 seconds to copy the next record (should be a load issue at that rate). ---- Scott Anderson wrote: > The 6.0a patch does include the following fixes: > > Fixed: [founditems] context used without a wrapping [search], [SQL], or > [sqlresults] context crashes the WebDNA engine. > Fixed: [SQLexecute] - 'selecting' the same field more than once, in an SQL > 'select' statement crashes the WebDNA engine. > > > The patch can be downloaded here: > http://webdna.smithmicro.com/default.tpl?PageID=57&PageName=Updates/Patches& > ParentID=50 > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of > lists > Sent: Monday, March 14, 2005 08:28 AM > To: WebDNA Talk > Subject: Re: WebDNA dying and trashing my databases > > > >>This looks like the error messages I am seeing on RedHat 4 >>with Apache 2.0.52 and WenDNA 6.0a. > > > I am also using apache 2.0x but never found 6.0a, just > running 6.0. > > What I have discovered is that this only happens when also > accessing a mysql db. This happened again 4 more times last > night (meaning trashing my db's 4 times). Have been forced > to run backups on my dbs every hour now. > > Maybe the mysql support isn't all that it is cracked up to > be? > > In my case, I am searching a WebDNA db, pulling a single > record, then inserting a few of the fields into a mysql db. > > When WebDNA dies, mysql keeps running fine (my ad server is > still running on this mysql server). > > Anyone have any suggestions? Is anyone making heavy use of > WebDNA and mysql? > > >>Nitai >> >>-- >>Redakto - Content Management that simply works >>Content Management & eBusiness Systems >> >>ComputerOil® AG >>Dammstrasse 7 >>5400 Baden / Switzerland >>Telefon +41 (0)844 44 55 66 >> >>info@computeroil.com >>http://computeroil.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/ eLists

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:

WebCatalog/Mac 2.1b2 New Features (1997) Formulas.db + Users.db (1997) Pull Down Search (2000) displaying New products (using [date]) (1997) taxTotal problem (1998) date (1999) Safari browser and WebDNA set-cookies (2003) Emailer help....! (1997) Combining search criteria in a context? (1998) problems with 2 tags shakur (1997) Webcat and other cgi (2000) WebDNA Solutions ... sorry! (1997) profiles (1999) temporary database? (2000) Quit revisited (1997) Date search - yes or no (1997) Problem with updating to 2.1.1 (1998) [WebDNA] Greetings to all (2016) Summing fields (1997) Trouble Searching (1999)