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

Seconds_Behind_Master gives impossible values

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.6.18
    • N/A
    • Galera, Replication
    • None
    • Linux x86_64

    Description

      After upgrade from 10.6.17 to 10.6.18, our monitoring started to give alerts multiple times a day from all replicas becuase Seconds_Behind_Master > 3600.

      It looks to me that value is no more seconds.

      Tested by checking value every two seconds. value jumps from 0 to 40726, might increase a bit for checks, and then reset back to 0.

      It is completey impossible for this value to jump from 0 to 40726 seconds in two seconds.
      Clearly a regression.

      It looks like time increases at the same time on all replicas, replication is set to replicate from galera cluster.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31413 Node has been dropped from the cluster on Startup / Shutdown with async replica

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is part of

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34924 gtid_slave_pos table rows newer been deleted on non replica nodes (wsrep_gtid_mode = 1)

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33977 MariaDB hangs on --wsrep-recover phase

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed

          Activity

            People

              janlindstrom Jan Lindström
              bleve Tuomo Soini
              Votes:
              1 Vote for this issue
              Watchers:
              11 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.