기술지원 문의
에러 로그 질문드립니다.
js / 2005-05-20 14:09
질문드립니다.. 다음과 같은 에러가 로그에 계속 차는데 무슨 문제인지요?
DB는 ORACLE 9i 입니다. 레진 버전은 resin-2.1.11 입니다.
좋은 하루 되세요..
---------- Exception Info ----------
java.sql.SQLException: ORA-00018: maximum number of sessions exceeded
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:259)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at com.caucho.sql.XADataSourceAdapter.getXAConnection(XADataSourceAdapter.java:119)
at com.caucho.sql.XADataSourceAdapter.getPooledConnection(XADataSourceAdapter.java:141)
at com.caucho.sql.DBPool.createConnection(DBPool.java:1421)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1347)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1201)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1175)
at clubenjoy.querymgr.QueryMgr.jProc(QueryMgr.java:239)
at clubenjoy.querymgr.QueryMgr.jProc(QueryMgr.java:199)
at _e_0picalbum._menu_0pic_0album__jsp._jspService(_menu_0pic_0album__jsp.java:217)
at com.caucho.jsp.JavaPage.service(JavaPage.java:44)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:115)
at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:222)
at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:103)
at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:80)
at com.caucho.jsp.QPageContext.forward(QPageContext.java:578)
at _e_0main._contents_0iframe__jsp._jspService(_contents_0iframe__jsp.java:223)
at com.caucho.jsp.JavaPage.service(JavaPage.java:44)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.http.filter.GzipFilter.doFilter(GzipFilter.java:128)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:346)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:534)
[답변]에러 로그 질문드립니다.
손님.. / 2005-05-23 09:33
ORA-00018: maximum number of sessions exceeded
- Cause: All session state objects are in use.
웹에서 검색을 해보니까. 이런 메시지를 확인할 수 있네요.
어플리케이션에서 DB connection 자원을 얻고, 사용한후, 반납이 안되는 현상이 발생하는 것 같네요.
connection 자원 close부분을 확인해 보는 것이 좋켔네요. ^^