DDL blocking on transaction in other connection with mvcc transaction model

--===============8980629012433117444==
Content-Type: multipart/alternative; boundary="00000000000015dfbc05c7c84c94"

--00000000000015dfbc05c7c84c94
Content-Type: text/plain; charset="UTF-8"

Hi,

We are experiencing sometimes a deadlock in our application when creating
tables in the in-memory hsql database.

The connection is created with the hsqldb.tx=mvcc flag.

When I start a transaction in one connection (autocommit false), select
some data, close both the resultset and the statement, and then create a
table in another connection without committing the first connection, the
application will hang.

With the default transaction model this works fine.

Is this expected behaviour, or a bug?

We could reproduce this with the latest 2.6.1 driver.

Thanks
Rob

--00000000000015dfbc05c7c84c94
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<br><br>We are experiencing sometimes a deadlock in our=
 application when creating tables in the in-memory hsql database.<br><br>Th=
e connection is created with the hsqldb.tx=3Dmvcc flag.<br><br>When I start=
 a transaction in one connection (autocommit false), select some data, clos=
e both the resultset and the statement, and then create a table in another =
connection without committing the first connection, the application will ha=
ng.<br><br>With the default transaction model this works fine.<br><br>Is th=
is expected behaviour, or a bug?<br><br>We could reproduce this with the la=
test 2.6.1 driver.<br><br>Thanks<br>Rob<br></div>

--00000000000015dfbc05c7c84c94--


--===============8980629012433117444==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============8980629012433117444==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--===============8980629012433117444==--