Hi, Could you try with the latest (beta) version of H2? I'm not sure if it's faster or slower, but it should be more stable with the multi-threaded option.
Regards, Thomas On Wednesday, March 19, 2014, Vishwanatha Sundarappa <[email protected]> wrote: > Thank you very much for your suggestion > > If I remove MULTI_THREADED, my server start up takes in few hours for > around 700M record of 150G. > Combination of LOG, UNDO_LOG and MULTI_THREADED, takes just 20-30mins. > > I need this H2 instance read only purpose, any alternative suggestion to > MULTI_THREADED? > > > > On Monday, March 17, 2014 9:58:54 PM UTC-7, Vishwanatha Sundarappa wrote: >> >> I am randomly getting RuntimeException when I am loading data through >> table link. (Note: loading multiple tables concurrently) >> I am using h2-1.3.175.jar and had issue with previous release too. >> >> Does anyone had issue? any help will be appreciated. >> >> General error: "java.lang.RuntimeException: old!=record pos:98472 >> old:page[98472] data leaf table:84 DIGIPLUG entries:14 parent:551 >> keys:[9889, 9890, 9891, 9892, 9893, 9894, 9895, 9896, 9897, 9898, 9899, >> 9900, 9901, 9902, 0] offsets:[2014, 1980, 1946, 1912, 1878, 1844, 1810, >> 1776, 1742, 1708, 1674, 1640, 1606, 1572, 0] new:page[98472] data leaf >> table:117 MATP entries:1 parent:565 keys:[6369, 0, 0, 0, 0] offsets:[2010, >> 0, 0, 0, 0]"; SQL statement: >> INSERT INTO matp(country_id , currency_code , component, configuration, >> music_type , icla_sales_channel , matp , start_date, end_date) select >> country_id, currency_code, component, configuration, music_type varchar, >> icla_sales_channel varchar, matp decimal, start_date, end_date from >> matp_link [50000-175] >> >> -- > 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 > [email protected]<javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to > [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> > . > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
