-
Problem report
-
Resolution: Duplicate
-
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)
-
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).