Symptoms

  1. Task "Install oam-aps to MN" fail with error:

    Failed to process executeInstallSequence at xpath tail HOOKS/HOOK[@when='finally' and @install='yes']/child::* for pkgId: 9408, ex message is: Failed to process EXEC command for package oam-backend of type other having pkgId: 9408, exception message: Invalid exitCode, HCL out: , HCL err: , HCL exit code: 1 input xml: <EXEC cmd="/usr/local/bin/oa-migrator" group="root" user="root" valid_exit_codes="0">
    <ARG value="init-db"/>
    </EXEC>
    
  2. OA migrator log /opt/oa-migrator/logs/debug.log contains the error:

     [2018-01-09 12:51:19,951] 139680786282304 [DBG] Command stderr: createuser: could not connect to database postgres: could not connect to server: No such file or directory
            Is the server running locally and accepting
            connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
    [2018-01-09 12:51:19,951] 139680786282304 [DBG] Command exit code: 1
    [2018-01-09 12:51:19,951] 139680786282304 [DBG] Context:
    Traceback (most recent call last):
      File "/opt/oa-migrator/lib/python2.7/site-packages/migrator/core/cli/commands/implementation_base.py", line 22, in new_func
        func(self, options)
      File "/opt/oa-migrator/lib/python2.7/site-packages/migrator/core/cli/commands/implementation/init_db.py", line 9, in run
        init_db()
      File "/opt/oa-migrator/lib/python2.7/site-packages/migrator/core/utils/init_db.py", line 41, in init_db
        error_message='role "{username}" already exists'.format(username=username)
      File "/opt/oa-migrator/lib/python2.7/site-packages/migrator/core/utils/init_db.py", line 86, in _run_local_command
        stderr_str
    MigrationError: Command 'su - postgres -c 'createuser -S -d -R oam'' executed locally failed with exit code 1.
    stdout:
    stderr:createuser: could not connect to database postgres: could not connect to server: No such file or directory
            Is the server running locally and accepting
            connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
    

Cause

Software-related issue #OAM-3065.

OA DB is running on separate node. OA migrator tries to create PostgreSQL DB user but corresponding scripts does not specify the IP address DB resides. Without hostname specified Migrator attempts to create DB user on MN which does not have PostgreSQL service running.

Resolution

Contact your Technical Account Manager or PTA team (pta@odin.com) to trace the status of #OAM-3065.

In case of PGHA is disabled according to Disabling PGHA Cluster - contact Odin Technical Support to apply workaround.

Internal content

Link on internal Article