Backup page fails to load the UI – Yugabyte

Environment:

Yugabyte version- 2.12.5

Issue:

The BACKUP page just spins and fails to bring up the UI as shown in the below screenshot

Resolution :

To resolve this issue, follow the below mention steps:

Step 1: Find out the number of backups in a given universe

select count(*) from backup where backup_info->>'universeUUID' = '<your_uuid_here>’;

Step 2: Find out backups older than 10 days for a given universe:

select count(*) from backup where backup_info->>'universeUUID' = '<universe_uuid_here>' and create_time < NOW() - INTERVAL '10 DAY';

Step 3: Create a temp table which keeps backup of the current backup table:

create table backup_temp as (select * from backup);

Step 4: Delete backup older than 10 days for a given universe

delete from backup where backup_info->>'universeUUID' = '<universe_uuid_here>' and create_time < NOW() - INTERVAL '10 DAY';

Note: we are taking 10 days here as an example and that be can change it based on how old backups they want to keep. Only INTERVAL '10 DAY'; needs to be changed in that case.

Root Cause:

This is because there were many counts of backup and API failed to load in UI it is a known bug and will be fixed in the newer (2.14.1 and later) version of yugabyte

Environment:

Issue:

Resolution :

Root Cause:

Related articles