You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Commit e05acca
Browse filesBrowse the repository at this point in the historyBrowse files
fix(postgres-operator): bump CloudNativePG to 1.28.1 to fix backup session skew
The chart pinned the operator image to 1.27.3 (values override) while shipping
the CNPG CRDs from chart appVersion 1.27.1 — upstream publishes no 1.27.2/1.27.3
chart (the line jumps 0.26.1=1.27.1 -> 0.27.0=1.28.0), so the image bump in
845192b could not carry matching CRDs. The 1.27.3 operator records backup
sessions in status.instanceID.sessionID on the Backup CR, but the 1.27.1 CRD
does not define that field, so the API server prunes it; the operator then
cannot correlate the running backup with the instance session, concludes the
instance manager restarted, and fails EVERY backup cluster-wide with
'instance manager was restarted during backup' (native barmanObjectStore and
the barman-cloud plugin alike). This blocked #3300 end to end.
Bump the vendored cloudnative-pg chart 0.26.1 -> 0.27.1 (appVersion 1.28.1) and
drop the image.tag override so the operator, its CRDs and the injected instance
manager all move together. 1.28.1 defines status.instanceID.sessionID, so
backups validate correctly. Verified on a dev cluster: after the bump the
'instance manager was restarted' failure is gone and plugin backups proceed
through the barman upload stage.
Note: Helm does not upgrade CRD schemas on , so existing clusters
need the regenerated CNPG CRDs applied out of band (kubectl apply) for the fix
to take effect — a fresh install picks them up automatically.
Co-Authored-By: Claude Opus 4.8 (1M context) <[email protected]>
Signed-off-by: Andrey Kolkov <[email protected]>
Copy file name to clipboardExpand all lines: packages/system/postgres-operator/charts/cloudnative-pg/values.yaml
+75-71Lines changed: 75 additions & 71 deletions
Original file line number
Diff line number
Diff line change
@@ -210,30 +210,30 @@ monitoringQueriesConfigMap:
210
210
queries: |
211
211
backends:
212
212
query: |
213
-
SELECT sa.datname
214
-
, sa.usename
215
-
, sa.application_name
216
-
, states.state
217
-
, COALESCE(sa.count, 0) AS total
218
-
, COALESCE(sa.max_tx_secs, 0) AS max_tx_duration_seconds
219
-
FROM ( VALUES ('active')
220
-
, ('idle')
221
-
, ('idle in transaction')
222
-
, ('idle in transaction (aborted)')
223
-
, ('fastpath function call')
224
-
, ('disabled')
225
-
) AS states(state)
226
-
LEFT JOIN (
227
-
SELECT datname
228
-
, state
229
-
, usename
230
-
, COALESCE(application_name, '') AS application_name
231
-
, COUNT(*)
232
-
, COALESCE(EXTRACT (EPOCH FROM (max(now() - xact_start))), 0) AS max_tx_secs
233
-
FROM pg_catalog.pg_stat_activity
234
-
GROUP BY datname, state, usename, application_name
235
-
) sa ON states.state = sa.state
236
-
WHERE sa.usename IS NOT NULL
213
+
SELECT sa.datname
214
+
, sa.usename
215
+
, sa.application_name
216
+
, states.state
217
+
, COALESCE(sa.count, 0) AS total
218
+
, COALESCE(sa.max_tx_secs, 0) AS max_tx_duration_seconds
219
+
FROM ( VALUES ('active')
220
+
, ('idle')
221
+
, ('idle in transaction')
222
+
, ('idle in transaction (aborted)')
223
+
, ('fastpath function call')
224
+
, ('disabled')
225
+
) AS states(state)
226
+
LEFT JOIN (
227
+
SELECT datname
228
+
, state
229
+
, usename
230
+
, COALESCE(application_name, '') AS application_name
231
+
, COUNT(*)
232
+
, COALESCE(EXTRACT (EPOCH FROM (max(now() - xact_start))), 0) AS max_tx_secs
233
+
FROM pg_catalog.pg_stat_activity
234
+
GROUP BY datname, state, usename, application_name
235
+
) sa ON states.state = sa.state
236
+
WHERE sa.usename IS NOT NULL
237
237
metrics:
238
238
- datname:
239
239
usage: "LABEL"
@@ -256,22 +256,22 @@ monitoringQueriesConfigMap:
256
256
257
257
backends_waiting:
258
258
query: |
259
-
SELECT count(*) AS total
260
-
FROM pg_catalog.pg_locks blocked_locks
261
-
JOIN pg_catalog.pg_locks blocking_locks
262
-
ON blocking_locks.locktype = blocked_locks.locktype
263
-
AND blocking_locks.database IS NOT DISTINCT FROM blocked_locks.database
264
-
AND blocking_locks.relation IS NOT DISTINCT FROM blocked_locks.relation
265
-
AND blocking_locks.page IS NOT DISTINCT FROM blocked_locks.page
266
-
AND blocking_locks.tuple IS NOT DISTINCT FROM blocked_locks.tuple
267
-
AND blocking_locks.virtualxid IS NOT DISTINCT FROM blocked_locks.virtualxid
268
-
AND blocking_locks.transactionid IS NOT DISTINCT FROM blocked_locks.transactionid
269
-
AND blocking_locks.classid IS NOT DISTINCT FROM blocked_locks.classid
270
-
AND blocking_locks.objid IS NOT DISTINCT FROM blocked_locks.objid
271
-
AND blocking_locks.objsubid IS NOT DISTINCT FROM blocked_locks.objsubid
272
-
AND blocking_locks.pid != blocked_locks.pid
273
-
JOIN pg_catalog.pg_stat_activity blocking_activity ON blocking_activity.pid = blocking_locks.pid
274
-
WHERE NOT blocked_locks.granted
259
+
SELECT count(*) AS total
260
+
FROM pg_catalog.pg_locks blocked_locks
261
+
JOIN pg_catalog.pg_locks blocking_locks
262
+
ON blocking_locks.locktype = blocked_locks.locktype
263
+
AND blocking_locks.database IS NOT DISTINCT FROM blocked_locks.database
264
+
AND blocking_locks.relation IS NOT DISTINCT FROM blocked_locks.relation
265
+
AND blocking_locks.page IS NOT DISTINCT FROM blocked_locks.page
266
+
AND blocking_locks.tuple IS NOT DISTINCT FROM blocked_locks.tuple
267
+
AND blocking_locks.virtualxid IS NOT DISTINCT FROM blocked_locks.virtualxid
268
+
AND blocking_locks.transactionid IS NOT DISTINCT FROM blocked_locks.transactionid
269
+
AND blocking_locks.classid IS NOT DISTINCT FROM blocked_locks.classid
270
+
AND blocking_locks.objid IS NOT DISTINCT FROM blocked_locks.objid
271
+
AND blocking_locks.objsubid IS NOT DISTINCT FROM blocked_locks.objsubid
272
+
AND blocking_locks.pid != blocked_locks.pid
273
+
JOIN pg_catalog.pg_stat_activity blocking_activity ON blocking_activity.pid = blocking_locks.pid
274
+
WHERE NOT blocked_locks.granted
275
275
metrics:
276
276
- total:
277
277
usage: "GAUGE"
@@ -309,16 +309,17 @@ monitoringQueriesConfigMap:
309
309
description: "Time at which postgres started (based on epoch)"
310
310
311
311
pg_replication:
312
-
query: "SELECT CASE WHEN (
313
-
NOT pg_catalog.pg_is_in_recovery()
314
-
OR pg_catalog.pg_last_wal_receive_lsn() = pg_catalog.pg_last_wal_replay_lsn())
315
-
THEN 0
316
-
ELSE GREATEST (0,
317
-
EXTRACT(EPOCH FROM (now() - pg_catalog.pg_last_xact_replay_timestamp())))
318
-
END AS lag,
319
-
pg_catalog.pg_is_in_recovery() AS in_recovery,
320
-
EXISTS (TABLE pg_stat_wal_receiver) AS is_wal_receiver_up,
321
-
(SELECT count(*) FROM pg_catalog.pg_stat_replication) AS streaming_replicas"
312
+
query: |
313
+
SELECT CASE WHEN (
314
+
NOT pg_catalog.pg_is_in_recovery()
315
+
OR pg_catalog.pg_last_wal_receive_lsn() = pg_catalog.pg_last_wal_replay_lsn())
316
+
THEN 0
317
+
ELSE GREATEST (0,
318
+
EXTRACT(EPOCH FROM (now() - pg_catalog.pg_last_xact_replay_timestamp())))
319
+
END AS lag,
320
+
pg_catalog.pg_is_in_recovery() AS in_recovery,
321
+
EXISTS (TABLE pg_stat_wal_receiver) AS is_wal_receiver_up,
322
+
(SELECT count(*) FROM pg_catalog.pg_stat_replication) AS streaming_replicas
322
323
metrics:
323
324
- lag:
324
325
usage: "GAUGE"
@@ -374,6 +375,9 @@ monitoringQueriesConfigMap:
374
375
, COALESCE(CAST(CAST('x'||pg_catalog.right(pg_catalog.split_part(last_failed_wal, '.', 1), 16) AS pg_catalog.bit(64)) AS pg_catalog.int8), -1) AS last_failed_wal_start_lsn
375
376
, EXTRACT(EPOCH FROM stats_reset) AS stats_reset_time
376
377
FROM pg_catalog.pg_stat_archiver
378
+
predicate_query: |
379
+
SELECT NOT pg_catalog.pg_is_in_recovery()
380
+
OR pg_catalog.current_setting('archive_mode') = 'always'
377
381
metrics:
378
382
- archived_count:
379
383
usage: "COUNTER"
@@ -586,20 +590,20 @@ monitoringQueriesConfigMap:
586
590
pg_stat_replication:
587
591
primary: true
588
592
query: |
589
-
SELECT usename
590
-
, COALESCE(application_name, '') AS application_name
591
-
, COALESCE(client_addr::text, '') AS client_addr
592
-
, COALESCE(client_port::text, '') AS client_port
593
-
, EXTRACT(EPOCH FROM backend_start) AS backend_start
594
-
, COALESCE(pg_catalog.age(backend_xmin), 0) AS backend_xmin_age
595
-
, pg_catalog.pg_wal_lsn_diff(pg_catalog.pg_current_wal_lsn(), sent_lsn) AS sent_diff_bytes
596
-
, pg_catalog.pg_wal_lsn_diff(pg_catalog.pg_current_wal_lsn(), write_lsn) AS write_diff_bytes
597
-
, pg_catalog.pg_wal_lsn_diff(pg_catalog.pg_current_wal_lsn(), flush_lsn) AS flush_diff_bytes
598
-
, COALESCE(pg_catalog.pg_wal_lsn_diff(pg_catalog.pg_current_wal_lsn(), replay_lsn),0) AS replay_diff_bytes
599
-
, COALESCE((EXTRACT(EPOCH FROM write_lag)),0)::float AS write_lag_seconds
600
-
, COALESCE((EXTRACT(EPOCH FROM flush_lag)),0)::float AS flush_lag_seconds
601
-
, COALESCE((EXTRACT(EPOCH FROM replay_lag)),0)::float AS replay_lag_seconds
602
-
FROM pg_catalog.pg_stat_replication
593
+
SELECT usename
594
+
, COALESCE(application_name, '') AS application_name
595
+
, COALESCE(client_addr::text, '') AS client_addr
596
+
, COALESCE(client_port::text, '') AS client_port
597
+
, EXTRACT(EPOCH FROM backend_start) AS backend_start
598
+
, COALESCE(pg_catalog.age(backend_xmin), 0) AS backend_xmin_age
599
+
, pg_catalog.pg_wal_lsn_diff(pg_catalog.pg_current_wal_lsn(), sent_lsn) AS sent_diff_bytes
600
+
, pg_catalog.pg_wal_lsn_diff(pg_catalog.pg_current_wal_lsn(), write_lsn) AS write_diff_bytes
601
+
, pg_catalog.pg_wal_lsn_diff(pg_catalog.pg_current_wal_lsn(), flush_lsn) AS flush_diff_bytes
602
+
, COALESCE(pg_catalog.pg_wal_lsn_diff(pg_catalog.pg_current_wal_lsn(), replay_lsn),0) AS replay_diff_bytes
603
+
, COALESCE((EXTRACT(EPOCH FROM write_lag)),0)::float AS write_lag_seconds
604
+
, COALESCE((EXTRACT(EPOCH FROM flush_lag)),0)::float AS flush_lag_seconds
605
+
, COALESCE((EXTRACT(EPOCH FROM replay_lag)),0)::float AS replay_lag_seconds
0 commit comments