gpdr configure backup report error "backup and archive info files exist but do not match the database"
search cancel

gpdr configure backup report error "backup and archive info files exist but do not match the database"

book

Article ID: 416755

calendar_today

Updated On:

Products

VMware Tanzu Greenplum

Issue/Introduction

When running gpdr configure backup, it may report error 

2025-11-03 01:14:52.129 P00   INFO: stanza-create command begin 2.48+GPDR.6: --config=/usr/local/gpdr/configs/pgbackrest-seg-1.conf --db-timeout=360000 --exec-id=289306-7ccb6cd6 --log-level-console=warn --log-path=/usr/local/gpdr/logs --pg1-path=/data/master/gpseg755-1 --pg1-port=5432 --pg1-socket-path=/tmp --pg1-user=gpadmin --repo1-host=pt1 --repo1-host-cmd="source /usr/local/greenplum-db-7.5.5/greenplum_path.sh && /usr/local/gpdr/bin/pgbackrest" --repo1-host-user=gpadmin --repo1-path=/data/master/stanza-1 --repo1-type=posix --stanza=gpdb-seg-1
2025-11-03 01:14:52.735 P00   INFO: stanza-create for stanza 'gpdb-seg-1' on repo1
2025-11-03 01:14:53.054 P00  ERROR: [028]: backup and archive info files exist but do not match the database
                                    HINT: is this the correct stanza?
                                    HINT: did an error occur during stanza-upgrade?
2025-11-03 01:14:53.054 P00   INFO: stanza-create command end: aborted with exception [028]
(END)

Environment

GDPB v7.5.5

Cause

This is caused by the recovery cluster already have some old or existing stanza setting there. It may located at /data/master at coordinator host or /data1/primary at the segment host. One example as below.

/data/master/stanza-1/archive/gpdb-seg-1/archive.info

Resolution

It's better remove or rename all the stanza-1 directory from all host of the recovery cluster before running "gpdr configure" from the primary cluster.