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

grastate.dat is not updated on node shutdown.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Not a Bug
    • None
    • N/A
    • Galera, Galera SST
    • None
    • CentOS Linux release 7.7.1908. 3 nodes. Intel(R) Xeon(R) Gold 6142 CPU @ 2.60GHz with 64 CPU's. Bare metal. 512GB RAM, galera-enterprise-4-26.4.14-1.el7_9.src.rpm

    Description

      During the normal shutdown of MariaDB 10.5.22 cluster node, grastate.dat-file is not updated and that leads to SST on start always. IST won't be available.

      [root@node6 ~]# date;ls -la /var/lib/mysql/datadir/grastate.dat ;cat /var/lib/mysql/datadir/grastate.dat; ps -auxww|grep mariadb |grep -v grep ; systemctl stop mariadb && ls -la /var/lib/mysql/datadir/grastate.dat ;cat /var/lib/mysql/datadir/grastate.dat; ps -auxww|grep mariadb |grep -v grep;date
      Fri Nov 17 09:50:34 +06 2023
      -rw-rw----. 1 mysql mysql 119 Nov 16 17:40 /var/lib/mysql/datadir/grastate.dat
      # GALERA saved state
      version: 2.1
      uuid:    00000000-0000-0000-0000-000000000000
      seqno:   -1
      safe_to_bootstrap: 0
            mysql    20759  751 71.6 467978704 378103816 ? Ssl  Nov16 10190:33 /usr/sbin/mariadbd --wsrep_start_position=5256dcba-7f0c-11ee-aabd-4fc1491ca19b:79256066
      -rw-rw----. 1 mysql mysql 119 Nov 16 17:40 /var/lib/mysql/datadir/grastate.dat
      # GALERA saved state
      version: 2.1
      uuid:    00000000-0000-0000-0000-000000000000
      seqno:   -1
      safe_to_bootstrap: 0
            Fri Nov 17 09:51:08 +06 2023
      [root@node6 ~]#

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            mihaQ MikaH
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.