Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.12.0
-
Phoenix 5.1
avatca 1.12
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
Attachments
Attachments
Issue Links
- links to
Activity
shining
created issue -
ASF GitHub Bot
made changes -
Field | Original Value | New Value |
---|---|---|
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Labels | pull-request-available |
ASF GitHub Bot
made changes -
Worklog Id | 206694 [ 206694 ] | |
Remaining Estimate | 0h [ 0 ] | |
Time Spent | 10m [ 600 ] |
shining
made changes -
Description |
When use avatica connect Phoenix QueryServer, I create an AvaticaConnection:
{code:java} Connection conntion = DriverManage.getConnection(url); connection.setAutoCommit(true); {code} 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 !image-2019-02-28-17-25-39-478.png! 3) after 10 min, upsert again, the connection will be recreate, but select null !image-2019-02-28-17-28-31-926.png! |
When use avatica connect Phoenix QueryServer, I create an AvaticaConnection:
{code:java} Connection conntion = DriverManage.getConnection(url); connection.setAutoCommit(true); {code} 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 !image-2019-02-28-17-25-39-478.png! 3) after 10 min, upsert again, the connection will be recreate, but select null !image-2019-02-28-17-28-31-926.png! [link title|https://github.com/apache/calcite-avatica/pull/86] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 209311 [ 209311 ] | |
Time Spent | 10m [ 600 ] | 20m [ 1200 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 221593 [ 221593 ] | |
Time Spent | 20m [ 1200 ] | 0.5h [ 1800 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 223007 [ 223007 ] | |
Time Spent | 0.5h [ 1800 ] | 40m [ 2400 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 224655 [ 224655 ] | |
Time Spent | 40m [ 2400 ] | 50m [ 3000 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 224774 [ 224774 ] | |
Time Spent | 50m [ 3000 ] | 1h [ 3600 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 224884 [ 224884 ] | |
Time Spent | 1h [ 3600 ] | 1h 10m [ 4200 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 226594 [ 226594 ] | |
Time Spent | 1h 10m [ 4200 ] | 1h 20m [ 4800 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 226596 [ 226596 ] | |
Time Spent | 1h 20m [ 4800 ] | 1.5h [ 5400 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 227402 [ 227402 ] | |
Time Spent | 1.5h [ 5400 ] | 1h 40m [ 6000 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 227994 [ 227994 ] | |
Time Spent | 1h 40m [ 6000 ] | 1h 50m [ 6600 ] |
ASF GitHub Bot
made changes -
Worklog Id | 227995 [ 227995 ] | |
Time Spent | 1h 50m [ 6600 ] | 2h [ 7200 ] |
ASF GitHub Bot
made changes -
Worklog Id | 227996 [ 227996 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 228174 [ 228174 ] | |
Time Spent | 2h [ 7200 ] | 2h 10m [ 7800 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 228181 [ 228181 ] | |
Time Spent | 2h 10m [ 7800 ] | 2h 20m [ 8400 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 228184 [ 228184 ] | |
Time Spent | 2h 20m [ 8400 ] | 2.5h [ 9000 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 228226 [ 228226 ] | |
Time Spent | 2.5h [ 9000 ] | 2h 40m [ 9600 ] |
ASF GitHub Bot
made changes -
Remote Link | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] | This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ] |
ASF GitHub Bot
made changes -
Worklog Id | 229516 [ 229516 ] | |
Time Spent | 2h 40m [ 9600 ] | 2h 50m [ 10200 ] |
Stamatis Zampetakis
made changes -
Fix Version/s | avatica-1.14.0 [ 12344953 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Stamatis Zampetakis
made changes -
Resolution | Fixed [ 1 ] | |
Status | Closed [ 6 ] | Reopened [ 4 ] |
Stamatis Zampetakis
made changes -
Resolution | Fixed [ 1 ] | |
Status | Reopened [ 4 ] | Resolved [ 5 ] |
Stamatis Zampetakis
made changes -
Summary | ConnectionProperties lose effectiveness when connection reopen after expired | Connection properties are lost after timeout |
Francis Chuang
made changes -
Status | Resolved [ 5 ] | Closed [ 6 ] |
Gavin McDonald
made changes -
Workflow | jira [ 13545395 ] | Calcite Workflow [ 13622519 ] |
Gavin McDonald
made changes -
Workflow | Calcite Workflow [ 13622519 ] | Default workflow, editable Closed status [ 13626448 ] |
Gavin McDonald
made changes -
Workflow | Default workflow, editable Closed status [ 13626448 ] | Calcite Workflow [ 13629406 ] |
Chris Wells
made changes -
Workflow | Calcite Workflow [ 13629406 ] | Classic - editable closed [ 14174713 ] |
Chris Wells
made changes -
Workflow | Classic - editable closed [ 14174713 ] | Calcite Workflow [ 14183386 ] |
Chris Wells
made changes -
Workflow | Calcite Workflow [ 14183386 ] | Classic - editable closed [ 14196470 ] |
Chris Wells
made changes -
Workflow | Classic - editable closed [ 14196470 ] | Calcite Workflow [ 14202820 ] |