| ERROR | org.springframework.dao.DataAccessResourceFailureException: ### Error querying database. Cause: java.sql.SQLException: I/O Error: Read timed out ### The error may exist in file [F:\hmpg_new_project\WEB-INF\classes\egovframework\sqlmap\mappers\mssql\AsaproSite_SQL_mssql.xml] ### The error may involve egovframework.com.asapro.site.service.SiteMapper.selectSiteList-Inline ### The error occurred while setting parameters ### SQL: SELECT SI.SITE_ID , SI.SITE_NAME , SI.SITE_DESCRIPTION , SI.SITE_DOMAIN , SI.SITE_TYPE , SI.SITE_THEME , SI.SITE_MAIN , SI.SITE_LOCALE , SI.SITE_LOGO , SI.SITE_REGDATE , FI.FILE_ID , FI.MEMBER_ID , FI.FILE_MODULE , FI.FILE_MODULE_ID , FI.FILE_MODULE_SUB , FI.FILE_MODULE_SUB_ID , FI.FILE_ORIGINAL_NAME , FI.FILE_PATH , FI.FILE_THUMBNAIL_PATH , FI.FILE_EXT , FI.FILE_MIME_TYPE , FI.FILE_MEDIA_TYPE , FI.FILE_SIZE , FI.FILE_REGDATE , FI.FILE_ALT_TEXT , FI.FILE_DOWNLOAD_COUNT , FI.FILE_UUID , FI.FILE_ORI_IMAGE_WIDTH , FI.FILE_ORI_IMAGE_HEIGHT , FI.FILE_ATTACHMENT_TYPE , FI.FILE_SERVLET_URL , FI.FILE_SERVLET_THUMBNAIL_URL FROM ASA_SITE SI LEFT OUTER JOIN ASA_FILEINFO FI ON SI.SITE_LOGO = FI.FILE_ID ORDER BY SITE_MAIN DESC, SITE_ID ASC ### Cause: java.sql.SQLException: I/O Error: Read timed out ; SQL []; I/O Error: Read timed out; nested exception is java.sql.SQLException: I/O Error: Read timed out |
|---|---|
| MESSAGE | ### Error querying database. Cause: java.sql.SQLException: I/O Error: Read timed out ### The error may exist in file [F:\hmpg_new_project\WEB-INF\classes\egovframework\sqlmap\mappers\mssql\AsaproSite_SQL_mssql.xml] ### The error may involve egovframework.com.asapro.site.service.SiteMapper.selectSiteList-Inline ### The error occurred while setting parameters ### SQL: SELECT SI.SITE_ID , SI.SITE_NAME , SI.SITE_DESCRIPTION , SI.SITE_DOMAIN , SI.SITE_TYPE , SI.SITE_THEME , SI.SITE_MAIN , SI.SITE_LOCALE , SI.SITE_LOGO , SI.SITE_REGDATE , FI.FILE_ID , FI.MEMBER_ID , FI.FILE_MODULE , FI.FILE_MODULE_ID , FI.FILE_MODULE_SUB , FI.FILE_MODULE_SUB_ID , FI.FILE_ORIGINAL_NAME , FI.FILE_PATH , FI.FILE_THUMBNAIL_PATH , FI.FILE_EXT , FI.FILE_MIME_TYPE , FI.FILE_MEDIA_TYPE , FI.FILE_SIZE , FI.FILE_REGDATE , FI.FILE_ALT_TEXT , FI.FILE_DOWNLOAD_COUNT , FI.FILE_UUID , FI.FILE_ORI_IMAGE_WIDTH , FI.FILE_ORI_IMAGE_HEIGHT , FI.FILE_ATTACHMENT_TYPE , FI.FILE_SERVLET_URL , FI.FILE_SERVLET_THUMBNAIL_URL FROM ASA_SITE SI LEFT OUTER JOIN ASA_FILEINFO FI ON SI.SITE_LOGO = FI.FILE_ID ORDER BY SITE_MAIN DESC, SITE_ID ASC ### Cause: java.sql.SQLException: I/O Error: Read timed out ; SQL []; I/O Error: Read timed out; nested exception is java.sql.SQLException: I/O Error: Read timed out |
| REQUEST_URI | /site/ksawork/content/sub01_04 |
| STATUS_CODE | 200 |
| STACKTRACE |
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:105) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) com.sun.proxy.$Proxy161.selectList(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) com.sun.proxy.$Proxy231.selectSiteList(Unknown Source) egovframework.com.asapro.site.service.impl.SiteServiceImpl.getSiteList(SiteServiceImpl.java:57) egovframework.com.asapro.site.service.impl.SiteServiceImpl.detectCurrentSite(SiteServiceImpl.java:398) jdk.internal.reflect.GeneratedMethodAccessor387.invoke(Unknown Source) java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.base/java.lang.reflect.Method.invoke(Method.java:566) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:267) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:58) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) com.sun.proxy.$Proxy232.detectCurrentSite(Unknown Source) egovframework.com.asapro.interceptor.SiteInterceptor.preHandle(SiteInterceptor.java:73) org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:130) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857) javax.servlet.http.HttpServlet.service(HttpServlet.java:670) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842) javax.servlet.http.HttpServlet.service(HttpServlet.java:779) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) egovframework.com.utl.wed.filter.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:25) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) egovframework.com.utl.wed.filter.CORSFilter.doFilter(CORSFilter.java:21) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) egovframework.com.asapro.support.filter.XSSFilter.doFilter(XSSFilter.java:40) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) org.springframework.web.multipart.support.MultipartFilter.doFilterInternal(MultipartFilter.java:118) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399) org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891) org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784) org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) java.base/java.lang.Thread.run(Thread.java:834) |