Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10383

Named pipes : multiple servers can listen on the same pipename

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 5.5.51
    • Platform Windows
    • 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\ |
      		 
      +--------------------+----------------------------------------+

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            wlad Vladislav Vaintroub
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.