[ 
https://issues.apache.org/jira/browse/CALCITE-2250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Francis Chuang updated CALCITE-2250:
------------------------------------
    Description: 
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.

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

  was:
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


> 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.
> 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