ovirt_experimental_master Fails: PostgreSQL is not Accessible During Engine Setup

Hello All. FYI. We started to see multiple master system tests failing in row with the following error in engine-setup logs [1]: 2017-01-17 06:46:29 DEBUG otopi.ovirt_engine_setup.engine_common.database database.getCredentials:1267 database connection failed Traceback (most recent call last): File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 1265, in getCredentials ] = self.isNewDatabase() File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 370, in isNewDatabase transaction=False, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 191, in execute database=database, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 125, in connect sslmode=sslmode, File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect conn = _connect(dsn, connection_factory=connection_factory, async=async) OperationalError: could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432? 3 jobs in row [2], [3], [4] currently failed due to this, so I suspect it is regression somewhere. It started around engine patch [5]: Change 69927 - Merged packaging: ovirt-engine-hosts-ansible-inventory: Init groups So that they always exist, even if empty. Change-Id: If0169b60012ab444c19385363168832f6cd151ab Bug-Url: https://bugzilla.redhat.com/1405813 however I am not sure of that is the cause or not. Will reply to this message if I get any updates. Thanks, [1] http://jenkins.ovirt.org/job/test-repo_ovirt_experimental_master/4789/artifa... [2] http://jenkins.ovirt.org/job/test-repo_ovirt_experimental_master/4789/ [3] http://jenkins.ovirt.org/job/test-repo_ovirt_experimental_master/4790/ [4] http://jenkins.ovirt.org/job/test-repo_ovirt_experimental_master/4791/ [5] https://gerrit.ovirt.org/#/c/69927/ -- Anton Marchukov Senior Software Engineer - RHEV CI - Red Hat

On Tue, Jan 17, 2017 at 2:59 PM, Anton Marchukov <amarchuk@redhat.com> wrote:
Hello All.
FYI. We started to see multiple master system tests failing in row with the following error in engine-setup logs [1]:
2017-01-17 06:46:29 DEBUG otopi.ovirt_engine_setup.engine_common.database database.getCredentials:1267 database connection failed Traceback (most recent call last): File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 1265, in getCredentials ] = self.isNewDatabase() File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 370, in isNewDatabase transaction=False, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 191, in execute database=database, File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py", line 125, in connect sslmode=sslmode, File "/usr/lib64/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect conn = _connect(dsn, connection_factory=connection_factory, async=async) OperationalError: could not connect to server: Connection refused Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
3 jobs in row [2], [3], [4] currently failed due to this, so I suspect it is regression somewhere.
The referenced log finishes with 'Execution of setup completed successfully', so it's ok. The above error is harmless, and appears in the log for every setup that uses automatic db provisioning. We might be able to get rid of it, to ease searching setup logs for real errors, not sure how easy it is. Please open a bug if you want.
It started around engine patch [5]:
Change 69927 - Merged packaging: ovirt-engine-hosts-ansible-inventory: Init groups So that they always exist, even if empty. Change-Id: If0169b60012ab444c193853631688 32f6cd151ab
I don't think it's related. Anton later said in private that the error was: http://jenkins.ovirt.org/job/test-repo_ovirt_experimental_master/4791/artifa... Adding Shirly.
Bug-Url: https://bugzilla.redhat.com/1405813
however I am not sure of that is the cause or not. Will reply to this message if I get any updates.
Thanks,
[1] http://jenkins.ovirt.org/job/test-repo_ovirt_experimental_master/4789/ artifact/exported-artifacts/basic_suite_master.sh-el7/ exported-artifacts/test_logs/basic-suite-master/post-001_ initialize_engine.py/lago-basic-suite-master-engine/_ var_log/ovirt-engine/setup/ovirt-engine-setup-20170117064623-x8tmgl.log [2] http://jenkins.ovirt.org/job/test-repo_ovirt_experimental_master/4789/ [3] http://jenkins.ovirt.org/job/test-repo_ovirt_experimental_master/4790/ [4] http://jenkins.ovirt.org/job/test-repo_ovirt_experimental_master/4791/ [5] https://gerrit.ovirt.org/#/c/69927/
-- Anton Marchukov Senior Software Engineer - RHEV CI - Red Hat
_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
-- Didi
participants (2)
-
Anton Marchukov
-
Yedidyah Bar David