thanks Noel, what does this exactly mean though? How do I know which transaction needs to be rolled back and how would I do that?
On Mar 14, 8:30 am, Noel Grandin <[email protected]> wrote: > that sounds like what happens where there is large transaction log with > open transactions that has to be rolled back. > > On 2012-03-14 04:06, david wrote: > > > > > > > > > Hello, > > > I have a 300 MB database which takes forever (forever=almost 40s) to > > open. I wonder why but can't really gain much information from the > > stack trace. On the FAQ it says I might find help here, so I hope > > somebody could give me a pointer of what to change. > > > Profiler: top 3 stack trace(s) of 38735 ms [build-161]: > > 3622/11017 (32%): > > at java.io.RandomAccessFile.readBytes(Native Method) > > at java.io.RandomAccessFile.read(Unknown Source) > > at org.h2.store.fs.FileDisk.read(FilePathDisk.java:422) > > at org.h2.store.fs.FileUtils.readFully(FileUtils.java:357) > > at org.h2.store.FileStore.readFully(FileStore.java:276) > > at org.h2.store.PageStore.readPage(PageStore.java:1260) > > at org.h2.store.PageStore.getPage(PageStore.java:712) > > at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:225) > > at org.h2.index.PageDataNode.getNextPage(PageDataNode.java:226) > > at org.h2.index.PageDataLeaf.getNextPage(PageDataLeaf.java:392) > > at org.h2.index.PageDataCursor.nextRow(PageDataCursor.java:90) > > at org.h2.index.PageDataCursor.next(PageDataCursor.java:49) > > at org.h2.table.RegularTable.addIndex(RegularTable.java:250) > > at org.h2.command.ddl.CreateIndex.update(CreateIndex.java:92) > > at org.h2.engine.MetaRecord.execute(MetaRecord.java:58) > > at org.h2.engine.Database.open(Database.java:605) > > at org.h2.engine.Database.openDatabase(Database.java:219) > > at org.h2.engine.Database.<init>(Database.java:214) > > at org.h2.engine.Engine.openSession(Engine.java:56) > > at org.h2.engine.Engine.openSession(Engine.java:159) > > at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138) > > at org.h2.engine.Engine.createSession(Engine.java:121) > > at org.h2.engine.Engine.createSession(Engine.java:28) > > at > > org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java: > > 285) > > 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:72) > > at org.h2.server.web.WebServer.getConnection(WebServer.java:644) > > at org.h2.server.web.WebApp.test(WebApp.java:839) > > at org.h2.server.web.WebApp.process(WebApp.java:215) > > at org.h2.server.web.WebApp.processRequest(WebApp.java:164) > > at org.h2.server.web.WebThread.process(WebThread.java:137) > > 1706/11017 (15%): > > at org.h2.table.Table.compareTypeSave(Table.java:1035) > > at org.h2.index.BaseIndex.compareValues(BaseIndex.java:244) > > at org.h2.index.BaseIndex.compareRows(BaseIndex.java:176) > > at org.h2.index.TreeIndex.add(TreeIndex.java:58) > > at org.h2.table.RegularTable.addRowsToIndex(RegularTable.java:327) > > at org.h2.table.RegularTable.addIndex(RegularTable.java:256) > > at org.h2.command.ddl.CreateIndex.update(CreateIndex.java:92) > > at org.h2.engine.MetaRecord.execute(MetaRecord.java:58) > > at org.h2.engine.Database.open(Database.java:605) > > at org.h2.engine.Database.openDatabase(Database.java:219) > > at org.h2.engine.Database.<init>(Database.java:214) > > at org.h2.engine.Engine.openSession(Engine.java:56) > > at org.h2.engine.Engine.openSession(Engine.java:159) > > at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138) > > at org.h2.engine.Engine.createSession(Engine.java:121) > > at org.h2.engine.Engine.createSession(Engine.java:28) > > at > > org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java: > > 285) > > 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:72) > > at org.h2.server.web.WebServer.getConnection(WebServer.java:644) > > at org.h2.server.web.WebApp.test(WebApp.java:839) > > at org.h2.server.web.WebApp.process(WebApp.java:215) > > at org.h2.server.web.WebApp.processRequest(WebApp.java:164) > > at org.h2.server.web.WebThread.process(WebThread.java:137) > > at org.h2.server.web.WebThread.run(WebThread.java:93) > > at java.lang.Thread.run(Unknown Source) > > 953/11017 (8%): > > at org.h2.table.Table.compareTypeSave(Table.java:1035) > > at org.h2.index.BaseIndex.compareValues(BaseIndex.java:244) > > at org.h2.index.BaseIndex.compareRows(BaseIndex.java:176) > > at org.h2.table.RegularTable$1.compare(RegularTable.java:323) > > at org.h2.table.RegularTable$1.compare(RegularTable.java:322) > > at java.util.Arrays.mergeSort(Unknown Source) > > at java.util.Arrays.sort(Unknown Source) > > at java.util.Collections.sort(Unknown Source) > > at org.h2.table.RegularTable.addRowsToIndex(RegularTable.java:321) > > at org.h2.table.RegularTable.addIndex(RegularTable.java:256) > > at org.h2.command.ddl.CreateIndex.update(CreateIndex.java:92) > > at org.h2.engine.MetaRecord.execute(MetaRecord.java:58) > > at org.h2.engine.Database.open(Database.java:605) > > at org.h2.engine.Database.openDatabase(Database.java:219) > > at org.h2.engine.Database.<init>(Database.java:214) > > at org.h2.engine.Engine.openSession(Engine.java:56) > > at org.h2.engine.Engine.openSession(Engine.java:159) > > at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138) > > at org.h2.engine.Engine.createSession(Engine.java:121) > > at org.h2.engine.Engine.createSession(Engine.java:28) > > at > > org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java: > > 285) > > 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:72) > > at org.h2.server.web.WebServer.getConnection(WebServer.java:644) > > at org.h2.server.web.WebApp.test(WebApp.java:839) > > at org.h2.server.web.WebApp.process(WebApp.java:215) > > at org.h2.server.web.WebApp.processRequest(WebApp.java:164) > > at org.h2.server.web.WebThread.process(WebThread.java:137) > > at org.h2.server.web.WebThread.run(WebThread.java:93) > > at java.lang.Thread.run(Unknown Source) > > packages: > > 37%: org.h2.store.fs > > 33%: org.h2.table > > 15%: org.h2.index > > . > > Profiler: top 3 stack trace(s) of 2 ms [build-161]: > > (none) > > packages: > > > Very kind regards, > > David -- 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.
