[h2] Index creation ignores MAX_MEMORY_ROWS setting

Hi, I use the latest stable version of H2 (1.3.176). During Index creation for very wide tables with nearly unique data in every column/row, OutOfMemory Errors can occur. I tracked down the reason for this within the H2 source. The reason is the buffering of rows in the addIndex method (source

[h2] Possible cause for error code 90031: java.io.IOException: Read error

Recently i have been facing with many errors in which the temp blob database file cannot be read, and read error exception thrown. Below is stack trace of one of them: org.h2.jdbc.JdbcSQLException: IO Exception: java.io.IOException: Read error; Application

Re: [h2] Deadlock trying to lock a table that is already locked?

Hi, As for when is the next release: my current plan is in about 3 weeks. Regards, Thomas On Thu, Nov 13, 2014 at 8:36 AM, Noel Grandin noelgran...@gmail.com wrote: On 2014-11-13 08:48 AM, Gili wrote: Hurray! I'm not crazy :) Okay, so what part of the behavior I was seeing was caused by

Re: [h2] how to become a donor

Hi, I get an email when a donation is made. I will then add the person or company in the supporters section on the history page. By the way, donations are used for infrastructure (test hardware, internet presence), and the rest is split among the main contributors (which is currently me and

Re: [h2] Index creation ignores MAX_MEMORY_ROWS setting

Hi Thanks, this is fixed in SVN and will be available in the next release. For now, I suggest using the -Dh2.maxMemoryRows command line parameter if you are starting up H2 separately, or if you are using H2 in embedded mode, set it directly in your code using System.putProperty. Regards,

Re: [h2] Re: org.h2.jdbc.JdbcSQLException: General error: java.lang.RuntimeException: page[5528] data leaf table

Hi Thomas, We have upgrade to 1.3.176 and are getting another error which is discussed in https://groups.google.com/forum/#!msg/h2-database/LfJX1m2h56g/533vOn5KjMMJ. Which version do you suggest us, 174 ? ? Thanks, Devesh On Friday, June 27, 2014 3:50:16 PM UTC+5:30, Thomas Mueller wrote:

[h2] Re: Query Taking Very Long Time on 1.1.111

I know this is very old post. We are still setting h2.optimizeInJoin to false. Is there a version from which this is no longer necessary. On Tuesday, April 28, 2009 11:08:23 AM UTC-7, Wes Clark wrote: I am noticing extremely long execution times for a few our queries, preventing our

Re: [h2] how to become a donor

Hi Thomas en Noel, Thanks for your response... The key point of my message was: I think it would help if there was an email address for paypal donations... In other words: I want to become a donor, but I don't know wich email-address to use for my donation. regards, Rins -- You

Re: [h2] Re: Query Taking Very Long Time on 1.1.111

The easiest is probably if you do a binary search. i.e. start with the newest version. If that works, great. Otherwise, pick a version halfway between your current version and the latest version and test that. etc, etc. On 2014-11-13 08:45 PM, Wes Clark wrote: I know this is very old post.

Re: [h2] how to become a donor

Hi, There is a PayPal button at the very bottom of the web page http://h2database.com/html/main.html - if you click it, you will get a PayPal web site where the email address is listed. Regards, Thomas On Fri, Nov 14, 2014 at 7:27 AM, Rinse Lemstra r.lems...@xso.nl wrote: Hi Thomas en Noel,