Hi Didi,

Can you please have a look?

Thanks,

--

SHIRLY RADCO

BI SeNIOR SOFTWARE ENGINEER

Red Hat Israel


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:

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/