You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "pranavbhole (via GitHub)" <gi...@apache.org> on 2023/12/06 06:58:08 UTC

[PR] Trace origin sql of No Such Connection failures (druid)

pranavbhole opened a new pull request, #15501:
URL: https://github.com/apache/druid/pull/15501

   ### Description
   After updating avatica client, it mandatory to set transparent_reconnection flag in jdbc uri to make sure that client does reconnect, ideally we should be see no such connection only from connectionSync request, if client is not setting flag then we see it from prepare phase itself that seems like a gap. This PR prints associated sql if it fails from prepare or prepareAndExecute  avatica calls. It can help to trace the origin of client and fix it.
   
   ```
   org.apache.calcite.avatica.NoSuchConnectionException: null
   	at org.apache.druid.sql.avatica.DruidMeta.getDruidConnection(DruidMeta.java:845) ~[druid-sql.jar]
   	at org.apache.druid.sql.avatica.DruidMeta.prepare(DruidMeta.java:274) ~[druid-sql.jar]
   	at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:201) ~[avatica-core-1.23.0.jar:1.23.0]
   	at org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1240) ~[avatica-core-1.23.0.jar:1.23.0]
   	at org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1211) ~[avatica-core-1.23.0.jar:1.23.0]
   ```
   
   This PR has:
   
   - [ ] been self-reviewed.
      - [ ] using the [concurrency checklist](https://github.com/apache/druid/blob/master/dev/code-review/concurrency.md) (Remove this item if the PR doesn't have any relation to concurrency.)
   - [ ] added documentation for new or modified features or behaviors.
   - [ ] a release note entry in the PR description.
   - [ ] added Javadocs for most classes and all non-trivial methods. Linked related entities via Javadoc links.
   - [ ] added or updated version, license, or notice information in [licenses.yaml](https://github.com/apache/druid/blob/master/dev/license.md)
   - [ ] added comments explaining the "why" and the intent of the code wherever would not be obvious for an unfamiliar reader.
   - [ ] added unit tests or modified existing tests to cover new code paths, ensuring the threshold for [code coverage](https://github.com/apache/druid/blob/master/dev/code-review/code-coverage.md) is met.
   - [ ] added integration tests.
   - [ ] been tested in a test Druid cluster.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [PR] Trace origin sql of No Such Connection failures (druid)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #15501:
URL: https://github.com/apache/druid/pull/15501#issuecomment-1986590783

   This pull request has been marked as stale due to 60 days of inactivity.
   It will be closed in 4 weeks if no further activity occurs. If you think
   that's incorrect or this pull request should instead be reviewed, please simply
   write any comment. Even if closed, you can still revive the PR at any time or
   discuss it on the dev@druid.apache.org list.
   Thank you for your contributions.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [PR] Trace origin sql of No Such Connection failures (druid)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed pull request #15501: Trace origin sql of No Such Connection failures
URL: https://github.com/apache/druid/pull/15501


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [PR] Trace origin sql of No Such Connection failures (druid)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #15501:
URL: https://github.com/apache/druid/pull/15501#issuecomment-2041249297

   This pull request/issue has been closed due to lack of activity. If you think that
   is incorrect, or the pull request requires review, you can revive the PR at any time.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org