You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Francis Chuang (JIRA)" <ji...@apache.org> on 2018/04/12 04:17:00 UTC
[jira] [Updated] (CALCITE-2250) Avatica with HSQLDB backend hangs
when using multiple transactions
[ https://issues.apache.org/jira/browse/CALCITE-2250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francis Chuang updated CALCITE-2250:
------------------------------------
Attachment: hang-avatica.zip
> 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 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)