Hi, I forward the message Vishwa sent to me in private.
As documentd, the options LOG=0 and UNDO_LOG=0 can lead to corruption; specially when used together with MULTI_THREADED=1. Regards, Thomas ---------- Forwarded message ---------- From: Vishwanatha Sundarappa <[email protected]> Date: Tue, Mar 18, 2014 at 6:43 AM Subject: Private message regarding: [h2] java.lang.RuntimeException - 50000-175 To: [email protected] Hello Thomas, Thank you for your quick response. URL=jdbc:h2:tcp://localhost:9123/ingestion;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOG=0;UNDO_LOG=0;MODE=MYSQL I am loading around 100 tables and memory goes more than 150G. This error is not consistent, sometime throws for different tables too. I do not have full stack trace. I will add stack trace and send you full details If I get any. Thanks Vishwa On Monday, March 17, 2014 10:34:51 PM UTC-7, Thomas Mueller wrote: > > Hi, > > Could you tell us what database URL you are using, and post the complete > stack trace please? > > Regards, > Thomas > > > > On Tue, Mar 18, 2014 at 5:58 AM, Vishwanatha Sundarappa < > [email protected]> 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. >> > > -- 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.
