기술지원 문의

에러 로그 질문드립니다.
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부분을 확인해 보는 것이 좋켔네요. ^^