Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5, 10.6
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
|