Re: Witango-Talk: Alan

Robert Garcia Wed, 02 Feb 2005 19:31:39 -0800

I don't know if this helps, but I have found witango 5 stablity can have everything to do with your datasource. Check for updates in your odbc driver and check with your datasource vendor.

For instance, I use primebase as my dbms, and had occasional crashes, and noticed it happened when it was opening connections. I also found that if I increased the datasource life to something like 12 hours, it got much more stable, but took up a ton of connections. Also, I developed a system for a client on there machines, and I had witango set up identically, but connecting to MS SQL 2000. It has never crashed, and is loaded similarly.

So I started sending odbc tracelogs to primebase and they found issues in there odbc/connection lib that allowed to threads to step on each other. Since witango opens the odbc conn in its own memory space, it causes witango to crash.

Download the SQL Server developer edition, see if the problem still exists. Then you know it is your DBMS, and not witango. Another way to test, make your dslife 0, so they don't cache at all, if there is a problem with the odbc connection like mine, it will go down faster than a cheap hooker. :-)

I have found that if witango is connected to a bug free( or close to it ) ds, it is incredibly stable. (since 5.01.065).

Also, check any other external function or things that may be running within the witango memory space to eliminate them first.

I read that 5.5 has rewritten the code for connecting to ds, maybe they do better exception handling and it won't crash as much, even with a buggy ds.

-- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Paradise, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Feb 1, 2005, at 9:42 AM, Alan Wolfe wrote:

We started to get unstable again and defragged and that helped some but not completely.

I talked to my buddy who helped us out last time trying to jog his memory and then luckily he remembered. We also did a scandisk, setting it to auto-repair anything it finds.

Who knows why, but after clearing up some space on the disk, scandisking and defragging, we are very stable again.
----- Original Message -----
From: "Alan Wolfe" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, December 02, 2004 4:01 PM
Subject: Re: Witango-Talk: Alan
Actualy yes, the defrag seemed to help alot. this was right after we defragged and i dont think we had rebooted or given much time to see if it improved any.
----- Original Message -----
From: "Peter Ternstr�m" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, December 02, 2004 3:52 PM
S
Alan,
you seem to have the exact same problem as I have, a really unstable
server.
My symptoms are the exact same. Did you manage to solve this issue
somehow?
Peter
On 04/06/2004, at 1:57 AM, Alan Wolfe wrote:
over the past week and a half for some reason witango and/or IIS has become really unstable, and we've had to restart witango a handful of times per day because it stopped responding. It seems too that the server is less responsive than it used to be.

the hard drive was fairly fragmented so we defragged and that helped a little with responsiveness but it's still not like it used to be and still unstable.

in the witango log, about half the time we have these crashes, theres
a
message about an expired user right before the crash, as the last
entry in
the log file:
[Expired] Variables for key [EMAIL PROTECTED]
not sure if thats triggering the crashes or coincidence.
also in the witango events log we have messages like this peppered
here and
there but have had these all along so not sure if it's related:
[ 3352] 2004-06-03 08:19:26 RUNTIME FATAL The "" application file, action "NULL", caused an unrecoverable OS exception [ 3352] 2004-06-03 08:19:26 RUNTIME FATAL System Exception at 0043e42a; Thread ID=3428; Code=EXCEPTION_ACCESS_VIOLATION Read: 00000118; [ 3352] 2004-06-03 08:19:26 RUNTIME FATAL System Exception at 0043e42a; Thread ID=3428; Stack: 00000000 00e5f4a0 0047de18 00e5f6e4 0041b788 00e5f500 00e5f540 00e5f554 00e5f53c 00e5f700 00e5f530
00a0d2f0
00a6e830 00e5f534 00000004 77f89570 ffffffff 00000000 77bbbb26
00360000
00a6bf78 00000002 00000020 0000f544 00000000 00e5f2f4 77bbbb70
00a6e5e8
77f45a34 00000010 ff00ffff 00360000 00e5f310 00360000 00e5f588
77f45a34
77f89570 00e5f5f8 00000000 77f47c00 009e1318 77f46700 00360700
005749f4
00000000 00000000 00000000 77bbbb00 00575040 00a6e8cc 00a6bf78
00a6bf78
00000000 00000010 77bb0000 00000001 00a6bf79 00000002 00000000
00e5f558
00000000 00e5f5f0 77bc4d50 77ba20f8 ffffffff 77bbbe90 00000020
00000000
00000002 00000000 00e5f678 00408b42 00000000 00a6e2d8 00e5f5fc
00a6e838
00408881 00e5f678 00a6e2d8 00360000 00e5f678 00000004 00013ed5
00e5f544
00a6e2d8 00e5f630 77f45a34 77f89458 ffffff00 77f467f9 77bbb9be
00360000
00000000 00000004 00000000 00e5f6d8 0000000e 004538a1 00a6e2d0
00a6bf78
00e5f724 00000020 0000f64c 00360000 00e5f430 77ba20c0 00e5f6a8
77f45a34
77f89570 ffffffff 77f473f3 77bbbb26 00360000 00000000 00000011
00000000
00e5f6b8 00000000 00a6e8cc 77bbbb70 77bbbe90 00a6e8cc 00000011
00a6e8cc
00000000 00e5f600 00a6c538 005749f4
We havent changed any witango code or software on the machine, this is coming just out of the blue it seems.
anyone have any idea what might cause this?
We are on windows 2003 server using witango 5.0.1.065, oterro (r:base) 2.6.00.03 and IIS.

Thank you for any help!
----- 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

--

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Paradise, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Alan

Reply via email to