TourTrend GmbH, enziano
http://enziano.com/enz_publisher/rother.png

Apache Tomcat/6.0.39 - Error report

HTTP Status 500 - PreparedStatementCallback; SQL [SELECT AVG(rating) FROM rating WHERE connected_to_type=? AND connected_to_id=?]; Communications link failure


type Exception report

message PreparedStatementCallback; SQL [SELECT AVG(rating) FROM rating WHERE connected_to_type=? AND connected_to_id=?]; Communications link failure

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

exception

org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [SELECT AVG(rating) FROM rating WHERE connected_to_type=? AND connected_to_id=?]; Communications link failure

Last packet sent to the server was 1 ms ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 1 ms ago.
	org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:98)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:805)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:824)
	org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJdbcTemplate.java:159)
	climbmap.webservice.resources.AreaResource$5.mapRow(AreaResource.java:209)
	climbmap.webservice.resources.AreaResource$5.mapRow(AreaResource.java:204)
	org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93)
	org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60)
	org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:708)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:787)
	org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:227)
	org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:233)
	climbmap.webservice.resources.AreaResource.get(AreaResource.java:197)
	sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
	com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ObjectOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:258)
	com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
	com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
	com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
	com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
	com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
	com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
	com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
	com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
	com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
	com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
	com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
	com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	etm.contrib.integration.web.HttpRequestPerformanceFilter.doFilter(HttpRequestPerformanceFilter.java:74)

root cause

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 1 ms ago.
	sun.reflect.GeneratedConstructorAccessor63.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
	com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2985)
	com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
	org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:703)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:805)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:824)
	org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJdbcTemplate.java:159)
	climbmap.webservice.resources.AreaResource$5.mapRow(AreaResource.java:209)
	climbmap.webservice.resources.AreaResource$5.mapRow(AreaResource.java:204)
	org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93)
	org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60)
	org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:708)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:787)
	org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:227)
	org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:233)
	climbmap.webservice.resources.AreaResource.get(AreaResource.java:197)
	sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
	com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ObjectOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:258)
	com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
	com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
	com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
	com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
	com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
	com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
	com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
	com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
	com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
	com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
	com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
	com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	etm.contrib.integration.web.HttpRequestPerformanceFilter.doFilter(HttpRequestPerformanceFilter.java:74)

root cause

java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
	com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2431)
	com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)
	com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
	org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:703)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:805)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:824)
	org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJdbcTemplate.java:159)
	climbmap.webservice.resources.AreaResource$5.mapRow(AreaResource.java:209)
	climbmap.webservice.resources.AreaResource$5.mapRow(AreaResource.java:204)
	org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93)
	org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60)
	org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:708)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:787)
	org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:227)
	org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:233)
	climbmap.webservice.resources.AreaResource.get(AreaResource.java:197)
	sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
	com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ObjectOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:258)
	com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
	com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
	com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
	com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
	com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
	com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
	com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
	com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
	com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
	com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
	com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
	com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	etm.contrib.integration.web.HttpRequestPerformanceFilter.doFilter(HttpRequestPerformanceFilter.java:74)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.39 logs.


Apache Tomcat/6.0.39