VMware Aria Operations upgrade from 8.17 to 8.18.1 fails with the error “error: Failedresource key=pak_manager.action_failed, resource args=[run sql db upgrade]"

Products

• VMware Aria Operations 8.x

Issue/Introduction

When attempting to upgrade from 8.17 to 8.18.1 the upgrade gets stuck on step 9 of 14 and the error “error: Failedresource key=pak_manager.action_failed, resource args=[run sql db upgrade]" is observed as seen below:

 Log /storage/db/vcops/vpostgres/data/serverlog showed:

2024-10-25 16:16:26.687 UTC 671bc45a.5b81 0    23425 8FATAL:  could not open log file "/storage/log/postgres/data/postgresql-25.log": Permission denied

• Note that postgres log storage was moved from /storage/db/vcops/vpostgres/ {data,repl}/pg_log to /storage/log/postgres/{data,repl}

  in 8.18.x.

 

Environment

VMware Aria Operations 8.x

Cause

/storage/log directory did not have the required permissions on the primary node. 

Example:

• Customer 8.17.2 primary node

  root@CUSTPRIMARY ~ ]# ll /storage
  
  drwxrwx--- 5 admin admin 4096 Sep 11  2020 log ######## WORLD READ/EXECUTE PERMISSION MISSING ########
  
  

• Clean Lab 8.17.2 primary node

  root@LABPRIMARY [ ~ ]# ll /storage
  
  drwxr-xr-x 5 root  root  4096 Oct 10 16:05 log
  

Resolution

• Fixed permissions on primary node /storage/log

  chmod 755 /storage/log