Upgrade failed on stage 9 of 14 in Aria Operations

Products

• VMware Aria Suite

Issue/Introduction

Upgrade failed on stage 9 of 14, showing the following error

Failedresource key=pak_manager.action_failed, resource args=[run master postgres db

The following error also appears on centralsqldbupgrade.log

2025-04-24 15:07:14,792 ERROR [main] .processSQL - error:  
> org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [DO $$  
> BEGIN  
> alter table metric_key add column if not exists attribute_key text;  
> update metric_key set attribute_key = regexp_replace(metric_key, ':[^\|]*|', '|', 'g');  
> alter table metric_key alter attribute_key set not null;  
> create index if not exists idx_metric_key_attribute_key on metric_key (attribute_key);  
> END;  
> $$;]; SQL state [XX001]; error code [0]; ERROR: invalid page in block 286 of relation base/16401/65474  
> Where: SQL statement "update metric_key set attribute_key = regexp_replace(metric_key, ':[^\|]*|', '|', 'g')"  
> PL/pgSQL function inline_code_block line 4 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: invalid page in block 286 of relation base/16401/65474  
> Where: SQL statement "update metric_key set attribute_key = regexp_replace(metric_key, ':[^\|]*|', '|', 'g')"  
> PL/pgSQL function inline_code_block line 4 at SQL statement

Environment

Aria Operations 8.x

Cause

Repl db corruption in the DB table is causing failure during the central DB upgrade step.

Resolution

Please open a ticket with GS Support.