vacuumdb: could not connect to database ovirt_engine_history
..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" 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
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/HGQJQ4LME5Y3YE...
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/HGQJQ4LME5Y3YE...
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@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* <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* <users@ovirt.org> To unsubscribe send an email to *users-leave@ovirt.org* <users-leave@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/HGQJQ4LME5Y3YE... <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/
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/HGQJQ4LME5Y3YE... _______________________________________________ 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/TGVLKYWJY2VZVI...
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.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 <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@mahle.com* <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* <rgolan@redhat.com>> An: *emanuel.santosvarina@mahle.com* <emanuel.santosvarina@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.santosvarina@mahle.com* <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* <users@ovirt.org> To unsubscribe send an email to *users-leave@ovirt.org* <users-leave@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/HGQJQ4LME5Y3YE... <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-leave@ovirt.org* <users-leave@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/TGVLKYWJY2VZVI... <https://lists.ovirt.org/archives/list/users@ovirt.org/message/TGVLKYWJY2VZVI34KBQCZLG2OTLKJCAC/>
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 <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.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 <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@mahle.com* <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* <rgolan@redhat.com>> An: *emanuel.santosvarina@mahle.com* <emanuel.santosvarina@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.santosvarina@mahle.com* <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-s etup/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-leave@ovirt.org* <users-leave@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/HGQJQ4LME5Y3YE... <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-leave@ovirt.org* <users-leave@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/TGVLKYWJY2VZVI... <https://lists.ovirt.org/archives/list/users@ovirt.org/message/TGVLKYWJY2VZVI34KBQCZLG2OTLKJCAC/>
-- Didi
Hi Didi, thanks for your reply ... no error updating to Software Version:4.2.5.3-1.el7 , so whatever failed it is fixed with the recent version .. Rgds, Ema
On Tue, Aug 21, 2018 at 2:39 PM, ema dos <emanuel.santosvarina@mahle.com> wrote:
Hi Didi,
thanks for your reply ...
no error updating to Software Version:4.2.5.3-1.el7 , so whatever failed it is fixed with the recent version .. Rgds,
Thanks for the report!
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/YKTRMUZ4B7TBPB...
-- Didi
participants (5)
-
ema dos -
emanuel.santosvarina＠mahle.com
-
Roy Golan -
Shirly Radco -
Yedidyah Bar David