Bergverlag Rother
http://enziano.com/enz_publisher/rother.png

Apache Tomcat/6.0.39 - Error report

HTTP Status 500 - PreparedStatementCallback; uncategorized SQLException for SQL [SELECT * from db.gen_poi JOIN (SELECT max(version) as maxv, gen_poi_id FROM (SELECT * from db.gen_poi WHERE language=? AND gen_poi_id IN ( 15662,15663,15664,15665,15666,15667) ) c1 GROUP BY gen_poi_id ) maxversions ON (db.gen_poi.gen_poi_id = maxversions.gen_poi_id AND gen_poi.version = maxversions.maxv) HAVING language=? ORDER BY geo_dist ASC]; SQL state [HY000]; error code [3]; Error writing file '/tmp/MYJSG9Hz' (Errcode: 28 - No space left on device); nested exception is java.sql.SQLException: Error writing file '/tmp/MYJSG9Hz' (Errcode: 28 - No space left on device)


type Exception report

message PreparedStatementCallback; uncategorized SQLException for SQL [SELECT * from db.gen_poi JOIN (SELECT max(version) as maxv, gen_poi_id FROM (SELECT * from db.gen_poi WHERE language=? AND gen_poi_id IN ( 15662,15663,15664,15665,15666,15667) ) c1 GROUP BY gen_poi_id ) maxversions ON (db.gen_poi.gen_poi_id = maxversions.gen_poi_id AND gen_poi.version = maxversions.maxv) HAVING language=? ORDER BY geo_dist ASC]; SQL state [HY000]; error code [3]; Error writing file '/tmp/MYJSG9Hz' (Errcode: 28 - No space left on device); nested exception is java.sql.SQLException: Error writing file '/tmp/MYJSG9Hz' (Errcode: 28 - No space left on device)

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

exception

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT * from db.gen_poi JOIN (SELECT max(version) as maxv, gen_poi_id FROM (SELECT * from db.gen_poi WHERE language=? AND gen_poi_id IN ( 15662,15663,15664,15665,15666,15667) ) c1 GROUP BY gen_poi_id ) maxversions ON (db.gen_poi.gen_poi_id = maxversions.gen_poi_id AND gen_poi.version = maxversions.maxv) HAVING language=? ORDER BY geo_dist ASC]; SQL state [HY000]; error code [3]; Error writing file '/tmp/MYJSG9Hz' (Errcode: 28 - No space left on device); nested exception is java.sql.SQLException: Error writing file '/tmp/MYJSG9Hz' (Errcode: 28 - No space left on device)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	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.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.TourResource.get(TourResource.java:300)
	sun.reflect.GeneratedMethodAccessor50.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.sql.SQLException: Error writing file '/tmp/MYJSG9Hz' (Errcode: 28 - No space left on device)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910)
	com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1405)
	com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2805)
	com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:467)
	com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2510)
	com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1746)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2135)
	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.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.TourResource.get(TourResource.java:300)
	sun.reflect.GeneratedMethodAccessor50.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


Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/www/live/application/../data/session) in Unknown on line 0