[h2] compactRewriteFully ?

Hi, MVStore.compactRewriteFully()  was removed in the most recent version of the MVStore. What is the best equivalent? compactMoveChunks() ? Thanks, Dan -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

Re: [h2] “h2-1.4.196.jar” can’t be opened because it is from an unidentified developer.

Right. And you are correct: I do not get the error when running H2 in my application. However, I wanted to run the H2 console and I did that by running the jar directly. That is where I get the error. On Thu, Jan 3, 2019 at 6:48 AM Noel Grandin wrote: > ah, this is the gatekeeper thing you are

[h2] “h2-1.4.196.jar” can’t be opened because it is from an unidentified developer.

Had hoped to use H2. It would be nice if the jar was properly identified so it doesn't get excluded by (corporate) Mac security settings. I know I can fork and build it myself, but that doesn't scale to my team and means we are forever tracking H2 releases. Is there a reason to package it as uni

[h2] Re: deadlock in MVStore

Is there an artifact server somewhere with SNAPSHOT releases I can point at? Or I would just have to build it locally? Thanks, Dan On Wednesday, August 8, 2018 at 9:33:29 AM UTC-5, Andrei Tokar wrote: > > Hi Dan, > > MVStore code has undergone significant changes since

[h2] Re: best way to get an MV store to compact?

Thanks for this tip, by the way - I wouldn't have guessed it, but this off-line compaction works _far_ better than anything I tried online. Dan On Thursday, August 2, 2018 at 8:24:12 PM UTC-5, Andrei Tokar wrote: > > Hi Dan, > > I think that > > MVStoreTool.compact(

[h2] deadlock in MVStore

hat can I do to prevent this from happening? Do you want me to file a bug report? I would have thought that committing and flushing would have also flushed the background writer... but apparently not... is there some way to sync and flush the background writer? Thanks, Dan -- You received

[h2] best way to get an MV store to compact?

igger than I expect. Basically, I'm trying to shut the system down in a state where the DB is as small as possible, so I can zip it and package it. Thanks, Dan -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

Re: [h2] MVStore and interrupts?

are happening, it breaks the MVStore pretty reliably, per the other thread I started. So there are obviously some multi-threading issues in the 1.4.197 line. I could do some testing at some point with your trunk code, if you want me to see if the multithread issues are fixed in trunk. Thanks, Dan

[h2] mv store corruption after compactMoveChunks

g compactMoveChunks() ? Perhaps, I should block my own threads prior to calling it, so I know that no operations are hitting it? I can provide instructions / code (its opensource) to reproduce this, but its not a simple test case, if you want to try to get to the bottom of it. Thanks, Dan -- You r

Re: [h2] MVStore and interrupts?

it work to set it to 0? Or, do I also need to call store.compactMoveChunks() at some interval? Thanks, Dan On Thursday, June 28, 2018 at 5:18:25 AM UTC-5, Thomas Mueller Graf wrote: > > Hi, > > > not interrupting is easier said than done with other libra

[h2] MVStore and interrupts?

looks like that class is only included in the H2 jar file? If MV Store is what gets broken, why isn't the fix / workaround included in the MV Store jar? This issue / workaround might be a good thing to add to the FAQ, as well. Thanks, Dan -- You received this message because you are subs

Re: [h2] MVStore and setVersionsToKeep(...)

can't set the versions variable during the Builder pattern for configuring the store. But maybe that doesn't make sense. Thanks, Dan -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop r

Re: [h2] MVStore and setVersionsToKeep(...)

Is there any other place I could look for additional documentation / details on the MV Store?  It does use this mailing list, I assume? Thanks, Dan On 06/23/2016 01:41 AM, Dan wrote: Hi

[h2] Re: NPE/performance degradation with version 1.4.185?

e encountered a very similar issue, where performance is much slower with the current versions (1.4.188 through 1.4.192) than it was with older versions. Thanks, Dan -- View this message in context: http://h2-database.66688.n3.nabble.com/NPE-performance-degradation-with-version-1-4-185-tp40309

[h2] MVStore and setVersionsToKeep(...)

emented in response to an explicit commit() call? I also noticed that you can't set the versions variable during the Builder pattern for configuring the store. But maybe that doesn't make sense. Thanks, Dan -- You received this message because you are subscribed to the Google Groups

[h2] update license to MPL 2.0 for GPL compatibility?

s "Incompatible with Secondary Licenses". (See below.) We would like to distribute H2 with a bunch of GPL code. Thomas, would you be willing to again consider updating the license to MPL 2.0? Thanks very much, Dan --- For details about why the redistribution upgrade doesn't create

Re: java.lang.RuntimeException: rowcount remaining=1 SYS when trying to connect to an H2 database.

an Windows XP, > Linux, Mac OS X, or JVMs other than Sun 1.5 or 1.6; the feature > MULTI_THREADED; the features AUTO_SERVER and AUTO_RECONNECT; the file > locking method 'Serialized'. > > So I suggest to upgrade to a more recent version of H2. > > Regards, > Th

Have composite index T(a,b): is index T(a) redundant?

on a? CREATE INDEX t(a) or is INDEX t(a) redundant and subsumed by CREATE INDEX t(a, b)? Thanks, Dan -- 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 h

java.lang.RuntimeException: rowcount remaining=1 SYS when trying to connect to an H2 database.

Hello, I am using H2 1.3.150 and I'm trying to connect to it whenever I start my application ( running on java 1.6.0_37 ), but after a restart of my application I wasn't able to connect to it anymore ( neither from my app and neither form the H2 Console ). The exception I get is : Caused by:

Can not reverse engineer H2 Database via psodbc

Trying to reverse engineer an H2 db using postgres ODBC (V8.2 and up), seems that the pg_catalog is not fully compatible with the pgodbc (tried with V8.2 to 9). Views are missing fields, functions missing from the schema pg_catalog. Here two such errors: [14.859]ERROR from backend during send_query

lobInDatabase and DEFAULT_MAX_LENGTH_INPLACE_LOB

for DEFAULT_MAX_LENGTH_INPLACE_LOB in INFORMATION_SCHEMA.SETTINGS. Thanks! Dan -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email t

Re: Performance Tuning and other random stuff...

On Tue, Jul 28, 2009 at 10:53 AM, bob mcgee wrote: > > Dan, > If you can give a little more info about the queries, indexes, and > table structures, I may be able to suggest why the indexes aren't > being used. > > The most likely culprits are: > Not having u

Re: Performance Tuning and other random stuff...

officially support H2 as a new database, I'll have to either rework them in such a way that H2 can use the indexes, or dig into H2's code a bit, and try to figure out why it isn't using the indexes. Thanks, Dan --~--~-~--~~~---~--~~ You received thi

Performance Tuning and other random stuff...

be passed in. I'm assuming that it treats the number as MB? But I'm just guessing Thanks for all the work on H2, Dan --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "H2 Database" group.