[
https://issues.apache.org/jira/browse/CALCITE-2250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16445133#comment-16445133
]
Kevin Risden commented on CALCITE-2250:
---------------------------------------
So I'm not 100% sure what is going on but the RemoteDriverTests
(https://github.com/apache/calcite-avatica/blob/master/server/src/test/java/org/apache/calcite/avatica/RemoteDriverTest.java#L246)
in Calcite Avatica have a lock in them. CALCITE-687 talks about why the lock
was introduced.
> Avatica with HSQLDB backend hangs when using multiple transactions
> ------------------------------------------------------------------
>
> Key: CALCITE-2250
> URL: https://issues.apache.org/jira/browse/CALCITE-2250
> Project: Calcite
> Issue Type: Bug
> Components: avatica
> Affects Versions: avatica-1.11.0
> Reporter: Francis Chuang
> Priority: Major
> Attachments: hang-avatica.zip
>
>
> I have a unit test in avatica-go that executes multiple transactions against
> avatica to test the optimistic concurrency.
> I noticed that this test hangs avatica when using the HSQLDB backend. I was
> not able to work out how to increase the log verbosity of avatica, so there
> were no meaningful logs.
> Reproducing is simple:
> * Open connection 1 and create database tables.
> * Disable autocommit on connection 1
> * Open connection 2
> * Disable autocommit on connection 2
> * Connection 1 executes a SELECT query
> * Connection 2 executes an INSERT query
> The last operation hangs avatica and we never get a response.
> I have attached a zip containing the protobuf messages being sent to avatica
> and a bash script to send the messages to avatica.
> Simply run ./hang-avatica-hsqldb.sh and it will send the messages to avatica.
> CURL will need to be installed and it assumes avatica is running on
> localhost:8765
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
