I've found that some stability can be had by increasing the datasourcelife towards 60 minutes. This value times out an unused datasource connection, which is the reciprocal event to the informational log entry that the server is creating a new connection. SQL server doesn't mind having connections open for weeks as far as I can tell, so the lower timeout values would only help DBMSes and drivers that might have memory leaking problems, or simply 'like' to be refreshed. The point here is that Witango should ultimately need to create fewer db connections (not necessarily simultaneously, but cumulative), and this in turn is a good thing. I can't explicitly say why, but the documentation about 5.5 states that the Data Source Pool has been improved for server optimization and performance. Obviously someone thought something needed to be done over 5.0.
And after all that, I'll just add that my servers open hundreds of datasource connections each day. There are currently 78 connections open to my SQL server right now and I do not experience the situation you are speaking of. Resetting the datasource, and save-as-ing your files, might shake out some corruption someplace. Robert -----Original Message----- From: Dave Machin [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 1:48 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: WiTango .65 unstable I didn't think it was an issue or related, but we get the following 'information' event hundreds of times per day: [ 3492] 2004-08-03 10:42:32 RUNTIME INFO No existing connection to the data source found, creating a new connection. DSN: odbc.ebay; User: administrator; It happens 20 or 30 times per hour. Is it an issue? ----- Original Message ----- From: "Jason Pamental" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 03, 2004 9:28 AM Subject: Re: Witango-Talk: WiTango .65 unstable Dave, This is also similar to what I've been experiencing with one of our clients. It seems to be DB-related, as I've been able to go through the 'last served' files each time, specifically set the deployment datasource and that has seemed to improve things dramatically. Not empirical evidence, but solid anecdotal I suppose... Jason On Aug 3, 2004, at 11:24 AM, Dave Machin wrote: > We've started having some troubling stability issues with WiTango .65 > on W2K SP4. > > Pages stop loading and it seems that WiTango is not responding. > Connections to IIS keep stacking up until we get about 260 connections > and eventually the page requests time out. IIS logs write code 500 > errors but the WiTango log is completely missing any entries for the > time until I kill and restart the process. The log entries prior to > the missing section seem completely normal. There are no errors in > the WiTango log and no events in the witangoevents.log file. WiTango > does not respond when asked to stop from Services and I have to kill > it using an application in order to restart it - at which point > everything seems fine for several hours or days. > > The server processor is not overly busy, but it isn't completely idle > either. During the outage the databases the applications talk to are > free of any blocks, so it doesn't seem that WiTango is waiting for > database response. The database is MS-SQL 2000, and the ODBC driver > is version 2000.85.1022.00. > > I'm at a bit of a loss as to what to even look at as to the possible > cause of the problem. Any idea what I should check? > > Dave Machin > > > E-Mail. [EMAIL PROTECTED] > Tel. 805.614.0123 x 30 > Address: 3201 Airpark Drive, Suite 104 > Santa Maria, CA > 93455âââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââââ > > ââââââÃÃSâÃPââÃâPÅNââà à âÃâââÃËÃ][ËâÃËââKÃ]Ë[Ã\â > âXZ[\â ËY -- ____________________________________________________________________ Jason Pamental, President [EMAIL PROTECTED] Bathysphere Digital Media Services, Inc. http://bathyspheredms.com ____________________________________________________________________ Tel: 401.490.6830 Fax: 401.490.6831 ________________________________________ A North American Distributor for Witango (http://www.witango.us) Rapid Web Application Development - XML Execution Engine ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________TUUCB t/wwaoodep/ii. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
