[CALCITE-2882] Connection properties are lost after timeout

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Fix Version/s: avatica-1.14.0
• Component/s: avatica
• Labels: pull-request-available

Environment

Phoenix 5.1
avatca 1.12

• Assignee: Unassigned
• Reporter: shining
• Created: 28/Feb/19 09:27
• Updated: 29/Apr/19 05:59
• Resolved: 17/Apr/19 23:52

Description

When use avatica connect Phoenix QueryServer, I create an AvaticaConnection:

Connection conntion = DriverManage.getConnection(url);
connection.setAutoCommit(true);

Avatica keep PhoenixConnection alive in the Cache, which will be expired after 10min by default.
I still use the older AvaticaConnection , it will reopen an PhoenixConnection, but the ConnectionProperties is loss, such as AutoCommit.

I use sqlline-thin.py to reappear the problem:
1) sqlline-thin.py http://localhost:8765
2) upsert one row and select

3) after 10 min, upsert again, the connection will be recreate, but select null

link title

Issue Links

• links to: GitHub Pull Request #86