On Tue, Dec 7, 2021 at 7:44 AM Maitler <[email protected]> wrote:
>
> Issue with oVirt fresh install, during step 3.5 'Installing and Configuring
> Data Warehouse on a Separate Machine':
> Following Guide: Installing oVirt as a standalone Engine with remote databases
>
> The two nodes; ovirt-net and ovirt-ctl are both fresh installed RHEL 8.4
> nodes, built to make this test environment. With ovirt-ctl being the engine
> host and ovirt-net hosting the postgres database and DWH services.
Please clarify the topology in more details. What exactly is intended
to run where?
>
> Upon following the steps through the engine-setup after confirming the
> installation settings,
On which machine?
> the setup gets to '[INFO] Creating a user for Grafana'
This should only happen on the dwh machine ("ovirt-net"?)
> then says the following error:
> [ ERROR ] Failed to execute stage 'Misc configuration': terminating
> connection due to administrator command
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> Afterwards within /etc/pki/ovirt-engine/ there's broken/empty symbolic links
> for apache certs and keys linking to apache-grafana which'll cause errors for
> further attempts are re-doing the engine-setup.
This is a known issue, but should be harmless - another engine-setup
would overwrite the changes.
>
>
>
> Here's the lines before and after the error in the output log from the setup:
>
> 2021-12-06 14:49:08,233-0330 DEBUG
> otopi.ovirt_engine_setup.engine_common.database database.execute:234
> Database: 'None', Statement: '
> select * from GetDwhHistoryTimekeepingByVarName(
> %(name)s
> )
> ', args: {'name': 'dwhHostname'}
> 2021-12-06 14:49:08,233-0330 DEBUG
> otopi.ovirt_engine_setup.engine_common.database database.execute:239 Creating
> own connection
> 2021-12-06 14:49:08,253-0330 DEBUG
> otopi.ovirt_engine_setup.engine_common.database database.execute:284 Result:
> [{'var_name': 'dwhHostname', 'var_value': None, 'var_datetime': None}]
> 2021-12-06 14:49:08,254-0330 DEBUG
> otopi.ovirt_engine_setup.engine_common.database database.execute:234
> Database: 'None', Statement: '
> select UpdateDwhHistoryTimekeeping(
> %(name)s,
> %(value)s,
> NULL
> )
> ', args: {'name': 'dwhHostname', 'value':
> 'cloud-ovirt-net.mun.cluster.dns'}
> 2021-12-06 14:49:08,254-0330 DEBUG otopi.context context._executeMethod:145
> method exception
> Traceback (most recent call last):
> File "/usr/lib/python3.6/site-packages/otopi/context.py", line 132, in
> _executeMethod
> method['method']()
> File
> "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-dwh/core/single_etl.py",
> line 167, in _misc
> value=self.environment[osetupcons.ConfigEnv.FQDN]
> File
> "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/dwh_history_timekeeping.py",
> line 63, in updateValueInTimekeeping
> ownConnection=False,
> File
> "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/database.py",
> line 258, in execute
> args,
> psycopg2.OperationalError: terminating connection due to administrator command
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> 2021-12-06 14:49:08,257-0330 ERROR otopi.context context._executeMethod:154
> Failed to execute stage 'Misc configuration': terminating connection due to
> administrator command
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
A guess:
Your setup (with the engine on one machine and its db+dwh+dwh_db on
another) is not a common
one, and was likely not tested with the addition of grafana
integration (new in 4.4).
So you can try this:
1. Setup DBs + engine (already done)
2. On engine-setup on the other machine, reply 'No' to 'Configure
grafana?'. This should hopefully succeed.
3. Run there 'engine-setup --reconfigure-optional-components' and
enable grafana. Hopefully will work this time...
In any case, please file a bug in bugzilla. Thanks!
Best regards,
--
Didi
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/[email protected]/message/6PGAWNIBJAYFHJPZQ7NYGB4MVI22XUH5/
