It's 1.3. I saw the earlier thread about MVStore disk space, which is a concern because the data inflation in PageStore is already very large. I posted an example some months ago. I have a branch that will put the larger items into the java port of leveldb to avoid this inflation, but leveldb has other problems that make it unusable in my app (in particular it opens more file descriptors than many OS will allow w/o mucking with system settings).
On Wednesday, June 4, 2014 11:50:03 AM UTC-7, Thomas Mueller wrote: > > Hi, > > What version of H2 did you use to create the database? With version 1.3.x > (using the PageStore), LOG=0 it is unstable as documented. > > Version 1.4.x (using the MVStore) on the other hand is known to use more > disk space right now, this will be improved in future versions. > > Regards, > Thomas > > On Tuesday, June 3, 2014, Brian Craft <craft...@gmail.com <javascript:>> > wrote: > >> Running a recovery, the resulting db file is 5x larger, and still growing. >> >> I just had a bulk load deadlock. I'm not sure how to interrupt these >> things, but started with kill -INT, then kill -SEGV, then kill -KILL. After >> that the db could not be opened, and would dump a bunch of lines like this >> into the trace: >> >> org.h2.jdbc.JdbcSQLException: Table "PROBEMAP_PROBES" not found; SQL >> statement: >> CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_E9 ON PUBLIC.PROBEMAP_PROBES(ID) >> [42102-175] >> 06-02 16:17:52 database: CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_E9 ON >> PUBLIC.PROBEMAP_PROBES(ID) >> >> >> I ran the recovery tool with >> >> java -cp ~/.m2/repository/com/h2database/h2/1.3.175/h2-1.3.175.jar >> org.h2.tools.Recover >> >> which generated a sql file that was 1.25x the size of the db file. I then >> loaded the script into a fresh db file with >> >> java -cp ~/.m2/repository/com/h2database/h2/1.3.175/h2-1.3.175.jar >> org.h2.tools.RunScript -url "jdbc:h2:recovered" -user '' -script >> cavm-testing.h2.sql >> >> which at the moment is more than 5x larger than the original db file. >> It's fairly remarkable. I may have to kill it. >> >> Any idea what would cause this, or if there's a way to prevent it? >> >> During the load which deadlocked the url was >> "cavm-testing;CACHE_SIZE=65536;UNDO_LOG=1;LOG=0;MVCC=TRUE" >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to h2-database+unsubscr...@googlegroups.com. >> To post to this group, send email to h2-database@googlegroups.com. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
