[MDEV-25423] Donor node fails to shutdown after mysqldump SST Created: 2021-04-15  Updated: 2021-04-19  Resolved: 2021-04-19

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.4, 10.5, 10.6
Fix Version/s: 10.4.19, 10.5.10

Type: Bug Priority: Major
Reporter: Ramesh Sivaraman Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: not-10.2, not-10.3


 Description   

Donor node fails to shutdown after mysqldump SST
Testcase

/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt/scripts/mariadb-install-db --no-defaults --force --auth-root-authentication-method=normal --basedir=/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt --datadir=/test/mtest/node1
 
/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt/scripts/mariadb-install-db --no-defaults --force --auth-root-authentication-method=normal --basedir=/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt --datadir=/test/mtest/node2
 
/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt/bin/mysqld --defaults-file=/test/mtest/n1.cnf --wsrep-new-cluster &
 
/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt/bin/mysql -uroot -S/test/mtest/node1/node1_socket.sock -e 'create database if not exists test'
 
sysbench /usr/share/sysbench/oltp_insert.lua --table-size=1000 --tables=10 --mysql-db=test --mysql-user=root --threads=10 --db-driver=mysql --mysql-socket=/test/mtest/node1/node1_socket.sock prepare
 
/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt/bin/mysqld --defaults-file=/test/mtest/n2.cnf &
 
/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt/bin/mysqladmin -uroot -S/test/mtest/node2/node2_socket.sock shutdown
 
# Donor node fails to stop
/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt/bin/mysqladmin -uroot -S/test/mtest/node1/node1_socket.sock shutdown

n1.cnf

[mysqld]
wsrep_cluster_address=gcomm://127.0.0.1:4951,127.0.0.1:3898,
wsrep_provider_options="gmcast.listen_addr=tcp://127.0.0.1:4951;"
tmpdir=/test/mtest/tmp1
socket=/test/mtest/node1/node1_socket.sock
datadir=/test/mtest/node1
port=7402
log-error=/test/mtest/logs/node1.err
wsrep_node_address=127.0.0.1
wsrep_node_incoming_address=127.0.0.1
server-id=101
basedir=/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt
wsrep-debug=1
innodb_file_per_table
innodb_autoinc_lock_mode=2
wsrep-provider=/test/mtest/GAL_MD150321-mariadb-10.6.0-linux-x86_64-opt/lib/libgalera_smm.so
wsrep_sst_auth=root:
wsrep_sst_method=mysqldump
binlog_format=ROW
log-output=none
wsrep_on=1
wsrep_slave_threads=2

Log from donor node

2021-04-14 21:18:05 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2021-04-14 21:18:05 2 [Note] WSREP: wsrep running threads now: 1
2021-04-14 21:18:05 3 [Note] WSREP: Applier thread exiting ret: 6 thd: 3
2021-04-14 21:18:05 3 [Note] WSREP: closing applier 3
2021-04-14 21:18:05 3 [Note] WSREP: wsrep system thread: 3, 0x1468f8000c58 closing
2021-04-14 21:18:05 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication)
2021-04-14 21:18:05 3 [Note] WSREP: wsrep running threads now: 0
2021-04-14 21:18:05 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-04-14 21:18:07 0 [Note] WSREP: Donor waited 30 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:18:25 0 [Note] WSREP: wsrep_deinit
2021-04-14 21:18:25 0 [Note] WSREP: dtor state: CLOSED
2021-04-14 21:18:25 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0.0967742, misses: 28, in use: 13, in pool: 15
2021-04-14 21:18:25 0 [Note] WSREP: mon: entered 31 oooe fraction 0 oool fraction 0
2021-04-14 21:18:25 0 [Note] WSREP: mon: entered 31 oooe fraction 0.322581 oool fraction 0.0322581
2021-04-14 21:18:25 0 [Note] WSREP: mon: entered 41 oooe fraction 0 oool fraction 0
2021-04-14 21:18:25 0 [Note] WSREP: cert index usage at exit 3011
2021-04-14 21:18:25 0 [Note] WSREP: cert trx map usage at exit 13
2021-04-14 21:18:25 0 [Note] WSREP: deps set usage at exit 0
2021-04-14 21:18:25 0 [Note] WSREP: avg deps dist 4.19355
2021-04-14 21:18:25 0 [Note] WSREP: avg cert interval 5.12903
2021-04-14 21:18:25 0 [Note] WSREP: cert index size 3011
2021-04-14 21:18:25 0 [Note] WSREP: Service thread queue flushed.
2021-04-14 21:18:25 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0
2021-04-14 21:18:25 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0.677419, misses: 10, in use: 0, in pool: 10
2021-04-14 21:18:25 0 [Note] WSREP: Flushing memory map to disk...
2021-04-14 21:18:37 0 [Note] WSREP: Donor waited 60 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:19:07 0 [Note] WSREP: Donor waited 90 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:19:37 0 [Note] WSREP: Donor waited 120 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:20:07 0 [Note] WSREP: Donor waited 150 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:20:37 0 [Note] WSREP: Donor waited 180 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:21:07 0 [Note] WSREP: Donor waited 210 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:21:37 0 [Note] WSREP: Donor waited 240 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:22:07 0 [Note] WSREP: Donor waited 270 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:22:37 0 [Note] WSREP: Donor waited 300 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:23:07 0 [Note] WSREP: Donor waited 330 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:23:37 0 [Note] WSREP: Donor waited 360 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:24:07 0 [Note] WSREP: Donor waited 390 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:24:37 0 [Note] WSREP: Donor waited 420 sec, extending systemd startup timeout as SSTis not completed
2021-04-14 21:25:07 0 [Note] WSREP: Donor waited 450 sec, extending systemd startup timeout as SSTis not completed


Generated at Thu Feb 08 09:37:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.