4:19 p.m.
On Tue, Dec 7, 2021 at 7:44 AM Maitler <maitlerb(a)gmail.com> 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