Invalid SessionHandle: SessionHandle [...]
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 30/100
Research direction
Start by tracing the SQLAlchemy dialect's handling of the Invalid SessionHandle error and compare the behavior described in #160. Read the linked SQLAlchemy disconnect-handling and pre-ping documentation to identify the relevant integration point. Done means the connector recognizes this error as a disconnect and preserves connection recovery for occurrences that are not timeouts.
Written by the indexing model from the issue text.
Description
This is not the same as #160 as the error message is slightly different and the fix for that does not work. This happens well before an hour or any timeout could be reached (I've seen it within minutes of starting our backend locally before). It looks like there are other situations where this can happen besides a timeout.
My understanding is that the sqlalchemy dialect should let sqlalchemy know to invalidate the connection rather than just failing/erroring (e.g. see here), though I don't know enough to understand the correct way to do that. Based on the sqlalchemy documentation,it sounds like the pre-ping is dialect-specific. Not sure if that needs to be changed or something else. The sqlalchemy documentation has an example for handling specific errors as disconnects, but it's only for sqlalchemy 2.0, so that's not really useful here.
- Dominant language
- Python
- Stars
- 233
- Forks
- 152
- Avg merge
- 21h 5m
- Merged PRs (30d)
- 10
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from databricks/databricks-sql-python
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
All issues in databricks/databricks-sql-python
Similar issues
-
fix: inaccuracy ⚠️
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
uabrc/uabrc.github.io#1255 · 1 comment ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
ethereum-optimism/factory#64 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
duckdb/duckdb-python#627 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
-
documentation
Difficulty 1/5 Under an hour Newbie friendliness 78/100
Qiskit/qiskit-addon-sqd#376 ·