On Tue, Sep 5, 2017 at 6:37 PM, Simone Tiraboschi <stirabos@redhat.com> wrote:


On Tue, Sep 5, 2017 at 3:54 PM, Evgheni Dereveanchin <ederevea@redhat.com> wrote:
Test failed: [ upgrade_engine ]

Link to suspected patches:

Link to Job:
* this is failing since around job run 2291 but was masked by other errors

Link to logs:

Error snippet from log:

<error>

2017-09-05 09:28:45,444-0400 DEBUG otopi.ovirt_engine_setup.engine_common.database database.execute:229 Creating own connection
2017-09-05 09:28:45,448-0400 DEBUG otopi.ovirt_engine_setup.engine_common.database database.execute:274 Result: [{'count': 153L}]
2017-09-05 09:28:45,448-0400 DEBUG otopi.ovirt_engine_setup.engine_common.database database.execute:224 Database: 'None', Statement: 'SHOW server_version', args: {}
2017-09-05 09:28:45,448-0400 DEBUG otopi.ovirt_engine_setup.engine_common.database database.execute:229 Creating own connection
2017-09-05 09:28:45,452-0400 DEBUG otopi.ovirt_engine_setup.engine_common.database database.execute:274 Result: [{'server_version': '9.2.18'}]
2017-09-05 09:28:45,452-0400 DEBUG otopi.ovirt_engine_setup.engine_common.database database.checkServerVersion:449 PostgreSQL server version: 9.2.18
2017-09-05 09:28:45,453-0400 DEBUG otopi.plugins.ovirt_engine_common.ovirt_engine.db.connection connection._setup:146 Existing credential use failed
Traceback (most recent call last):
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-common/ovirt-engine/db/connection.py", line 141, in _setup
    ] = dbovirtutils.checkDBMSUpgrade()
  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 490, in checkDBMSUpgrade
    self.checkClientVersion()
  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 457, in checkClientVersion
    self.command.get('psql'),
  File "/usr/lib/python2.7/site-packages/otopi/command.py", line 74, in get
    command=command
RuntimeError: Command 'psql' is required but missing
2017-09-05 09:28:45,454-0400 DEBUG otopi.context context._executeMethod:142 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/otopi/context.py", line 132, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-common/ovirt-engine/db/connection.py", line 162, in _setup
    raise RuntimeError(msg)
RuntimeError: Cannot connect to Engine database using existing credentials: engine@localhost:5432
2017-09-05 09:28:45,455-0400 ERROR otopi.context context._executeMethod:151 Failed to execute stage 'Environment setup': Cannot connect to Engine database using existing credentials: engine@localhost:5432


It seams that for some strange reasons the test upgrade job is not installing rh-postgresql95-postgresql which should be instead required as for my modification the spec file:


OK, understood.
The dependency on the postgres 9.5 client from scl was just on ovirt-engine and not on ovirt-engine-setup-plugin-ovirt-engine-common as it should be.

OST upgrade test is correctly running
  yum -y update ovirt-*setup*
updating just engine-setup from a local repo.

While I tested it instead I was updating all the rpms from my local build without building a local repo, that's why I didn't realized it, sorry!


https://gerrit.ovirt.org/#/c/81476/ should address it.


 

Not sure if it's just a repo sync issue or something similar:
And, by the way, the job is also testing 4.0.6.3 -> 4.2.0-0.0 and not 4.1 -> 4.2 as it should be (not sure why it's working).


This is still an issue, not sure  why our code doesn't detect it.
 
Relevant log section:

Resolving Dependencies
--> Running transaction check
---> Package ovirt-engine-dwh-setup.noarch 0:4.0.6-1.el7.centos will be updated
---> Package ovirt-engine-dwh-setup.noarch 0:4.2.1-0.0.master.20170903090219.el7.centos will be an update
---> Package ovirt-engine-extension-aaa-ldap-setup.noarch 0:1.2.2-1.el7 will be updated
---> Package ovirt-engine-extension-aaa-ldap-setup.noarch 0:1.3.5-0.0.master.git7230cd9.el7.centos will be an update
--> Processing Dependency: ovirt-engine-extension-aaa-ldap = 1.3.5-0.0.master.git7230cd9.el7.centos for package: ovirt-engine-extension-aaa-ldap-setup-1.3.5-0.0.master.git7230cd9.el7.centos.noarch
---> Package ovirt-engine-setup.noarch 0:4.0.6.3-1.el7.centos will be updated
---> Package ovirt-engine-setup.noarch 0:4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos will be an update
---> Package ovirt-engine-setup-base.noarch 0:4.0.6.3-1.el7.centos will be updated
---> Package ovirt-engine-setup-base.noarch 0:4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos will be an update
--> Processing Dependency: ovirt-engine-lib >= 4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos for package: ovirt-engine-setup-base-4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos.noarch
--> Processing Dependency: otopi >= 1.7.1 for package: ovirt-engine-setup-base-4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos.noarch
---> Package ovirt-engine-setup-plugin-ovirt-engine.noarch 0:4.0.6.3-1.el7.centos will be updated
---> Package ovirt-engine-setup-plugin-ovirt-engine.noarch 0:4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos will be an update
---> Package ovirt-engine-setup-plugin-ovirt-engine-common.noarch 0:4.0.6.3-1.el7.centos will be updated
---> Package ovirt-engine-setup-plugin-ovirt-engine-common.noarch 0:4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos will be an update
---> Package ovirt-engine-setup-plugin-vmconsole-proxy-helper.noarch 0:4.0.6.3-1.el7.centos will be updated
---> Package ovirt-engine-setup-plugin-vmconsole-proxy-helper.noarch 0:4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos will be an update
---> Package ovirt-engine-setup-plugin-websocket-proxy.noarch 0:4.0.6.3-1.el7.centos will be updated
---> Package ovirt-engine-setup-plugin-websocket-proxy.noarch 0:4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos will be an update
---> Package ovirt-imageio-proxy-setup.noarch 0:0.4.0-0.201608310602.gita9b573b.el7.centos will be updated
---> Package ovirt-imageio-proxy-setup.noarch 0:1.1.0-0.201708142346.git4dd31c9.el7.centos will be an update
---> Package ovirt-setup-lib.noarch 0:1.0.2-1.el7.centos will be updated
---> Package ovirt-setup-lib.noarch 0:1.1.5-0.0.master.20170823122959.git1480342.el7.centos will be an update
--> Running transaction check
---> Package otopi.noarch 0:1.5.2-1.el7.centos will be updated
--> Processing Dependency: otopi = 1.5.2-1.el7.centos for package: otopi-java-1.5.2-1.el7.centos.noarch
---> Package otopi.noarch 0:1.7.2-0.0.master.20170816071636.git7a3278c.el7.centos will be an update
---> Package ovirt-engine-extension-aaa-ldap.noarch 0:1.2.2-1.el7 will be updated
---> Package ovirt-engine-extension-aaa-ldap.noarch 0:1.3.5-0.0.master.git7230cd9.el7.centos will be an update
---> Package ovirt-engine-lib.noarch 0:4.0.6.3-1.el7.centos will be updated
---> Package ovirt-engine-lib.noarch 0:4.2.0-0.0.master.20170905115642.git4a0716e.el7.centos will be an update
--> Running transaction check
---> Package otopi-java.noarch 0:1.5.2-1.el7.centos will be updated
---> Package otopi-java.noarch 0:1.7.2-0.0.master.20170816071636.git7a3278c.el7.centos will be an update
--> Finished Dependency Resolution



 

</error>

--
Regards,
Evgheni Dereveanchin