[ 
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)

Reply via email to