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

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

      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

        1. full_list_while_still_running.csv
          5 kB
          Sergejs Olonkins
        2. zabbix_server_2nd_time.log
          521 kB
          Sergejs Olonkins

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

              Created:
              Updated:
              Resolved: