Hi Shirly, here you are:
--snip
ovirt_engine_history=# SELECT * FROM history_configuration;
var_name | var_value | var_datetime
-------------------+-----------+------------------------
default_language | en_US |
firstSync | false | 2018-04-09 15:52:00+02
MinimalETLVersion | 4.2.0 |
lastHourAggr | | 2018-07-03 12:00:00+02
HourlyAggFailed | false |
lastDayAggr | | 2018-07-02 00:00:00+02
(6 rows)
ovirt_engine_history=#
--snap
date
Tue Jul 3 13:16:27 CEST 2018
Thanky you,
Ema
Von: "Shirly Radco" <sra...@redhat.com>
An: emanuel.santosvar...@mahle.com,
Kopie: "Roy Golan" <rgo...@redhat.com>, "users" <users@ovirt.org>
Datum: 03.07.2018 12:37
Betreff: Re: [ovirt-users] Antwort: Re: vacuumdb: could not connect
to database ovirt_engine_history
Hi,
Please share your history_configuration table content
in ovirt_engine_history db:
SELECT * FROM history_configuration;
the date and time you run this query
and the ovirt_engine_dwh.log
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel
TRIED. TESTED. TRUSTED.
On Fri, Jun 29, 2018 at 9:06 AM, <emanuel.santosvar...@mahle.com> wrote:
Hi Roy, well db is alive :
su - postgres -c 'scl enable rh-postgresql95 -- psql ovirt_engine_history'
psql (9.5.9)
Type "help" for help.
ovirt_engine_history=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------------------------+-------+----------------------
public | calendar | table | ovirt_engine_history
public | cluster_configuration | table | ovirt_engine_history
public | datacenter_configuration | table | ovirt_engine_history
public | datacenter_storage_domain_map | table | ovirt_engine_history
public | enum_translator | table | ovirt_engine_history
public | history_configuration | table | ovirt_engine_history
public | host_configuration | table | ovirt_engine_history
public | host_daily_history | table | ovirt_engine_history
public | host_hourly_history | table | ovirt_engine_history
public | host_interface_configuration | table | ovirt_engine_history
public | host_interface_daily_history | table | ovirt_engine_history
public | host_interface_hourly_history | table | ovirt_engine_history
public | host_interface_samples_history | table | ovirt_engine_history
public | host_samples_history | table | ovirt_engine_history
public | schema_version | table | ovirt_engine_history
public | statistics_vms_users_usage_daily | table | ovirt_engine_history
public | statistics_vms_users_usage_hourly | table | ovirt_engine_history
public | storage_domain_configuration | table | ovirt_engine_history
public | storage_domain_daily_history | table | ovirt_engine_history
public | storage_domain_hourly_history | table | ovirt_engine_history
public | storage_domain_samples_history | table | ovirt_engine_history
public | tag_details | table | ovirt_engine_history
public | tag_relations_history | table | ovirt_engine_history
public | users_details_history | table | ovirt_engine_history
public | vm_configuration | table | ovirt_engine_history
public | vm_daily_history | table | ovirt_engine_history
public | vm_device_history | table | ovirt_engine_history
public | vm_disk_configuration | table | ovirt_engine_history
public | vm_disk_daily_history | table | ovirt_engine_history
public | vm_disk_hourly_history | table | ovirt_engine_history
public | vm_disk_samples_history | table | ovirt_engine_history
public | vm_disks_usage_daily_history | table | ovirt_engine_history
public | vm_disks_usage_hourly_history | table | ovirt_engine_history
public | vm_disks_usage_samples_history | table | ovirt_engine_history
public | vm_hourly_history | table | ovirt_engine_history
public | vm_interface_configuration | table | ovirt_engine_history
public | vm_interface_daily_history | table | ovirt_engine_history
public | vm_interface_hourly_history | table | ovirt_engine_history
public | vm_interface_samples_history | table | ovirt_engine_history
public | vm_samples_history | table | ovirt_engine_history
(40 rows)
ovirt_engine_history=#
Von: "Roy Golan" <rgo...@redhat.com>
An: emanuel.santosvar...@mahle.com,
Kopie: users@ovirt.org
Datum: 28.06.2018 17:37
Betreff: Re: [ovirt-users] vacuumdb: could not connect to database
ovirt_engine_history
On Thu, 28 Jun 2018 at 18:06 <emanuel.santosvar...@mahle.com> wrote:
..trying to update from 4.2.3 to 4.2.4 engine-setup fails with the
following error:
--snip
2018-06-28 16:26:45,507+0200 DEBUG
otopi.plugins.ovirt_engine_setup.ovirt_engine_dwh.db.vacuum
plugin.execute:926 execute-output:
['/usr/share/ovirt-engine-dwh/bin/dwh-vacuum.sh', '-f', '-v'] stderr:
vacuumdb: could not connect to database ovirt_engine_history: FATAL:
password authentication failed for user "ovirt_engine_history"
do you have dwh installed? if no just skip this vacuum part.
you can check the db connection from cli using
$ su - postgres -c 'scl enable rh-postgresql95 -- psql
ovirt-engine-history'
2018-06-28 16:26:45,507+0200 DEBUG otopi.context
context._executeMethod:143 method exception
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/otopi/context.py", line 133, in
_executeMethod
method['method']()
File
"/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine-dwh/db/vacuum.py",
line 126, in _vacuum
self.execute(args=args)
File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line 931, in
execute
command=args[0],
RuntimeError: Command '/usr/share/ovirt-engine-dwh/bin/dwh-vacuum.sh'
failed to execute
2018-06-28 16:26:45,508+0200 ERROR otopi.context
context._executeMethod:152 Failed to execute stage 'Misc configuration':
Command '/usr/share/ovirt-engine-dwh/bin/dwh-vacuum.sh' failed to execute
2018-06-28 16:26:45,508+0200 DEBUG otopi.transaction transaction.abort:119
aborting 'Yum Transaction'
--snap
Any ideas?
Thank You,
Ema_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/HGQJQ4LME5Y3YELU46GRDT6QS4SJUAQ6/
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/TGVLKYWJY2VZVI34KBQCZLG2OTLKJCAC/
ovirt-engine-dwhd.log
Description: Binary data
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/FFAXHFPHQY5QOCWZ23ONOB2F6ID47VHK/
