Hi Eric, I don't use MySQL myself, but I would check out the Witango documentation on the "dataSourceLife" configuration variable.
Maybe Witango or the MySQL driver is having trouble interpreting when a previous Datasource connection has properly expired, or if it's still open and available. Setting the dataSourceLife=0 might be a good place to start. Although this can affect performance, I would be curious if this temporarily fixes things. Then slowly increase the timeout and see what happens. Hope this helps a little. Cheers.... Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community --------------------- XML-Extranet - http://xml-extra.net 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) --------------------- > -----Original Message----- > From: Eric Pridham [mailto:[EMAIL PROTECTED] > Sent: Monday, August 18, 2003 3:09 PM > To: [EMAIL PROTECTED] > Subject: Re: Witango-Talk: Server Errors > > > It seems to definitely be an issue with Witango and MySQL. Tango > scripts that do not hit a datasource run without problems. > > I do not have any logging on MySQL that I can tell. However, I did > notice something that may shed some light on the issue. I have > phpMyAdmin installed, and it shows active processes connected to the > database. When I do the initial query a process appears on the list > with the status "Sleep" which seems to stick around indefinitely. I > attempted to kill the process and now the process has the status > "Killed" but still shows up on the process list (with an > ever-increasing "Time" value). > > My thought is that there is some persistent connection that > Witango is > holding on to that is interfering with all subsequent DB > actions (which > might also explain the timeout when I try to stop the Witango > Server 5 > service). > > I restarted the MySQL service and checked the active > processes again, > and the ghost process was gone. However, the tango scripts > still would > not work. And, again, attempting to restart the Witango > service hangs, > forcing me to reboot the server. > > Weird. > > - Eric > > On Monday, August 18, 2003, at 01:11 PM, Bill Conlon wrote: > > > Is the problem between witango and IIS or witango and mySQL? Try to > > confirm that you can run any number of taf files that don't > hit the db. > > > > Do you have logging on in mysql? Maybe that will show the > source of > > the > > problem. > > > > What about a taf (DirectDBMS action) that doesn't hit > tables, but just > > performs a SQL action, e.g. SELECT NOW(); > > > > > >> Hello All, > >> > >> I'm new to the list, so excuse me if my question is a > repeat (although > >> a quick search of the archives turned up nothing about my issue). > >> > >> I have Witango 5.01.062 on a Windows 2000 machine running IIS and > >> MySQL > >> (and the latest MySQL ODBC drivers). > >> > >> Whenever I run a tango script that hits the database (I've > only tested > >> Search actions so far), the first ever action runs fine. Every > >> subsequent Search action fails with an "Unrecoverable OS Exception" > >> error being written to the Application log. This isn't > limited to a > >> single script, either. That is to say, I have a login > script that > >> does > >> a single search. The first time I run it, I log in fine. > From that > >> point on, every tango script that has a Search action, > including that > >> login script, fails. > >> > >> Also, when I then try to do a Stop/Start on the Witango 5 > service, the > >> Stop fails saying that it was unable to successfully stop > the service > >> "in a timely fashion" (and then it no longer gives me the option to > >> stop or start). I am forced to reboot the server for it to start > >> working again. > >> > >> Any ideas, or at least any pointers on where I should look > if this is > >> already covered in some documentation that I might've missed? > >> > >> Thanks. > >> > >> - Eric > >> > >> Wow Pages, Inc. > >> http://www.wowpages.com/ > >> > >> > >> > ______________________________________________________________ > ________ > >> __ > >> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > >> > > > > > > Bill Conlon > > > > To the Point > > 345 California Avenue Suite 2 > > Palo Alto, CA 94306 > > > > office: 650.327.2175 > > fax: 650.329.8335 > > mobile: 650.906.9929 > > e-mail: mailto:[EMAIL PROTECTED] > > web: http://www.tothept.com > > > > > > > ______________________________________________________________ > _________ > > _ > > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > > Wow Pages, Inc. > http://www.wowpages.com/ > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
