They were related to the database, Oterro would accept a whole lot of variations of sql syntax (like sel instead of select, and you can omit commas from column lists and such), but it turned out, some variations worked better than others, and some would cause crashes.
Changing to more correct SQL syntax made most of our problems disapear. We still have a couple crashes every handful of days but its much more acceptable than it was. At one point in time we had a complicated while loop that under certain circumstances would loop infinitely and cause witango to crash too, you might look into that if you are using a loop that might not be terminating. Another thing you might do to find the place it's crashing would be to put some file append actions in your code to write out to a log file certain information like "user ref <userref> is at <filename> in position 2". SO when it crashes you can look at the log and see the last couple entries to see if theres a pattern. ----- Original Message ----- From: "Peter Ternstr�m" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 01, 2004 3:22 PM Subject: Re: Witango-Talk: Quoting of method call parameters > What kind of issues were those? Please tell us more, we're kind of fumbling > in the dark for a solution > > Peter > > > ----- Original Message ----- > From: "Alan Wolfe" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, December 02, 2004 12:15 AM > Subject: Re: Witango-Talk: Quoting of method call parameters > > > > Nope sorry we have: > > > > R:Base for database > > > > IIS6 > > > > Windows 2003 server > > > > Witango 5.0.1.065 > > > > there were some issues we worked through so thought id ask. > > > > ----- Original Message ----- > > From: "Peter Ternstr�m" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, December 01, 2004 3:08 PM > > Subject: Re: Witango-Talk: Quoting of method call parameters > > > > > >> Im using MS SQL server 2000 with SP3 > >> > >> IIS6 > >> > >> Win 2003 server > >> > >> Witango 5.5 > >> > >> > >> Any similar experiences with this setup? > >> > >> > >> Peter > >> > >> ----- Original Message ----- > >> From: "Alan Wolfe" <[EMAIL PROTECTED]> > >> To: <[EMAIL PROTECTED]> > >> Sent: Thursday, December 02, 2004 12:09 AM > >> Subject: Re: Witango-Talk: Quoting of method call parameters > >> > >> > >> > Hey Peter, > >> > > >> > Just curious, what database are you using? > >> > > >> > ----- Original Message ----- > >> > From: "Peter Ternstr�m" <[EMAIL PROTECTED]> > >> > To: <[EMAIL PROTECTED]> > >> > Sent: Wednesday, December 01, 2004 3:03 PM > >> > Subject: Re: Witango-Talk: Quoting of method call parameters > >> > > >> > > >> >> It works great on our development server, but on the production > >> >> servers > >> >> it > >> >> crashes under load. > >> >> > >> >> Today we had 4 crashes, and severe load. > >> >> > >> >> Yesterday we only had 1 crash, but moderate load. > >> >> > >> >> Crashlog doesnt point me out to one tcf or taf file, so it must be > >> > something > >> >> in the app server...or our code ;-) > >> >> > >> >> Peter > >> >> > >> >> > >> >> > >> >> > >> >> ----- Original Message ----- > >> >> From: "Ben Johansen" <[EMAIL PROTECTED]> > >> >> To: <[EMAIL PROTECTED]> > >> >> Sent: Wednesday, December 01, 2004 11:43 PM > >> >> Subject: RE: Witango-Talk: Quoting of method call parameters > >> >> > >> >> > >> >> The easiest way to tell is to create a stub method that take in the > >> >> parameters and records/displays them somewhere without any other code > > in > >> > the > >> >> method > >> >> This should tell you if the variables are to blame or it is you code. > >> >> > >> >> Since most of us think that our code (mine included) is brilliant and > >> >> correct the first time out of chute, then it must be the software. LOL > >> >> ;-) > >> >> > >> >> > >> >> Ben Johansen - http://www.pcforge.com > >> >> Authorized Witango & MDaemon Reseller > >> >> Available for Witango Developement > >> >> > >> >> > >> >> -----Original Message----- > >> >> From: Peter Ternstr�m [mailto:[EMAIL PROTECTED] > >> >> Sent: Wednesday, December 01, 2004 3:31 PM > >> >> To: [EMAIL PROTECTED] > >> >> Subject: Re: Witango-Talk: Quoting of method call parameters > >> >> > >> >> Thanks Ben, > >> >> > >> >> Im experiencing server crashes under heavy load and I am trying to > > figure > >> >> out the problem. Its always a TCF that causes the crash. In the > >> >> current > >> >> method calls, values that are integers or will evaluate to integers > > (from > >> >> vars, column refs etc) are NOT quoted. > >> >> > >> >> Could not quoting values in method calls cause the server to crash? > >> >> (on > >> >> heavy load) > >> >> > >> >> ? > >> >> > >> >> Peter > >> >> > >> >> > >> >> ----- Original Message ----- > >> >> From: "Ben Johansen" <[EMAIL PROTECTED]> > >> >> To: <[EMAIL PROTECTED]> > >> >> Sent: Wednesday, December 01, 2004 9:41 PM > >> >> Subject: RE: Witango-Talk: Quoting of method call parameters > >> >> > >> >> > >> >> Either quote is fine '""' or "''" > >> >> The issue with this quote is not the type of the column but the name > >> > itself, > >> >> since column names can contain spaces, I consider it a most habit to > >> >> quote > >> >> these > >> >> > >> >> Ben Johansen - http://www.pcforge.com > >> >> Authorized Witango & MDaemon Reseller > >> >> Available for Witango Developement > >> >> > >> >> > >> >> -----Original Message----- > >> >> From: Peter Ternstr�m [mailto:[EMAIL PROTECTED] > >> >> Sent: Wednesday, December 01, 2004 1:30 PM > >> >> To: [EMAIL PROTECTED] > >> >> Subject: Re: Witango-Talk: Quoting of method call parameters > >> >> > >> >> Thanks, > >> >> > >> >> so how about column references? > >> >> > >> >> <@CALLMETHOD OBJECT="object" SCOPE="d2" > >> >> METHOD="show_messenger_voting_form(<@COLUMN 'messenger.auid'>)" > >> >> ENCODING=META> > >> >> > >> >> The auid can only contain integers, but should I quote it anyway? > >> >> > >> >> And if I quote it, should, how should I quote it? > >> >> > >> >> <@CALLMETHOD OBJECT="object" SCOPE="d2" > >> >> METHOD="show_messenger_voting_form('<@COLUMN "messenger.auid">')" > >> >> ENCODING=META> > >> >> > >> >> ? > >> >> > >> >> Peter > >> >> > >> >> > >> >> > >> >> ----- Original Message ----- > >> >> From: "Alan Wolfe" <[EMAIL PROTECTED]> > >> >> To: <[EMAIL PROTECTED]> > >> >> Sent: Wednesday, December 01, 2004 6:51 PM > >> >> Subject: Re: Witango-Talk: Quoting of method call parameters > >> >> > >> >> > >> >> > And if you want to be "fully xml compliant" (witango is getting > >> >> > stricter > >> >> > on > >> >> > that sometime in the future isnt it? I recall something about that > >> >> > at > >> > the > >> >> > last conference), you will want to quote just about EVERYTHING so > >> >> > better > >> >> > safe now then sorry later on i think (: > >> >> > > >> >> > for the xml compliance it's only for attributes of tags though if i > >> >> > understand correctly, so instead of this which works now: > >> >> > <@RANDOM HIGH=100 LOW=1> > >> >> > > >> >> > you'd want this: > >> >> > <@RANDOM HIGH="100" LOW="1"> > >> >> > > >> >> > ----- Original Message ----- > >> >> > From: "Ben Johansen" <[EMAIL PROTECTED]> > >> >> > To: <[EMAIL PROTECTED]> > >> >> > Sent: Wednesday, December 01, 2004 9:41 AM > >> >> > Subject: RE: Witango-Talk: Quoting of method call parameters > >> >> > > >> >> > > >> >> > Here is a couple of quick rules that I use in Witango > >> >> > > >> >> > If it is contains a space "Quote It" > >> >> > If it is a String/Text "Quote it even if it doesn't have a space" > >> >> > If it is a number "Quoting Optional" if the number is in a Witango > >> >> > Variable > >> >> > "Quote It" > >> >> > > >> >> > You can pretty much quote all because Witango doesn't use explicitly > >> > typed > >> >> > vars they pretty much are all strings > >> >> > > >> >> > <@CALC EXP="1 + 1"> = <@CALC EXP="'1' + '1'"> > >> >> > > >> >> > > >> >> > Ben Johansen - http://www.pcforge.com > >> >> > Authorized Witango & MDaemon Reseller > >> >> > Available for Witango Developement > >> >> > > >> >> > > >> >> > -----Original Message----- > >> >> > From: Peter Ternstr�m [mailto:[EMAIL PROTECTED] > >> >> > Sent: Wednesday, December 01, 2004 10:11 AM > >> >> > To: [EMAIL PROTECTED] > >> >> > Subject: Witango-Talk: Quoting of method call parameters > >> >> > > >> >> > Hello everyone, > >> >> > > >> >> > sorry for this maybe stupid question; > >> >> > > >> >> > what is correct quoting in a method call? > >> >> > > >> >> > if the parameters are integer values, should they be quoted anyway? > >> >> > > >> >> > Thanks for all help > >> >> > > >> >> > Peter > >> >> > > > ________________________________________________________________________ > >> >> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> >> > > >> >> > > >> >> > > > ________________________________________________________________________ > >> >> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> >> > > >> >> > > > ________________________________________________________________________ > >> >> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> >> > >> >> > > ________________________________________________________________________ > >> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> >> > >> >> > >> >> > > ________________________________________________________________________ > >> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> >> > >> >> > > ________________________________________________________________________ > >> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> >> > >> >> > >> >> > > ________________________________________________________________________ > >> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> >> > >> >> > > ________________________________________________________________________ > >> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> > > >> > ________________________________________________________________________ > >> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >> > >> ________________________________________________________________________ > >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > ________________________________________________________________________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
