Cannot create a cluster with a database containing LOB's

[Jimmitry PAYET]

When using the exclusive mode, LOB operations could cause the thread
to block. This also affected the CreateCluster tool (when using BLOB
or CLOB data). version 1.3.168.

I have built a very simple test case showing the issue:

1. Following the cluster creation tutorial, I create two directories:
server1 & server2

2. I run an H2 server on both:
        java org.h2.tools.Server -tcp -tcpPort 9101 -baseDir server1
        java org.h2.tools.Server -tcp -tcpPort 9102 -baseDir server2

3. I create a new database "test" on the first one, by executing the
following statements:
        create table Test(c1 number(5), c2 varchar(100), c3 CLOB);
        insert into Test(c1, c2, c3) values (10, 'Hello',
repeat('Hello', 10000));
        insert into Test(c1, c2, c3) values (20, 'World',
repeat('World', 10000));

4. I try to create a cluster, by running:
        java org.h2.tools.CreateCluster
          -urlSource jdbc:h2:tcp://localhost:9101/

test
          -urlTarget jdbc:h2:tcp://localhost:9102/test
          -user sa
          -serverList localhost:9101,localhost:9102

5. The command does not terminate. An empty "backup.sql" file is
created in the current directory.

and the code block at org.h2.engine.Session.waitIfExclusiveModeEnabled

What is wrong there? Is there a workaround?

Thanks!

[Thomas Mueller]

Hi,

This should be fixed in todays release.

Regards,

Thomas

--
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/-/ejgSS5M1FhUJ.
To post to this group, send email to h2-da...@googlegroups.com.
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.

[Jimmitry PAYET]

Hi Thomas,

This is great. I migrate my server successfully in 1.3.169.
In my next release, I add on my main page a link to h2database.com and thank you to you.

Regards,
Jimmitry.

2012/9/9 Thomas Mueller <thomas.to...@gmail.com>