Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
13.3
-
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
- is caused by
-
MDEV-42003 Enhance mariadbd-multi to support mariadbd prefixes
-
- In Testing
-