[CONJ-492] Failover must handle 70100 error code Created: 2017-06-07  Updated: 2017-07-26  Resolved: 2017-07-24

Status: Closed
Project: MariaDB Connector/J
Component/s: Failover
Affects Version/s: None
Fix Version/s: 2.1.0

Type: Task Priority: Major
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None

Sprint: 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

 Comments   
Comment by Diego Dupin [ 2017-07-25 ]

this evolution works only for MariaDB server, since MySQL server don't make distinction (KILL command return ER_QUERY_INTERRUPTED (error 1317) )

Generated at Thu Feb 08 03:16:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.