[ovirt-devel] ovirt_experimental_master Fails: PostgreSQL is not Accessible During Engine Setup

[Yedidyah Bar David]

On Tue, Jan 17, 2017 at 2:59 PM, Anton Marchukov <amarchuk at 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/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-dwh/ovirt-engine-dwhd.log

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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
>



-- 
Didi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20170117/eb0a06dd/attachment.html>