HTTP 상태 500 – 내부 서버 오류


타입 예외 보고

메시지 행 [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)의 풀 스택 트레이스를, 서버 로그들에서 확인할 수 있습니다.


Apache Tomcat/9.0.52