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]. 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.
