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

Donor node fails to shutdown after mysqldump SST

    XMLWordPrintable

    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

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: