I'm not sure how it works in a cluster, but H2 can only handle a single thread at a time, so will block in MVCC mode anyway if you have a single long running operation. You could try with MULTI_THREADED=1 to allow multithreading.

On 17/01/2013 6:58 PM, Matouš Voldřich wrote:
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
            [email protected].
            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
        <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
        <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
        <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.

--
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].
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