Apache Tomcat/6.0.20 - Error report

HTTP Status 500 -

type Exception report

message

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

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: !!!com.gr.SystemException:Exception while getting html from target container
nested exception:
!!!com.gr.SystemException:StandardXmlDataSource.getXmlElement: error while getting xml for xml data source with id 201048427366
nested exception:
!!!com.gr.data.DataServerException:IndexDataServer.search: error => 
nested exception:
!!!com.wildgroup.db.DBException:Exception while processing SQL statement: 
 CREATE TEMPORARY TABLE IF NOT EXISTS INDEX_ID_2(STEP integer not null, ID bigint(20) not null, key (STEP, ID)) TYPE=HEAP
 in context of factory: com.wildgroup.db.DBConnectionManager$DBConnectionPool, poolname:CMS, url:jdbc:mysql://192.168.1.2:3306/cms?useUnicode=true&characterEncoding=UTF8, maxconn:450, timeout:86400000
 connection info:Pooled connection (id=14)
java.sql.SQLException: Error writing file '/tmp/#sql6c9d_454be_35c55.frm' (Errcode: 28)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2298)
	at com.wildgroup.db.TPreparedQuery.rs(TPreparedQuery.java:164)
	at com.gr.data.IndexDataServer.search(IndexDataServer.java:413)
	at gene.indexer.SearchParameter.search(SearchParameter.java:266)
	at projects.asp.services.StandardXmlDataSource.searchChildren(StandardXmlDataSource.java:1407)
	at projects.asp.services.StandardXmlDataSource.searchChildren(StandardXmlDataSource.java:1372)
	at projects.asp.services.StandardXmlDataSource.getObjectsListFromCategory(StandardXmlDataSource.java:1178)
	at projects.asp.services.products.ProductsXmlDataSource.getXmlElement(ProductsXmlDataSource.java:362)
	at gene.transform.renderer.XslRenderer.genHtml(XslRenderer.java:162)
	at com.gr.cms.containers.OnlineContainersManager.getHtmlFromRenderable(OnlineContainersManager.java:406)
	at com.gr.cms.containers.OnlineContainersManager.getHtmlFromOnlineContainer(OnlineContainersManager.java:372)
	at com.gr.cms.containers.OnlineContainersManager.getFragmentHtml(OnlineContainersManager.java:350)
	at org.apache.jsp.modules.online.fragment_jsp._jspService(fragment_jsp.java:302)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
	at java.lang.Thread.run(Thread.java:745)

	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

javax.servlet.ServletException: !!!com.gr.SystemException:Exception while getting html from target container
nested exception:
!!!com.gr.SystemException:StandardXmlDataSource.getXmlElement: error while getting xml for xml data source with id 201048427366
nested exception:
!!!com.gr.data.DataServerException:IndexDataServer.search: error => 
nested exception:
!!!com.wildgroup.db.DBException:Exception while processing SQL statement: 
 CREATE TEMPORARY TABLE IF NOT EXISTS INDEX_ID_2(STEP integer not null, ID bigint(20) not null, key (STEP, ID)) TYPE=HEAP
 in context of factory: com.wildgroup.db.DBConnectionManager$DBConnectionPool, poolname:CMS, url:jdbc:mysql://192.168.1.2:3306/cms?useUnicode=true&characterEncoding=UTF8, maxconn:450, timeout:86400000
 connection info:Pooled connection (id=14)
java.sql.SQLException: Error writing file '/tmp/#sql6c9d_454be_35c55.frm' (Errcode: 28)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2298)
	at com.wildgroup.db.TPreparedQuery.rs(TPreparedQuery.java:164)
	at com.gr.data.IndexDataServer.search(IndexDataServer.java:413)
	at gene.indexer.SearchParameter.search(SearchParameter.java:266)
	at projects.asp.services.StandardXmlDataSource.searchChildren(StandardXmlDataSource.java:1407)
	at projects.asp.services.StandardXmlDataSource.searchChildren(StandardXmlDataSource.java:1372)
	at projects.asp.services.StandardXmlDataSource.getObjectsListFromCategory(StandardXmlDataSource.java:1178)
	at projects.asp.services.products.ProductsXmlDataSource.getXmlElement(ProductsXmlDataSource.java:362)
	at gene.transform.renderer.XslRenderer.genHtml(XslRenderer.java:162)
	at com.gr.cms.containers.OnlineContainersManager.getHtmlFromRenderable(OnlineContainersManager.java:406)
	at com.gr.cms.containers.OnlineContainersManager.getHtmlFromOnlineContainer(OnlineContainersManager.java:372)
	at com.gr.cms.containers.OnlineContainersManager.getFragmentHtml(OnlineContainersManager.java:350)
	at org.apache.jsp.modules.online.fragment_jsp._jspService(fragment_jsp.java:302)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
	at java.lang.Thread.run(Thread.java:745)

	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
	org.apache.jsp.modules.online.fragment_jsp._jspService(fragment_jsp.java:317)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

!!!com.gr.SystemException:Exception while getting html from target container
nested exception:
!!!com.gr.SystemException:StandardXmlDataSource.getXmlElement: error while getting xml for xml data source with id 201048427366
nested exception:
!!!com.gr.data.DataServerException:IndexDataServer.search: error => 
nested exception:
!!!com.wildgroup.db.DBException:Exception while processing SQL statement: 
 CREATE TEMPORARY TABLE IF NOT EXISTS INDEX_ID_2(STEP integer not null, ID bigint(20) not null, key (STEP, ID)) TYPE=HEAP
 in context of factory: com.wildgroup.db.DBConnectionManager$DBConnectionPool, poolname:CMS, url:jdbc:mysql://192.168.1.2:3306/cms?useUnicode=true&characterEncoding=UTF8, maxconn:450, timeout:86400000
 connection info:Pooled connection (id=14)
java.sql.SQLException: Error writing file '/tmp/#sql6c9d_454be_35c55.frm' (Errcode: 28)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2298)
	at com.wildgroup.db.TPreparedQuery.rs(TPreparedQuery.java:164)
	at com.gr.data.IndexDataServer.search(IndexDataServer.java:413)
	at gene.indexer.SearchParameter.search(SearchParameter.java:266)
	at projects.asp.services.StandardXmlDataSource.searchChildren(StandardXmlDataSource.java:1407)
	at projects.asp.services.StandardXmlDataSource.searchChildren(StandardXmlDataSource.java:1372)
	at projects.asp.services.StandardXmlDataSource.getObjectsListFromCategory(StandardXmlDataSource.java:1178)
	at projects.asp.services.products.ProductsXmlDataSource.getXmlElement(ProductsXmlDataSource.java:362)
	at gene.transform.renderer.XslRenderer.genHtml(XslRenderer.java:162)
	at com.gr.cms.containers.OnlineContainersManager.getHtmlFromRenderable(OnlineContainersManager.java:406)
	at com.gr.cms.containers.OnlineContainersManager.getHtmlFromOnlineContainer(OnlineContainersManager.java:372)
	at com.gr.cms.containers.OnlineContainersManager.getFragmentHtml(OnlineContainersManager.java:350)
	at org.apache.jsp.modules.online.fragment_jsp._jspService(fragment_jsp.java:302)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
	at java.lang.Thread.run(Thread.java:745)

	com.gr.cms.containers.OnlineContainersManager.getHtmlFromOnlineContainer(OnlineContainersManager.java:374)
	com.gr.cms.containers.OnlineContainersManager.getFragmentHtml(OnlineContainersManager.java:350)
	org.apache.jsp.modules.online.fragment_jsp._jspService(fragment_jsp.java:302)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

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