* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.
|
|
Window7 32bit, Linux 64bit 등 |
|
|
[cubrid_rel] 수행 결과 |
|
|
[도움말]-[버전정보] 확인 |
|
|
java, php, odbc 등 입력 |
* CUBRID 응용 오류, SQL 오류 또는 SQL 튜닝 관련된 문의는 반드시 다음의 내용을 추가해 주세요. 비밀글이나 비밀 댓글도 가능합니다.
* 저희가 상황을 이해하고, 재현이 가능해야 알 수 있는 문제들이 많습니다. 가능한 정보/정황들을 부탁합니다.
| 에러 내용 및 재현 방법 | 재현 가능한 Source와 SQL |
| 관련 테이블(인덱스, 키정보 포함) 정보 | CUBRID 홈 디렉토리 아래 log 디렉토리 압축 |
-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------
Your transaction (index 15, NIFDSDB@nifds_db|16927) timed out waiting on S_LOCK lock on instance 1|471|91 of class tb_cmn_brd_data. You are waiting for user(s) to finish.[CAS INFO-10.188.99.47:33000,43,16927],[SESSION-3857],[URL-jdbc:cubrid:10.188.99.47:33000:nifds:nifdsdb:********:?charSet=utf-8].
at cubrid.jdbc.jci.UConnection.createJciException(UConnection.java:2196)
at cubrid.jdbc.jci.UInputBuffer.<init>(UInputBuffer.java:112)
at cubrid.jdbc.jci.UConnection.send_recv_msg(UConnection.java:1769)
at cubrid.jdbc.jci.UConnection.send_recv_msg(UConnection.java:1781)
at cubrid.jdbc.jci.UStatement.executeInternal(UStatement.java:782)
at cubrid.jdbc.jci.UStatement.execute(UStatement.java:849)
at cubrid.jdbc.driver.CUBRIDStatement.executeCoreInternal(CUBRIDStatement.java:906)
at cubrid.jdbc.driver.CUBRIDStatement.executeCore(CUBRIDStatement.java:871)
at cubrid.jdbc.driver.CUBRIDPreparedStatement.execute(CUBRIDPreparedStatement.java:486)
at core.log.impl.PreparedStatementLoggable.execute(PreparedStatementLoggable.java:109)
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at core.log.aop.handler.DaoInfo.doAround(DaoInfo.java:97)
at core.log.aop.reflection.profiler.AroundProfiler.invoke(AroundProfiler.java:19)
at com.sun.proxy.$Proxy71.execute(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at com.elevizer.j2ee.agent.jdbc.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:133)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
at egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:296)
at egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
at egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
at egovframework.rte.psl.dataaccess.EgovAbstractDAO.list(EgovAbstractDAO.java:226)
at egovframework.cms.brd.service.impl.BoardDataDAO.list(BoardDataDAO.java:66)
at egovframework.cms.brd.service.impl.BoardDataServiceImpl.getList(BoardDataServiceImpl.java:71)
at egovframework.cms.brd.service.impl.BoardDataServiceImpl$$FastClassBySpringCGLIB$$15e6c702.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:651)
at egovframework.cms.brd.service.impl.BoardDataServiceImpl$$EnhancerBySpringCGLIB$$520257cd.getList(<generated>)
at egovframework.cms.main.web.MainController.index(MainController.java:145)
at sun.reflect.GeneratedMethodAccessor296.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:178)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:444)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:432)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:860)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:705)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:818)
at jeus.servlet.engine.ServletWrapper.executeServlet(ServletWrapper.java:242)
at jeus.servlet.filter.FilterChainImpl.internalDoFilter(FilterChainImpl.java:141)
at jeus.servlet.filter.FilterChainImpl.doFilter(FilterChainImpl.java:93)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at jeus.servlet.filter.FilterChainImpl.internalDoFilter(FilterChainImpl.java:124)
at jeus.servlet.filter.FilterChainImpl.doFilter(FilterChainImpl.java:93)
at jeus.servlet.engine.ServletWrapper.execute(ServletWrapper.java:204)
at jeus.servlet.engine.WebtobRequestProcessor.run(WebtobRequestProcessor.java:195)
이렇게 에러 로그가 나오는데 해결 방법을 모르겟습니다.
해결방법 있으시면 답변 부탁드립니다.
감사합니다.
