<div><br></div> <div><br></div> <div>8월 22, 2016 11:32:47 오전 org.apache.catalina.core.StandardWrapperValve invoke</div> <div>심각: Servlet.service() for servlet [appServlet] in context with path [/mstmIndex] threw exception [Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: </div> <div>### Error querying database.  Cause: java.sql.SQLException: Query execution was interrupted</div> <div>### The error may exist in file [E:\java\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp3\wtpwebapps\mstmIndex\WEB-INF\classes\com\mstmIndex\host\model\dao\def\MstmIndexMapper.xml]</div> <div>### The error may involve com.mstmIndex.host.model.dao.def.MstmIndexMapper.getCampDbFormInfo-Inline</div> <div>### The error occurred while setting parameters</div> <div>### SQL: SELECT *   FROM mCampaignDbInfo_Table   WHERE mCampaignNo=?</div> <div>### Cause: java.sql.SQLException: Query execution was interrupted</div> <div>; uncategorized SQLException for SQL []; SQL state [70100]; error code [1317]; Query execution was interrupted; nested exception is java.sql.SQLException: Query execution was interrupted] with root cause</div> <div>java.sql.SQLException: Query execution was interrupted</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1146)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:787)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at java.lang.reflect.Method.invoke(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.sun.proxy.$Proxy37.execute(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:59)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at java.lang.reflect.Method.invoke(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.sun.proxy.$Proxy28.selectOne(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:165)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:69)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.sun.proxy.$Proxy31.getCampDbFormInfo(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.mstmIndex.host.model.service.MstmIndexServiceImpl.getCampDbFormInfo(MstmIndexServiceImpl.java:48)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at com.mstmIndex.host.controller.MstmIndexController.mstmWebIntroPopProc(MstmIndexController.java:113)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at java.lang.reflect.Method.invoke(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2500)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2489)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)</div> <div><span class="Apple-tab-span" style="white-space:pre;"> </span>at java.lang.Thread.run(Unknown Source)</div> <div><br></div> <div><br></div> <div>회사 내 테스트용 서버에서는 잘 돌아 갔었는데 </div> <div><br></div> <div>이번에 외부에 서버를 셋팅 해서 돌려 보니 높은 확률로 저런 에러를 냅니다. </div> <div><br></div> <div>항상 에러가 나는것은 아니구요 거의 10번중 7,8번은 나옵니다. </div> <div><br></div> <div>구글링 해보니깐 보통은 mysql 드라이버 문제라고 하는데 드라이버도 구글링에서 보면 해결책이리고 제시되는 드라이버 버전을</div> <div><br></div> <div>사용 중입니다. </div> <div><br></div> <div>어떤 식으로 처리를 해야 할지... 고견이 있으시면 댓글 좀 부탁 드리겠습니다. </div> <div><br></div> <div><br></div>