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

Zabbix server goes down during DB failover process

XMLWordPrintable

    • S25-W8/9

      Issue:
      HA manager stops and Zabbix Server goes down during DB failover process.

      416837:20250127:203322.364 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  cannot execute SELECT FOR UPDATE in a read-only transaction
 [select ha_nodeid,name,status,lastaccess,address,port,ha_sessionid from ha_node order by ha_nodeid for update]
416837:20250127:203322.366 HA manager has been paused
416836:20250127:203322.368 HA manager error: database error
416837:20250127:203322.414 HA manager has been stopped
416836:20250127:203322.416 Zabbix Server stopped. Zabbix 6.0.35 (revision 8a9017e52e7).

      This problem is same as ZBX-23685.
      The fix for ZBX-23685 works only when HANodeName of zabbix_server.conf is set, but the customer now uses zabbix server in standalone mode and won't use Zabbix HA.

      Expected:
      The requirement is the consistent behavior as we had prior to Zabbix 5.0 even without Zabbix HA.

            sboidenko Sergejs Boidenko
            shirai Sayaka Hirai
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: