Duplicate backup storages in different namespaces causes pg backup problems

Description

Hi @oksana.grishchenko, It seems that we can create duplicate backup storages in different namespaces now. This confuses the system for postgresql databases and this error is displayed

Scheduled Backups stay in Unknown status

 

Environment

None

Attachments

5

Activity

Show:

Manish Chawla September 19, 2024 at 1:56 PM

Tested with Everest v1.2.0-rc3 version and did not observe the issue. Manual and scheduled backups were successful with the backup storage having same bucket name, region and url as another one in a different namespace

Oksana Grishchenko September 13, 2024 at 8:56 AM

Hi ! thank you for providing a detailed STR. The problem was fixed only partially, created a PR to fix it completely Checked the solution according to the STR - now it works as expected. The change is small and don’t affect other functionality except of creating scheduled PG backups.

Manish Chawla September 13, 2024 at 5:11 AM

Hi , I tested this with Everest v1.2.0-rc2 version and I am observing the same issue. The scenario is as follows:

Installed mysql operator in a1 namespace and pg operator in a2 namespace.

Created a mysql database with namespace1 backup storage. Enable scheduled backups and PITR.

Created a pg database with namespace2 backup storage. Enable scheduled backups and PITR.

Both namespace1 and namsepace2 have the same bucket name, region and url.

The backup in pg database gets stuck in Unknown Status. The backup schedule is created with the namespace2 backup storage but the backup is started with namespace1 backup storage.

The everest operator displays this error in logs

Attaching the everest operator log

Please check this issue, thanks.

Manish Chawla September 9, 2024 at 11:40 AM

The backup storages have different names, namespace1 and namespace2 but the bucket name, region and url are same. The scheduled backup was created using namespace1 backup storage, but Everest started the backup using namespace2 backup storage.

Unresolved

Details

Assignee

Reporter

Fix versions

Affects versions

Priority

Smart Checklist

Created September 9, 2024 at 10:42 AM
Updated October 1, 2024 at 7:43 PM