Issue with DWH Installtion "Failed to execute stage 'Misc configuration': terminating connection due to administrator command"
7:44 p.m.
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.
Upon following the steps through the engine-setup after confirming the installation
settings, the setup gets to '[INFO] Creating a user for Grafana' 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.
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.
2021-12-06 14:49:08,257-0330 DEBUG otopi.plugins.otopi.dialog.human human.format:69
newline sent to logger
2021-12-06 14:49:08,258-0330 DEBUG otopi.transaction transaction.abort:124 aborting
'DNF Transaction'
4:19 p.m.
New subject: Issue with DWH Installtion "Failed to execute stage 'Misc configuration': terminating connection due to administrator command"
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
5:31 p.m.
New subject: Issue with DWH Installtion "Failed to execute stage 'Misc configuration': terminating connection due to administrator command"
Please clarify the topology in more details. What exactly is
intended
to run where?
The guess of the engine on one machine (ovirt-ctl) then the db, dwh dwh_db on the separate
machine (ovirt-net)
On which machine?
This is on ovirt-net when trying to setup dwh+dwh_db
This should only happen on the dwh machine ("ovirt-net"?)
Yes, has only happened during the DWH setup on ovirt-net
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...
Trying this; the initial setup for just dwh+dwh_db without grafana goes by successfully
now, however the reconfiguration setup run fails similarly as before:
[ INFO ] Creating a user for Grafana
[ 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.
Thank you in advance,
Maitlin
885
days inactive
892
days old
2 comments
3 participants
participants (3)
-
Maitler -
Maitlin Blundon
-
Yedidyah Bar David