Thanks for answers. Well our problem is that H2 is used in 
highly concurrent environment where multiple threads (spread accross a 
cluster) are making queries to one H2 cluster (2 nodes). And because of H2 
locks entire table, the queries often wait and block. If there is a long 
running operation (like backup of 5 milion records), it blocks H2 server 
for 30sec - 1 minute, halting everything.

I know that chosing H2 for this use case was wrong and am trying to 
convince to switch to some other server, but right now we are investigating 
the options we have.

Matous 

Dne pondělí, 14. ledna 2013 21:08:20 UTC+1 Thomas Mueller napsal(a):
>
> Hi,
>
> The cluster mode is also an area that is not very well tested. And using 
> LOCK_MODE=0 is not recommended (even when not using a cluster). 
>
> What problem do you want to solve? Why don't you just use the default 
> settings?
>
> Regards,
> Thomas
>
>
> On Sun, Jan 13, 2013 at 3:32 PM, Ryan How <[email protected]<javascript:>
> > wrote:
>
>>  I'm not sure sorry, someone else might be able to answer for you. I 
>> could only suggest give it a go and see if it works. I don't see why it 
>> wouldn't work, you are only changing transaction isolation level.
>>
>> Thanks, Ryan
>>
>>
>> On 13/01/2013 6:24 PM, Matouš Voldřich wrote:
>>  
>> Thanks for answer. We will give it a try and at write some tests. 
>>
>>  Could you answer my second question? Is it possible to set LOCK_MODE=0 
>> and still use cluster mode?
>>
>>  Thanks 
>> Matous
>>
>> Dne sobota, 12. ledna 2013 15:34:27 UTC+1 Kartweel napsal(a): 
>>>
>>>  MVCC has been around for a while, so it is pretty stable. But I did 
>>> find a bug the other day with "for update" and lobs, so it still has bugs. 
>>> It isn't as well tested as the rest of the engine, and not as well 
>>> supported :)
>>>
>>> Ryan
>>>
>>> On 11/01/2013 6:35 PM, Matouš Voldřich wrote:
>>>  
>>> Hi, 
>>>
>>>  I would like to ask about H2 feature MVCC (multi version concurrency). 
>>> On some places this feature is marked as experimental so I would like to 
>>> ask about its status. Is it ussable?
>>>
>>>  We would like to prevent locking of entire table. Are there any other 
>>> options? I found only to use LOCK_LEVEL=0 since we do not need transactions 
>>> at all (we use it as simple INSERT-GET-UPDATE-DELETE store). But we also 
>>> use cluster, so I'm not sure if setting it will not disable the cluster 
>>> functionality as well.
>>>
>>>  Thanks.
>>> Matous
>>> -- 
>>> 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/-/IPVunNjiwuUJ<https://groups.google.com/d/msg/h2-database/-/IPVunNjiwuUJ>
>>> **.
>>> To post to this group, send email to [email protected].
>>> To unsubscribe from this group, send email to h2-database...@**
>>> googlegroups.com.
>>> For more options, visit this group at http://groups.google.com/**
>>> group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en>
>>> .
>>>
>>>
>>>   -- 
>> 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/-/vImI06FfFZMJ.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> To unsubscribe from this group, send email to 
>> [email protected] <javascript:>.
>> For more options, visit this group at 
>> http://groups.google.com/group/h2-database?hl=en.
>>
>>
>>  -- 
>> You received this message because you are subscribed to the Google Groups 
>> "H2 Database" group.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> To unsubscribe from this group, send email to 
>> [email protected] <javascript:>.
>> For more options, visit this group at 
>> http://groups.google.com/group/h2-database?hl=en.
>>
>
>

-- 
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/-/5TNsLRCIhHMJ.
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.

Reply via email to