Hello! I am trying to load big table: 250 columns and 6 million lines in H2. It loads (or I think at least it is because the db is now 11.5GB), but It gives me always out of memory as soon as I try to make a query on it. I stopped my program andI tried to access the H2 database outside my own program and through the commandline tool and after 10-15minutes of waiting, I get this error:
SQL Exception: Allgemeiner Fehler: "java.lang.RuntimeException: old!=record pos: 516 old:page[516] data leaf table:0 SYS entries:1 parent:514 keys:[5] offsets:[1 947] new:page[516] data leaf table:8 LOBS entries:0 parent:0 keys:null offsets:n ull" General error: "java.lang.RuntimeException: old!=record pos:516 old:page[516] da ta leaf table:0 SYS entries:1 parent:514 keys:[5] offsets:[1947] new:page[516] d ata leaf table:8 LOBS entries:0 parent:0 keys:null offsets:null"; SQL statement: CREATE CACHED TABLE IF NOT EXISTS INFORMATION_SCHEMA.LOBS(ID BIGINT PRIMARY KEY, BYTE_COUNT BIGINT, TABLE INT) HIDDEN [50000-169] [Enter] jdbc:h2:... I am using version 1.3.168. I can't attach the database since it is very big. Is this a result of the "out of memory" exception I am getting when doing the big query? how can I make this work? Thanks in advance, Kais -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/6NYu5xiRtO8J. 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.
