[MDEV-10383] Named pipes : multiple servers can listen on the same pipename Created: 2016-07-16  Updated: 2016-08-09  Resolved: 2016-08-09

Status: Closed
Project: MariaDB Server
Component/s: Platform Windows
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: 5.5.51

Type: Bug Priority: Major
Reporter: Vladislav Vaintroub Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 0
Labels: None
Environment:

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\ |
+--------------------+----------------------------------------+


Generated at Thu Feb 08 07:41:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.