Search Engine: Elastic

Article ID: 132039, created on Jan 9, 2018, last review on Jun 19, 2018

  • Applies to:
  • Operations Automation 7.2
  • Operations Automation 7.3

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.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 31987597efff5a3a9ce779cc203bbe5e 1941880841f714e458ae4dc3d9f3062d dd79f16c76b9dca75205ab5e9f5465ea

Email subscription for changes to this article
Save as PDF