Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Major 
- 
    Resolution: Fixed
- 
    2.5.5
- 
    None
- 
    MariaDB 10.4.13
 PHP 7.4.7
Description
| $dsn = "mysql:host=10.152.183.98;port=3306;dbname=test"; | 
| $pdo = new PDO($dsn, $config['username'], $config['password']); | 
| $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); | 
| try { | 
| $res = $pdo->exec('use `test`'); | 
| } catch (PDOException $e) { | 
|     var_dump($e->getMessage()); | 
| } | 
| 
 | 
When i execute "use `test`" with backtick i get following error
SQLSTATE[HY000]: General error: 2003 Lost connection to backend server: connection closed by peer
and in the MaxScale log receive this error
|  error  : (30) [readwritesplit] (Splitter-Service) Lost connection to the master server, closing session. Lost connection to master server while connection was idle. Connection has been idle for 0 seconds. Error caused by: #HY000: Lost connection to backend server: connection closed by peer. Last close reason: <none>. Last error:  | 
| error  : (30) Invalid authentication message from backend 'dbsrv1'. Error code: 1049, Msg : #42000: Unknown database '`test`'
 | 
It works If i connect directly to the MariaDB instance
and it works without backticks regardless if I connect to through MaxScale or MariaDB