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

Donor node fails to shutdown after mysqldump SST

Details

    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
      

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            jplindst Jan Lindström (Inactive)
            ramesh Ramesh Sivaraman
            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.