Michigan State University

Apache Tomcat/7.0.52 (Ubuntu) - Error report

HTTP Status 500 - javax.servlet.ServletException: javax.servlet.jsp.JspException:


type Exception report

message javax.servlet.ServletException: javax.servlet.jsp.JspException:

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: 
        	SELECT DISTINCT
            	b.id,
				b.brand
			FROM
				pieces p
			LEFT JOIN
				brand b on p.brand = b.id
			LEFT JOIN
				subcollectionLink sl on sl.piece = p.id
			WHERE
				sl.subcollection = 3
            AND
            	b.brand like ?
			AND
				b.brand is not NULL
			ORDER BY
				b.brand
			
		: No operations allowed after connection closed.
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

root cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: 
        	SELECT DISTINCT
            	b.id,
				b.brand
			FROM
				pieces p
			LEFT JOIN
				brand b on p.brand = b.id
			LEFT JOIN
				subcollectionLink sl on sl.piece = p.id
			WHERE
				sl.subcollection = 3
            AND
            	b.brand like ?
			AND
				b.brand is not NULL
			ORDER BY
				b.brand
			
		: No operations allowed after connection closed.
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)
	org.apache.jsp.exhibits.sliker.beverages_jsp._jspService(beverages_jsp.java:717)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
	sun.reflect.GeneratedConstructorAccessor42.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	com.mysql.jdbc.Util.getInstance(Util.java:386)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
	com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1311)
	com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1303)
	com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4530)
	com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4495)
	com.mysql.jdbc.LoadBalancedMySQLConnection.prepareStatement(LoadBalancedMySQLConnection.java:2204)
	sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	com.mysql.jdbc.LoadBalancingConnectionProxy.invoke(LoadBalancingConnectionProxy.java:643)
	com.mysql.jdbc.FailoverConnectionProxy.invoke(FailoverConnectionProxy.java:136)
	com.sun.proxy.$Proxy4.prepareStatement(Unknown Source)
	org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
	org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:222)
	org.apache.jsp.exhibits.sliker.beverages_jsp._jspx_meth_sql_005fquery_005f2(beverages_jsp.java:1653)
	org.apache.jsp.exhibits.sliker.beverages_jsp._jspx_meth_c_005fotherwise_005f2(beverages_jsp.java:1580)
	org.apache.jsp.exhibits.sliker.beverages_jsp._jspx_meth_c_005fchoose_005f3(beverages_jsp.java:1323)
	org.apache.jsp.exhibits.sliker.beverages_jsp._jspService(beverages_jsp.java:590)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

root cause

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 25,067,317 milliseconds ago.  The last packet sent successfully to the server was 25,067,318 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
	sun.reflect.GeneratedConstructorAccessor44.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1129)
	com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3988)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2598)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
	com.mysql.jdbc.LoadBalancedMySQLConnection.execSQL(LoadBalancedMySQLConnection.java:158)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313)
	org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:224)
	org.apache.jsp.exhibits.sliker.keytermpieces_jsp._jspx_meth_sql_005fquery_005f0(keytermpieces_jsp.java:833)
	org.apache.jsp.exhibits.sliker.keytermpieces_jsp._jspService(keytermpieces_jsp.java:550)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

root cause

java.net.SocketException: Broken pipe
	java.net.SocketOutputStream.socketWrite0(Native Method)
	java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
	java.net.SocketOutputStream.write(SocketOutputStream.java:159)
	java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
	java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
	com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3969)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2598)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
	com.mysql.jdbc.LoadBalancedMySQLConnection.execSQL(LoadBalancedMySQLConnection.java:158)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313)
	org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:224)
	org.apache.jsp.exhibits.sliker.keytermpieces_jsp._jspx_meth_sql_005fquery_005f0(keytermpieces_jsp.java:833)
	org.apache.jsp.exhibits.sliker.keytermpieces_jsp._jspService(keytermpieces_jsp.java:550)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.52 (Ubuntu) logs.


Apache Tomcat/7.0.52 (Ubuntu)