tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Seetha Rao" <s...@vertizone.net>
Subject Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted
Date Thu, 20 Jul 2006 18:34:34 GMT
Hi,

We are doing a test where mySQL server goes down when user is accessing a
webapplication.
We have setup tomcat with the required parameters for DBCP to handle such a
case.
It works fine in a set up where Tomcat and mySQL are on the same windows
machine.
But in a setup where Tomcat is on Windows machine connecting to mySQL
running on a linux machine, it does not work.

Here are the versions:

Tomcat 5.0
mySQL 4.1
Linux 2.6 Fedora

We have configured Tomcat with the following in our webapp xml file (I'm
pasting a part of it)

<parameter>
<name>validationQuery</name>
<value>select 1</value>
</parameter>

<parameter>
<name>testOnBorrow</name>
<value>true</value>
</parameter>

<parameter>
<name>testWhileIdle</name>
<value>true</value>
</parameter>

<parameter>
<name>timeBetweenEvictionRunsMillis</name>
<value>10000</value>
</parameter>

<parameter>
<name>minEvictableIdleTimeMillis</name>
<value>60000</value>
</parameter>

<parameter>
<name>url</name>
<value>jdbc:mysql://190.162.50.20:3306/xyz_office?autoReconnect=true</value>
</parameter>

Here is the test we are doing;
1. Enter the web application, do something which accesses the database
2. Stop mysql server and restart on linux
3. Try to do something in the web application
4. Tomcat gives the following exception

stdout.log

java.sql.SQLException: No operations allowed after statement closed.
This comes many many times, basically an overflow.

In the browser:

javax.servlet.ServletException: Servlet execution threw an exception

org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670
)
	org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:637)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:46)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
24)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:10
69)

org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProces
sor.java:455)

org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

This comes many many times, basically an overflow.

root cause

java.lang.StackOverflowError

org.apache.coyote.tomcat5.CoyoteRequest.getAttribute(CoyoteRequest.java:909)

org.apache.coyote.tomcat5.CoyoteRequestFacade.getAttribute(CoyoteRequestFaca
de.java:214)

Could anyone please give us some hints?

Thanks
Seetha


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message