Postgresql WAL check failing when node is in recovery

XMLWordPrintable

    • Type: Problem report
    • Resolution: Cannot Reproduce
    • Priority: Trivial
    • None
    • Affects Version/s: 5.4.5
    • Component/s: Agent2 plugin (G)
    • None
    • Environment:
      Linux OL7
      Zabbix Server and Proxy in docker

      The Postgresql Plugin for doing WAL Checks will fail the alert when the node is in recovery as a cluster backup. It seems like this shouldn't be a failure as its not exactly an issue

       

      Looking to see what gets executed these are the results:

      sudo -u postgres psql -c 'SELECT pg_is_in_recovery()'
      pg_is_in_recovery
      -------------------
      t
      (1 row)

       

      sudo -u postgres psql -c 'SELECT COUNT FROM pg_stat_wal_receiver'
      count
      -------
      1
      (1 row)

       

      I know there are dependent items for this check, but it since there isn't exactly an issue seems like the item should be passing its checks.

       

            Assignee:
            Aleksandr Iantsen
            Reporter:
            Dennis Whitney
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: