Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-20116

HA node is becomes unavailable after network connection is restored

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Won't fix
    • 6.0.0alpha5
    • 6.0 (plan)
    • Server (S)
    • Team A
    • Sprint 81 (Oct 2021)
    • 1

    Description

      MySQL: If an Active node has issues with DB connection and then another node takes over the active state, after the connection is restored the previously Active node remains in set to status Standby and after the failover delay passes it becomes Unavailable again instead of remaining is Standby status (Active since is not updated after restoring the connection).

      Steps to reproduce:

      1. Set up a High availability cluster with 1 active node and 1 standby node
      2. Turn of the network for the node that is in Active status
      3. Wait for the failover period to pass
      4. Observe that the previously active node is now in status Unknown and that the standby node is now active
      5. Restore the connection to the node in status unavailable
      6. Observe that The Unavailable node is now in status Standby, but the Last access is not updated every 5 sec
      7. Wait for Failover delay to pass

      Result: even though the connection is restored, the standby node becomes unavaiable again, last access is not updated.
      Expected: Last access should be updated each 5 sec and node should be in Standby mode after the connection is restored.

      Log file: zabbix_server_2nd_time.log
      Full mysql process list: full_list_while_still_running.csv

      Attachments

        Activity

          People

            vso Vladislavs Sokurenko
            solonkins Sergejs Olonkins
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: