On Tue, Jul 3, 2018 at 2:51 PM, Shirly Radco <sradco@redhat.com> wrote:

Hi Didi,

Can you please have a look?

Sorry I didn't reply earlier. Is this resolved? If not, please see below.

Thanks,
--
SHIRLY RADCO
BI SeNIOR SOFTWARE ENGINEER
Red Hat Israel
TRIED. TESTED. TRUSTED.
On Tue, Jul 3, 2018 at 2:20 PM, <emanuel.santosvarina@mahle.com> wrote:
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" <sradco@redhat.com>
An: emanuel.santosvarina@mahle.com,
Kopie: "Roy Golan" <rgolan@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.santosvarina@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" <rgolan@redhat.com>
An: emanuel.santosvarina@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.santosvarina@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:

In principle you can run this command manually. Take down the dwh service while you run it.

As Roy said, you can also reply 'No' when asked about running it.

If it fails, and you want to debug, you can try this. Open a new root shell on the machine, and run there:

. /usr/share/ovirt-engine-dwh/bin/dwh-prolog.sh
export PGPASSWORD=$DWH_DB_PASSWORD
psql -h $DWH_DB_HOST -p $DWH_DB_PORT -U $DWH_DB_USER -d $DWH_DB_DATABASE -w

If it works, then there might be some bug in /usr/share/ovirt-engine-dwh/bin/generate-pgpass.sh .

If it fails, then I have no idea how dwhd itself works.

Perhaps you have some custom configuration in your PostgreSQL?

Thanks and best regards,

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-leave@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-leave@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/

Didi