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] stopThis 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 SIGSEGVMar 14 20:52:59 bear WebDNAMonitor[14474]: WebDNA restarts with pid [26953]Mar 14 20:56:52 bear WebDNA[26953]: WebDNA receives signal SIGSEGVMar 14 20:56:52 bear WebDNAMonitor[14474]: WebDNA restarts with pid [27265]Mar 14 21:11:31 bear WebDNA[27265]: WebDNA receives signal SIGSEGVMar 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:

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] stopThis 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 SIGSEGVMar 14 20:52:59 bear WebDNAMonitor[14474]: WebDNA restarts with pid [26953]Mar 14 20:56:52 bear WebDNA[26953]: WebDNA receives signal SIGSEGVMar 14 20:56:52 bear WebDNAMonitor[14474]: WebDNA restarts with pid [27265]Mar 14 21:11:31 bear WebDNA[27265]: WebDNA receives signal SIGSEGVMar 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:

apostrophe in search item (1997) why why why (2004) Enough already! (1998) Modifying order output (1997) [BULK] [WebDNA] Version 7 Config problem (2011) Associative lookup style? + bit more (1997) Search returns all, not 20 (1997) [Solved - with code] catching WebDNA error messages (2003) writing cart to db (1998) RequiredFields notes ... (1997) Append command(2) (2000) Thanks Grant (1997) emailer w/F2 (1997) Protect (1997) [WebDNA] Google Cloud (2014) Extended [ConvertChars] (1997) 3rd request: What are SMSI's upgrade policies? (2003) Req: Array Tags Explained, simple and clear (2004) RE: HTTP Header info (1997) Almost a there but..bye bye NetCloak (1997)