Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
None
-
Windows
Description
2 or more different servers can "bind" to the same pipe name.
The effects can be interesting, as the client never knows which server it connects to.
My tests with 2 servers show that client would connect them into "round-robin" fashion
I.e I started 2 servers, with --skip-networking --enable-named-pipe, from different directories.
client connects/quits, connects again and ends up on the different server than the 1st time.
|
PS D:\work\server\xxx> .\client\Debug\mysql -uroot --protocol=pipe
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 4
|
Server version: 10.2.2-MariaDB-debug Source distribution
|
|
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> show variables like 'character_sets_dir';
|
+--------------------+------------------------------------------------------+
|
| Variable_name | Value |
|
+--------------------+------------------------------------------------------+
|
| character_sets_dir | D:\work\10.2-wlad-batch-mode\xxx\sql\share\charsets\ |
|
+--------------------+------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [(none)]> quit
|
Bye
|
PS D:\work\server\xxx> .\client\Debug\mysql -uroot --protocol=pipe
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 4
|
Server version: 10.2.2-MariaDB-debug Source distribution
|
|
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> show variables like 'character_sets_dir';
|
+--------------------+----------------------------------------+
|
| Variable_name | Value |
|
+--------------------+----------------------------------------+
|
| character_sets_dir | D:\work\server\xxx\sql\share\charsets\ |
|
+--------------------+----------------------------------------+
|