[
https://issues.apache.org/jira/browse/CALCITE-1950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16129958#comment-16129958
]
Francis Chuang commented on CALCITE-1950:
-----------------------------------------
Some further info.
It seems the server starts to hang once I run a test to test optimistic
currency. The test current hangs:
- `CREATE TABLE some_table (id INTEGER PRIMARY KEY, msg VARCHAR,version
INTEGER)`
- Prepare statement1: `INSERT INTO some_table (id, msg, version) VALUES(?, ?,
?)`
- Insert 6 rows using statement1.
- Start tx1
- Start tx2
- Using tx1, `SELECT MAX(version) FROM some_table`
- Using tx2, `INSERT INTO some_table (id, msg, version) VALUES(?, ?, ?)`. At
this point, it seems the server starts to hang and I am unable to perform any
further operations.
> Avatica HSQLDB docker image hangs
> ---------------------------------
>
> Key: CALCITE-1950
> URL: https://issues.apache.org/jira/browse/CALCITE-1950
> Project: Calcite
> Issue Type: Bug
> Components: avatica
> Reporter: Francis Chuang
> Assignee: Josh Elser
>
> I am using the calcite-avatica hsqldb image here:
> https://hub.docker.com/r/f21global/calcite-avatica/
> The image is built using this docker file:
> https://github.com/apache/calcite-avatica/tree/master/docker/src/main/docker/hypersql
> I am currently running integration tests for the Go client against that
> image. It seems that after a certain amount of operations, the server will
> lock up. From the Go http client, it seems that avatica no longer responds.
> There wasn't any interesting information when I ran `docker logs` on the
> container avatica/hsqldb is running in.
> When it starts hanging, tests that were passing previously would fail
> randomly, because the test is not able to get a response form avatica.
> Usually, deleting and recreating the container would resolve the problem, but
> after using the same container through a few more test cycles, it starts to
> hang again.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
