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/