Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2882

Connection properties are lost after timeout

Details

    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

      Attachments

        1. image-2019-02-28-17-25-39-478.png
          88 kB
          shining
        2. image-2019-02-28-17-28-31-926.png
          417 kB
          shining

        Issue Links

          Activity

            shining shining created issue -
            githubbot ASF GitHub Bot made changes -
            Field Original Value New Value
            Remote Link This issue links to "GitHub Pull Request #86 (Web Link)" [ 148334 ]
            githubbot ASF GitHub Bot made changes -
            Labels pull-request-available
            githubbot ASF GitHub Bot made changes -
            Worklog Id 206694 [ 206694 ]
            Remaining Estimate 0h [ 0 ]
            Time Spent 10m [ 600 ]
            shining 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]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 209311 [ 209311 ]
            Time Spent 10m [ 600 ] 20m [ 1200 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 221593 [ 221593 ]
            Time Spent 20m [ 1200 ] 0.5h [ 1800 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 223007 [ 223007 ]
            Time Spent 0.5h [ 1800 ] 40m [ 2400 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 224655 [ 224655 ]
            Time Spent 40m [ 2400 ] 50m [ 3000 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 224774 [ 224774 ]
            Time Spent 50m [ 3000 ] 1h [ 3600 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 224884 [ 224884 ]
            Time Spent 1h [ 3600 ] 1h 10m [ 4200 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 226594 [ 226594 ]
            Time Spent 1h 10m [ 4200 ] 1h 20m [ 4800 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 226596 [ 226596 ]
            Time Spent 1h 20m [ 4800 ] 1.5h [ 5400 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 227402 [ 227402 ]
            Time Spent 1.5h [ 5400 ] 1h 40m [ 6000 ]
            githubbot 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 ]
            githubbot 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 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 227994 [ 227994 ]
            Time Spent 1h 40m [ 6000 ] 1h 50m [ 6600 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 227995 [ 227995 ]
            Time Spent 1h 50m [ 6600 ] 2h [ 7200 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 227996 [ 227996 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 228174 [ 228174 ]
            Time Spent 2h [ 7200 ] 2h 10m [ 7800 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 228181 [ 228181 ]
            Time Spent 2h 10m [ 7800 ] 2h 20m [ 8400 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 228184 [ 228184 ]
            Time Spent 2h 20m [ 8400 ] 2.5h [ 9000 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 228226 [ 228226 ]
            Time Spent 2.5h [ 9000 ] 2h 40m [ 9600 ]
            githubbot 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 ]
            githubbot ASF GitHub Bot made changes -
            Worklog Id 229516 [ 229516 ]
            Time Spent 2h 40m [ 9600 ] 2h 50m [ 10200 ]
            zabetak Stamatis Zampetakis made changes -
            Fix Version/s avatica-1.14.0 [ 12344953 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            zabetak Stamatis Zampetakis made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            zabetak Stamatis Zampetakis made changes -
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Resolved [ 5 ]
            zabetak Stamatis Zampetakis made changes -
            Summary ConnectionProperties lose effectiveness when connection reopen after expired Connection properties are lost after timeout
            francischuang Francis Chuang made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            gmcdonald Gavin McDonald made changes -
            Workflow jira [ 13545395 ] Calcite Workflow [ 13622519 ]
            gmcdonald Gavin McDonald made changes -
            Workflow Calcite Workflow [ 13622519 ] Default workflow, editable Closed status [ 13626448 ]
            gmcdonald Gavin McDonald made changes -
            Workflow Default workflow, editable Closed status [ 13626448 ] Calcite Workflow [ 13629406 ]
            iroh Chris Wells made changes -
            Workflow Calcite Workflow [ 13629406 ] Classic - editable closed [ 14174713 ]
            iroh Chris Wells made changes -
            Workflow Classic - editable closed [ 14174713 ] Calcite Workflow [ 14183386 ]
            iroh Chris Wells made changes -
            Workflow Calcite Workflow [ 14183386 ] Classic - editable closed [ 14196470 ]
            iroh Chris Wells made changes -
            Workflow Classic - editable closed [ 14196470 ] Calcite Workflow [ 14202820 ]

            People

              Unassigned Unassigned
              shining shining
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 50m
                  2h 50m