Well this issue continues. Code has been commented, logged, oracle permissions all tickety boo, no locks.
It really is intermittent, and in my opinion seems to be somewhat related to network traffic. I talked to one of the tech guys and he seemed to think I was nuts. It never happens at night or on the weekends when I am pretty much the only one on the network. Does that sound possible to any one with more experience than I? Although we moved it to the live server we had some install problems there and so I am still running off my dev machine. It is just a regular P4 with about 1600mhz and 256 ram. Do you think the freezing will cease when running off the server? And on the other subject: have any of you tried other app servers out there? Do you have any opinions? Tomcat seems to be the industry standard but if I can't resolve this freezing issue I might get some pressure to try some different technology. -----Original Message----- From: Hunter, Sandra [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2003 2:52 PM To: 'Tomcat Users List' Subject: RE: Tomcat Freezing? The lock may be an issue: I'll run that past our DBA but that's the only thing I haven't looked at. We have actually moved the app to another machine to see if that makes any difference. If anyone gets a bright idea I would love to hear it! Puzzled Sandra -----Original Message----- From: Jason Bainbridge [mailto:[EMAIL PROTECTED] Sent: Friday, May 16, 2003 12:11 PM To: Tomcat Users List Subject: Re: Tomcat Freezing? I'm running out of ideas myself... I gather this is quite a beefy machine you're running it on? Are you using the right version of the Oracle Thin Driver for the version of Oracle you are running? Have you got a DBA on site or are you able to look at the appropriate v$ view to see what query it died on and possibly why? It's not something like not releasing a lock on a record or commits not being on or something silly like that in the Oracle config? Jason On Sat, 17 May 2003 02:29 am, Hunter, Sandra wrote: > I spoke too soon. I am really stumped now. > Code that ran yesterday, won't run today. I have gone through it line by > line, commenting it all out, and then gradually adding in each line, and > then it runs again. Same code. No changes. > If I restart Tomcat the code will run. Sometimes. Other times not. > I have looked at the Tomcat logs and I don't see anything that tells me > anything. > There must be some common event that is causing this but I can't seem to > place it or find it. > It almost seems like the code needs a warm up run before it can really get > going. How weird is that? > Any idea what I should be looking for? > Besides a psychiatrist? > Sandra > > -----Original Message----- > From: Hunter, Sandra [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 15, 2003 3:29 PM > To: 'Tomcat Users List' > Subject: RE: Tomcat Freezing? > > Well it has stopped. I think I did have a code error: I was calling the > wrong statement for a resultset, so calling it twice. I have made such an > error before without causing such a crisis but I guess Tomcat had just had > enough of my foolishness. > It is so frustrating to not know why something is happening and I thought I > had done everything right but after doing it twice it got sorted out. > Thanks all! > Sandra > > -----Original Message----- > From: Jason Bainbridge [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 15, 2003 2:41 PM > To: Tomcat Users List > Subject: Re: Tomcat Freezing? > > I assume you are using the Oracle JDBC Thin drivers then? Just want to make > sure you aren't doing anything like using the JDBC-ODBC bridge but I doubt > it > just clutching at straws... > > Do the log files shine any info on the problem? (not your log messages but > the > Tomcat logs)? > > J. > > On Fri, 16 May 2003 05:28 am, Hunter, Sandra wrote: > > The queries all run in Oracle. > > Other pages with SQL queries all run fine. > > The privileges all allow for the SQL stuff I am doing which is very > > basic. I am going through the commenting process again and lines that ran > > fine half an hour ago with no changes made now seem to be stalling. > > Even when I close the app, Tomcat is still hung and I can't close it from > > the command line. > > I close all my resultsets and statements and connections. > > I could include all my code but there are thousands of lines and there > > seems to be no consistent line or lines that are causing the problem. > > > > -----Original Message----- > > From: George Sexton [mailto:[EMAIL PROTECTED] > > Sent: Thursday, May 15, 2003 2:10 PM > > To: Tomcat Users List > > Subject: RE: Tomcat Freezing? > > > > Have you looked at your database and made sure that you don't have > > blocking > > > issues keeping your queries from running? > > > > -----Original Message----- > > From: Hunter, Sandra [mailto:[EMAIL PROTECTED] > > Sent: Thursday, May 15, 2003 3:06 PM > > To: 'Tomcat Users List' > > Subject: RE: Tomcat Freezing? > > > > > > This freezing problem seems to be really intermittent. I am really > > stumped. > > > I have put in printlines every other line and commented out just about > > everything and then gradually added stuff and it will freeze at pretty > > (apparently) random places. It stopped doing it with one page (for no > > apparent reason) and now has started doing it with another. But it > > doesn't happen consistently. > > No applets, etc. Nothing fancy at all just straight ahead java and sql. > > I surely am confused. > > > > -----Original Message----- > > From: Bill Barker [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, May 14, 2003 10:40 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Tomcat Freezing? > > > > I second Matt's suggestions. If you are really stumped as to the > > problem, try inserting logging statements every few lines in your JSP (if > > you are not using a real logging package, such as log4j, Tomcat's default > > JSPPage class extends GenericServlet, so you can simply do something like > > <% log("Getting DB info"); %>). > > > > "Matt Wiseley" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > Sandra, > > > > If it's only happening with one JSP, and it happens every time it's > > requested, it's almost certainly a coding problem. Without looking at the > > source code, it's pretty hard to say what's causing it. From my own > > experience, I have seen only two coding errors that "hang" Tomcat. The > > first is opening database connections from a pool and not closing them. > > The > > > second is a page that forwards to itself somehow. Also look for code that > > creates an endless loop of some kind, although these usually either run > > out > > > of memory, cause an overflow, or time out. > > > > Matt > > > > > Being new and inexperienced as I am I don't know how to problem solve > > > this issue. > > > > > > I have a jsp app that I am running in Tomcat 4.0 with Apache 2 HTTP > > > > server > > > > > on a Win2k pro box. > > > > > > My apologies to those who receive this twice. Some weirdness with my > > > > address > > > > > book. > > > > > > All has been well until now. I have one page that is freezing: it > > doesn't > > > > complete loading after several minutes. When I try to shut down Tomcat > > it > > > > also doesn't do anything. It displays this message in the command line: > > > "Stopping service Tomcat-Standalone" but after several minutes the > > window > > > is > > > > > still open and the task manager tells me Tomcat is still running. I > > > have tried stopping tomcat,deleting all the files in the work folder > > > and restarting Tomcat. > > > > > > I know it must be something to do with the page, but I don't know where > > > to begin to look or what to look for. > > > > > > Any ideas? > > > > > > > > > > > > Sandra Patricia Hunter > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] -- Jason Bainbridge KDE Web Team - http://kde.org [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
