[ 
https://issues.apache.org/jira/browse/SPARK-58619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Cheng Pan resolved SPARK-58619.
-------------------------------
    Fix Version/s: 4.3.0
       Resolution: Fixed

Issue resolved by pull request 57831
[https://github.com/apache/spark/pull/57831]

> Assign SQLSTATE 08003 to the INVALID_HANDLE session sub-conditions
> ------------------------------------------------------------------
>
>                 Key: SPARK-58619
>                 URL: https://issues.apache.org/jira/browse/SPARK-58619
>             Project: Spark
>          Issue Type: Improvement
>          Components: Connect, Spark Core
>    Affects Versions: 4.3.0
>            Reporter: Jiwon Park
>            Assignee: Jiwon Park
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.3.0
>
>
> The {{INVALID_HANDLE}} session sub-conditions ({{SESSION_CHANGED}}, 
> {{SESSION_CLOSED}}, {{SESSION_NOT_FOUND}}) mean the server-side session 
> backing a Connect client is gone, which SQL standard {{08003}} (connection 
> does not exist) describes. They inherit {{INVALID_HANDLE}}'s generic 
> {{HY000}}, so tools detecting dead connections by SQLSTATE class {{08}} 
> cannot recognize them, and the Connect JDBC driver hard-codes a remapping as 
> a workaround (raised in the SPARK-57933 review).
> Renaming them into a class-08 condition is not viable: released Connect 
> clients match the condition names for session invalidation and reattach 
> re-execution, and nothing in a new client can repair that direction. Per the 
> PR discussion, support an optional sub-condition level {{sqlState}} in the 
> error framework as a documented wire-compatibility exception and assign 
> {{08003}} to the three session sub-conditions, with guardrails: the error 
> README documents the exception, discourages new overrides even within the 
> same error class, and notes a future server-side compatibility layer may 
> remove it; a new {{SparkThrowableSuite}} invariant fails any sub-condition 
> {{sqlState}} outside an explicit allowlist.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to