None of the queries in the log look unusual. We reran many of them and they all return fine. We did see a query timeout in the witango events log and the strange thing was that if we subtracted the timeout seconds from the timestamp of the event and looked back in the log we didn't find an entry for any query related to the application that timed out.
We're also getting INFO messages at what I would think to be an alarming rate saying 'no existing connection to the data source found, creating a new connection' - they're being written about 1 per second all the time. In fact, just now, WiTango was writing those message so quickly that I couldn't open the events log file... ----- Original Message ----- From: "Bill Conlon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 09, 2004 9:52 AM Subject: Re: Witango-Talk: URGENT: MS-SQL hanging - process non-yielding > Can you inspect the queries in the Witango.log to look for the deadlock? > > On Thursday, December 9, 2004, at 09:30 AM, Dave Machin wrote: > > > Has anyone seen the following situation: > > > > Once or twice a day our MS-SQL SP3 database server stops responding. > > All > > jobs on it hang and it is unresponsive to enterprise manager. WiTango > > locks > > up waiting on queries to return. The database log shows several > > occurences > > of the following error: > > > > Process 69:0 (6b0) UMS Context 0x0D37A8B0 appears to be non-yielding on > > Scheduler 2. > > Error: 17883, Severity: 1, State: 0 > > > > We've installed a recommended hotfix from Microsoft to no avail. > > > > When we kill the WiTango service the database comes back. > > > > Since we can't connect to the database during this time, I can't tell > > what > > the process ID mentioned in the error is - by the time we can get back > > in > > it's gone. Since killing WiTango seems to fix it, I'm assuming it's a > > WiTango query of some kind. > > > > We're running: W2K SP4, WiTango .065 with SQL Server ODBC driver > > version > > 2000.85.1022.00. Database is W2K SP3, MS-SQL SP3. > > > > Any help would be appreciated... > > > > Dave Machin > > > > > > _______________________________________________________________________ > > _ > > 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
