Details
- 
    
Task
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Fixed
 - 
    None
 - 
    None
 
Description
Actual Statement.setQueryTimeout use one additional thread per query. 
The actual implementation create an additional thread. When timeout, a  new connection will be created to permit executing a query to killing the current connection. 
Since server 10.1, MariaDB server has a command that permit server to handle that directly : https://mariadb.com/kb/en/mariadb/aborting-statements/ with command : SET STATEMENT max_statement_time=1 FOR "..."
The solution has to be implemented.
This has another advantage to be compatible with maxscale (existing connection is not, since the thread ID number is a fake Maxscale thread ID)