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 201066503051 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=181) java.sql.SQLException: Error writing file '/tmp/#sql5f5b_132be_c6b.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.products.ProductsXmlDataSource.getDataSourcesTreeWithOnes(ProductsXmlDataSource.java:547) at projects.asp.services.products.ProductsXmlDataSource.getXmlElement(ProductsXmlDataSource.java:356) 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 201066503051 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=181) java.sql.SQLException: Error writing file '/tmp/#sql5f5b_132be_c6b.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.products.ProductsXmlDataSource.getDataSourcesTreeWithOnes(ProductsXmlDataSource.java:547) at projects.asp.services.products.ProductsXmlDataSource.getXmlElement(ProductsXmlDataSource.java:356) 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 201066503051 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=181) java.sql.SQLException: Error writing file '/tmp/#sql5f5b_132be_c6b.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.products.ProductsXmlDataSource.getDataSourcesTreeWithOnes(ProductsXmlDataSource.java:547) at projects.asp.services.products.ProductsXmlDataSource.getXmlElement(ProductsXmlDataSource.java:356) 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.