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

mariadbd-multi cannot report or stop a server whose group has an empty socket= and a port=

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 13.3
    • 13.3
    • Scripts & Clients
    • None
    • Not for Release Notes

    Description

      If a server's group has an empty socket= and a port=, mariadbd-multi report says the server is not running and mariadbd-multi stop cannot stop it

      Test case

      BASEDIR=/test/mtest/MDEV-42003/MD031126-mariadb-13.2.0-linux-x86_64-opt
      TMPDIR=/tmp/testdir
      export HOME=$TMPDIR PATH=$BASEDIR/bin:$PATH
      unset MYSQL_HOME MARIADB_HOME
      mkdir -p $TMPDIR/itmp
      $BASEDIR/scripts/mariadb-install-db --no-defaults --basedir=$BASEDIR --datadir=$TMPDIR/d2 --tmpdir=$TMPDIR/itmp --auth-root-authentication-method=normal >/dev/null 2>&1
      cat > $TMPDIR/multi.cnf <<EOC
      [mysqld_multi]
      mysqld=$BASEDIR/bin/mariadbd
      mysqladmin=$BASEDIR/bin/mariadb-admin
      user=root
      [mysqld2]
      datadir=$TMPDIR/d2
      socket=
      port=13307
      bind-address=127.0.0.1
      pid-file=$TMPDIR/p2
      log-error=$TMPDIR/e2.err
      EOC
       
      mariadbd-multi --defaults-file=$TMPDIR/multi.cnf --no-log --silent start 2; sleep 5
      mariadb --no-defaults -uroot -h127.0.0.1 -P13307 -BNe 'SELECT @@socket, @@port' 2>/dev/null
      mariadbd-multi --defaults-file=$TMPDIR/multi.cnf --no-log --silent report 2
      mariadbd-multi --defaults-file=$TMPDIR/multi.cnf --no-log --silent --tcp-ip report 2
      mariadbd-multi --defaults-file=$TMPDIR/multi.cnf --no-log --silent stop 2; sleep 5
      [ -e $TMPDIR/p2 ] && echo "server 2 running" || echo "server 2 stopped"
       
      # Cleanup
      mariadb-admin --no-defaults -uroot -h127.0.0.1 -P13307 shutdown >/dev/null 2>&1; sleep 3; 
      rm -rf $TMPDIR
      

      Actual result

      mariadbd-multi log file version 3.0; run: Tue Nov 10 10:34:34 2026
       
      Starting MariaDB servers
      	13307
      mariadbd-multi log file version 3.0; run: Tue Nov 10 10:34:39 2026
      Reporting MariaDB servers
      MariaDB server from group: mysqld2 is not running
      mariadbd-multi log file version 3.0; run: Tue Nov 10 10:34:39 2026
      Reporting MariaDB servers
      MariaDB server from group: mysqld2 is running
      mariadbd-multi log file version 3.0; run: Tue Nov 10 10:34:39 2026
       
      Stopping MariaDB servers
      /test/mtest/MDEV-42003/MD031126-mariadb-13.2.0-linux-x86_64-opt/bin/mariadb-admin: connect to server at 'localhost' failed
      error: 'Can't connect to local server through socket '' (111)'
      Check that mariadbd is running and that the socket: '' exists!
      server 2 running
        

      Expected result

      mariadbd-multi log file version 3.0; run: Tue Nov 10 10:51:23 2026
       
      Starting MariaDB servers
      	13307
      mariadbd-multi log file version 3.0; run: Tue Nov 10 10:51:28 2026
      Reporting MariaDB servers
      MariaDB server from group: mysqld2 is running
      mariadbd-multi log file version 3.0; run: Tue Nov 10 10:51:28 2026
      Reporting MariaDB servers
      MariaDB server from group: mysqld2 is running
      mariadbd-multi log file version 3.0; run: Tue Nov 10 10:51:28 2026
       
      Stopping MariaDB servers
      WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
      server 2 stopped
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5h
                  0.5h

                  Git Integration

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