Re: Tomcat STILL freezing - time to look at another app server?

[John Turner]

Other things it might be: database server trying to log, thrashing on the 
db server, lack of an index, corrupted index, and the ever-popular DNS 
timeout.

John

On Wed, 28 May 2003 10:48:45 -0700, Hunter, Sandra 
<[EMAIL PROTECTED]> wrote:

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]



--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]