1 Replies Last post: May 26, 2007 1:50 AM by Scott Hebert  
Scott Hebert Newbie 64 posts since
Sep 13, 2006
Currently Being Moderated

May 25, 2007 10:10 PM

HSQL Out of memory exception

Hi,

 

After re-starting our Tomcat server, we ran into a this error screen trying to log in:

 

 

Unexpected Error

 

Error message: ConnectionCallback; uncategorized SQLException for SQL []; SQL state S1000; error code 72; out of memory; nested exception is java.sql.SQLException: out of memory

Show stacktrace

 

org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state S1000; error code 72; out of memory; nested exception is java.sql.SQLException: out of memory

java.sql.SQLException: out of memory

     at org.hsqldb.jdbc.Util.throwError(Unknown Source)

     at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source)

     at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)

     at jetbrains.buildServer.serverSide.impl.query.GenericQuery.doExecuteQuery(GenericQuery.java:34)

     at jetbrains.buildServer.serverSide.impl.query.GenericQuery.execute(GenericQuery.java:28)

     at jetbrains.buildServer.serverSide.impl.query.CachingGenericQuery.access$001(CachingGenericQuery.java)

     at jetbrains.buildServer.serverSide.impl.query.CachingGenericQuery$1.execute(CachingGenericQuery.java:1)

     at jetbrains.buildServer.serverSide.impl.query.CachingGenericQuery.getCachedOrExecute(CachingGenericQuery.java:13)

     at jetbrains.buildServer.serverSide.impl.query.CachingGenericQuery.execute(CachingGenericQuery.java:11)

     at jetbrains.buildServer.serverSide.impl.query.GenericQuery$2.run(GenericQuery.java:1)

     at jetbrains.buildServer.serverSide.impl.DBFacade$15.doInConnection(DBFacade.java:1)

     at jetbrains.buildServer.serverSide.impl.DBFacade$16.doInConnection(DBFacade.java:1)

     at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:230)

     at jetbrains.buildServer.serverSide.impl.DBFacade._runSql(DBFacade.java:218)

     at jetbrains.buildServer.serverSide.impl.DBFacade.runSql(DBFacade.java:152)

     at jetbrains.buildServer.serverSide.impl.query.GenericQuery.execute(GenericQuery.java:26)

     at jetbrains.buildServer.serverSide.impl.query.CachingGenericQuery.access$201(CachingGenericQuery.java:2)

     at jetbrains.buildServer.serverSide.impl.query.CachingGenericQuery$3.execute(CachingGenericQuery.java:1)

     at jetbrains.buildServer.serverSide.impl.query.CachingGenericQuery.getCachedOrExecute(CachingGenericQuery.java:13)

     at jetbrains.buildServer.serverSide.impl.query.CachingGenericQuery.execute(CachingGenericQuery.java:22)

     at jetbrains.buildServer.serverSide.impl.UserModelImpl.findUserById(UserModelImpl.java:81)

     at jetbrains.buildServer.controllers.login.RememberMe.getUser(RememberMe.java:72)

     at jetbrains.buildServer.controllers.login.WebLoginModelImpl.loginFromRememberMeCookie(WebLoginModelImpl.java:88)

     at jetbrains.buildServer.controllers.login.WebLoginModelImpl.refreshLogin(WebLoginModelImpl.java:59)

     at jetbrains.buildServer.controllers.login.AuthorizedUserInterceptorImpl.isUserOk(AuthorizedUserInterceptorImpl.java:18)

     at jetbrains.buildServer.controllers.login.AuthorizedUserInterceptorImpl.preHandle(AuthorizedUserInterceptorImpl.java:40)

     at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:713)

     at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)

     at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)

     at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:348)

     at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

     at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

     at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

     at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

     at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

     at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

     at java.lang.Thread.run(Thread.java:595)

 

 

I've since increased the memory available to Tomcat to 1G.

 

We are running TC 1.2

 

Any idea on how to fix this?

 

Thanks,

 

Scott

 

Message was edited by:

        Scott Hebert

More Like This

  • Retrieving data ...