[ovirt-users] Re: Antwort: Re: vacuumdb: could not connect to database ovirt_engine_history

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(a)redhat.com&gt; An: emanuel.santosvarina(a)mahle.com, Kopie: "Roy Golan" <rgolan(a)redhat.com&gt;, "users" <users(a)ovirt.org&gt; 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.santosvarina(a)mahle.com* <emanuel.santosvarina(a)mahle.com&gt;&gt; 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(a)redhat.com* <rgolan(a)redhat.com&gt;&gt; An: *emanuel.santosvarina(a)mahle.com* <emanuel.santosvarina(a)mahle.com&gt;, Kopie: *users(a)ovirt.org* <users(a)ovirt.org&gt; 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(a)mahle.com* <emanuel.santosvarina(a)mahle.com&gt;&gt; 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(a)ovirt.org* <users(a)ovirt.org&gt; To unsubscribe send an email to *users-leave(a)ovirt.org* <users-leave(a)ovirt.org&gt; 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/HGQJQ4LME5Y... _______________________________________________ Users mailing list -- *users(a)ovirt.org* <users(a)ovirt.org&gt; To unsubscribe send an email to *users-leave(a)ovirt.org* <users-leave(a)ovirt.org&gt; 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/TGVLKYWJY2V...