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 ; error code ; 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 ; error code ; 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

1 comment

Seems like it is a HSQL corruption...I'm now moving to MySQL!

0

Please sign in to leave a comment.