Hi Didi,

Can you please have a look?

Thanks,

--

SHIRLY RADCO

BI SeNIOR SOFTWARE ENGINEER

Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>

On Tue, Jul 3, 2018 at 2:20 PM, <emanuel.santosvar...@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" <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 <https://www.redhat.com/>
>
> <https://red.ht/sig> *TRIED. TESTED. TRUSTED.*
> <https://redhat.com/trusted>
>
>
> On Fri, Jun 29, 2018 at 9:06 AM, <*emanuel.santosvar...@mahle.com*
> <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* <rgo...@redhat.com>>
> An:        *emanuel.santosvar...@mahle.com*
> <emanuel.santosvar...@mahle.com>,
> Kopie:        *users@ovirt.org* <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*
> <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* <users@ovirt.org>
> To unsubscribe send an email to *users-le...@ovirt.org*
> <users-le...@ovirt.org>
> Privacy Statement: *https://www.ovirt.org/site/privacy-policy/*
> <https://www.ovirt.org/site/privacy-policy/>
> oVirt Code of Conduct:
> *https://www.ovirt.org/community/about/community-guidelines/*
> <https://www.ovirt.org/community/about/community-guidelines/>
> List Archives:
> *https://lists.ovirt.org/archives/list/users@ovirt.org/message/HGQJQ4LME5Y3YELU46GRDT6QS4SJUAQ6/*
> <https://lists.ovirt.org/archives/list/users@ovirt.org/message/HGQJQ4LME5Y3YELU46GRDT6QS4SJUAQ6/>
>
> _______________________________________________
> Users mailing list -- *users@ovirt.org* <users@ovirt.org>
> To unsubscribe send an email to *users-le...@ovirt.org*
> <users-le...@ovirt.org>
> Privacy Statement: *https://www.ovirt.org/site/privacy-policy/*
> <https://www.ovirt.org/site/privacy-policy/>
> oVirt Code of Conduct:
> *https://www.ovirt.org/community/about/community-guidelines/*
> <https://www.ovirt.org/community/about/community-guidelines/>
> List Archives:
> *https://lists.ovirt.org/archives/list/users@ovirt.org/message/TGVLKYWJY2VZVI34KBQCZLG2OTLKJCAC/*
> <https://lists.ovirt.org/archives/list/users@ovirt.org/message/TGVLKYWJY2VZVI34KBQCZLG2OTLKJCAC/>
>
>
>
_______________________________________________
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/HWXABX5RZCY24I5BMT6N5RZDTJFBIHGU/

Reply via email to