Symptoms

Task Install DB slave of OSS DB on node #xx failed with error like:

"Error: Internal error: /usr/bin/python /usr/bin/python sysdb_master_ctrl.py deploy 30 1 ******** uinode 365 /usr/local/pem/tmp/client_ctrl.py /usr/local/pem/etc/slave_db.conf failed with code 1 saying: STDOUT: '2018-02-27 06:56:51.333 [DEBUG] read agent config from /usr/local/pem/etc/pleskd.props"
...
<message>/bin/sh /bin/sh -c rpm -ql postgresql90-odbc | grep /psqlodbc\.so$ failed with code 1 saying: STDOUT: '' STDERR ''</message>
...
ERROR: role "oa_192_168_1_71" cannot be dropped because some objects depend on it
DETAIL: 1 object in database oss
Traceback (most recent call last):
File "sysdb_master_ctrl.py", line 14, in <module>
deployRv = uDBAccessAPI.deployPgSlave(slaveHostID, isBillingMaster, masterRoorPwd, readOnlyUserType, additionalIPs, slaveScriptCb, tuple(sys.argv[8:]))
File "/usr/lib/python2.7/site-packages/poaupdater/uDBAccessAPI.py", line 313, in deployPgSlave
runOnMaster(""" su - postgres -c "psql --port=%d -c \\"DROP ROLE IF EXISTS %s\\"" """ % (masterPort, roUserName,))
...

Cause

pa-central-repo repository is not configured on DB replication host.

Resolution

  1. Login to Database replication host and Configure pa-central-repo on the replica host. For example, you can copy /etc/yum.repos.d/pa-central.repo from CloudBlue Commerce Core node
  2. Enable repository with command yum --enablerepo=pa-central-repo clean metadata;
  3. Rerun failed task from Task Manager.

Internal content