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

Backend PG database, HA done by Keepalived, can cause Zabbix server to crash during DB switching

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 6.0.24, 6.0.25, 6.0.26rc1, 6.4.9, 6.4.10, 6.4.11rc1, 7.0.0alpha7, 7.0.0alpha8, 7.0.0alpha9, 7.0 (plan)
    • Server (S)
    • None

      The backend is a PostgreSQL database,
      When the main database fails and switches to the backup database, after the backup database obtains the virtual IP,
      Start switching to the main database (prior to this, the pg database was in a read-only state).
      This will cause the zabbix Server service to crash

      zbx log Error:
      979436:20230106:161849.497 [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]
      979436:20230106:161849.498 HA manager has been paused
      979433:20230106:161849.498 HA manager error: database error
      979436:20230106:161849.532 HA manager has been stopped
      979433:20230106:161849.534 Zabbix Server stopped. Zabbix 6.0.24 (revision b2b72d85a4d).

       

            aigars.kadikis Aigars Kadikis
            wengchenxu wengchenxu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: