타입 예외 보고
메시지 행 [27]에서 [consult/consult/index.jsp]을(를) 처리하는 중 예외 발생
설명 서버가, 해당 요청을 충족시키지 못하게 하는 예기치 않은 조건을 맞닥뜨렸습니다.
예외
org.apache.jasper.JasperException: 행 [27]에서 [consult/consult/index.jsp]을(를) 처리하는 중 예외 발생 24: param.setSmember_fk(smember_fk); 25: 26: param.setOrderbyString(orderby); //정렬 배열 선언 27: ArrayList<CommonVO> list = cd.list(param); 28: int[] rowPageCount = cd.count(param); 29: 30: Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:610) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:489) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) XssFilter.doFilter(XssFilter.java:43) SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:41)
근본 원인 (root cause)
javax.servlet.ServletException: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the common.list-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Table './eulsung/consult' is marked as crashed and should be repaired org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:657) org.apache.jsp.consult.consult.index_jsp._jspService(index_jsp.java:1580) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) XssFilter.doFilter(XssFilter.java:43) SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:41)
근본 원인 (root cause)
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the common.list-InlineParameterMap. --- Check the statement (query failed). --- Cause: java.sql.SQLException: Table './eulsung/consult' is marked as crashed and should be repaired com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139) com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94) com.vizensoft.board.common.CommonDAO.list(CommonDAO.java:82) org.apache.jsp.consult.consult.index_jsp._jspService(index_jsp.java:284) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) XssFilter.doFilter(XssFilter.java:43) SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:41)
근본 원인 (root cause)
java.sql.SQLException: Table './eulsung/consult' is marked as crashed and should be repaired com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) com.mysql.jdbc.Connection.execSQL(Connection.java:3176) com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153) com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:794) org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168) com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185) com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221) com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189) com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139) com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94) com.vizensoft.board.common.CommonDAO.list(CommonDAO.java:82) org.apache.jsp.consult.consult.index_jsp._jspService(index_jsp.java:284) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) XssFilter.doFilter(XssFilter.java:43) SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:41)
비고 근본 원인(root cause)의 풀 스택 트레이스를, 서버 로그들에서 확인할 수 있습니다.