-
Problem report
-
Resolution: Unresolved
-
Blocker
-
7.0.13
-
None
-
Sprint candidates
Steps to reproduce:
- use 7.0.12+ with change mentioned under
ZBX-26038
Result:
1344962:20250620:030612.794 database is down: retrying in 10 seconds 1344962:20250620:030622.816 database connection re-established 1344962:20250620:030622.817 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030622.817 database is down: retrying in 10 seconds 1344962:20250620:030632.839 database connection re-established 1344962:20250620:030632.840 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030632.840 database is down: retrying in 10 seconds 1344962:20250620:030642.864 database connection re-established 1344962:20250620:030642.866 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030642.866 database is down: retrying in 10 seconds 1344962:20250620:030652.890 database connection re-established 1344962:20250620:030652.891 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030652.891 database is down: retrying in 10 seconds 1344962:20250620:030702.916 database connection re-established 1344962:20250620:030702.917 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030702.917 database is down: retrying in 10 seconds 1344962:20250620:030712.943 database connection re-established 1344962:20250620:030712.944 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030712.944 database is down: retrying in 10 seconds 1344962:20250620:030722.967 database connection re-established 1344962:20250620:030722.968 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030722.968 database is down: retrying in 10 seconds 1344962:20250620:030732.992 database connection re-established 1344962:20250620:030732.993 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030732.993 database is down: retrying in 10 seconds 1344962:20250620:030743.017 database connection re-established 1344962:20250620:030743.018 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030743.018 database is down: retrying in 10 seconds 1344962:20250620:030753.040 database connection re-established 1344962:20250620:030753.041 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030753.041 database is down: retrying in 10 seconds 1344962:20250620:030803.067 database connection re-established 1344962:20250620:030803.069 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030803.069 database is down: retrying in 10 seconds 1344962:20250620:030813.091 database connection re-established 1344962:20250620:030813.092 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030813.092 database is down: retrying in 10 seconds 1344962:20250620:030823.114 database connection re-established 1344962:20250620:030823.115 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030823.115 database is down: retrying in 10 seconds 1344962:20250620:030833.139 database connection re-established 1344962:20250620:030833.140 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030833.140 database is down: retrying in 10 seconds 1344962:20250620:030843.163 database connection re-established 1344962:20250620:030843.164 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030843.164 database is down: retrying in 10 seconds 1344962:20250620:030853.187 database connection re-established 1344962:20250620:030853.188 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030853.188 database is down: retrying in 10 seconds 1344962:20250620:030903.210 database connection re-established 1344962:20250620:030903.211 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030903.211 database is down: retrying in 10 seconds 1344962:20250620:030913.238 database connection re-established 1344962:20250620:030913.239 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030913.239 database is down: retrying in 10 seconds 1344962:20250620:030923.263 database connection re-established 1344962:20250620:030923.264 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030923.264 database is down: retrying in 10 seconds 1344962:20250620:030933.286 database connection re-established 1344962:20250620:030933.287 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030933.287 database is down: retrying in 10 seconds 1344962:20250620:030943.310 database connection re-established 1344962:20250620:030943.311 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030943.311 database is down: retrying in 10 seconds 1344962:20250620:030953.334 database connection re-established 1344962:20250620:030953.335 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:030953.335 database is down: retrying in 10 seconds 1344962:20250620:031003.358 database connection re-established 1344962:20250620:031003.359 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031003.359 database is down: retrying in 10 seconds 1344962:20250620:031013.387 database connection re-established 1344962:20250620:031013.388 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031013.388 database is down: retrying in 10 seconds 1344962:20250620:031023.410 database connection re-established 1344962:20250620:031023.411 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031023.411 database is down: retrying in 10 seconds 1344962:20250620:031033.433 database connection re-established 1344962:20250620:031033.435 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031033.435 database is down: retrying in 10 seconds 1344962:20250620:031043.458 database connection re-established 1344962:20250620:031043.460 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031043.460 database is down: retrying in 10 seconds 1344962:20250620:031053.486 database connection re-established 1344962:20250620:031053.487 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031053.487 database is down: retrying in 10 seconds 1344962:20250620:031103.516 database connection re-established 1344962:20250620:031103.517 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031103.517 database is down: retrying in 10 seconds 1344962:20250620:031113.540 database connection re-established 1344962:20250620:031113.541 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031113.541 database is down: retrying in 10 seconds 1344962:20250620:031123.567 database connection re-established 1344962:20250620:031123.569 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031123.569 database is down: retrying in 10 seconds 1344962:20250620:031133.594 database connection re-established 1344962:20250620:031133.595 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031133.595 database is down: retrying in 10 seconds 1344962:20250620:031143.618 database connection re-established 1344962:20250620:031143.619 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031143.619 database is down: retrying in 10 seconds 1344962:20250620:031153.642 database connection re-established 1344962:20250620:031153.643 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031153.643 database is down: retrying in 10 seconds 1344962:20250620:031203.665 database connection re-established 1344962:20250620:031203.666 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031203.666 database is down: retrying in 10 seconds 1344962:20250620:031213.689 database connection re-established 1344962:20250620:031213.690 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031213.690 database is down: retrying in 10 seconds 1344962:20250620:031223.712 database connection re-established 1344962:20250620:031223.714 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031223.714 database is down: retrying in 10 seconds 1344962:20250620:031233.737 database connection re-established 1344962:20250620:031233.738 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031233.738 database is down: retrying in 10 seconds 1344962:20250620:031243.759 database connection re-established 1344962:20250620:031243.760 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031243.760 database is down: retrying in 10 seconds 1344962:20250620:031253.787 database connection re-established 1344962:20250620:031253.788 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031253.788 database is down: retrying in 10 seconds 1344962:20250620:031303.810 database connection re-established 1344962:20250620:031303.811 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031303.811 database is down: retrying in 10 seconds 1344962:20250620:031313.838 database connection re-established 1344962:20250620:031313.839 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031313.839 database is down: retrying in 10 seconds 1344962:20250620:031323.861 database connection re-established 1344962:20250620:031323.862 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031323.862 database is down: retrying in 10 seconds 1344962:20250620:031333.884 database connection re-established 1344962:20250620:031333.885 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031333.885 database is down: retrying in 10 seconds 1344962:20250620:031343.908 database connection re-established 1344962:20250620:031343.909 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031343.909 database is down: retrying in 10 seconds 1344962:20250620:031353.937 database connection re-established 1344962:20250620:031353.939 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031353.939 database is down: retrying in 10 seconds 1344962:20250620:031403.961 database connection re-established 1344962:20250620:031403.962 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031403.962 database is down: retrying in 10 seconds 1344962:20250620:031413.985 database connection re-established 1344962:20250620:031413.986 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031413.986 database is down: retrying in 10 seconds 1344962:20250620:031424.010 database connection re-established 1344962:20250620:031424.011 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031424.011 database is down: retrying in 10 seconds 1344962:20250620:031434.036 database connection re-established 1344962:20250620:031434.037 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031434.037 database is down: retrying in 10 seconds 1344962:20250620:031444.065 database connection re-established 1344962:20250620:031444.066 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031444.066 database is down: retrying in 10 seconds 1344962:20250620:031454.092 database connection re-established 1344962:20250620:031454.094 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031454.094 database is down: retrying in 10 seconds 1344962:20250620:031504.118 database connection re-established 1344962:20250620:031504.119 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031504.119 database is down: retrying in 10 seconds 1344962:20250620:031514.143 database connection re-established 1344962:20250620:031514.144 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction 1344962:20250620:031514.144 database is down: retrying in 10 seconds 1344962:20250620:031524.171 database connection re-established 1344962:20250620:031524.173 [Z3009] query failed due to read-only transaction: [0] PGRES_FATAL_ERROR:ERROR: cannot execute UPDATE in a read-only transaction
12 hours of read only for PCS enabled cluster...
Expected:
Do not break working functionality.
- caused by
-
ZBX-26038 Zabbix server goes down during DB failover process
-
- Closed
-