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)