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 = 2
        AND
          	b.brand like ?
				AND
					b.brand is not NULL
				AND
					(p.private = 0 OR p.private IS NULL)
			ORDER BY
				b.brand
			
		: The last packet successfully received from the server was 10,564,838 milliseconds ago.  The last packet sent successfully to the server was 10,564,838 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.
	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 = 2
        AND
          	b.brand like ?
				AND
					b.brand is not NULL
				AND
					(p.private = 0 OR p.private IS NULL)
			ORDER BY
				b.brand
			
		: The last packet successfully received from the server was 10,564,838 milliseconds ago.  The last packet sent successfully to the server was 10,564,838 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.
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)
	org.apache.jsp.exhibits.sliker.foods_jsp._jspService(foods_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.CommunicationsException: The last packet successfully received from the server was 10,564,838 milliseconds ago.  The last packet sent successfully to the server was 10,564,838 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.GeneratedConstructorAccessor45.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.foods_jsp._jspx_meth_sql_005fquery_005f2(foods_jsp.java:1656)
	org.apache.jsp.exhibits.sliker.foods_jsp._jspx_meth_c_005fotherwise_005f2(foods_jsp.java:1581)
	org.apache.jsp.exhibits.sliker.foods_jsp._jspx_meth_c_005fchoose_005f3(foods_jsp.java:1323)
	org.apache.jsp.exhibits.sliker.foods_jsp._jspService(foods_jsp.java:591)
	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.foods_jsp._jspx_meth_sql_005fquery_005f2(foods_jsp.java:1656)
	org.apache.jsp.exhibits.sliker.foods_jsp._jspx_meth_c_005fotherwise_005f2(foods_jsp.java:1581)
	org.apache.jsp.exhibits.sliker.foods_jsp._jspx_meth_c_005fchoose_005f3(foods_jsp.java:1323)
	org.apache.jsp.exhibits.sliker.foods_jsp._jspService(foods_jsp.java:591)
	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)