I have had a problem that sounds very similar many times (I don't learn very fast.) In all my cases, the problem was running the connection pool out of connections because I wasn't freeing the connections in c couple of places. The fact that it occurs when trying to insert something into the data base indicates that it is related to that activity.
----- Original Message ----- From: "Hunter, Sandra" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Wednesday, May 28, 2003 1:48 PM Subject: RE: Tomcat STILL freezing - time to look at another app server? > I am not able to reproduce the problem reliably: that's what is making me > crazy. > It happens when things are being inserted to the database but never on the > same page, never everytime, doesn't matter what else I am doing or what else > has been done. No one else is accessing this database right now so I am the > only one and I have tested and retested all the sql. > I am stumped. > Hopefully running on the server will improve the situation. > You know, though, I am demoing the app for my client this afternoon so maybe > it is just a smelling fear thing. > Thanks for the feedback you guys. > > -----Original Message----- > From: Shapira, Yoav [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 28, 2003 8:35 AM > To: Tomcat Users List > Subject: RE: Tomcat STILL freezing - time to look at another app server? > > > Howdy, > That's unfortunate ;( I've had tough issues that appeared to be random > (like your network traffic hypothesis) and were very difficult to debug > ;( > > I've tried many many containers / app servers, and always come back to > tomcat. This was even before I started contributing to tomcat's > codebase, and is more true now than ever. > > So you are never able to reproduce the problem reliably? > > Yoav Shapira > Millennium ChemInformatics > > > >-----Original Message----- > >From: Hunter, Sandra [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, May 28, 2003 11:26 AM > >To: 'Tomcat Users List' > >Subject: Tomcat STILL freezing - time to look at another app server? > > > >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] > > > > > This e-mail, including any attachments, is a confidential business > communication, and may contain information that is confidential, proprietary > and/or privileged. This e-mail is intended only for the individual(s) to > whom it is addressed, and may not be saved, copied, printed, disclosed or > used by anyone else. If you are not the(an) intended recipient, please > immediately delete this e-mail from your computer system and notify the > sender. Thank you. > > > --------------------------------------------------------------------- > 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]
