Data Repository upgrade fails with permissions error for /opt/vertica/log/local-coerce*

Products

• Network Observability
• CA Performance Management

Issue/Introduction

DX NetOps Perforemance Management Data Repository Vertica database upgrade fails due to problems with access to the current local-coerce-<Date>_<Time> directory.

The dr_install ends with a generic fail message. Reviewing the /opt/vertica/log/vertica.log we see an error.

<INFO> <PexpectAdapter: pmadmin@<IP_Node1> sudo>: (seqn=4568 rc=0) ['find: '/opt/vertica/log/local-coerce-20230825_195702': Permission denied', '/opt/vertica']

In the log directory we see this.

[root@Node0001 log]# ls -altr | grep local*
lrwxrwxrwx  1 root    root           46 Oct 16 15:49 verify-latest.xml -> local-coerce-20241016_154956/iter03/verify.xml
drwxr-xr-x  5 root    root           73 Oct 16 15:49 local-coerce-20241016_154956

Environment

All supported DX NetOps Performance Management releases

Cause

Local environmental requirements result in the file created with access requirements beyond the install owners ability.

Resolution

To resolve the problem, when the database is stopped and before running dr_validate.sh, delete the current local-coerce* directory referenced in the error message.

The next install run will result in a new one being created.

It may be necessary to take this step each time the install is run.