Francis Chuang created CALCITE-2250:
---------------------------------------
Summary: 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
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 was no
meaningful logs.
The operation 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)
