Hi,
So far this is a one off event that occurred recently. A database was
created inside our application in embedded mode with a minimal set of
data and default database settings using version 1.1.15.
(I should disclose it has a patch for hacking in some full outer join
support - the one i emailed to the list a while ago - but at this
point that code will not have been executed and i cannot see how it
could be a contributing factor).
I have tried opening the database with our 1.1.15 and a vanilla 1.1.19
in console mode and it has the same error each time.
The database was not big (200kb), I tried deleting the index (no difference).
Recovering this particular database is not important, but preventing a
recurrence is. I have kept hold of the broken database files in case
they are helpful.
Please advise!
Mike
(stacktrace attached).
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
[ERROR]execute: Unhandled problem while performing request
[Sun 10:27:41]
[ERROR]org.h2.jdbc.JdbcSQLException: Out of memory. [90108-115]
at
org.h2.message.Message.getSQLException(Message.java:105)
at
org.h2.message.Message.convert(Message.java:266)
at
org.h2.engine.Database.openDatabase(Database.java:247)
at
org.h2.engine.Database.<init>(Database.java:215)
at
org.h2.engine.Engine.openSession(Engine.java:58)
at
org.h2.engine.Engine.openSession(Engine.java:140)
at
org.h2.engine.Engine.getSession(Engine.java:120)
at
org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
at
org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
at
org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at
org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at
org.h2.Driver.connect(Driver.java:58)
at
java.sql.DriverManager.getConnection(DriverManager.java:582)
at
java.sql.DriverManager.getConnection(DriverManager.java:185)
at
com.emanate5.sql.h2.H2$1.getConnection(H2.java:67)
at
com.emanate5.sql.Database.newConnection(Database.java:60)
at
com.emanate5.sql.Database.getConnection(Database.java:248)
at
com.emanate5.sql.Database.executeQuery(Database.java:320)
at
com.emanate5.etype.sql.StructTable.select(StructTable.java:261)
at
com.emanate5.etype.sql.StructTable.loadMany(StructTable.java:319)
at
com.emanate5.etype.sql.ReifiedTable.loadMany(ReifiedTable.java:39)
at
com.emanate5.etype.sql.ReifiedTable.loadMany(ReifiedTable.java:45)
at
com.emanate5.instance.registry.ModuleRegistry.load(ModuleRegistry.java:173)
at
com.emanate5.instance.installation.Instance$Control.connect(Instance.java:59)
at
com.emanate5.instance.installation.Instance$Control.startServing(Instance.java:95)
at
com.emanate5.instance.installation.InstallationHandler.startServing(InstallationHandler.java:59)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:597)
at
com.emanate5.etype.EMethod.invoke(EMethod.java:73)
at
com.emanate5.etype.EMethod.invokeHandle(EMethod.java:87)
at
com.emanate5.dynamic.xmlrpc.TimHandler.execute(TimHandler.java:39)
at
org.apache.xmlrpc.server.XmlRpcServerWorker.execute(XmlRpcServerWorker.java:43)
at
org.apache.xmlrpc.server.XmlRpcServer.execute(XmlRpcServer.java:83)
at
com.emanate5.dynamic.xmlrpc.TimServer.execute(TimServer.java:55)
at
com.emanate5.dynamic.xmlrpc.TimServer.execute(TimServer.java:37)
at
com.emanate5.installation.EmanateXmlrpcServlet.doPost(EmanateXmlrpcServlet.java:68)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at
com.emanate5.etype.EmanateServlet.service_(EmanateServlet.java:53)
at
com.emanate5.etype.EmanateServlet.service(EmanateServlet.java:22)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
com.emanate5.installation.InstanceMasterServlet.dispatch(InstanceMasterServlet.java:92)
at
com.emanate5.installation.InstanceMasterServlet.service(InstanceMasterServlet.java:46)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
com.emanate5.installation.ServletHandler.handle(ServletHandler.java:60)
at
org.mortbay.jetty.handler.HandlerList.handle(HandlerList.java:49)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at
org.mortbay.jetty.Server.handle(Server.java:324)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)
at
org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:741)
at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:213)
at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:403)
at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
at
org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:522)
Caused by:
java.lang.OutOfMemoryError: Java heap space
at
org.h2.util.IntArray.checkCapacity(IntArray.java:74)
at
org.h2.util.IntArray.add(IntArray.java:42)
at
org.h2.store.DiskFile.setBlockCount(DiskFile.java:163)
at
org.h2.store.DiskFile.setUnused(DiskFile.java:671)
at
org.h2.store.DiskFile.init(DiskFile.java:409)
at
org.h2.engine.Database.open(Database.java:592)
at
org.h2.engine.Database.openDatabase(Database.java:220)
at
org.h2.engine.Database.<init>(Database.java:215)
at
org.h2.engine.Engine.openSession(Engine.java:58)
at
org.h2.engine.Engine.openSession(Engine.java:140)
at
org.h2.engine.Engine.getSession(Engine.java:120)
at
org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
at
org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
at
org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at
org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at
org.h2.Driver.connect(Driver.java:58)
at
java.sql.DriverManager.getConnection(DriverManager.java:582)
at
java.sql.DriverManager.getConnection(DriverManager.java:185)
at
com.emanate5.sql.h2.H2$1.getConnection(H2.java:67)
at
com.emanate5.sql.Database.newConnection(Database.java:60)
at
com.emanate5.sql.Database.getConnection(Database.java:248)
at
com.emanate5.sql.Database.executeQuery(Database.java:320)
at
com.emanate5.etype.sql.StructTable.select(StructTable.java:261)
at
com.emanate5.etype.sql.StructTable.loadMany(StructTable.java:319)
at
com.emanate5.etype.sql.ReifiedTable.loadMany(ReifiedTable.java:39)
at
com.emanate5.etype.sql.ReifiedTable.loadMany(ReifiedTable.java:45)
at
com.emanate5.instance.registry.ModuleRegistry.load(ModuleRegistry.java:173)
at
com.emanate5.instance.installation.Instance$Control.connect(Instance.java:59)
at
com.emanate5.instance.installation.Instance$Control.startServing(Instance.java:95)
at
com.emanate5.instance.installation.InstallationHandler.startServing(InstallationHandler.java:59)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
