Sometimes my H2-based application takes a very long time to start up. This always occurs if the application was not shut down cleanly, but I've also seen it after what I thought was a clean shutdown.
Would increasing the cache size help? I am currently using the default value. Thread 7433: (state = IN_NATIVE) - java.io.RandomAccessFile.writeBytes(byte[], int, int) @bci=0 (Compiled frame; information may be imprecise) - java.io.RandomAccessFile.write(byte[], int, int) @bci=4, line=466 (Compiled frame) - org.h2.store.FileStore.write(byte[], int, int) @bci=96, line=331 (Compiled frame) - org.h2.store.DiskFile.writeBack(org.h2.util.CacheObject) @bci=115, line=880 (Compiled frame) - org.h2.util.CacheLRU.removeOld() @bci=173, line=125 (Compiled frame) - org.h2.util.CacheLRU.removeOldIfRequired() @bci=12, line=85 (Compiled frame) - org.h2.util.CacheLRU.put(org.h2.util.CacheObject) @bci=129, line=63 (Compiled frame) - org.h2.store.DiskFile.getRecord(org.h2.engine.Session, int, org.h2.store.RecordReader, int) @bci=351, line=601 (Compiled frame) - org.h2.store.Storage.getRecord(org.h2.engine.Session, int) @bci=14, line=94 (Compiled frame) - org.h2.index.BtreeIndex.getPage(org.h2.engine.Session, int) @bci=6, line=179 (Compiled frame) - org.h2.index.BtreeNode.add(org.h2.result.Row, org.h2.engine.Session) @bci=132, line=99 (Compiled frame) - org.h2.index.BtreeNode.add(org.h2.result.Row, org.h2.engine.Session) @bci=141, line=100 (Compiled frame) - org.h2.index.BtreeNode.add(org.h2.result.Row, org.h2.engine.Session) @bci=141, line=100 (Compiled frame) - org.h2.index.BtreeNode.add(org.h2.result.Row, org.h2.engine.Session) @bci=141, line=100 (Compiled frame) - org.h2.index.BtreeIndex.add(org.h2.engine.Session, org.h2.result.Row) @bci=80, line=221 (Compiled frame) - org.h2.table.TableData.addRowsToIndex(org.h2.engine.Session, org.h2.util.ObjectArray, org.h2.index.Index) @bci=55, line=260 (Compiled frame) - org.h2.table.TableData.addIndex(org.h2.engine.Session, java.lang.String, int, org.h2.table.IndexColumn[], org.h2.index.IndexType, int, java.lang.String) @bci=330, line=196 (Compiled frame) - org.h2.command.ddl.CreateIndex.update() @bci=247, line=90 (Interpreted frame) - org.h2.engine.MetaRecord.execute(org.h2.engine.Database, org.h2.engine.Session, org.h2.api.DatabaseEventListener) @bci=30, line=85 (Interpreted frame) - org.h2.engine.Database.open(int, int) @bci=1068, line=602 (Interpreted frame) - org.h2.engine.Database.<init>(java.lang.String, org.h2.engine.ConnectionInfo, java.lang.String) @bci=586, line=212 (Interpreted frame) - org.h2.engine.Engine.openSession(org.h2.engine.ConnectionInfo, boolean, java.lang.String) @bci=72, line=56 (Interpreted frame) - org.h2.engine.Engine.openSession(org.h2.engine.ConnectionInfo) @bci=30, line=125 (Interpreted frame) - org.h2.engine.Engine.getSession(org.h2.engine.ConnectionInfo) @bci=2, line=108 (Interpreted frame) - org.h2.engine.Session.createSession(org.h2.engine.ConnectionInfo) @bci=4, line=242 (Interpreted frame) - org.h2.jdbc.JdbcConnection.<init>(org.h2.engine.ConnectionInfo, boolean) @bci=106, line=115 (Interpreted frame) - org.h2.jdbc.JdbcConnection.<init>(java.lang.String, java.util.Properties) @bci=11, line=88 (Interpreted frame) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
