Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
Sprint connector/j 2.1.0
Description
Driver failover handling is based on 08xxx sql state that indicate a connection exception.
A "KILL CONNECTION" command will return a 70100 that is not automatically handled by failover.
70xxx sql state familly stand for interrupted exception.
specifically 70100 sql state can be issue with different kind of error :
- ER_STATEMENT_TIMEOUT (error 1969)
- ER_QUERY_INTERRUPTED (error 1317)
- ER_CONNECTION_KILLED (error 1927)
The 70100 sql state with error code 1927 (= KILL CONNECTION) must be handled by driver to reconnect automatically WITHOUT relaunching query
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Driver failover handling is based on 08xxx sql state that indicate a connection exception.
A "KILL CONNECTION" command will return a 70100 that is not automatically handled by failover. 70xxx sql state familly stand for interrupted exception. specifically 70100 sql state can be issue with different kind of error : * ER_STATEMENT_TIMEOUT (error 1969) * ER_QUERY_INTERRUPTED (error 1317) * ER_CONNECTION_KILLED (error 1927) The 70100 sql state with error code 1927 must be handle by driver to reconnect automatically WITHOUT relaunching query ! |
Driver failover handling is based on 08xxx sql state that indicate a connection exception.
A "KILL CONNECTION" command will return a 70100 that is not automatically handled by failover. 70xxx sql state familly stand for interrupted exception. specifically 70100 sql state can be issue with different kind of error : * ER_STATEMENT_TIMEOUT (error 1969) * ER_QUERY_INTERRUPTED (error 1317) * ER_CONNECTION_KILLED (error 1927) The 70100 sql state with error code 1927 (= KILL CONNECTION) must be handled by driver to reconnect automatically WITHOUT relaunching query |
| Sprint | Sprint connector/j 2.1.0 [ 169 ] |
| Rank | Ranked higher |
| issue.field.resolutiondate | 2017-07-24 16:48:55.0 | 2017-07-24 16:48:55.89 |
| Component/s | Failover [ 12200 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 81146 ] | MariaDB v4 [ 128351 ] |
this evolution works only for MariaDB server, since MySQL server don't make distinction (KILL command return ER_QUERY_INTERRUPTED (error 1317) )